SAP ABAP Table TRACV_ACCITEM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	TRACV_ACCITEM	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	OS_GUID_PI	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
5	OS_GUID_PC	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
6	OS_GUID_UD	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRGT_USER_DATA
7	DIS_FLOWTYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type	TRDC_DFLOWTYPE
8	SZART	☐	TPM_SZART	XFELD	CHAR	1	0	Payment Transaction
9	ACC_SYMBOL	☐	TPM_ACC_SYMBOL	TPM_ACC_SYMBOL	CHAR	16	0	Account Symbol for Account Assignment Reference	TRAC_ACCSYMB
10	AA_REF	☐	TPM_AA_REF	TPM_AA_REF	CHAR	12	0	Account Assignment Reference of Position Management
11	POSTING_CAT	☐	TPM_POSTING_CAT	TPM_POSTING_CAT	INT1	3	0	Posting Category
12	POSTING_KEY	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key
13	GL_ACCOUNT	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number
14	POSITION_AMT	☐	TPM_FOREIGN_AMT	TPM_AMOUNT	CURR	21	2	Amount in Transaction Currency
15	POSITION_CURR	☐	TPM_FOREIGN_CURR	WAERS	CUKY	5	0	Transaction Currency
16	LOCAL_AMT	☐	TPM_LOCAL_AMT	TPM_AMOUNT	CURR	21	2	Amount in Local Currency
17	LOCAL_CURR	☐	TPM_LOCAL_CURR	WAERS	CUKY	5	0	Local Currency
18	AWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
19	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
20	ACPOSTINGDATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
21	ACPOSTINGPERIOD	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
22	ACPOSTINGYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
23	DOCUMENT_STATE	☐	TPM_TRACDOCSTATE	TPM_TRACDOCSTATE	CHAR	1	0	TRAC Document Status
24	SPECIALLEDGER	☐	RLDNR	RLDNR	CHAR	2	0	Ledger
25	CONTEXT	☐	DIF_IDENT_CONTEXT	DIF_IDENT_CONTEXT	CHAR	3	0	Context for Identifier
26	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
27	COM_VAL_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
28	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	TRGC_VAL_CLASS
29	ACCOUNTING_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	TRGC_TR_ACC_CODE
30	COMPANY_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
31	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
32	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
33	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
34	PORTFOLIO	☐	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	TWPOB
35	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
36	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number	VDARL
37	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
38	DEAL_NUMBER	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
39	CREATE_NAME	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
40	CREATE_DATE	☐	DERF	DATUM	DATS	8	0	First Entered on
41	CHANGE_NAME	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
42	CHANGE_DATE	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
43	ACREVERSALDATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
44	ACREVERSALPERIOD	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
45	ACREVERSALYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
46	TRDFLOWNR	☐	TPM_TRDFLOWNR	TPM_TRDFLOWNR	INT4	10	0	Number of a Distributor Flow
47	DOCUMENT_DATE	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
48	ACC_PRINCIPLE	☐	ACCOUNTING_PRINCIPLE	ACCOUNTING_PRINCIPLE	CHAR	4	0	Accounting Principle
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	BUSTRANSID	☐	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
52	BUSTRANSCAT	☐	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
53	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
54	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
55	BLART	☐	BLART	BLART	CHAR	2	0	Document type
56	PAYMENT_DATE	☐	TPM_PAYMENT_DATE	TPM_POSITION_DATE	DATS	8	0	Payment Date
57	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number
58	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
59	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method
60	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement
61	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key
62	RPBANK_TRAC	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
63	HOUSE_BANK_TRAC	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank
64	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator
65	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country
66	ALLOCNR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
67	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
68	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area
69	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
70	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type
71	VBUND	☐	VBUND	RCOMP	CHAR	6	0	Company ID
72	KONTRAHENT	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number
73	ISSUER	☐	REPKE_NEW	BU_PARTNER	CHAR	10	0	Issuer Identity Key
74	TR_REV_REASON	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal
75	ACREVERSALREASON	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal
76	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
77	REVERSAL_BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
78	DEAL_NUMBER_TM	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction
79	POST_CAT	☐	TPM_TRAC_POST_CATEGORY	TPM_TRAC_POST_CATEGORY	CHAR	1	0	Update to Financial Accounting Indicator
80	CREATE_CAT	☐	TPM_TRAC_CREATE_CATEGORY	TPM_TRAC_CREATE_CATEGORY	CHAR	1	0	Indicator: Generate TRAC Document in Release
81	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
82	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee
83	HOUSE_BANK_ACC	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account
84	SIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
85	FLAG_LONG_SHORT	☐	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRACV_ACCITEM	ACCOUNTING_CODE	TRGC_TR_ACC_CODE	TR_ACC_CODE
2	TRACV_ACCITEM	ACCOUNT_GROUP	TRGT_SECACCGRP	SEC_ACCT_GRP
3	TRACV_ACCITEM	ACC_SYMBOL	TRAC_ACCSYMB	ACC_SYMBOL		1	CN
4	TRACV_ACCITEM	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT	REF	1	CN
5	TRACV_ACCITEM	COMPANY_CODE	T001	BUKRS
6	TRACV_ACCITEM	COM_VAL_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS
7	TRACV_ACCITEM	DEAL_NUMBER	VTBFHA	RFHA	KEY	1	CN
8	TRACV_ACCITEM	DIS_FLOWTYPE	TRDC_DFLOWTYPE	DIS_FLOWTYPE	KEY	1	CN
9	TRACV_ACCITEM	DOCUMENT_GUID	TRACT_DOCUMENT	OS_GUID
10	TRACV_ACCITEM	LOANS_CONTRACT	VDARL	RANL
11	TRACV_ACCITEM	OS_GUID_UD	TRGT_USER_DATA	OS_GUID	KEY	1	CN
12	TRACV_ACCITEM	PORTFOLIO	TWPOB	RPORTB
13	TRACV_ACCITEM	POSITION_ACCOUNT	TRFT_POS_ACCOUNT	POS_ACCOUNT	KEY	1	CN
14	TRACV_ACCITEM	PRODUCT_TYPE	TZPA	GSART
15	TRACV_ACCITEM	SECURITY_ACCOUNT	TWD01	RLDEPO
16	TRACV_ACCITEM	SECURITY_ID	VWPANLA	RANL
17	TRACV_ACCITEM	VALUATION_AREA	TRGC_VAL_AREA	VALUATION_AREA
18	TRACV_ACCITEM	VALUATION_CLASS	TRGC_VAL_CLASS	VALUATION_CLASS

History

Last changed by/on	SAP	20130529
SAP Release Created in