What is the transaction code.

[Former Member]

Hi gurus-

What is the transaction code to find out in which tables and/or in which structure any field (like kostl, pspnr frgzu etc) is used.

I know it is something like se84 or se85, but if I try these it goes to abap development work bench. I tried these in ECC and BW.

Any help is appreciated.

Thanks

[Former Member · Accepted solution]

Hi,

I don't think there is a Tcode for this.

in r/3 side

GO to se11->ROOFIELD table-> ctrlshiftf10->field KOSTL...you will find the data soucres in which this field is. figure out the relative DS for your use.

Then go to HELP.SAP and search for this DS.

you will find the Table name and Structure name.

Hope i m clr.

Regards,

San!

[Former Member · Accepted solution]

<u>To check out the table a field belongs to:</u>

SE11 -> DD03L -> Utilities -> Table Contents -> Display-> Execute (F8) with <FIELDNAME>.

Regards,

R.Ravi

[Former Member]

Hi

There is one way to find out is go to SE11 or SE12 and give the field name in 'data type' and click the button 'Where-used list', it will give the list of tables where this field is used. Hope this will help you.

Thanks,

SR

[Former Member]

yeah .. 'where used icon' .. I got it.. I was looking for that...

gr8 guyz.. points awarded.

Thanks

[Former Member]

Hi,

Go to help.sap.com and search for the field. There is no transaction codes which tell this.But if you know atleast one table or structure where the particular field is used then go to the table or srtucture in SE11 and you can try the "where used" function to find the other references.

like kostl is in table GLPCA

Regards

Happy Tony