SAP ABAP View TRACV_DOC_ITEM (View of Accounting Adaptor Documents and Accounting Items)

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_DOC_ITEM
Short Description	View of Accounting Adaptor Documents and Accounting Items
Root table	TRACT_ACCITEM	Accounting Items

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRACT_ACCITEM	TRACT_ACCITEM
2	TRACT_DOCUMENT

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				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	ACC_SYMBOL	TRACT_ACCITEM	ACC_SYMBOL		☐	TPM_ACC_SYMBOL	☐	Account Symbol for Account Assignment Reference
7	AA_REF	TRACT_ACCITEM	AA_REF		☐	TPM_AA_REF	☐	Account Assignment Reference of Position Management
8	POSTING_CAT	TRACT_ACCITEM	POSTING_CAT		☐	TPM_POSTING_CAT	☐	Posting Category
9	POSTING_KEY	TRACT_ACCITEM	POSTING_KEY		☐	BSCHL	☐	Posting Key
10	GL_ACCOUNT	TRACT_ACCITEM	GL_ACCOUNT		☐	SAKNR	☐	G/L Account Number
11	POSITION_AMT	TRACT_ACCITEM	POSITION_AMT		☐	TPM_FOREIGN_AMT	☐	Amount in Transaction Currency
12	POSITION_CURR	TRACT_ACCITEM	POSITION_CURR		☐	TPM_FOREIGN_CURR	☐	Transaction Currency
13	LOCAL_AMT	TRACT_ACCITEM	LOCAL_AMT		☐	TPM_LOCAL_AMT	☐	Amount in Local Currency
14	LOCAL_CURR	TRACT_ACCITEM	LOCAL_CURR		☐	TPM_LOCAL_CURR	☐	Local Currency
15	ACPOSTINGDATE	TRACT_DOCUMENT	ACPOSTINGDATE		☐	BUDAT	☐	Posting Date in the Document
16	DOCUMENT_STATE	TRACT_DOCUMENT	DOCUMENT_STATE		☐	TPM_TRACDOCSTATE	☐	TRAC Document Status
17	SZART	TRACT_ACCITEM	SZART		☐	TPM_SZART	☐	Payment Transaction
18	TRDFLOWNR	TRACT_ACCITEM	TRDFLOWNR		☐	TPM_TRDFLOWNR	☐	Number of a Distributor Flow
19	BELNR	TRACT_ACCITEM	BELNR		☐	BELNR_D	☐	Accounting Document Number
20	REVERSAL_BELNR	TRACT_ACCITEM	REVERSAL_BELNR		☐	BELNR_D	☐	Accounting Document Number
21	BUZEI	TRACT_ACCITEM	BUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
22	LOGVO	TRACT_ACCITEM	LOGVO		☐	LOGVO	☐	Logical Transaction
23	BLART	TRACT_ACCITEM	BLART		☐	BLART	☐	Document type
24	PAYMENT_DATE	TRACT_ACCITEM	PAYMENT_DATE		☐	TPM_PAYMENT_DATE	☐	Payment Date
25	KUNNR	TRACT_ACCITEM	KUNNR		☐	KUNNR	☐	Customer Number
26	ZTERM	TRACT_ACCITEM	ZTERM		☐	DZTERM	☐	Terms of payment key
27	ZLSCH	TRACT_ACCITEM	ZLSCH		☐	DZLSCH	☐	Payment method
28	UZAWE	TRACT_ACCITEM	UZAWE		☐	UZAWE	☐	Payment method supplement
29	ZLSPR	TRACT_ACCITEM	ZLSPR		☐	DZLSPR	☐	Payment Block Key
30	RPBANK	TRACT_ACCITEM	RPBANK		☐	TB_RPBANK	☐	Partner bank details
31	HOUSE_BANK	TRACT_ACCITEM	HOUSE_BANK		☐	TB_RHABKI	☐	Short key for own house bank
32	LZBKZ	TRACT_ACCITEM	LZBKZ		☐	LZBKZ	☐	State central bank indicator
33	LANDL	TRACT_ACCITEM	LANDL		☐	LANDL	☐	Supplying Country
34	ALLOCNR	TRACT_ACCITEM	ALLOCNR		☐	DZUONR	☐	Assignment number
35	SGTXT	TRACT_ACCITEM	SGTXT		☐	SGTXT	☐	Item Text
36	GSBER	TRACT_ACCITEM	GSBER		☐	GSBER	☐	Business Area
37	KOSTL	TRACT_ACCITEM	KOSTL		☐	KOSTL	☐	Cost Center
38	RMVCT	TRACT_ACCITEM	RMVCT		☐	RMVCT	☐	Transaction type
39	VBUND	TRACT_ACCITEM	VBUND		☐	VBUND	☐	Company ID
40	KONTRAHENT	TRACT_ACCITEM	KONTRAHENT		☐	TB_KUNNR_NEW	☐	Business Partner Number
41	ISSUER	TRACT_ACCITEM	ISSUER		☐	REPKE_NEW	☐	Issuer Identity Key
42	BUSTRANSID	TRACT_DOCUMENT	BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
43	TR_ACC_CODE	TRACT_DOCUMENT	TR_ACC_CODE		☐	TPM_ACC_CODE	☐	Accounting Code
44	VALUATION_AREA	TRACT_DOCUMENT	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
45	AWREF	TRACT_DOCUMENT	AWREF		☐	AWREF	☐	Reference document number
46	AWORG	TRACT_DOCUMENT	AWORG		☐	AWORG	☐	Reference organisational units
47	ACPOSTINGPERIOD	TRACT_DOCUMENT	ACPOSTINGPERIOD		☐	MONAT	☐	Fiscal period
48	ACPOSTINGYEAR	TRACT_DOCUMENT	ACPOSTINGYEAR		☐	GJAHR	☐	Fiscal Year
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	ACREVERSALDATE	TRACT_DOCUMENT	ACREVERSALDATE		☐	BUDAT	☐	Posting Date in the Document
52	ACREVERSALPERIOD	TRACT_DOCUMENT	ACREVERSALPERIOD		☐	MONAT	☐	Fiscal period
53	ACREVERSALYEAR	TRACT_DOCUMENT	ACREVERSALYEAR		☐	GJAHR	☐	Fiscal Year
54	LEDGERSELECTION	TRACT_DOCUMENT	LEDGERSELECTION		☐	TPM_LEDGER_SELECTION	☐	Accounting Ledger Selection
55	DOCUMENT_DATE	TRACT_DOCUMENT	DOCUMENT_DATE		☐	BLDAT	☐	Document Date in Document
56	ACC_PRINCIPLE	TRACT_DOCUMENT	ACC_PRINCIPLE		☐	ACCOUNTING_PRINCIPLE	☐	Accounting Principle
57	CREATE_CAT	TRACT_DOCUMENT	CREATE_CAT		☐	TPM_TRAC_CREATE_CATEGORY	☐	Indicator: Generate TRAC Document in Release
58	REF_BUSTRANSID	TRACT_DOCUMENT	REF_BUSTRANSID		☐	TPM_REFBUSTRANSID	☐	Business Transaction ID of Reference Business Transaction
59	BUSTRANSCAT	TRACT_DOCUMENT	BUSTRANSCAT		☐	TPM_BUSTRANSCAT	☐	Business Transaction Category
60	DEAL_NUMBER	TRACT_DOCUMENT	DEAL_NUMBER		☐	TB_RFHA	☐	Financial Transaction
61	BKTXT	TRACT_DOCUMENT	BKTXT		☐	BKTXT	☐	Document Header Text
62	XBLNR	TRACT_DOCUMENT	XBLNR		☐	XBLNR1	☐	Reference Document Number
63	ACREVERSALREASON	TRACT_DOCUMENT	ACREVERSALREASON		☐	STGRD	☐	Reason for Reversal
64	TR_REV_REASON	TRACT_DOCUMENT	TR_REV_REASON		☐	SSTOGRD	☐	Reason for Reversal
65	POST_CAT	TRACT_DOCUMENT	POST_CAT		☐	TPM_TRAC_POST_CATEGORY	☐	Update to Financial Accounting Indicator

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