SAP ABAP View TRACV_ITEM_DATA (Document Item with Position Context)

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_ITEM_DATA
Short Description	Document Item with Position Context
Root table	TRACT_ACCITEM	Accounting Items

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRACT_ACCITEM	TRACT_ACCITEM
2	TRACT_POSCONTEXT
3	DIFT_POS_IDENT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRACT_POSCONTEXT	MANDT	JL	EQ				0	0
2	TRACT_ACCITEM	MANDT	JR	EQ			AND	0	0
3	TRACT_POSCONTEXT	OS_GUID	JL	EQ				0	0
4	TRACT_ACCITEM	PC_GUID	JR	EQ			AND	0	0
5	DIFT_POS_IDENT	MANDT	JL	EQ				0	0
6	TRACT_POSCONTEXT	MANDT	JR	EQ			AND	0	0
7	DIFT_POS_IDENT	OS_GUID	JL	EQ				0	0
8	TRACT_POSCONTEXT	POS_IDENTIF_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	PC_GUID	TRACT_ACCITEM	PC_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
5	DIS_FLOWTYPE	TRACT_ACCITEM	DIS_FLOWTYPE		☐	TPM_DIS_FLOWTYPE	☐	Update Type
6	SZART	TRACT_ACCITEM	SZART		☐	TPM_SZART	☐	Payment Transaction
7	AA_REF	TRACT_ACCITEM	AA_REF		☐	TPM_AA_REF	☐	Account Assignment Reference of Position Management
8	ACC_SYMBOL	TRACT_ACCITEM	ACC_SYMBOL		☐	TPM_ACC_SYMBOL	☐	Account Symbol for Account Assignment Reference
9	POSTING_CAT	TRACT_ACCITEM	POSTING_CAT		☐	TPM_POSTING_CAT	☐	Posting Category
10	POSTING_KEY	TRACT_ACCITEM	POSTING_KEY		☐	BSCHL	☐	Posting Key
11	GL_ACCOUNT	TRACT_ACCITEM	GL_ACCOUNT		☐	SAKNR	☐	G/L Account Number
12	POSITION_AMT	TRACT_ACCITEM	POSITION_AMT		☐	TPM_FOREIGN_AMT	☐	Amount in Transaction Currency
13	POSITION_CURR	TRACT_ACCITEM	POSITION_CURR		☐	TPM_FOREIGN_CURR	☐	Transaction Currency
14	LOCAL_AMT	TRACT_ACCITEM	LOCAL_AMT		☐	TPM_LOCAL_AMT	☐	Amount in Local Currency
15	LOCAL_CURR	TRACT_ACCITEM	LOCAL_CURR		☐	TPM_LOCAL_CURR	☐	Local Currency
16	TRDFLOWNR	TRACT_ACCITEM	TRDFLOWNR		☐	TPM_TRDFLOWNR	☐	Number of a Distributor Flow
17	BELNR	TRACT_ACCITEM	BELNR		☐	BELNR_D	☐	Accounting Document Number
18	REVERSAL_BELNR	TRACT_ACCITEM	REVERSAL_BELNR		☐	BELNR_D	☐	Accounting Document Number
19	BUZEI	TRACT_ACCITEM	BUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
20	LOGVO	TRACT_ACCITEM	LOGVO		☐	LOGVO	☐	Logical Transaction
21	BLART	TRACT_ACCITEM	BLART		☐	BLART	☐	Document type
22	PAYMENT_DATE	TRACT_ACCITEM	PAYMENT_DATE		☐	TPM_PAYMENT_DATE	☐	Payment Date
23	KUNNR	TRACT_ACCITEM	KUNNR		☐	KUNNR	☐	Customer Number
24	ZTERM	TRACT_ACCITEM	ZTERM		☐	DZTERM	☐	Terms of payment key
25	ZLSCH	TRACT_ACCITEM	ZLSCH		☐	DZLSCH	☐	Payment method
26	UZAWE	TRACT_ACCITEM	UZAWE		☐	UZAWE	☐	Payment method supplement
27	ZLSPR	TRACT_ACCITEM	ZLSPR		☐	DZLSPR	☐	Payment Block Key
28	RPBANK	TRACT_ACCITEM	RPBANK		☐	TB_RPBANK	☐	Partner bank details
29	HOUSE_BANK	TRACT_ACCITEM	HOUSE_BANK		☐	TB_RHABKI	☐	Short key for own house bank
30	LZBKZ	TRACT_ACCITEM	LZBKZ		☐	LZBKZ	☐	State central bank indicator
31	LANDL	TRACT_ACCITEM	LANDL		☐	LANDL	☐	Supplying Country
32	ALLOCNR	TRACT_ACCITEM	ALLOCNR		☐	DZUONR	☐	Assignment number
33	SGTXT	TRACT_ACCITEM	SGTXT		☐	SGTXT	☐	Item Text
34	GSBER	TRACT_ACCITEM	GSBER		☐	GSBER	☐	Business Area
35	KOSTL	TRACT_ACCITEM	KOSTL		☐	KOSTL	☐	Cost Center
36	RMVCT	TRACT_ACCITEM	RMVCT		☐	RMVCT	☐	Transaction type
37	VBUND	TRACT_ACCITEM	VBUND		☐	VBUND	☐	Company ID
38	KONTRAHENT	TRACT_ACCITEM	KONTRAHENT		☐	TB_KUNNR_NEW	☐	Business Partner Number
39	ISSUER	TRACT_ACCITEM	ISSUER		☐	REPKE_NEW	☐	Issuer Identity Key
40	POS_IDENTIF_OID	TRACT_POSCONTEXT	POS_IDENTIF_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
41	COMPANY_CODE	DIFT_POS_IDENT	COMPANY_CODE		☐	BUKRS	☐	Company Code
42	SECURITY_ID	DIFT_POS_IDENT	SECURITY_ID		☐	VVRANLW	☐	Security ID Number
43	DEAL_NUMBER	DIFT_POS_IDENT	DEAL_NUMBER		☐	TB_RFHA	☐	Financial Transaction
44	LOANS_CONTRACT	DIFT_POS_IDENT	LOANS_CONTRACT		☐	RANL	☐	Contract Number
45	VALUATION_CLASS	DIFT_POS_IDENT	VALUATION_CLASS		☐	TPM_VAL_CLASS	☐	Valuation Class
46	PRODUCT_TYPE	DIFT_POS_IDENT	PRODUCT_TYPE		☐	VVSART	☐	Product Type
47	SECURITY_ACCOUNT	DIFT_POS_IDENT	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
48	PORTFOLIO	DIFT_POS_IDENT	PORTFOLIO		☐	TPM_PORTFOLIO_DIFF	☐	Portfolio as Differentiation Characteristic
49	ACCOUNT_GROUP	DIFT_POS_IDENT	ACCOUNT_GROUP		☐	TPM_SEC_ACCT_GRP	☐	Securities Account Group
50	POSITION_ACCOUNT	DIFT_POS_IDENT	POSITION_ACCOUNT		☐	TPM_POS_ACCOUNT_FUT	☐	Futures Account for Listed Options and Futures
51	FLAG_LONG_SHORT	DIFT_POS_IDENT	FLAG_LONG_SHORT		☐	TPM_FLAG_LONG_SHORT	☐	Indicator: Long or Short Position
52	VALUATION_AREA	DIFT_POS_IDENT	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area

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	200