topic Re: Searching update insert and delete statements in Application Development and Automation Discussions

Searching update insert and delete statements

Former Member — Wed, 04 Feb 2009 06:30:21 GMT

Hi.

Suppose, there is change request containing 10 or more programs.

One of the program has statements, working with database tables,

like update, insert or delete.

Is there any transaction where we can select request number and find

programs working with tables directly.

Re: Searching update insert and delete statements

GauthamV — Wed, 04 Feb 2009 06:36:01 GMT

I dont think there is any such transaction according to your requirement.

You can get all programs in arequest from E071 table.

USe RPR_ABAP_SOURCE_SCAN program to search

update, insert or delete in your programs.

Re: Searching update insert and delete statements

Sandeep_Panghal — Wed, 04 Feb 2009 06:37:03 GMT

You can check the transport request using SE01/09/10 and check for the table and then use a where used list to find all the programs where this table is used.

Re: Searching update insert and delete statements

Former Member — Wed, 04 Feb 2009 06:41:20 GMT

Hello

1. Goto table E071 with TRKORR = change request and OBJECT = {reps, repo, rept}

2. In field OBJ_NAME will be all reports names in this request

3. In abap-programm upload this reports into internal table

4. Search for 'update' 'insert' and 'delete'

P.s. it is only for reports

Re: Searching update insert and delete statements

Former Member — Wed, 04 Feb 2009 08:01:26 GMT

Thank you very much.