z tables

[Former Member]

If there are two tables in a database, for example Table ZACCDETAILT and

ZACCDETAILS,where ZACCDETAILT has all the fields present in ZACCDETAILS with two extra fields ,I would like a transaction code to maintain all the fields of table ZACCDETAILT and when saving this must update both tables (ZACCDETAILS and ZACCDETAILT.

[former_member156446]

Hi Reethu

Its better you right a small program.. and create a transaction code for that program using SE93 Tcode.

in the program you will using

Modify ZACCDETAILS from Itab.

modify ZACCDETAILT from Itab2.

[Former Member]

You will need to modify the program generated by the SM30 or the Dynpros.

Greetings,

Blag.

[ThomasZloch]

I suggest you try creating a maintenance view containing a join of these two tables and then generate a maintenance dialog for this view.

Greetings

Thomas

[Former Member]

Go in se80 and try to search the function group with the same name of your transaction.

Try to modify it as u want.

Bye

[Former Member]

Generate Table Maintainance using the following steps and customize the

code generated by SAP 😘

*Steps..

GO TO SE11

Give the table name

Press change..

In the menu..UTILITIES -> TABLE MAINTENANCE GENERATOR.

GIve the authorization group &NC&

Choose the single step radio button..

Give the screen number 1.

Give the function group..Give the table name itself as the function group.

Press create. button.

Now the screen is generated..go to sm30 and maintain the table entries.