Skip to Content
author's profile photo Former Member
Former Member

Creation of text table

Hello everybody,

I have created a text table :

the table zsocietes with the field ((mandt - socid as keys , and other fields)

the text table zsocietesT with the field ((mandt - socid , SPRAS as keys , and desc for decription)

after i have linked mandt and socid of table zsocietesT by foreign key ( text table ) of zsocietes.

Know the system know that the text table of my table is zsocietesT goood

THe Problem is i am supposed when i display zsocietes i will see in the dictionnary the column desc attached to my original table in the langage that i am working ( we suppose that i filled the ZsocietesT with at least one entry with description in (FR & EN) .

i didn't see any column in my original table (i supposed to see desc in this table).

thanks for your response.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2011 at 01:36 PM


    Did you maintain the cardinality/ Foreign Key field type properly? I mean the Foreign key field type "Key fields of a text table" radiobutton should be selected and make sure you put the foreign key in the text table.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      I've just created a table and its text table for a my developoment (I haven't yet generated maintenance program for SM30)

      When I defined the text table I've inserted:

      MANDT (foreign key with T000), key field

      SPRAS (foreign key with T002), key field

      <my field> (foreign key with my z-table, checked text table, cardinality 1:CN), key field

      descr (domain BEZEI40)

      Now I see the record of my z-table by SE16 I can see the descr field of text table


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.