topic Re: table in Application Development and Automation Discussions

table

Former Member — Thu, 30 Nov 2006 06:57:09 GMT

what is text table ,value table ,logtable?

thanks

Re: table

jayanthi_jayaraman — Thu, 30 Nov 2006 07:02:49 GMT

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

Re: table

Former Member — Thu, 30 Nov 2006 07:06:15 GMT

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

Re: table

Former Member — Thu, 30 Nov 2006 07:06:57 GMT

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.

Re: table

Former Member — Thu, 30 Nov 2006 07:09:14 GMT

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

Re: table

Former Member — Thu, 30 Nov 2006 07:11:08 GMT

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