SAP ABAP Table TRACV_DOC_ITEM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	TRACV_DOC_ITEM	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	DOCUMENT_GUID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRACT_DOCUMENT
3	ITEM_NUMBER	☑	POSNR_ACC	POSNR_ACC	NUMC	10	0	Accounting Document Line Item Number
4	PC_GUID	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRACT_POSCONTEXT
5	DIS_FLOWTYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type	TRDC_DFLOWTYPE
6	ACC_SYMBOL	☐	TPM_ACC_SYMBOL	TPM_ACC_SYMBOL	CHAR	16	0	Account Symbol for Account Assignment Reference	TRAC_ACCSYMB
7	AA_REF	☐	TPM_AA_REF	TPM_AA_REF	CHAR	12	0	Account Assignment Reference of Position Management
8	POSTING_CAT	☐	TPM_POSTING_CAT	TPM_POSTING_CAT	INT1	3	0	Posting Category
9	POSTING_KEY	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key
10	GL_ACCOUNT	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number
11	POSITION_AMT	☐	TPM_FOREIGN_AMT	TPM_AMOUNT	CURR	21	2	Amount in Transaction Currency
12	POSITION_CURR	☐	TPM_FOREIGN_CURR	WAERS	CUKY	5	0	Transaction Currency
13	LOCAL_AMT	☐	TPM_LOCAL_AMT	TPM_AMOUNT	CURR	21	2	Amount in Local Currency
14	LOCAL_CURR	☐	TPM_LOCAL_CURR	WAERS	CUKY	5	0	Local Currency
15	ACPOSTINGDATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
16	DOCUMENT_STATE	☐	TPM_TRACDOCSTATE	TPM_TRACDOCSTATE	CHAR	1	0	TRAC Document Status
17	SZART	☐	TPM_SZART	XFELD	CHAR	1	0	Payment Transaction
18	TRDFLOWNR	☐	TPM_TRDFLOWNR	TPM_TRDFLOWNR	INT4	10	0	Number of a Distributor Flow
19	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
20	REVERSAL_BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
21	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
22	LOGVO	☐	LOGVO	LOGVO	CHAR	6	0	Logical Transaction
23	BLART	☐	BLART	BLART	CHAR	2	0	Document type
24	PAYMENT_DATE	☐	TPM_PAYMENT_DATE	TPM_POSITION_DATE	DATS	8	0	Payment Date
25	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number
26	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
27	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method
28	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement
29	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key
30	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
31	HOUSE_BANK	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank
32	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator
33	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country
34	ALLOCNR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
35	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
36	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area
37	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
38	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type
39	VBUND	☐	VBUND	RCOMP	CHAR	6	0	Company ID
40	KONTRAHENT	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number
41	ISSUER	☐	REPKE_NEW	BU_PARTNER	CHAR	10	0	Issuer Identity Key
42	BUSTRANSID	☐	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
43	TR_ACC_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code
44	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area
45	AWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
46	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
47	ACPOSTINGPERIOD	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
48	ACPOSTINGYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
49	REVERSAL_AWREF	☐	REVERSAL_AWREF	AWREF	CHAR	10	0	Reversal Reference Document Number
50	REVERSAL_AWORG	☐	REVERSAL_AWORG	AWORG	CHAR	10	0	Reversal Reference Organizational Units
51	ACREVERSALDATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
52	ACREVERSALPERIOD	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
53	ACREVERSALYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
54	LEDGERSELECTION	☐	TPM_LEDGER_SELECTION	TPM_LEDGER_SELECTION	INT1	3	0	Accounting Ledger Selection
55	DOCUMENT_DATE	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
56	ACC_PRINCIPLE	☐	ACCOUNTING_PRINCIPLE	ACCOUNTING_PRINCIPLE	CHAR	4	0	Accounting Principle
57	CREATE_CAT	☐	TPM_TRAC_CREATE_CATEGORY	TPM_TRAC_CREATE_CATEGORY	CHAR	1	0	Indicator: Generate TRAC Document in Release
58	REF_BUSTRANSID	☐	TPM_REFBUSTRANSID	SYSUUID	RAW	16	0	Business Transaction ID of Reference Business Transaction
59	BUSTRANSCAT	☐	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
60	DEAL_NUMBER	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction
61	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
62	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
63	ACREVERSALREASON	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal
64	TR_REV_REASON	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal
65	POST_CAT	☐	TPM_TRAC_POST_CATEGORY	TPM_TRAC_POST_CATEGORY	CHAR	1	0	Update to Financial Accounting Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRACV_DOC_ITEM	ACC_SYMBOL	TRAC_ACCSYMB	ACC_SYMBOL		1	CN
2	TRACV_DOC_ITEM	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT	REF	1	CN
3	TRACV_DOC_ITEM	DIS_FLOWTYPE	TRDC_DFLOWTYPE	DIS_FLOWTYPE	KEY	1	CN
4	TRACV_DOC_ITEM	DOCUMENT_GUID	TRACT_DOCUMENT	OS_GUID
5	TRACV_DOC_ITEM	PC_GUID	TRACT_POSCONTEXT	OS_GUID	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in