topic How to perform Where Used programatically in Application Development and Automation Discussions

How to perform Where Used programatically

Former Member — Wed, 13 Nov 2013 18:37:10 GMT

Hi Friends,

I have a requirement where in i need to perform where used list on a Data Element n and fetch the DB Tables and corresponding fields having this information. Once i have this information, i have to check for the value in those particular fields and if the value is non blank then i need to report those erroneous records.

To start of with, i am exploring options how to programtically call where used list from a ZProgram by taking Data Element as input parameter.

Any pointers on this would be of great help.

Thanks,

uday

Re: How to perform Where Used programatically

Former Member — Wed, 13 Nov 2013 19:37:12 GMT

Have you tried debugging through the logic of the where-used function from SE11? That would be my first port of call...

Gareth.

Re: How to perform Where Used programatically

Former Member — Thu, 14 Nov 2013 05:04:15 GMT

Hi Udaya,

Check the View 'DD03VV' in SE11

Pass the field ROLLNAME = Required Data Element Name

This will give the desired result as mentioned.

To check the query to be written see the Table/Join conditions of the View DD03VV and do the needful changes.

Hope it Helps

Regards

Re: How to perform Where Used programatically

sascha_reissig — Thu, 14 Nov 2013 05:38:38 GMT

Hi Udaya,

you also could scan the abap code using RS_ABAP_SOURCE_SCAN (just a general approach) or you can play a bit with function module RS_EU_CROSSREF (this is the cross ref function) or another way is to work with 'RS_INFOSYSTEM_CREATE_REQUEST'.

regards, Sascha

Re: How to perform Where Used programatically

Former Member — Fri, 15 Nov 2013 00:17:34 GMT

Thanks So much Byju. This resolved my requirement.

Regards,Uday