Create Text Table

[Former Member]

Hi!

Can you please suggest how to create a text table( Containing Desc.) for a transparent table. In Database view I can do so.

Thanks

[Former Member · Accepted solution]

Hi

To create a text table just goto SEll and create table with the same key fields and an additional Key Field SPRAS ( This should be the first key field ). Add a non key field "description" to this table .

Now to enable the linkage of two in te text table create a foreign key relationship to original table with the first key field ( after SPRAS ) and in the cardinality

make it as key field of a text table.

Cheers.

[Former Member · Accepted solution]

Thanks Sanjay. It is working fine. You can put SPRAS field even at last also, it will work. Thanks anyway for the help.

[Former Member]

Hi

If you want to create a Text Table you should to do the following steps:

1) By trx Se11 create your text table with only these fields:

- MANDT --> Data element MANDT (key)

- SPRAS --> Data element SPRAS (Key)

- FIELD --> Your fields (Key)

- TEXT1 --> Data element TEXT20 (short text)

- TEXT2 --> Data element TEXT50 (long text)

2) After creating the text table, assign the foreign key to field key:

- MANDT --> T000

- SPRAS --> T005

- FIELD --> Your master data table TABLE where you

define the value for FIELD

In this case set the flag "Key fields of a

texts table".

Now you have created a text table for yuor table TABLE, if yuo want update the data of TABLE and its text table once, you can create a maintenance view with your TABLE and its TEXT TABLE.

Max

[Former Member]

hi,

Text table is a table which includes language also.

for ex you want to create a text field for XXXXX

fields are to be

mandt keyfield

xxxx key

spras key

description

cheers,

sasi