topic Re: Text table in Application Development and Automation Discussions

Text table

Former Member — Tue, 11 May 2010 09:37:05 GMT

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

Re: Text table

former_member194669 — Tue, 11 May 2010 09:39:56 GMT

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

a®

Re: Text table

Former Member — Tue, 11 May 2010 09:42:57 GMT

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

Re: Text table

former_member224404 — Tue, 11 May 2010 09:44:12 GMT

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

Re: Text table

Former Member — Tue, 11 May 2010 09:45:50 GMT

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

Re: Text table

Former Member — Tue, 11 May 2010 10:12:16 GMT

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

Re: Text table

Former Member — Tue, 11 May 2010 10:15:26 GMT

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

Regards

Vinod

Re: Text table

Former Member — Tue, 11 May 2010 10:25:06 GMT

thanks all for your replies