How to perform Where Used programatically

[Former Member]

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

[Former Member]

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

Gareth.

[Former Member]

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

[Former Member]

Thanks So much Byju. This resolved my requirement.

Regards,Uday

[sascha_reissig]

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