topic Re: interesting table in Application Development and Automation Discussions

interesting table

Former Member — Thu, 09 Nov 2006 07:59:11 GMT

Hai..

I have found a database table with two fields but when i see the entries of the table ,i found three fields...Can any one say me what is the reason for it..

regards,

Jhansi

Re: interesting table

Former Member — Thu, 09 Nov 2006 08:02:12 GMT

It has a text table, check is se11 table <yourtable>T or something like <your table>* and T at the end.

If a certain table has a text table, the text column from text table is displayed while displaing entries of main table via se11

Message was edited by: Tomasz Kozerski

Re: interesting table

Former Member — Thu, 09 Nov 2006 08:02:19 GMT

hi,

is it a sap std table or user defined table?

Re: interesting table

Former Member — Thu, 09 Nov 2006 08:06:04 GMT

its sap standard table...

Re: interesting table

Former Member — Thu, 09 Nov 2006 08:37:47 GMT

Hai,

Tomasz kozerski

Thank you very much for the reply...Can you please say me what should i do to know whether a table has a text table..

Regards,

Jhansi

Re: interesting table

Former Member — Thu, 09 Nov 2006 08:42:17 GMT

The link between main table and text table is defined via foreign keys.

Check this link to learn more:

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

Re: interesting table

Former Member — Thu, 09 Nov 2006 08:46:26 GMT

Hi Jhansikiran

SAP by default checks the texts table if any exist and display the text for the corresponding fields. This is same even when we use SAP Query tool.

Please check FM: <b>TABLE_GET_TEXTTABLE</b> for the same.

Kind Regards

Eswar