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