TRLT_FLOW

Transparent Table Application Table
50 Fields 3 CDS Views

Treasury Ledger Flows

TRLT_FLOW is an SAP database table in S/4HANA. Treasury Ledger Flows. It contains 50 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_TreasuryLedgerFlow view from BASIC Treasury Ledger Flow
I_TrsyLedgerTransactionFlow view_entity from BASIC Treasury Ledger Flow
P_Trltranspos view from BASIC

Fields (50)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY transaction_oid TPM_DB_OS_GUID DB Object ID
KEY trlflownumber TPM_TRLFLOWNR Flow Number
flownumber TPM_TRDFLOWNR Flow Number
sourcetarget_flg TPM_SOURCE_TARGET_FLG Source / Target
transfer_group TPM_TRANSFER_GROUP Transfer group
flowtype TPM_DIS_FLOWTYPE Update Type
amount_factor TPM_AMOUNT_FACTOR Val.Coefficient
quant_cat TPM_QTY_PM_CAT Qty Category
amount_cat TPM_AMT_PM_CAT Position Change Cat.
units TPM_UNITS_L Units
nominal_amt TPM_NOMINAL_AMT Nominal Amount
nominal_org_amt TPM_NOMINAL_ORG_AMT Original Nom.Amt PC
nominal_curr TPM_NOMINAL_CURR Nominal Crcy
posamt_idx_clean TPM_POSITION_AMT_IDX_CLEAN Index-Clean
position_amt TPM_POSITION_AMT Amt (Pos. Crcy)
position_curr TPM_POSITION_CURR Position Crcy
valuation_amt TPM_VALUATION_AMT Amount ValnCrcy
valuation_curr TPM_VALUATION_CURR Valuation Currency
calculation_date DVALUT Calculat. date
calc_date_incl VVSINCL Inclusive Ind.
due_date TPM_DUE_DATE Due Date
calc_begin DBERVON CalculationFrom
calc_end DBERBIS Calculation To
eff_int_rate_u TPM_TRL_EFF_INT_RATE_USED Used Effect.Int.Rate
sched_eff_rate RDPT_SCHEDULE_KEY_EFF_RATE RS for EIR
eff_int_rate_n TPM_TRL_EFF_INT_RATE_NEW New Effect.Int.Rate
sched_fix RDPT_SCHEDULE_KEY_FIX Fixed RS
ib_schedule_version_used_eir FTBAS_VERSION_NUMBER_EFF_RATE Schedule EIR
ib_schedule_version TRBA_VERSION_NUMBER Version
period_calc_date TPM_PERIOD_CALC_DATE Per. Calc. Date
period_calc_date_incl TPM_PERIOD_CALC_DATE_INCL Incl. Per. Calc. Dt.
bbasis BBASIS Base Amount
par_usage TPM_PAR_USAGE Parameter Usage
sub_sourcetarget TPM_SUB_SOURCE_TARGET Srce/Trgt:SPos.
sub_transfergrp TPM_SUB_TRANSFER_GROUP Subpos.Trans.Gp
init_classifier TRPA_INITIAL_STAGE Initial Stage
dcsid TBA_DCSID DCS ID
quantity FTR_QUAN Qty
unit_of_measure TPM_CTY_UOM Unit of Measure
tax_category IDCFM_TAX_CATEGORY Tax Category
units_base FTR_UNITS_CALC_BASE Units Calc.Base
nominal_value_per_unit FTR_NOMINAL_VALUE_PER_UNIT Nominal Value
sum_id_sum TB_SUM_ID_SUM Accum. Flow ID
documentid TPM_TRDDOCID Routing slip doc. ID
booking_state TPM_TRL_BOOKINGSTATE Posting Status
user_data_oid TPM_DB_OS_GUID DB Object ID
position_oid TPM_DB_OS_GUID DB Object ID
trldate TPM_TRLDATE TRL Date
subposition_oid OS_GUID GUID

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 Flows
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRLT_FLOW (
    MANDT,                         -- Client [MANDT]
    TRANSACTION_OID,               -- DB Object ID [TPM_DB_OS_GUID]
    TRLFLOWNUMBER,                 -- Flow Number [TPM_TRLFLOWNR]
    FLOWNUMBER,                    -- Flow Number [TPM_TRDFLOWNR]
    SOURCETARGET_FLG,              -- Source / Target [TPM_SOURCE_TARGET_FLG]
    TRANSFER_GROUP,                -- Transfer group [TPM_TRANSFER_GROUP]
    FLOWTYPE,                      -- Update Type [TPM_DIS_FLOWTYPE]
    AMOUNT_FACTOR,                 -- Val.Coefficient [TPM_AMOUNT_FACTOR]
    QUANT_CAT,                     -- Qty Category [TPM_QTY_PM_CAT]
    AMOUNT_CAT,                    -- Position Change Cat. [TPM_AMT_PM_CAT]
    UNITS,                         -- Units [TPM_UNITS_L]
    NOMINAL_AMT,                   -- Nominal Amount [TPM_NOMINAL_AMT]
    NOMINAL_ORG_AMT,               -- Original Nom.Amt PC [TPM_NOMINAL_ORG_AMT]
    NOMINAL_CURR,                  -- Nominal Crcy [TPM_NOMINAL_CURR]
    POSAMT_IDX_CLEAN,              -- Index-Clean [TPM_POSITION_AMT_IDX_CLEAN]
    POSITION_AMT,                  -- Amt (Pos. Crcy) [TPM_POSITION_AMT]
    POSITION_CURR,                 -- Position Crcy [TPM_POSITION_CURR]
    VALUATION_AMT,                 -- Amount ValnCrcy [TPM_VALUATION_AMT]
    VALUATION_CURR,                -- Valuation Currency [TPM_VALUATION_CURR]
    CALCULATION_DATE,              -- Calculat. date [DVALUT]
    CALC_DATE_INCL,                -- Inclusive Ind. [VVSINCL]
    DUE_DATE,                      -- Due Date [TPM_DUE_DATE]
    CALC_BEGIN,                    -- CalculationFrom [DBERVON]
    CALC_END,                      -- Calculation To [DBERBIS]
    EFF_INT_RATE_U,                -- Used Effect.Int.Rate [TPM_TRL_EFF_INT_RATE_USED]
    SCHED_EFF_RATE,                -- RS for EIR [RDPT_SCHEDULE_KEY_EFF_RATE]
    EFF_INT_RATE_N,                -- New Effect.Int.Rate [TPM_TRL_EFF_INT_RATE_NEW]
    SCHED_FIX,                     -- Fixed RS [RDPT_SCHEDULE_KEY_FIX]
    IB_SCHEDULE_VERSION_USED_EIR,  -- Schedule EIR [FTBAS_VERSION_NUMBER_EFF_RATE]
    IB_SCHEDULE_VERSION,           -- Version [TRBA_VERSION_NUMBER]
    PERIOD_CALC_DATE,              -- Per. Calc. Date [TPM_PERIOD_CALC_DATE]
    PERIOD_CALC_DATE_INCL,         -- Incl. Per. Calc. Dt. [TPM_PERIOD_CALC_DATE_INCL]
    BBASIS,                        -- Base Amount [BBASIS]
    PAR_USAGE,                     -- Parameter Usage [TPM_PAR_USAGE]
    SUB_SOURCETARGET,              -- Srce/Trgt:SPos. [TPM_SUB_SOURCE_TARGET]
    SUB_TRANSFERGRP,               -- Subpos.Trans.Gp [TPM_SUB_TRANSFER_GROUP]
    INIT_CLASSIFIER,               -- Initial Stage [TRPA_INITIAL_STAGE]
    DCSID,                         -- DCS ID [TBA_DCSID]
    QUANTITY,                      -- Qty [FTR_QUAN]
    UNIT_OF_MEASURE,               -- Unit of Measure [TPM_CTY_UOM]
    TAX_CATEGORY,                  -- Tax Category [IDCFM_TAX_CATEGORY]
    UNITS_BASE,                    -- Units Calc.Base [FTR_UNITS_CALC_BASE]
    NOMINAL_VALUE_PER_UNIT,        -- Nominal Value [FTR_NOMINAL_VALUE_PER_UNIT]
    SUM_ID_SUM,                    -- Accum. Flow ID [TB_SUM_ID_SUM]
    DOCUMENTID,                    -- Routing slip doc. ID [TPM_TRDDOCID]
    BOOKING_STATE,                 -- Posting Status [TPM_TRL_BOOKINGSTATE]
    USER_DATA_OID,                 -- DB Object ID [TPM_DB_OS_GUID]
    POSITION_OID,                  -- DB Object ID [TPM_DB_OS_GUID]
    TRLDATE,                       -- TRL Date [TPM_TRLDATE]
    SUBPOSITION_OID,               -- GUID [OS_GUID]
    PRIMARY KEY (MANDT, TRANSACTION_OID, TRLFLOWNUMBER)
);

Learn More