topic Re: Text tables in Application Development and Automation Discussions

Text tables

Former Member — Thu, 02 Mar 2006 06:35:18 GMT

Hi All!

I had a doubt and if anybody can explain me.

I had noticed that for every check table there is a text table attached to it with extension T.Suppose check table is TVV5 and the text table is TVV5T.

What is the necessity for this.If anybody can explain mw it will be of great help.

Regrads

Pavan

Re: Text tables

Former Member — Thu, 02 Mar 2006 06:40:35 GMT

These text tables are used to store information specific to the language.

You can see a SPRSL or Language Key field for the table.

You can choose language and seee descriptions on that one....

Re: Text tables

Former Member — Thu, 02 Mar 2006 06:44:14 GMT

Hi Pavan,

Check table with text table

You can define a text table [Ext.] for a table. If the check table for a field has a text table

defined for it, the input help displays both the key fields from the check table and the

corresponding text from the text table in the user’s logon language.

Regards,

sudheer.

Re: Text tables

Former Member — Thu, 02 Mar 2006 06:44:38 GMT

Hi Wenceslaus!

Can u please explain me what the following code does.I took it from SAP standard program.

IF KNVV-KVGR5 EQ SPACE.

CLEAR TVV5T.

ELSE.

IF TVV5T-SPRAS NE SY-LANGU

OR TVV5T-KVGR5 NE KNVV-KVGR5.

SELECT SINGLE * FROM TVV5T WHERE SPRAS = SY-LANGU

AND KVGR5 = KNVV-KVGR5.

IF SY-SUBRC NE 0.

CLEAR TVV5T.

ENDIF.

regards

Pavan

Re: Text tables

Former Member — Thu, 02 Mar 2006 06:46:17 GMT

Hi Kumar,

Every Tavle with a T at the end , as You mentioned is the text table..

descriptions in R/3 are stored in special language-dependent tables called text tables.

A text table is a table that contains spoken-language descriptions of values in a check table.

These descriptions are stored in multiple languages. The primary key of the text table is the same as the primary key of the check table, with the addition of a spras (language) column

The primary key of any text table is composed of the fields mandt and spras, followed by the validation field (or fields)....

One or more description fields follow this primary key...

regards

satesh

Re: Text tables

Former Member — Thu, 02 Mar 2006 06:48:23 GMT

Hi,

read this SAP help on Text tables..

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ea9e446011d189700000e8322d00/content.htm

Regards

vijay

Re: Text tables

Former Member — Thu, 02 Mar 2006 06:48:55 GMT

Hi Kumar,

The code checks the user login language SY-LANGU

If they are not equal it then retrieves data (a single record) from the table for the user login language for the customer group 5.

Re: Text tables

Former Member — Thu, 02 Mar 2006 06:49:58 GMT

hi there ,

yeah good question .

see tvv5 has a text table tvv5t and if u notice there is one more filed called spras language.

a material can be called with different name in different languages . the same matrial text hav to be in different languages so that when a person based on his login can see the material name.

if i want to validate the same material text in language

check in the same table TVV5T giving de ,gr as login languages .

if not then look in to mara-matnr and makt-matnr, makt-matnr makt-spras as the primary key.

in the table TVV5T u will unerstand this as y he gave spras as primary key this is the reason.

vijay.

Re: Text tables

Former Member — Thu, 02 Mar 2006 06:51:51 GMT

hi kumar,

in your code , as SPRAS in a key field in a text table as i've already mentioned , you select a value from that table based on a field of another table .. which is corresponding to your SY-LANGU..

and then populate it into an itab..

regards

satesh

Re: Text tables

Former Member — Thu, 02 Mar 2006 08:03:03 GMT

A text table is a table that contains spoken-language descriptions of values in a check table. These descriptions are stored in multiple languages. The primary key of the text table is the same as the primary key of the check table, with the addition of a spras (language) column.

The R/3 system supports multiple spoken languages, and thus enables users to sign on using the language of their choice. Because of this, descriptions in R/3 are stored in special language-dependent tables called text tables.

FOR MORE DOCUMENTATION PLEASE GO THROUGH THE LINK

<a href="http://cma.zdnet.com/book/abap/ch04/ch04.htm">http://cma.zdnet.com/book/abap/ch04/ch04.htm</a>

IF THIS IS USEFUL PLEASE REWARD POINTS

REGARDS

ANOOP

Message was edited by: ANOOP R.S

Re: Text tables

Former Member — Thu, 02 Mar 2006 08:07:56 GMT

Language depended text will be stored in that text table.

Re: Text tables

Former Member — Thu, 02 Mar 2006 08:13:09 GMT

Hi kumar,

1. text table

R/3 software of sap

can be used in various countries

and VARIOUS LANGUAGES.

2. So, wherever the LANGUAGE /TEXT

part comes into picture,

there needs to be some EXTRA facility.

(so that multi-lingual operation can be done)

3. For the same reason,

ALL TEXTS are stored in

a separate TABLE (suffix with T most of the times)

4. Hence there is :

MAINTABLE , TEXTTABLE.

5 The relation is :

one -

>many

6. This way, only that text is picked up

which is in the logon language.

regards,

amit m.