How to find a transparent table from structure

[Former Member]

Hi All,

Can anyone tell me how to find the transparent table when got F1 (field help) and technical info button? Sometimes the table specified is not always a transparent table.

For example in XK03 (Vendor Display), in the Street address field, when I hit F1 and goto Tech Info I see ADDR1_DATA as table name. But in fact it's a structure. From This structure how can I find out the transparent table where the data is physically stored?

Thanks in Advance.

[Former Member · Accepted solution]

The address data stored in LFA1

LFA1 Vendor Master (General Section)

LFA1M1 Vendor Master View LFA1 LFM1

LFAS Vendor master (VAT registration numbers ge

LFAT Vendor master record (tax groupings)

LFB1 Vendor Master (Company Code)

LFB5 Vendor master (dunning data)

LFBK Vendor Master (Bank Details)

LFBW Vendor master record (withholding tax type

LFC1 Vendor master (transaction figures)

[Former Member · Accepted solution]

Hi Charlie,

Is there a process u utlize to find transparent tables? For any field (not just Vendor Address data)

What is the best and quickest way to find transparant tablen given any field?

For example, given Field XYZ find the transparent table. How to proceed?

Thanks in advance

Edited by: Duke Dukester on Aug 13, 2008 3:44 PM

[Former Member · Accepted solution]

Go to SE15 adn open the ABAP dictionary folder

Than open fields folder

click on table field

enter the field name and execute

here you will find all the transpernt tables used by this field.

[Former Member · Accepted solution]

Charlie,

THANK you SO much!!!!!

[Former Member]

The best way is to find the data element while in the ABAP Dictionary (for your structure). By double clicking the data element for the field you are looking for, you can see the definition of that data element. You can do a "Where Used" for Tables on this data element and then search through your results. The Address for a Vendor is stored in the LFA1 table.

[Former Member]

Hi Mike,

Is this the only way, I get lots of results when I use "Where-Used" for data element. How do I know which one is the correct transparent table?

[Former Member]

This is the only way that I know of. You can further search results on keywords such as Vendor. It can be long and tedious at times, that is why I gave you the table name as well.