SAP ABAP View TRACV_ACCITEM (Posting lines)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-AC (Application Component) Transfer to Financial Accounting
     ⤷ FTR_ACCOUNTING_ADAPTOR (Package) CFM TM: Accounting Adaptor

Basic Data

View Type	D	Database View
Database View	TRACV_ACCITEM
Short Description	Posting lines
Root table	TRACT_ACCITEM	Accounting Items

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRACT_ACCITEM	TRACT_ACCITEM
2	TRACT_DOCUMENT
3	TRACT_POSCONTEXT
4	DIFT_POS_IDENT
5	TRGT_USER_DATA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRACT_DOCUMENT	MANDT	JL	EQ				0	0
2	TRACT_ACCITEM	MANDT	JR	EQ			AND	0	0
3	TRACT_DOCUMENT	OS_GUID	JL	EQ				0	0
4	TRACT_ACCITEM	DOCUMENT_GUID	JR	EQ			AND	0	0
5	TRACT_POSCONTEXT	MANDT	JL	EQ				0	0
6	TRACT_ACCITEM	MANDT	JR	EQ			AND	0	0
7	TRACT_POSCONTEXT	OS_GUID	JL	EQ				0	0
8	TRACT_ACCITEM	PC_GUID	JR	EQ			AND	0	0
9	DIFT_POS_IDENT	MANDT	JL	EQ				0	0
10	TRACT_POSCONTEXT	MANDT	JR	EQ			AND	0	0
11	DIFT_POS_IDENT	OS_GUID	JL	EQ				0	0
12	TRACT_POSCONTEXT	POS_IDENTIF_OID	JR	EQ			AND	0	0
13	TRGT_USER_DATA	MANDT	JL	EQ				0	0
14	TRACT_DOCUMENT	MANDT	JR	EQ			AND	0	0
15	TRGT_USER_DATA	OS_GUID	JL	EQ				0	0
16	TRACT_DOCUMENT	USER_NDATA_OID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TRACT_ACCITEM	MANDT		☐	MANDT	☐	Client
2	DOCUMENT_GUID	TRACT_ACCITEM	DOCUMENT_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
3	ITEM_NUMBER	TRACT_ACCITEM	ITEM_NUMBER		☐	POSNR_ACC	☐	Accounting Document Line Item Number
4	OS_GUID_PI	DIFT_POS_IDENT	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
5	OS_GUID_PC	TRACT_POSCONTEXT	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
6	OS_GUID_UD	TRACT_DOCUMENT	USER_NDATA_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
7	DIS_FLOWTYPE	TRACT_ACCITEM	DIS_FLOWTYPE		☐	TPM_DIS_FLOWTYPE	☐	Update Type
8	SZART	TRACT_ACCITEM	SZART		☐	TPM_SZART	☐	Payment Transaction
9	ACC_SYMBOL	TRACT_ACCITEM	ACC_SYMBOL		☐	TPM_ACC_SYMBOL	☐	Account Symbol for Account Assignment Reference
10	AA_REF	TRACT_ACCITEM	AA_REF		☐	TPM_AA_REF	☐	Account Assignment Reference of Position Management
11	POSTING_CAT	TRACT_ACCITEM	POSTING_CAT		☐	TPM_POSTING_CAT	☐	Posting Category
12	POSTING_KEY	TRACT_ACCITEM	POSTING_KEY		☐	BSCHL	☐	Posting Key
13	GL_ACCOUNT	TRACT_ACCITEM	GL_ACCOUNT		☐	SAKNR	☐	G/L Account Number
14	POSITION_AMT	TRACT_ACCITEM	POSITION_AMT		☐	TPM_FOREIGN_AMT	☐	Amount in Transaction Currency
15	POSITION_CURR	TRACT_ACCITEM	POSITION_CURR		☐	TPM_FOREIGN_CURR	☐	Transaction Currency
16	LOCAL_AMT	TRACT_ACCITEM	LOCAL_AMT		☐	TPM_LOCAL_AMT	☐	Amount in Local Currency
17	LOCAL_CURR	TRACT_ACCITEM	LOCAL_CURR		☐	TPM_LOCAL_CURR	☐	Local Currency
18	AWREF	TRACT_DOCUMENT	AWREF		☐	AWREF	☐	Reference document number
19	AWORG	TRACT_DOCUMENT	AWORG		☐	AWORG	☐	Reference organisational units
20	ACPOSTINGDATE	TRACT_DOCUMENT	ACPOSTINGDATE		☐	BUDAT	☐	Posting Date in the Document
21	ACPOSTINGPERIOD	TRACT_DOCUMENT	ACPOSTINGPERIOD		☐	MONAT	☐	Fiscal period
22	ACPOSTINGYEAR	TRACT_DOCUMENT	ACPOSTINGYEAR		☐	GJAHR	☐	Fiscal Year
23	DOCUMENT_STATE	TRACT_DOCUMENT	DOCUMENT_STATE		☐	TPM_TRACDOCSTATE	☐	TRAC Document Status
24	SPECIALLEDGER	TRACT_DOCUMENT	SPECIALLEDGER		☐	RLDNR	☐	Ledger
25	CONTEXT	DIFT_POS_IDENT	CONTEXT		☐	DIF_IDENT_CONTEXT	☐	Context for Identifier
26	VALUATION_AREA	DIFT_POS_IDENT	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
27	COM_VAL_CLASS	DIFT_POS_IDENT	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
28	VALUATION_CLASS	DIFT_POS_IDENT	VALUATION_CLASS		☐	TPM_VAL_CLASS	☐	Valuation Class
29	ACCOUNTING_CODE	DIFT_POS_IDENT	ACCOUNTING_CODE		☐	TPM_ACC_CODE	☐	Accounting Code
30	COMPANY_CODE	DIFT_POS_IDENT	COMPANY_CODE		☐	BUKRS	☐	Company Code
31	PRODUCT_TYPE	DIFT_POS_IDENT	PRODUCT_TYPE		☐	VVSART	☐	Product Type
32	SECURITY_ACCOUNT	DIFT_POS_IDENT	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
33	SECURITY_ID	DIFT_POS_IDENT	SECURITY_ID		☐	VVRANLW	☐	Security ID Number
34	PORTFOLIO	DIFT_POS_IDENT	PORTFOLIO		☐	TPM_PORTFOLIO_DIFF	☐	Portfolio as Differentiation Characteristic
35	ACCOUNT_GROUP	DIFT_POS_IDENT	ACCOUNT_GROUP		☐	TPM_SEC_ACCT_GRP	☐	Securities Account Group
36	LOANS_CONTRACT	DIFT_POS_IDENT	LOANS_CONTRACT		☐	RANL	☐	Contract Number
37	POSITION_ACCOUNT	DIFT_POS_IDENT	POSITION_ACCOUNT		☐	TPM_POS_ACCOUNT_FUT	☐	Futures Account for Listed Options and Futures
38	DEAL_NUMBER	DIFT_POS_IDENT	DEAL_NUMBER		☐	TB_RFHA	☐	Financial Transaction
39	CREATE_NAME	TRGT_USER_DATA	CREATE_NAME		☐	RERF	☐	Entered by
40	CREATE_DATE	TRGT_USER_DATA	CREATE_DATE		☐	DERF	☐	First Entered on
41	CHANGE_NAME	TRGT_USER_DATA	CHANGE_NAME		☐	RBEAR	☐	Employee ID
42	CHANGE_DATE	TRGT_USER_DATA	CHANGE_DATE		☐	DBEAR	☐	Last Edited on
43	ACREVERSALDATE	TRACT_DOCUMENT	ACREVERSALDATE		☐	BUDAT	☐	Posting Date in the Document
44	ACREVERSALPERIOD	TRACT_DOCUMENT	ACREVERSALPERIOD		☐	MONAT	☐	Fiscal period
45	ACREVERSALYEAR	TRACT_DOCUMENT	ACREVERSALYEAR		☐	GJAHR	☐	Fiscal Year
46	TRDFLOWNR	TRACT_ACCITEM	TRDFLOWNR		☐	TPM_TRDFLOWNR	☐	Number of a Distributor Flow
47	DOCUMENT_DATE	TRACT_DOCUMENT	DOCUMENT_DATE		☐	BLDAT	☐	Document Date in Document
48	ACC_PRINCIPLE	TRACT_DOCUMENT	ACC_PRINCIPLE		☐	ACCOUNTING_PRINCIPLE	☐	Accounting Principle
49	REVERSAL_AWREF	TRACT_DOCUMENT	REVERSAL_AWREF		☐	REVERSAL_AWREF	☐	Reversal Reference Document Number
50	REVERSAL_AWORG	TRACT_DOCUMENT	REVERSAL_AWORG		☐	REVERSAL_AWORG	☐	Reversal Reference Organizational Units
51	BUSTRANSID	TRACT_DOCUMENT	BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
52	BUSTRANSCAT	TRACT_DOCUMENT	BUSTRANSCAT		☐	TPM_BUSTRANSCAT	☐	Business Transaction Category
53	BKTXT	TRACT_DOCUMENT	BKTXT		☐	BKTXT	☐	Document Header Text
54	XBLNR	TRACT_DOCUMENT	XBLNR		☐	XBLNR1	☐	Reference Document Number
55	BLART	TRACT_ACCITEM	BLART		☐	BLART	☐	Document type
56	PAYMENT_DATE	TRACT_ACCITEM	PAYMENT_DATE		☐	TPM_PAYMENT_DATE	☐	Payment Date
57	KUNNR	TRACT_ACCITEM	KUNNR		☐	KUNNR	☐	Customer Number
58	ZTERM	TRACT_ACCITEM	ZTERM		☐	DZTERM	☐	Terms of payment key
59	ZLSCH	TRACT_ACCITEM	ZLSCH		☐	DZLSCH	☐	Payment method
60	UZAWE	TRACT_ACCITEM	UZAWE		☐	UZAWE	☐	Payment method supplement
61	ZLSPR	TRACT_ACCITEM	ZLSPR		☐	DZLSPR	☐	Payment Block Key
62	RPBANK_TRAC	TRACT_ACCITEM	RPBANK		☐	TB_RPBANK	☐	Partner bank details
63	HOUSE_BANK_TRAC	TRACT_ACCITEM	HOUSE_BANK		☐	TB_RHABKI	☐	Short key for own house bank
64	LZBKZ	TRACT_ACCITEM	LZBKZ		☐	LZBKZ	☐	State central bank indicator
65	LANDL	TRACT_ACCITEM	LANDL		☐	LANDL	☐	Supplying Country
66	ALLOCNR	TRACT_ACCITEM	ALLOCNR		☐	DZUONR	☐	Assignment number
67	SGTXT	TRACT_ACCITEM	SGTXT		☐	SGTXT	☐	Item Text
68	GSBER	TRACT_ACCITEM	GSBER		☐	GSBER	☐	Business Area
69	KOSTL	TRACT_ACCITEM	KOSTL		☐	KOSTL	☐	Cost Center
70	RMVCT	TRACT_ACCITEM	RMVCT		☐	RMVCT	☐	Transaction type
71	VBUND	TRACT_ACCITEM	VBUND		☐	VBUND	☐	Company ID
72	KONTRAHENT	TRACT_ACCITEM	KONTRAHENT		☐	TB_KUNNR_NEW	☐	Business Partner Number
73	ISSUER	TRACT_ACCITEM	ISSUER		☐	REPKE_NEW	☐	Issuer Identity Key
74	TR_REV_REASON	TRACT_DOCUMENT	TR_REV_REASON		☐	SSTOGRD	☐	Reason for Reversal
75	ACREVERSALREASON	TRACT_DOCUMENT	ACREVERSALREASON		☐	STGRD	☐	Reason for Reversal
76	BELNR	TRACT_ACCITEM	BELNR		☐	BELNR_D	☐	Accounting Document Number
77	REVERSAL_BELNR	TRACT_ACCITEM	REVERSAL_BELNR		☐	BELNR_D	☐	Accounting Document Number
78	DEAL_NUMBER_TM	TRACT_DOCUMENT	DEAL_NUMBER		☐	TB_RFHA	☐	Financial Transaction
79	POST_CAT	TRACT_DOCUMENT	POST_CAT		☐	TPM_TRAC_POST_CATEGORY	☐	Update to Financial Accounting Indicator
80	CREATE_CAT	TRACT_DOCUMENT	CREATE_CAT		☐	TPM_TRAC_CREATE_CATEGORY	☐	Indicator: Generate TRAC Document in Release
81	BUZEI	TRACT_ACCITEM	BUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
82	RPZAHL	TRACT_ACCITEM	RPZAHL		☐	TB_RPZAHL_NEW	☐	Payer/payee
83	HOUSE_BANK_ACC	TRACT_ACCITEM	HOUSE_BANK_ACC		☐	TB_RHKTID	☐	Short key for house bank account
84	SIGN	TRACT_ACCITEM	SIGN		☐	TB_SSIGN	☐	Direction of flow
85	FLAG_LONG_SHORT	DIFT_POS_IDENT	FLAG_LONG_SHORT		☐	TPM_FLAG_LONG_SHORT	☐	Indicator: Long or Short Position

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	462_10