Table maintenance

[Former Member]

Dear Friends,

i have two tables like follows

ZTable1

Material

Description

ZTable2

Material

Weight

so i want to maintain these two tables in one table maintenance view

i mean in table maintenance screen should display Material / Weight / Description

when i add records these two tables must update and delete /updates also needed

is the possible? then please guide me with steps

Thanks in advance

[nabheetscn]

You can try by creating a maintainence view.

Refer below mentioned link.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ecdf446011d189700000e8322d00/frameset.htm

nabheet

[Former Member]

Hello Nelson,

I believe you need to create one maintainance view & include your fields accordingly. Later you need to transaction code for maintainance view.

Regards,

Amit

[raymond_giuseppi]

What are the key fields, if it is only MATERIAL, you can describe ZTABLE1 as a text table for ZTABLE2 (foreign key), so table maintenance generator on ZTABLE2 will automatically manage ZTABLE1.

You could also build a maintenance view joining those two tables and build the table maintenance on this view.

Some remarks

- Where is the language field in ZTABLE1 ?

- Where is the MANDT field in both tables ?

Regards,

Raymond

[former_member1125862]

Hi,

For this you have to create the CLUSTER VIEW to maintain like this.

You can get so many examples regarding the CLUSTER VIEW in Google.

Thanks

Kruthik

[Former Member]

Hi thanks for your quick responds

i have created maintenance table with foreign keys

but when i view maintenance screen only display table two fields

when i click on the new entries button table one field also displayed but when i enter data and save only table two update

what is the issue