Question Re: What is the transaction code. in Technology Q&A

What is the transaction code.

Former Member — Tue, 21 Nov 2006 05:58:17 GMT

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

Re: What is the transaction code.

Former Member — Tue, 21 Nov 2006 06:15:56 GMT

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!

Re: What is the transaction code.

Former Member — Tue, 21 Nov 2006 06:17:13 GMT

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

Re: What is the transaction code.

Former Member — Tue, 21 Nov 2006 06:17:51 GMT

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

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

Regards,

R.Ravi

Re: What is the transaction code.

Former Member — Tue, 21 Nov 2006 06:18:16 GMT

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,

Re: What is the transaction code.

Former Member — Tue, 21 Nov 2006 06:27:22 GMT

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

gr8 guyz.. points awarded.

Thanks