table

[Former Member]

what is text table ,value table ,logtable?

thanks

[jayanthi_jayaraman]

Hi,

Table A is text table of table B if A contains additional key field f2 inaddition to A's key field f1.

Value table is a table which is used for domain level setting.

Logtable,I guess is to collect the changes made.

Message was edited by:

Jayanthi Jayaraman

[Former Member]

Text Table

Table A is a text table of table B if the key of A comprises the key of B and an additional language key field (field of data type LANG). Table A may therefore contain explanatory text in several languages for each key entry of B.

pls refer to this SAP Help link :

http://help.sap.com/saphelp_erp2005vp/helpdata/en/cf/21ea9e446011d189700000e8322d00/frameset.htm

[Former Member]

for the performanance issue Instead of writting the data changes directly to the database as soon as any changes made,

the changes are logged into the table at the application server and when the commit work occurs, the changes logged into log table are transferred to Database server.

for the log table function modules update work (se 37-->FM attribute) are required.

[Former Member]

hi

a text table is used to store the texts of a master table.

for example, table TVAK is the table which stores the sales document types. but the texts for the sales documents are stored in a different table which is called text table.

for TVAK, the text table is TVAKT.

and log table is which stores the information about the change of the data in table.

hope this info helps u

thanks

pavan

[Former Member]

Hi Maya,

Text table is used to store all descriptions in all languages with including all key fields of another table.

E.G. DD03T is text table of DD03L.

Value table will give the reference of all values to another table field. i.e it works as foriegn key table.

E.G. T001 table has value table of field BUKRS.

Log table will stores all log values of table.

E.G. I hope tcode SCU03 will helps in this aspect.

Regards

Bhupal Reddy