topic Re: Update DD table in Application Development and Automation Discussions

Update DD table

Former Member — Mon, 29 Jan 2007 20:59:08 GMT

Hi ,

I need to add entries into a DD table through a report program.

This report must be triggered automatically when ever a new delivery number is entered into the master data table.

Thanks

Former Member — Mon, 29 Jan 2007 21:06:28 GMT

Hi,

You can write a User-exit for this. Whenever the delivery is created, the user exit should call the program to insert records into the DB table.

Check the following procedure to enter records into DB table.

1. Lock the table in optimistic mode

2. validate the data

3. Lock the table in exlusive mode.

4. Insert the records using INSERT/Update/Modify commands

Insert

Update

Modify

5. If update is successful, then unlock and commit the database

6. if unsuccessful, rollback and unlock the table.

Regards,

Vara

Former Member — Mon, 29 Jan 2007 21:24:47 GMT

Although i am not sure, try calling your report in this BADI DELIVERY_PUBLISH (Announcement of delivery data during database update)

Thanks,

Santosh