Saturday, March 24, 2012

ABAP: How to assign Text tables

As you know, one can find out the description/text for a particular field from the assigned text table.
E.g Material number (MARA-MATNR) description can be fetched from MAKT table based on foreign key relationships between MARA and MAKT tables.

First check the assigned text table, SE11-> Goto-> Text table and you can find the table name.

Now how to assign the text tables , there is small trick in doing so.
In MARA assign MAKT as text table and in MAKT specify the foreign key relationship on MATNR as : Key fields of a text table and give Cardinality as 1:CN.

Cheers,
Sandeep