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,

Welcome to SDN.

This is the concept of text table. No need to link anywhere.

If you want to create any table like this.

1. take Add all key of the table i.e.In T005 MANDT,LAND1

2. add two fields : language and Text i.e. SPARS, TEXT

3. Make language as key field

4. Save table as transparent table.

Link two table by specifying key fields.

i.e MANDT.LAND1 from T005T as check table

SPARS from T002 as check table

Regards

Bhupal Reddy

[Former Member]

Hi Sam

Seems you have opened duplicate thread onthe same topic. Kindly close one and proceed with the other to avoid confusion.

Kind Regards

Eswar