topic Re: Database update programs in Application Development and Automation Discussions

Database update programs

Former Member — Thu, 15 Jun 2006 10:51:17 GMT

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

Re: Database update programs

Former Member — Thu, 15 Jun 2006 10:57:18 GMT

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

Re: Database update programs

Former Member — Thu, 15 Jun 2006 11:02:28 GMT

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.

Re: Database update programs

Former Member — Thu, 15 Jun 2006 11:03:08 GMT

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

Re: Database update programs

dani_mn — Thu, 15 Jun 2006 11:16:45 GMT

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

Regards,

Wasim Ahmed

Re: Database update programs

Former Member — Thu, 15 Jun 2006 11:24:38 GMT

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.

Re: Database update programs

Former Member — Thu, 15 Jun 2006 11:29:28 GMT

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

Re: Database update programs

Former Member — Thu, 15 Jun 2006 11:34:50 GMT

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

Re: Database update programs

Former Member — Thu, 15 Jun 2006 14:24:41 GMT

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