TRDT_FLOW

Transparent Table Application Table
128 Fields 2 CDS Views

Persistent distributor flows

TRDT_FLOW is an SAP database table in S/4HANA. Persistent distributor flows. It contains 128 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_Trdtflow view_entity from BASIC P_View for Table trdt_flow
R_FinTransDistributorFlow view from BASIC Reuse of distributor flows

Fields (128)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bustrans_os_guid tpm_db_os_guid DB Object ID
KEY flow_number tpm_trdflownr Flow Number
dis_flowtype tpm_dis_flowtype Update Type
alloc_nmbr dzuonr Assignment
company_code bukrs Company Code
valuation_area tpm_val_area Valuation Area
product_type vvsart Product Type
transaction_type tb_sfhaart Transactn Type
com_val_class tpm_com_val_class Gen. Valn Class
valuation_class tpm_val_class Val. Class
security_id vvranlw Security Class
security_account rldepo Securities Acct
account_group tpm_sec_acct_grp Sec.AcctGrp
portfolio rportb Portfolio
trader rdealer Trader
loans_contract ranl Contract Number
deal_number tb_rfha Transaction
position_account tpm_pos_account_fut Futures Acct
lot_id tpm_lot_id Lot
flag_long_short tpm_flag_long_short Long/Short Position
fund fm_fund Fund
grant_nbr gm_grant_nbr Grant
external_account tpm_ext_account External Account
diff_currency tpm_diff_currency Pos. Crcy
units tpm_units_l Units
nominal_curr tpm_nominal_curr Nominal Crcy
nominal_amt tpm_nominal_amt Nominal Amount
nominal_org_amt tpm_nominal_org_amt Original Nom.Amt PC
position_curr tpm_position_curr Position Crcy
position_amt tpm_position_amt Amt (Pos. Crcy)
posamt_idx_clean tpm_position_amt_idx_clean Index-Clean
quant_cat tpm_qty_pm_cat Qty Category
active_passive tpm_active_passive Assets/Liab.
local_curr tpm_local_curr Local Currency
local_amt tpm_local_amt Amount (Local Crcy)
valuation_curr tpm_valuation_curr Valuation Currency
valuation_amt tpm_valuation_amt Amount ValnCrcy
trl_pos_man_cat tpm_amt_pm_cat Position Change Cat.
fixed_aa_ref tpm_aa_ref Acct Assignment Ref.
sourcetarget_flg tpm_source_target_flg Source / Target
transfer_group tpm_transfer_group Transfer group
lot_creation tpm_lot_creation Lot creation
amount_factor tpm_amount_factor Val.Coefficient
payment_curr tpm_payment_curr Payment Crcy
payment_amt tpm_payment_amt Payment Amount
sign tb_ssign Direction
house_bank tb_rhabki House Bank
house_bank_acc tb_rhktid House Bank Acct
payment_date tpm_payment_date Payt Date
due_date tpm_due_date Due Date
rpbank tb_rpbank Partner Bank
rpzahl tb_rpzahl_new Payer/Payee
szart tb_szart Pmnt Transact.
zlsch dzlsch Pymt Meth.
uzawe uzawe Pmnt Meth. Sup.
spayrq tb_spayrq Payment request
sprsng tb_sprsng Individual pmnt
sprgrd tb_sprgrd Group Determ.
scspay tb_scspay Same Direction
zwels dzwels Payment Methods
paygr paygr Grouping
calculation_date dvalut Calculat. date
calc_date_incl vvsincl Inclusive Ind.
coupon_date tpm_coupon_date Coupon Date
coupon_sign tpm_coupon_sign Coupon
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
landl landl Supply C/R
lzbkz lzbkz SCB Ind.
rpcode rpcode Repetitive Code
rp_text rpcode_text Reference Text
rfhazu tb_rfhazu Activity
nordext tb_nordext External Ref.
sfgzustt tb_sfgzuty Activity Cat.
skhwfix tb_skhwfix Translation->LC
transl_date wwert_d Translatn Date
rkondgr tb_rkondgr Direction
counterparty tb_kunnr_new Partner
snotdelivered ftr_not_del_flg Not Delivered
clearing_status tpm_trea_clearing_status Clearing Status
clearing_date tpm_trea_clearing_date_act Act. Clrg Date
mndid sepa_mndid Mandate Ref.
presentation_id ftr_persent_id Presentatn Itm
hedged_item_id thm_hedge_id Hedged Item ID
exposure_item_id toe_exposure_item_id Exposure Item ID
exposure_subitem_id toe_exposure_subitem_id Exposure Subitem ID
svult vvsvult Mon-End Val.Dte
sroundfactor tfm_sroundfactor Factor RC
rounddecfactor tfm_rounddecfactor Dec. Fac. Round
jexpointfactor tfm_jexpointfactor Expo Int Factor
sroundbasefactor tfm_sroundbasefactor Base Factor RC
rounddecbasefactor tfm_rounddecbasefactor Dec. BF Round.
flowfactor tfm_flowfactor Flow Factor
basefactor tfm_basefactor Base Factor
sroundratefactor tfm_sroundratefactor Int. Factor RC
rounddecratefactor tfm_rounddecratefactor Dec. Int. Fac.
aavgdays tfm_aavgdays Days AIR
pavginterest tfm_pavginterest Aver. Int. Rate
ssequence tfm_sequence Sequence Number
sstckkz sstckkz Acc.int.meth.
sflat vvsflat Traded flat
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.
fx_fixing_date tb_dfix Fixing Date
wbs_element ps_psp_pnr WBS Element
cost_center kostl Cost Center
profit_center prctr Profit Center
functional_area fkber Functional Area
custom_diff_term_1 tpm_cust_diff_term_value Cust.Diff.Term Val.
custom_diff_term_2 tpm_cust_diff_term_value Cust.Diff.Term Val.
custom_diff_term_3 tpm_cust_diff_term_value Cust.Diff.Term Val.
custom_diff_term_4 tpm_cust_diff_term_value Cust.Diff.Term Val.
custom_diff_term_5 tpm_cust_diff_term_value Cust.Diff.Term Val.
nominal_amt_per_unit tfm_bnwhr_per_unit Nominal amt per Unit
position_amt_per_unit tfm_bbwhr_per_unit Position amt perUnit
posamt_idx_clean_per_unit tfm_bbwhr_idxclean_per_unit Index-clean perUnit
bbasis_per_unit tfm_bbasis_per_unit Base amt unit
nominal_value_per_unit ftr_nominal_value_per_unit Nominal Value
units_base ftr_units_calc_base Units Calc.Base
payment_reason farp_payt_rsn Payment Reason
sum_id_sum tb_sum_id_sum Accum. Flow 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.

