TRDT_TRDBUSTRANS

Transparent Table Application Table
27 Fields 5 CDS Views

Treasury: Persistent distributor business transaction

TRDT_TRDBUSTRANS is an SAP database table in S/4HANA. Treasury: Persistent distributor business transaction. It contains 27 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_TreasuryBusinessTransaction view from BASIC Business Transaction
I_TrsyDistributorBusTrans view from BASIC Trsy Distributor Business Transactions
P_TrdtTrdtBusTrans view from BASIC
R_FinTransDistributorFlow view inner BASIC Reuse of distributor flows
R_TrsyDistributorBizTransExtID view_entity from BASIC TRDBusinessTransaction by ExtBusTransID

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY os_guid TPM_DB_OS_GUID DB Object ID
user_data_cls TPM_DB_OS_GUID DB Object ID
user_data_oid TPM_DB_OS_GUID DB Object ID
version TPM_TRDVERSION Dist. Version
owner TPM_BUSTRANS_OWNER Origin BT
company_code BUKRS Company Code
valuation_area TPM_VAL_AREA Valuation Area
bustransid TPM_BUSTRANSID Bus. Trans. ID
extbustransid TPM_EXTBUSTRANSID External BT ID
bustranscat TPM_BUSTRANSCAT Bus. Trans. Cat
product_group TPM_PRODUCT_GROUP Product Group
product_category SANLF Prod. Category
bustrans_state TPM_BUSTRANS_STATE Status
planned_action TPM_PLANNED_ACTION Action
position_date TPM_POSTING_DATE Posting Date
create_date TPM_BT_CREATE_DATE Creation Date
create_time TPM_BT_CREATE_TIME Creation Time
ref_bustransid TPM_REFBUSTRANSID Reference BT-ID
tr_rev_reason SSTOGRD Reversal Reason
document_date BLDAT Document Date
fi_post_date TPM_FI_POSTING_DATE FI Posting Date
fi_post_period TPM_FI_POSTING_PERIOD FI Period
fi_rev_date TPM_FI_REVERSAL_DATE FI Reversal Date
fi_rev_period TPM_FI_REVERSAL_PERIOD FI Rev.Period
deal_number TB_RFHA Transaction
tables_used TPM_TABLES_USED DB Tables Used

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: Persistent distributor business transaction
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRDT_TRDBUSTRANS (
    MANDT,             -- Client [MANDT]
    OS_GUID,           -- DB Object ID [TPM_DB_OS_GUID]
    USER_DATA_CLS,     -- DB Object ID [TPM_DB_OS_GUID]
    USER_DATA_OID,     -- DB Object ID [TPM_DB_OS_GUID]
    VERSION,           -- Dist. Version [TPM_TRDVERSION]
    OWNER,             -- Origin BT [TPM_BUSTRANS_OWNER]
    COMPANY_CODE,      -- Company Code [BUKRS]
    VALUATION_AREA,    -- Valuation Area [TPM_VAL_AREA]
    BUSTRANSID,        -- Bus. Trans. ID [TPM_BUSTRANSID]
    EXTBUSTRANSID,     -- External BT ID [TPM_EXTBUSTRANSID]
    BUSTRANSCAT,       -- Bus. Trans. Cat [TPM_BUSTRANSCAT]
    PRODUCT_GROUP,     -- Product Group [TPM_PRODUCT_GROUP]
    PRODUCT_CATEGORY,  -- Prod. Category [SANLF]
    BUSTRANS_STATE,    -- Status [TPM_BUSTRANS_STATE]
    PLANNED_ACTION,    -- Action [TPM_PLANNED_ACTION]
    POSITION_DATE,     -- Posting Date [TPM_POSTING_DATE]
    CREATE_DATE,       -- Creation Date [TPM_BT_CREATE_DATE]
    CREATE_TIME,       -- Creation Time [TPM_BT_CREATE_TIME]
    REF_BUSTRANSID,    -- Reference BT-ID [TPM_REFBUSTRANSID]
    TR_REV_REASON,     -- Reversal Reason [SSTOGRD]
    DOCUMENT_DATE,     -- Document Date [BLDAT]
    FI_POST_DATE,      -- FI Posting Date [TPM_FI_POSTING_DATE]
    FI_POST_PERIOD,    -- FI Period [TPM_FI_POSTING_PERIOD]
    FI_REV_DATE,       -- FI Reversal Date [TPM_FI_REVERSAL_DATE]
    FI_REV_PERIOD,     -- FI Rev.Period [TPM_FI_REVERSAL_PERIOD]
    DEAL_NUMBER,       -- Transaction [TB_RFHA]
    TABLES_USED,       -- DB Tables Used [TPM_TABLES_USED]
    PRIMARY KEY (MANDT, OS_GUID)
);

Learn More