topic Re: z tables in Application Development and Automation Discussions

z tables

Former Member — Thu, 24 Jan 2008 16:35:51 GMT

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.

Re: z tables

former_member156446 — Thu, 24 Jan 2008 16:38:34 GMT

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.

Re: z tables

Former Member — Thu, 24 Jan 2008 16:41:43 GMT

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

Greetings,

Blag.

Re: z tables

ThomasZloch — Thu, 24 Jan 2008 16:48:42 GMT

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

Re: z tables

Former Member — Thu, 24 Jan 2008 16:51:57 GMT

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

Re: z tables

Former Member — Thu, 24 Jan 2008 18:31:46 GMT

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.