SAP ABAP Table TRACT_DOCUMENT (Treasury: Accounting Adaptor Document)

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

Table Category	TRANSP	Transparent table
Transparent table	TRACT_DOCUMENT	Table Relationship Diagram
Short Description	Treasury: Accounting Adaptor Document

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	OS_GUID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
3	.INCLUDE	☐				0	0	Treasury: Include Structure for TRAC Documents
4	BUSTRANSID	☐	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
5	DOCUMENTID	☐	TPM_TRDDOCID	SYSUUID	RAW	16	0	Distributor Document ID
6	TR_ACC_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	*
7	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	*
8	AWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
9	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
10	ACPOSTINGDATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
11	ACPOSTINGPERIOD	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
12	ACPOSTINGYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
13	REVERSAL_AWREF	☐	REVERSAL_AWREF	AWREF	CHAR	10	0	Reversal Reference Document Number
14	REVERSAL_AWORG	☐	REVERSAL_AWORG	AWORG	CHAR	10	0	Reversal Reference Organizational Units
15	ACREVERSALDATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
16	ACREVERSALPERIOD	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
17	ACREVERSALYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
18	DOCUMENT_STATE	☐	TPM_TRACDOCSTATE	TPM_TRACDOCSTATE	CHAR	1	0	TRAC Document Status
19	LEDGERSELECTION	☐	TPM_LEDGER_SELECTION	TPM_LEDGER_SELECTION	INT1	3	0	Accounting Ledger Selection
20	SPECIALLEDGER	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	*
21	DOCUMENT_DATE	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
22	ACC_PRINCIPLE	☐	ACCOUNTING_PRINCIPLE	ACCOUNTING_PRINCIPLE	CHAR	4	0	Accounting Principle	*
23	POST_CAT	☐	TPM_TRAC_POST_CATEGORY	TPM_TRAC_POST_CATEGORY	CHAR	1	0	Update to Financial Accounting Indicator
24	CREATE_CAT	☐	TPM_TRAC_CREATE_CATEGORY	TPM_TRAC_CREATE_CATEGORY	CHAR	1	0	Indicator: Generate TRAC Document in Release
25	REF_BUSTRANSID	☐	TPM_REFBUSTRANSID	SYSUUID	RAW	16	0	Business Transaction ID of Reference Business Transaction
26	BUSTRANSCAT	☐	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
27	DEAL_NUMBER	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
28	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
29	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
30	ACREVERSALREASON	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal	*
31	TR_REV_REASON	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	*
32	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
33	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
34	USER_NDATA_CLS	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
35	USER_NDATA_OID	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRGT_USER_DATA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRACT_DOCUMENT	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT	REF	1	CN
2	TRACT_DOCUMENT	MANDT	T000	MANDT	KEY	1	CN
3	TRACT_DOCUMENT	USER_NDATA_OID	TRGT_USER_DATA	OS_GUID	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in