topic Re: Table maintenance in Application Development and Automation Discussions

Table maintenance

Former Member — Fri, 01 Jul 2011 08:13:59 GMT

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

Re: Table maintenance

nabheetscn — Fri, 01 Jul 2011 08:29:48 GMT

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

Re: Table maintenance

Former Member — Fri, 01 Jul 2011 08:30:57 GMT

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

Re: Table maintenance

RaymondGiuseppi — Fri, 01 Jul 2011 08:31:13 GMT

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

Re: Table maintenance

former_member1125862 — Fri, 01 Jul 2011 09:22:42 GMT

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

Re: Table maintenance

Former Member — Fri, 01 Jul 2011 09:31:13 GMT

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