Table TD07

[Former Member]

Hi all,

When i go to the fields tab i can see 3 fields

MANDT

GSART

SVZWECK

When i go to display the contents i get the below 6 fields

MANDT

GSART

SVZWECK

XTEXT

XKBEZ

XLBEZ

Where are the last 3 fields (XTEXT, XKBEZ, XLBEZ) comming from ?

I cannot find them in the FIELDS tab

Regards

[Former Member]

hai,

the last three fields are coming from table TD07T .

<removed_by_moderator>

Regards

jase

Edited by: Julius Bussche on Jul 14, 2008 5:29 PM

[Former Member]

Hi,

The last tree fields are coming from Table TD07T. The short description of table itself shows that it is linked with TD07.

TD07T-Purpose of loan (Texts for table TD07). i.e XTEXT, XKBEZ, XLBEZ.

<removed_by_moderator>

Regards,

Sharmi.

Edited by: Julius Bussche on Jul 14, 2008 5:29 PM

[Former Member]

Hi Rajvansh.

The two fields:

GSART

SVZWECK

are from the Table TD07 - For loans.

As we know that mostly all tables have a text table.

Hence, The table TD07 is linked to text table TD07T.

The table TD07T has those fields:

GSART

SVZWECK

XTEXT

XKBEZ

XLBEZ

And If you see fields GSART

SVZWECK

are the COMMON KEY FIELDS in both the tables.

You can see the relationship in ENTRY/CHECK window it has TD07 as a check table.

(Please all friends do not mention "Reward points it is not a good practise)

Good Luck & Regards.

Harsh

Edited by: Harsh Dave on Jul 12, 2008 11:08 AM

Edited by: Harsh Dave on Jul 12, 2008 11:09 AM

Edited by: Harsh Dave on Jul 12, 2008 11:11 AM

[Former Member]

Hi Rajvansh Ravi,

U r seeing few more filelds in output but it's not present in the Table field List...

This is due to TEXT TABLE attached with the Table u r looking

There are many tables like this...

It's for facilitating the user to see Text information in the main Table itselfe...

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

http://cma.zdnet.com/book/abap/ch04/ch04.htm

Also have a look on below links...

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/text-table-config-1316232?cv=expanded#

http://sapport.blogspot.com/2007/01/creation-of-text-table-in-abap.html

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

[Former Member]

Thanks all