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
⤷ 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 |