text tables

[Former Member]

hi, I noticed in SAP sometimes it is hard to find text tables, mean the tables that store the text value for certain values in the system, example for p0001-gsber which is business area, if you retrieve p0001-gsber you get the number value of the business area, when I go to pa0001 it shows the table that the business area is related to I go there and there is a text field but it is not accesible b/c it is not shown in se11 on the pa0001 structure. I notice this for a lot of fields.

examples field that I am looking for text for:

p0009-bankl - Bank

p0000-massg

p0001-gsber - business area

p0002-famst - marital status

pretty much it, is there any easy way to find the text table for different fields in sap, or does anyone know some of the tables for these.

thanks

[Former Member]

The normal mechanism is.......

In SE11 look for the <b>check table</b> column, double click on the check table, this will take you to the table against which this field is validated (foreign key). Now from the menu select <b>Goto -> Text Table</b>.

This will give you the text table.

In many cases the values are stored in the domain for this you have to go to the <b>Value Range</b> tab in the domain, tables involved are <b>DD07L and DD07T</b>.

Now in some cases, the check table is not defined for the table field. This is when experience comes in handy..

e.g.

PA0001-GSBER, text table is TGSBT.

Try it for the other fields.

Now there is one exception here, PA0009-BANKL or P0009-BANKL, the Bank names are managed using Central Address Management. (However you may find the name in BNKA itself if the record is not managed using Central Address Management)

The Table for BANKL is BNKA, in ther you will find BNKA-ADRNR, use this number to go to ADRC to get the Bank address and name (ADRC-NAME1)

Phew!

Rishi