-- Persistent distributor flows
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRDT_FLOW (
    MANDT,                         -- Client [mandt]
    BUSTRANS_OS_GUID,              -- DB Object ID [tpm_db_os_guid]
    FLOW_NUMBER,                   -- Flow Number [tpm_trdflownr]
    DIS_FLOWTYPE,                  -- Update Type [tpm_dis_flowtype]
    ALLOC_NMBR,                    -- Assignment [dzuonr]
    COMPANY_CODE,                  -- Company Code [bukrs]
    VALUATION_AREA,                -- Valuation Area [tpm_val_area]
    PRODUCT_TYPE,                  -- Product Type [vvsart]
    TRANSACTION_TYPE,              -- Transactn Type [tb_sfhaart]
    COM_VAL_CLASS,                 -- Gen. Valn Class [tpm_com_val_class]
    VALUATION_CLASS,               -- Val. Class [tpm_val_class]
    SECURITY_ID,                   -- Security Class [vvranlw]
    SECURITY_ACCOUNT,              -- Securities Acct [rldepo]
    ACCOUNT_GROUP,                 -- Sec.AcctGrp [tpm_sec_acct_grp]
    PORTFOLIO,                     -- Portfolio [rportb]
    TRADER,                        -- Trader [rdealer]
    LOANS_CONTRACT,                -- Contract Number [ranl]
    DEAL_NUMBER,                   -- Transaction [tb_rfha]
    POSITION_ACCOUNT,              -- Futures Acct [tpm_pos_account_fut]
    LOT_ID,                        -- Lot [tpm_lot_id]
    FLAG_LONG_SHORT,               -- Long/Short Position [tpm_flag_long_short]
    FUND,                          -- Fund [fm_fund]
    GRANT_NBR,                     -- Grant [gm_grant_nbr]
    EXTERNAL_ACCOUNT,              -- External Account [tpm_ext_account]
    DIFF_CURRENCY,                 -- Pos. Crcy [tpm_diff_currency]
    UNITS,                         -- Units [tpm_units_l]
    NOMINAL_CURR,                  -- Nominal Crcy [tpm_nominal_curr]
    NOMINAL_AMT,                   -- Nominal Amount [tpm_nominal_amt]
    NOMINAL_ORG_AMT,               -- Original Nom.Amt PC [tpm_nominal_org_amt]
    POSITION_CURR,                 -- Position Crcy [tpm_position_curr]
    POSITION_AMT,                  -- Amt (Pos. Crcy) [tpm_position_amt]
    POSAMT_IDX_CLEAN,              -- Index-Clean [tpm_position_amt_idx_clean]
    QUANT_CAT,                     -- Qty Category [tpm_qty_pm_cat]
    ACTIVE_PASSIVE,                -- Assets/Liab. [tpm_active_passive]
    LOCAL_CURR,                    -- Local Currency [tpm_local_curr]
    LOCAL_AMT,                     -- Amount (Local Crcy) [tpm_local_amt]
    VALUATION_CURR,                -- Valuation Currency [tpm_valuation_curr]
    VALUATION_AMT,                 -- Amount ValnCrcy [tpm_valuation_amt]
    TRL_POS_MAN_CAT,               -- Position Change Cat. [tpm_amt_pm_cat]
    FIXED_AA_REF,                  -- Acct Assignment Ref. [tpm_aa_ref]
    SOURCETARGET_FLG,              -- Source / Target [tpm_source_target_flg]
    TRANSFER_GROUP,                -- Transfer group [tpm_transfer_group]
    LOT_CREATION,                  -- Lot creation [tpm_lot_creation]
    AMOUNT_FACTOR,                 -- Val.Coefficient [tpm_amount_factor]
    PAYMENT_CURR,                  -- Payment Crcy [tpm_payment_curr]
    PAYMENT_AMT,                   -- Payment Amount [tpm_payment_amt]
    SIGN,                          -- Direction [tb_ssign]
    HOUSE_BANK,                    -- House Bank [tb_rhabki]
    HOUSE_BANK_ACC,                -- House Bank Acct [tb_rhktid]
    PAYMENT_DATE,                  -- Payt Date [tpm_payment_date]
    DUE_DATE,                      -- Due Date [tpm_due_date]
    RPBANK,                        -- Partner Bank [tb_rpbank]
    RPZAHL,                        -- Payer/Payee [tb_rpzahl_new]
    SZART,                         -- Pmnt Transact. [tb_szart]
    ZLSCH,                         -- Pymt Meth. [dzlsch]
    UZAWE,                         -- Pmnt Meth. Sup. [uzawe]
    SPAYRQ,                        -- Payment request [tb_spayrq]
    SPRSNG,                        -- Individual pmnt [tb_sprsng]
    SPRGRD,                        -- Group Determ. [tb_sprgrd]
    SCSPAY,                        -- Same Direction [tb_scspay]
    ZWELS,                         -- Payment Methods [dzwels]
    PAYGR,                         -- Grouping [paygr]
    CALCULATION_DATE,              -- Calculat. date [dvalut]
    CALC_DATE_INCL,                -- Inclusive Ind. [vvsincl]
    COUPON_DATE,                   -- Coupon Date [tpm_coupon_date]
    COUPON_SIGN,                   -- Coupon [tpm_coupon_sign]
    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]
    LANDL,                         -- Supply C/R [landl]
    LZBKZ,                         -- SCB Ind. [lzbkz]
    RPCODE,                        -- Repetitive Code [rpcode]
    RP_TEXT,                       -- Reference Text [rpcode_text]
    RFHAZU,                        -- Activity [tb_rfhazu]
    NORDEXT,                       -- External Ref. [tb_nordext]
    SFGZUSTT,                      -- Activity Cat. [tb_sfgzuty]
    SKHWFIX,                       -- Translation->LC [tb_skhwfix]
    TRANSL_DATE,                   -- Translatn Date [wwert_d]
    RKONDGR,                       -- Direction [tb_rkondgr]
    COUNTERPARTY,                  -- Partner [tb_kunnr_new]
    SNOTDELIVERED,                 -- Not Delivered [ftr_not_del_flg]
    CLEARING_STATUS,               -- Clearing Status [tpm_trea_clearing_status]
    CLEARING_DATE,                 -- Act. Clrg Date [tpm_trea_clearing_date_act]
    MNDID,                         -- Mandate Ref. [sepa_mndid]
    PRESENTATION_ID,               -- Presentatn Itm [ftr_persent_id]
    HEDGED_ITEM_ID,                -- Hedged Item ID [thm_hedge_id]
    EXPOSURE_ITEM_ID,              -- Exposure Item ID [toe_exposure_item_id]
    EXPOSURE_SUBITEM_ID,           -- Exposure Subitem ID [toe_exposure_subitem_id]
    SVULT,                         -- Mon-End Val.Dte [vvsvult]
    SROUNDFACTOR,                  -- Factor RC [tfm_sroundfactor]
    ROUNDDECFACTOR,                -- Dec. Fac. Round [tfm_rounddecfactor]
    JEXPOINTFACTOR,                -- Expo Int Factor [tfm_jexpointfactor]
    SROUNDBASEFACTOR,              -- Base Factor RC [tfm_sroundbasefactor]
    ROUNDDECBASEFACTOR,            -- Dec. BF Round. [tfm_rounddecbasefactor]
    FLOWFACTOR,                    -- Flow Factor [tfm_flowfactor]
    BASEFACTOR,                    -- Base Factor [tfm_basefactor]
    SROUNDRATEFACTOR,              -- Int. Factor RC [tfm_sroundratefactor]
    ROUNDDECRATEFACTOR,            -- Dec. Int. Fac. [tfm_rounddecratefactor]
    AAVGDAYS,                      -- Days AIR [tfm_aavgdays]
    PAVGINTEREST,                  -- Aver. Int. Rate [tfm_pavginterest]
    SSEQUENCE,                     -- Sequence Number [tfm_sequence]
    SSTCKKZ,                       -- Acc.int.meth. [sstckkz]
    SFLAT,                         -- Traded flat [vvsflat]
    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]
    FX_FIXING_DATE,                -- Fixing Date [tb_dfix]
    WBS_ELEMENT,                   -- WBS Element [ps_psp_pnr]
    COST_CENTER,                   -- Cost Center [kostl]
    PROFIT_CENTER,                 -- Profit Center [prctr]
    FUNCTIONAL_AREA,               -- Functional Area [fkber]
    CUSTOM_DIFF_TERM_1,            -- Cust.Diff.Term Val. [tpm_cust_diff_term_value]
    CUSTOM_DIFF_TERM_2,            -- Cust.Diff.Term Val. [tpm_cust_diff_term_value]
    CUSTOM_DIFF_TERM_3,            -- Cust.Diff.Term Val. [tpm_cust_diff_term_value]
    CUSTOM_DIFF_TERM_4,            -- Cust.Diff.Term Val. [tpm_cust_diff_term_value]
    CUSTOM_DIFF_TERM_5,            -- Cust.Diff.Term Val. [tpm_cust_diff_term_value]
    NOMINAL_AMT_PER_UNIT,          -- Nominal amt per Unit [tfm_bnwhr_per_unit]
    POSITION_AMT_PER_UNIT,         -- Position amt perUnit [tfm_bbwhr_per_unit]
    POSAMT_IDX_CLEAN_PER_UNIT,     -- Index-clean perUnit [tfm_bbwhr_idxclean_per_unit]
    BBASIS_PER_UNIT,               -- Base amt unit [tfm_bbasis_per_unit]
    NOMINAL_VALUE_PER_UNIT,        -- Nominal Value [ftr_nominal_value_per_unit]
    UNITS_BASE,                    -- Units Calc.Base [ftr_units_calc_base]
    PAYMENT_REASON,                -- Payment Reason [farp_payt_rsn]
    SUM_ID_SUM,                    -- Accum. Flow ID [tb_sum_id_sum]
    PRIMARY KEY (MANDT, BUSTRANS_OS_GUID, FLOW_NUMBER)
);

Learn More