Table Link Issue

[Former Member]

Hi,

Please help me to find out a way to design a table, which displays some fields of a another table only when viewing the record from se11. Below is an example using standard tables.

In "T005" table the last field is "SUREG" ( u can see it in SE11), then see the contents (CtrlShiftF10), then execute (F8), then double click on one record. It displays the content of the record, go to the down and see, there are some fields below to the field "SUREG". But thoes are not defined in "T005" table, but thoes are in table "T005T".

So "T005" has designed to pick and show the particular records from "T005T" according to the "LAND1" field. I want to do the same thing to a table designed. Can someone pls help me to design it.

Thanks.

Sam

[Former Member]

Hi Sam

The linkage is called TEXT TABLE.

For doing this:

1. Create the main table.

2. Create the reference table, with texts for the field.

3. Define the Foreign Key relation ship in the second table for the field with Foreign Key field type as <b>Key fields of a text table</b>.

4. Activate

Kind Regards

Eswar