interesting table

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

hi,

is it a sap std table or user defined table?

[Former Member]

its sap standard table...