topic Re: How to create Text Tables and Value Tables ? in Application Development and Automation Discussions

How to create Text Tables and Value Tables ?

Former Member — Wed, 13 Jun 2007 20:58:03 GMT

Hi all,

How we can create the Text Table ? Step by Step

How we can create the Value Table ? Step by Step

Note : I am not asking about the creation of simple transparant table ...

Thanks In advance.

How to use Text tables ?

With Example Please..

Thanks in advance.

Regards.

Raj

Re: How to create Text Tables and Value Tables ?

Former Member — Wed, 13 Jun 2007 21:00:40 GMT

Hi Raj,

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.

Regards

Aneesh.

Re: How to create Text Tables and Value Tables ?

Former Member — Wed, 13 Jun 2007 21:03:51 GMT

Hi,

<b> Text table</b> - If you want to create TEXT table for any table then just need to create table with the key fields of the other table along with that we need to create 2 more fields - those are language field & description.

<b>Value table</b> - Any table can be attached as value table for the table, only thing is field relations should be there in that table.

Regards,

*DJ

Reward, if its useful

Re: How to create Text Tables and Value Tables ?

Former Member — Wed, 13 Jun 2007 21:09:39 GMT

Raj,

Just see the tables MARA and MAKT you will get to know how to create text tables.

The only inportant things to take care of are:

1. Include SPRAS and Description fields

2. Make sure to fill in the check table.

Let us know if u need more help.

Rgds,

Naren

Message was edited by:

Naren Someneni