TRDT_SEC_FLOW

Transparent Table Application Table
46 Fields 1 CDS Views

Persistent distributor flows: Part for BEPP adaptor

TRDT_SEC_FLOW is an SAP database table in S/4HANA. Persistent distributor flows: Part for BEPP adaptor. It contains 46 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_TrdtSecFlow view_entity from BASIC P_View for TRDT_SECFLOW

Fields (46)

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
dguel_kp dguel_kp Item Eff. From
pkond pkond Percentage Rate
sinclvon vvsexclvon Exclusive Start
sinclbis vvsinclbis Incl. End Date
sinclverr vvsinclver Incl. Clrg Date
skoart skoart Condition Type
srefziti vvsrefziti RefFlwCat-A/D
sultbis vvsultbis Month-End EndDt
sultverr vvsultverr MnthEndClearing
sultvon vvsultvon Mth-End StartDt
szbmeth szbmeth Int.calc.method
szegen szegen Incoming Payt
dschluss vvdschluss Closing date
merkm tb_merkm Characteristics
refer tb_refer Internal Ref.
zuond tb_zuond Assignment
nordext nordext ExtOrderNo
objnr j_objnr Object number
peffzins peffzins Effect.int.rate
seffmeth seffmeth Eff.Int. Method
rkontra rkontra_new Counterparty
norder secpositionnumber Position number
rzbank vvrzbank_new Paying Bank
dbudat budat Posting Date
dgjahr gjahr Fiscal Year
rbelnrfi belnr_d Document Number
rbelnrfi2 belnr_d Document Number
swoher tb_swoher Source of Flow
skalidwt tfmskalidwt Int. Calendar
jexpozins tfm_sintcomp Exponential
atage vvatage Number of Days
abastage abastage No. base days
bbasis bbasis Base Amount
ppayment tfm_ppayment Payment Rate
sberfima sbewfima Calc. Category
ad_ref_cat tpm_ad_reference_cat Accr./Def. Ref.Cat.
ad_ref_term tpm_ad_reference_term Reference
ad_flow_cat tpm_ad_flow_cat Accr./Def. Flow Cat.
init_classifier trpa_initial_stage Initial Stage
dverrech vvdverrech Settlem. date
tax_category idcfm_tax_category Tax Category
price bapitm_buprc_l Price
semiannual_price_for_quantity idcfm_tax_fund_sean_qty_price SemUnitsPrice

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: Part for BEPP adaptor
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRDT_SEC_FLOW (
    MANDT,                          -- Client [mandt]
    BUSTRANS_OS_GUID,               -- DB Object ID [tpm_db_os_guid]
    FLOW_NUMBER,                    -- Flow Number [tpm_trdflownr]
    DGUEL_KP,                       -- Item Eff. From [dguel_kp]
    PKOND,                          -- Percentage Rate [pkond]
    SINCLVON,                       -- Exclusive Start [vvsexclvon]
    SINCLBIS,                       -- Incl. End Date [vvsinclbis]
    SINCLVERR,                      -- Incl. Clrg Date [vvsinclver]
    SKOART,                         -- Condition Type [skoart]
    SREFZITI,                       -- RefFlwCat-A/D [vvsrefziti]
    SULTBIS,                        -- Month-End EndDt [vvsultbis]
    SULTVERR,                       -- MnthEndClearing [vvsultverr]
    SULTVON,                        -- Mth-End StartDt [vvsultvon]
    SZBMETH,                        -- Int.calc.method [szbmeth]
    SZEGEN,                         -- Incoming Payt [szegen]
    DSCHLUSS,                       -- Closing date [vvdschluss]
    MERKM,                          -- Characteristics [tb_merkm]
    REFER,                          -- Internal Ref. [tb_refer]
    ZUOND,                          -- Assignment [tb_zuond]
    NORDEXT,                        -- ExtOrderNo [nordext]
    OBJNR,                          -- Object number [j_objnr]
    PEFFZINS,                       -- Effect.int.rate [peffzins]
    SEFFMETH,                       -- Eff.Int. Method [seffmeth]
    RKONTRA,                        -- Counterparty [rkontra_new]
    NORDER,                         -- Position number [secpositionnumber]
    RZBANK,                         -- Paying Bank [vvrzbank_new]
    DBUDAT,                         -- Posting Date [budat]
    DGJAHR,                         -- Fiscal Year [gjahr]
    RBELNRFI,                       -- Document Number [belnr_d]
    RBELNRFI2,                      -- Document Number [belnr_d]
    SWOHER,                         -- Source of Flow [tb_swoher]
    SKALIDWT,                       -- Int. Calendar [tfmskalidwt]
    JEXPOZINS,                      -- Exponential [tfm_sintcomp]
    ATAGE,                          -- Number of Days [vvatage]
    ABASTAGE,                       -- No. base days [abastage]
    BBASIS,                         -- Base Amount [bbasis]
    PPAYMENT,                       -- Payment Rate [tfm_ppayment]
    SBERFIMA,                       -- Calc. Category [sbewfima]
    AD_REF_CAT,                     -- Accr./Def. Ref.Cat. [tpm_ad_reference_cat]
    AD_REF_TERM,                    -- Reference [tpm_ad_reference_term]
    AD_FLOW_CAT,                    -- Accr./Def. Flow Cat. [tpm_ad_flow_cat]
    INIT_CLASSIFIER,                -- Initial Stage [trpa_initial_stage]
    DVERRECH,                       -- Settlem. date [vvdverrech]
    TAX_CATEGORY,                   -- Tax Category [idcfm_tax_category]
    PRICE,                          -- Price [bapitm_buprc_l]
    SEMIANNUAL_PRICE_FOR_QUANTITY,  -- SemUnitsPrice [idcfm_tax_fund_sean_qty_price]
    PRIMARY KEY (MANDT, BUSTRANS_OS_GUID, FLOW_NUMBER)
);

Learn More