Skip to Content
author's profile photo
Former Member

Create Text Table

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Oct 03, 2005 at 12:29 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 03, 2005 at 12:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 03, 2005 at 12:48 PM

    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

    Add comment
    10|10000 characters needed characters exceeded