TRDT_SEC_FLOW

Transparent Table Application Table
45 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 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_TrdtSecFlow view from BASIC

Fields (45)

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

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]
    PRIMARY KEY (MANDT, BUSTRANS_OS_GUID, FLOW_NUMBER)
);

Learn More