TRLT_TRANSACTION

Transparent Table Application Table
26 Fields 2 CDS Views

Treasury Ledger Business Transactions

TRLT_TRANSACTION is an SAP database table in S/4HANA. Treasury Ledger Business Transactions. It contains 26 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TreasuryLedgerTransaction view_entity from BASIC Treasury Ledger Transaction
R_TrsyLdgrTransOfProdGrpExpsr view_entity from BASIC Trsy Ldgr Trans of Prod Group Exposures

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY os_guid TPM_DB_OS_GUID DB Object ID
product_group TPM_PRODUCT_GROUP Product Group
bustranscat TPM_BUSTRANSCAT Bus. Trans. Cat
trldate TPM_TRLDATE TRL Date
bustransid TPM_BUSTRANSID Bus. Trans. ID
create_date TPM_BT_CREATE_DATE Creation Date
create_time TPM_BT_CREATE_TIME Creation Time
bustransstate TPM_TRLTRANSTATE TRL Trans.Stat.
booking_state TPM_TRL_BOOKINGSTATE Posting Status
valuation_area TPM_VAL_AREA Valuation Area
tr_acc_code TPM_ACC_CODE Accounting Code
refbustransid TPM_BUSTRANSID Bus. Trans. ID
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
migr_init_flg TPM_FLG_MIGR_INIT Migr/Init
igt_status TPM_IGT_STATUS IGT Status
fbp_needed TPM_FBP_NEEDED FBP Required
fbp_exists TPM_FBP_EXISTS Add-On Avail.
link_val_area TPM_VAL_AREA Valuation Area
link_bustransid TPM_BUSTRANSID Bus. Trans. ID
flg_efftest TPM_FLG_EFFTEST ET exist?
user_data_oid TPM_DB_OS_GUID DB Object ID
user_data_cls 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 Ledger Business Transactions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRLT_TRANSACTION (
    MANDT,            -- Client [MANDT]
    OS_GUID,          -- DB Object ID [TPM_DB_OS_GUID]
    PRODUCT_GROUP,    -- Product Group [TPM_PRODUCT_GROUP]
    BUSTRANSCAT,      -- Bus. Trans. Cat [TPM_BUSTRANSCAT]
    TRLDATE,          -- TRL Date [TPM_TRLDATE]
    BUSTRANSID,       -- Bus. Trans. ID [TPM_BUSTRANSID]
    CREATE_DATE,      -- Creation Date [TPM_BT_CREATE_DATE]
    CREATE_TIME,      -- Creation Time [TPM_BT_CREATE_TIME]
    BUSTRANSSTATE,    -- TRL Trans.Stat. [TPM_TRLTRANSTATE]
    BOOKING_STATE,    -- Posting Status [TPM_TRL_BOOKINGSTATE]
    VALUATION_AREA,   -- Valuation Area [TPM_VAL_AREA]
    TR_ACC_CODE,      -- Accounting Code [TPM_ACC_CODE]
    REFBUSTRANSID,    -- Bus. Trans. ID [TPM_BUSTRANSID]
    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]
    MIGR_INIT_FLG,    -- Migr/Init [TPM_FLG_MIGR_INIT]
    IGT_STATUS,       -- IGT Status [TPM_IGT_STATUS]
    FBP_NEEDED,       -- FBP Required [TPM_FBP_NEEDED]
    FBP_EXISTS,       -- Add-On Avail. [TPM_FBP_EXISTS]
    LINK_VAL_AREA,    -- Valuation Area [TPM_VAL_AREA]
    LINK_BUSTRANSID,  -- Bus. Trans. ID [TPM_BUSTRANSID]
    FLG_EFFTEST,      -- ET exist? [TPM_FLG_EFFTEST]
    USER_DATA_OID,    -- DB Object ID [TPM_DB_OS_GUID]
    USER_DATA_CLS,    -- DB Object ID [TPM_DB_OS_GUID]
    PRIMARY KEY (MANDT, OS_GUID)
);

Learn More