Update DD table

[Former Member]

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]

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

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3a6d358411d1829f0000e829fbfe/content.htm

Update

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3a94358411d1829f0000e829fbfe/content.htm

Modify

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3ac8358411d1829f0000e829fbfe/content.htm

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

6. if unsuccessful, rollback and unlock the table.

Regards,

Vara

[Former Member]

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

Thanks,

Santosh