TRACT_DOCUMENT

Transparent Table Application Table
34 Fields 2 CDS Views

Treasury: Accounting Adaptor Document

TRACT_DOCUMENT is an SAP database table in S/4HANA. Treasury: Accounting Adaptor Document. It contains 34 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TrsyAccountingItemDocument view from BASIC Treasury Accounting Item Document
P_TractDocument view from BASIC

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY os_guid TPM_DB_OS_GUID DB Object ID
bustransid TPM_BUSTRANSID Bus. Trans. ID
documentid TPM_TRDDOCID Routing slip doc. ID
tr_acc_code TPM_ACC_CODE Accounting Code
valuation_area TPM_VAL_AREA Valuation Area
awref AWREF Reference Doc.
aworg AWORG Refer. Org.Unit
acpostingdate BUDAT Posting Date
acpostingperiod MONAT Period
acpostingyear GJAHR Fiscal Year
reversal_awref REVERSAL_AWREF Reversal reference
reversal_aworg REVERSAL_AWORG Reversal reference
acreversaldate BUDAT Posting Date
acreversalperiod MONAT Period
acreversalyear GJAHR Fiscal Year
document_state TPM_TRACDOCSTATE Status
ledgerselection TPM_LEDGER_SELECTION Posting > Accounting
specialledger RLDNR Ledger
document_date BLDAT Document Date
acc_principle ACCOUNTING_PRINCIPLE Accounting Principle
post_cat TPM_TRAC_POST_CATEGORY Update to FI
create_cat TPM_TRAC_CREATE_CATEGORY Gen. Doc. in Release
ref_bustransid TPM_REFBUSTRANSID Reference BT-ID
bustranscat TPM_BUSTRANSCAT Bus. Trans. Cat
deal_number TB_RFHA Transaction
bktxt BKTXT Doc.Header Text
xblnr XBLNR1 Reference
acreversalreason STGRD Reversal Reason
tr_rev_reason SSTOGRD Reversal Reason
bupla BUPLA Business place
secco SECCO Section Code
user_ndata_cls TPM_DB_OS_GUID DB Object ID
user_ndata_oid TPM_DB_OS_GUID DB Object ID

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Treasury: Accounting Adaptor Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRACT_DOCUMENT (
    MANDT,             -- Client [MANDT]
    OS_GUID,           -- DB Object ID [TPM_DB_OS_GUID]
    BUSTRANSID,        -- Bus. Trans. ID [TPM_BUSTRANSID]
    DOCUMENTID,        -- Routing slip doc. ID [TPM_TRDDOCID]
    TR_ACC_CODE,       -- Accounting Code [TPM_ACC_CODE]
    VALUATION_AREA,    -- Valuation Area [TPM_VAL_AREA]
    AWREF,             -- Reference Doc. [AWREF]
    AWORG,             -- Refer. Org.Unit [AWORG]
    ACPOSTINGDATE,     -- Posting Date [BUDAT]
    ACPOSTINGPERIOD,   -- Period [MONAT]
    ACPOSTINGYEAR,     -- Fiscal Year [GJAHR]
    REVERSAL_AWREF,    -- Reversal reference [REVERSAL_AWREF]
    REVERSAL_AWORG,    -- Reversal reference [REVERSAL_AWORG]
    ACREVERSALDATE,    -- Posting Date [BUDAT]
    ACREVERSALPERIOD,  -- Period [MONAT]
    ACREVERSALYEAR,    -- Fiscal Year [GJAHR]
    DOCUMENT_STATE,    -- Status [TPM_TRACDOCSTATE]
    LEDGERSELECTION,   -- Posting > Accounting [TPM_LEDGER_SELECTION]
    SPECIALLEDGER,     -- Ledger [RLDNR]
    DOCUMENT_DATE,     -- Document Date [BLDAT]
    ACC_PRINCIPLE,     -- Accounting Principle [ACCOUNTING_PRINCIPLE]
    POST_CAT,          -- Update to FI [TPM_TRAC_POST_CATEGORY]
    CREATE_CAT,        -- Gen. Doc. in Release [TPM_TRAC_CREATE_CATEGORY]
    REF_BUSTRANSID,    -- Reference BT-ID [TPM_REFBUSTRANSID]
    BUSTRANSCAT,       -- Bus. Trans. Cat [TPM_BUSTRANSCAT]
    DEAL_NUMBER,       -- Transaction [TB_RFHA]
    BKTXT,             -- Doc.Header Text [BKTXT]
    XBLNR,             -- Reference [XBLNR1]
    ACREVERSALREASON,  -- Reversal Reason [STGRD]
    TR_REV_REASON,     -- Reversal Reason [SSTOGRD]
    BUPLA,             -- Business place [BUPLA]
    SECCO,             -- Section Code [SECCO]
    USER_NDATA_CLS,    -- DB Object ID [TPM_DB_OS_GUID]
    USER_NDATA_OID,    -- DB Object ID [TPM_DB_OS_GUID]
    PRIMARY KEY (MANDT, OS_GUID)
);

Learn More