‎2006 Mar 08 5:21 PM
Hi all,
I have a field related to vendor. It is ktokk. I just want to find out in which vendor master table it is existing like lfa1 or lfb1. What is the best way to find which field belongs to which table. Because If I am doing recording it is referring to structure.
Regards,
Varun.
‎2006 Mar 08 5:24 PM
In a lot of cases, the field names is the same as the data element that is used. In SE11, enter the data elment name ktokk and click the appropriate radiobutton, then click the where used. you will get a list. LFA1 is there. This will not always work if the data element name is different than the actual field name in the table.
Of cousre, if you have some idea about the tables, you can just enter the table name and do a "FIND" once the table fields are displayed.
Regards,
Rich Heilman
‎2006 Mar 08 5:24 PM
In a lot of cases, the field names is the same as the data element that is used. In SE11, enter the data elment name ktokk and click the appropriate radiobutton, then click the where used. you will get a list. LFA1 is there. This will not always work if the data element name is different than the actual field name in the table.
Of cousre, if you have some idea about the tables, you can just enter the table name and do a "FIND" once the table fields are displayed.
Regards,
Rich Heilman
‎2006 Mar 08 5:24 PM
Hi,
the field is in table : LFA1.
USe T/code SE11--> Select data type --> enter ktokk and check where used (Tables)
Lanka
‎2006 Mar 08 5:25 PM
Hi,
The best way is to find using Where used List
Goto SE11 ---> Select Data Type radio button and give your field. Select your field and press where-used-list ICON you can get a popup and select only Table fields check box. It will display all the tables where this field exists.
‎2006 Mar 08 5:25 PM
It belongs to LFA1. You can try to go to SE12, enter KTOKK and select the radiobutton for 'Data Element' and then look for 'whereused' in tables.
Srinivas