topic Re: Data Upload into a Ztable in Application Development and Automation Discussions

Data Upload into a Ztable

Former Member — Wed, 14 May 2008 15:57:58 GMT

Hi,

I have a Ztable in the Production system and the Client wants to know all the porgrams from where the data is being added into the ZTABLE.

By using the Where-used-List I am getting lots of tables .

Is there any other way of knowing the same.

Thanks...

R Adarsh

Re: Data Upload into a Ztable

Former Member — Wed, 14 May 2008 16:02:00 GMT

Hi,

You can use INSERT statement to insert the records into the table.

Re: Data Upload into a Ztable

Former Member — Wed, 14 May 2008 16:06:08 GMT

Execute RPR_ABAP_SOURCE_SCAN program and give INSERT ZTABLE or MODIFY ZTABLE in 'Find string' and execute ..

Regards,

Santosh

Re: Data Upload into a Ztable

Former Member — Wed, 14 May 2008 16:06:18 GMT

the only way you're going to find that out is to do the Where-Used on that table & examine each of those programs to see if they're updating your table.

regards,

robert.

EDIT: the above example looks good, too, however, i'm not sure howm uch spacing will count in your search terms. If it does, you may not pick up INSERT ZTABLE (with multiple spaces in between), but only INSERT ZTABLE.

Edited by: robert phelan on May 14, 2008 6:06 PM

Edited by: robert phelan on May 14, 2008 6:08 PM

Re: Data Upload into a Ztable

Former Member — Wed, 14 May 2008 16:11:32 GMT

Where-Used List just pulls all the programs where the field/table reference is made in data declaration... and sometimes you might actually define the fields as char type and still update/insert records to the table... I have tried the below method earlier and it was useful... we used it to generate the list of custom programs where a HR infotype field was retrieved (can be direct select, function module or marco read)

You can try this way... depends on how comfortable you are in excel as there is some manual work involved

run the program RS_ABAP_SOURCE_SCAN or RPR_ABAP_SOURCE_SCAN with the following parameters

Program Name: SAPLZ, SAPMZ, LZ, MZ, Z* (Should cover all the custom reports, Module pool and function modules)

Find String: <Z Table Name>, INSERT, UPDATE, MODIFY (maybe first run the program only for <Z Table> to get the programs and then take the list and run it for INSERT, UPDATE, MODIFY )

Let me know if you need help & Hope this helpful.

Thanks,

Pavan