topic Re: text table in Application Development and Automation Discussions

text table

Former Member — Mon, 29 Jan 2007 20:08:20 GMT

what makes a text table?

Re: text table

Former Member — Mon, 29 Jan 2007 20:11:15 GMT

HI Darshdeep,

Can you elaborate?

AFAIK, the language field is a must and the other key field must belong to the object which it decsribes.

Regards,

Ravi

Re: text table

Former Member — Mon, 29 Jan 2007 20:31:38 GMT

Hi,

A Text Table will always contain a language field. Also, normally it will have the same name except 'T' will be post fixed. For e.g. Table TSTC has a text table TSTCT.

Reward points if the answer is helpful.

Regards,

Mukul

Re: text table

Former Member — Mon, 29 Jan 2007 21:40:46 GMT

Hi,

Table A is a text table of table B if the key of A comprises the key of B and an additional language key field (field of data type LANG). Table A may therefore contain explanatory text in several languages for each key entry of B.

To link the key entries with the text, text table A must be linked with table B using a foreign key. Key fields of a text table must be selected here for the type of foreign key fields

If table B is the check table of a field, the existing key entries of table B are displayed as possible input values when the input help (F4) is pressed. The explanatory text (contents of the first character-like non-key-field of text table A) is also displayed in the user's logon language for each key value in table B.

Only one text table can be created for table B! The system checks this when you attempt to activate a table with text foreign keys for B.

I hope this answers your quesiton.

Regards,

Vara