Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.