Text table

[Former Member]

Hi,

Suppose table 1 is the text table of table2. then this text table will contain exactly the same numebr of keys of table2 or it can contain other key field as well apart from the key field of table1.

thanks

tanmaya

[former_member194669]

Usually Text contains one more additional field SPRAS" as anguage key

a®

[Former Member]

Hi,

Well, the text table will never contain exaclty the same number of keys as the config table, because the key to the text table will always include the language as well.

If it contains other key fields apart from this, one entry in the config table will not relate to one single description, which seens to defeat the purpose of the text table.

Regards,

Nick

[former_member224404]

Hi Tanmaya,

If I think about the definition of a text table then it means a table which will contains various texts in multilingual format for a field.

So if you try to create a text table TT of a field F of table T where F is a primary key, then in TT F and SPRAS(Language) will be primary key apart from MANDT.

It is because the purpose of the text table lies to support multiple language support so you have to create SPRAS(Language) a key to make the entries unique.

E.g. take a look in T002 where T002T is the text table of it.

Thanks,

Mainak

[Former Member]

Hi Tanmaya,

Kindly go through the below link

http://www.google.co.in/search?hl=en&source=hp&q=whatistexttablein+SAP&aq=o&aqi=&aql=&oq=&gs_rfai=

Cheerz

Ram

[Former Member]

hi ,

thanksu all for your reply.

i know that text table also contain language key field and short text field(optional) i m asking is it contain any other key fields apart from the key field of the foreign key table.

suppose a foreign key table have k1 and k2 as a key then text table will definetly have k1,k2, spras(language), short text(optional). apart from these fields can text table have other key field like k3 and k4

thanks

tanmaya

[Former Member]

No, Language (SPRAS) will be the only additonal key in the text table apart from the keys of Parent table

Regards

Vinod

[Former Member]

thanks all for your replies