‎2007 Oct 12 7:38 PM
plzzzzz tell what is text table . how to create it . what is the use of it ?
pls tell me the names of some std text tables.?
‎2007 Oct 12 7:44 PM
hi,
Hi check these links..... u can find lot of info......
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ea9e446011d189700000e8322d00/frameset.htm
http://sap.ittoolbox.com/groups/technical-functional/sap-dev/text-table-config-1317339#
here is a brief description:
In general the text table's name will be "T" attached as the last character for the actual table name...
Check TSTC table ... The text table for this is TSTCT
This Text table contains the Key same as the main table with an Extra field Language as key...
The contents of this table are the texts for the field values....
For example take a field value SE38 in the table TSTC....
The text for this is SBAP Editor !!! This text is maintained in the table TSTCT....
To create a text table just goto SE11 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
‎2007 Oct 12 7:44 PM
Hi,
In general the text table's name will be "T" attached as the last character for the actual table name.
For example, TSTC table ... The text table for this is TSTCT.
This Text table contains the Key same as the main table with an Extra field Language as key ... The contents of this table are the texts for the field values ...
For example take a field value SE38 in the table TSTC ...
The text for this is SBAP Editor !!! This text is maintained in the table TSTCT ...
Regards,
Ferry Lianto