topic Text Table? in Application Development and Automation Discussions

Text Table?

Former Member — Fri, 12 Oct 2007 18:38:24 GMT

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.?

Re: Text Table?

Former Member — Fri, 12 Oct 2007 18:44:10 GMT

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#

;&#56724;

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

Re: Text Table?

ferry_lianto — Fri, 12 Oct 2007 18:44:30 GMT

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