Database update programs

[Former Member]

I have to generate a list of custom programs that makes database table update?

All the programs that can update the database tables (like BDC progs)

Can this be done?

Regrads

Alok Pathak

[Former Member]

yes, you will be able to update database records by recording the transactions in SHDB and then creating BDC programs to update these records.

[Former Member]

go to transaction SE49.

and enter the program name it show which table is updated . if any programm update any table it show all the list of table which are updated...

this is suficient for making u logic to find out programm name which update tables.

[Former Member]

Through BAPI and BDC Programs you can update the database table.

Example : Using BAPI_MATERIAL_SAVEDATA

you can create material so that the related database table will be updated.

Message was edited by: mukesh kumar

[dani_mn]

for this you have to read the source code of programs one by one.

Regards,

Wasim Ahmed

[Former Member]

Hi,

You have to use BDC programs.....wel i suggest you to use a tool LSMW which is used for data migration and data is transferred much faster.It is a code free tool

Please visit the links.

http://www.scmexpertonline.com/downloads/SCM_LSMW_StepsOnWeb.doc

http://www.sap-img.com/sap-data-migration.htm

http://www.sapgenie.com/saptech/lsmw.htm

http://www.sappoint.com/abap/bdcconcept.pdf

http://help.sap.com/saphelp_crm50/helpdata/en/d1/aa003d4b8a11d189510000e829fbbd/content.htm

Please reward if it helps.

[Former Member]

Yes, it can be done. You have to write a custom program.

in that program you have to READ the reports using the

<b> READ REPORT prog INTO itab.</b>

and now read the source code for UPDATES and CALL TRANSACTIONS etc.

Regards

vijay

[Former Member]

Hi Alok,

YOu should also take care of th fnction modules which are updating the database tables.

You should also get the programs that call the function modules which update the databases.

YOu can use the program:

RPR_ABAP_SOURCE_SCAN to scan the program for certain words like update/modify/delete/call transaction etc.

Regards,

Ravi

[Former Member]

I really don't think it's possible to get a comprehensive list. Your Z program may call an SAP FM which in turn calls another SAP FM which then does some database updates.

We control it procedurally; report programs have 'R' as the fourth character of the name and update programs have 'U' as the fourth character.

Rob