topic Re: Updating a database table in Application Development and Automation Discussions

Updating a database table

Former Member — Mon, 21 Jan 2008 16:44:27 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.

Thanks and regards

Ashish

Re: Updating a database table

Former Member — Mon, 21 Jan 2008 16:58:19 GMT

Hello,

What is the question??

Do you want the full code for it??

Bye

Gabriel

Re: Updating a database table

Former Member — Mon, 21 Jan 2008 18:32:38 GMT

Hello,

If you create a maintenance view between these tables ZACCDETAILS and ZACCDETAILT, you can update them together in SM30. Otherwise, you have create a program and in the 'Save' event, you can take care of the required condition.

Thanks,

Venu

Re: Updating a database table

Former Member — Tue, 22 Jan 2008 03:41:44 GMT

ashish,

Pls. go through this link you will have complete idea...

But don't forget to reward if useful.....

Re: Updating a database table

Former Member — Tue, 22 Jan 2008 05:17:58 GMT

hi,

if i think right if u press save button, then u r able to update one database table for the same u written code in the program just like that u can write code for the second database tabale,then pblm will solve...

reward points if useful,

seshu.

Re: Updating a database table

Former Member — Tue, 22 Jan 2008 11:17:52 GMT

Hello Venu,

Can u give me the procedure to solve this problem with the help of maintanence view,because i tried doing this but it gets updated in only table .

Thanks and regards

Ashish

Re: Updating a database table

Former Member — Tue, 22 Jan 2008 16:41:25 GMT

Hi Ashish,

In table maintainance generator, you can add your code to populate data in ZACCDETAILT. Steps would be

1. Create maintainance generator for table ZACCDETAILS

2. Select Event '02' - ( After saving the data in database ) or 05 ( create new entry ) while creating maintaiance generator.

SE11 --> Utilities -> Table maintainance Generator -> environment -> modification -> events

3. You can add your code for these events to save data in table ZACCDETAILT.

Using SM30, you can save data in ZACCDETAILS as well as ZACCDETAILT.

Hope it will help you.

Regards,

Naren