Table Link Issue

Former Member — Fri, 01 Dec 2006 06:49:04 GMT

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

Re: Table Link Issue

Former Member — Fri, 01 Dec 2006 07:02:56 GMT

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

topic Re: Table Link Issue in Application Development and Automation Discussions

Table Link Issue

Re: Table Link Issue