TZB0A

Transparent Table Customizing Table

Definition of flow types

TZB0A is an SAP database table in S/4HANA. Definition of flow types. It contains 42 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CmmdtyHdgFinInstrTransFlwCat view_entity inner BASIC Commodity Fin Transaction Flow Categories
I_FinTransFlowType view from BASIC Financial Transaction Flow Type

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rantyp RANTYP Contract Type
KEY sbewart SBEWART Flow Type
sbewagrp SBAGRP FlowTypeGrp
sbewziti SBEWZITI Flow Category
ssolhab VVSSOLHAB Debit/Credit
jzinsbas JZINSBAS Interest base
jzinszpt JZINSZPT Interest date
jresald RSALD Trans. rem.bal.
xbuchk XBUCHK PostShrtTxt
jbuckz BUCKZ Rel.to posting
jfdbuc FDBUC Relev. to CM
jeffzi EFFZI Eff.int.calc.
sabgrenz VVSABGRENZ Acc./defer.
seffzivz VVSEFFZIVZ +/- sign
jstock VVJSTOCK Relev.to PRF
szegen SZEGEN Incoming Payt
jziabba VVJZIABBA Int.based accr/def.
sberfima SBEWFIMA Calc. Category
sfibu VVSFIBU IP clearing
sbust VVSBUST Posting Control
svorgkz VVSVORGKZ Activity ID
saktpas VVSAKTPAS Asset/Liab.
jvgleffz VVJVGLEFFZ Comp.eff.int.
jeffzi2 VVJEFFZI2 Intern.eff.int.
seinbehalt VVSEINBE Withhold. disb.
swpterm VVSWPTERM Forward deal.
sabgv TB_SABGV Acc/def.proced.
szadri SZADRI Third party pmt
spayrq TB_SPAYRQ Payment request
sprsng TB_SPRSNG Individual pmnt
snodunn SNODUNN No dunning
ssign TB_SSIGN Direction
spayrq_lo SPAYRQ_LOAN Payment request
sprsng_lo SPRSNG_LOAN Individual Pmnt
snodun_int SNODUNN_INTEREST No dunning int.
xhide_sm XHIDE_SM Hide flow type
vorgtyp VORGTYP_LO Activity Cat.
vedeffz VEDEFFZ Rel.CDefEInt
vjahreffz VJAHREFFZINS Yearly Eff.Interst
cli_relevant TB_CLI_RELEVANT CLI-Relevant
contab_relevant TB_FICO_CONTAB_RELEVANT Rel.f.Cond.Tab.

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.

-- Definition of flow types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TZB0A (
    MANDT,            -- Client [MANDT]
    RANTYP,           -- Contract Type [RANTYP]
    SBEWART,          -- Flow Type [SBEWART]
    SBEWAGRP,         -- FlowTypeGrp [SBAGRP]
    SBEWZITI,         -- Flow Category [SBEWZITI]
    SSOLHAB,          -- Debit/Credit [VVSSOLHAB]
    JZINSBAS,         -- Interest base [JZINSBAS]
    JZINSZPT,         -- Interest date [JZINSZPT]
    JRESALD,          -- Trans. rem.bal. [RSALD]
    XBUCHK,           -- PostShrtTxt [XBUCHK]
    JBUCKZ,           -- Rel.to posting [BUCKZ]
    JFDBUC,           -- Relev. to CM [FDBUC]
    JEFFZI,           -- Eff.int.calc. [EFFZI]
    SABGRENZ,         -- Acc./defer. [VVSABGRENZ]
    SEFFZIVZ,         -- +/- sign [VVSEFFZIVZ]
    JSTOCK,           -- Relev.to PRF [VVJSTOCK]
    SZEGEN,           -- Incoming Payt [SZEGEN]
    JZIABBA,          -- Int.based accr/def. [VVJZIABBA]
    SBERFIMA,         -- Calc. Category [SBEWFIMA]
    SFIBU,            -- IP clearing [VVSFIBU]
    SBUST,            -- Posting Control [VVSBUST]
    SVORGKZ,          -- Activity ID [VVSVORGKZ]
    SAKTPAS,          -- Asset/Liab. [VVSAKTPAS]
    JVGLEFFZ,         -- Comp.eff.int. [VVJVGLEFFZ]
    JEFFZI2,          -- Intern.eff.int. [VVJEFFZI2]
    SEINBEHALT,       -- Withhold. disb. [VVSEINBE]
    SWPTERM,          -- Forward deal. [VVSWPTERM]
    SABGV,            -- Acc/def.proced. [TB_SABGV]
    SZADRI,           -- Third party pmt [SZADRI]
    SPAYRQ,           -- Payment request [TB_SPAYRQ]
    SPRSNG,           -- Individual pmnt [TB_SPRSNG]
    SNODUNN,          -- No dunning [SNODUNN]
    SSIGN,            -- Direction [TB_SSIGN]
    SPAYRQ_LO,        -- Payment request [SPAYRQ_LOAN]
    SPRSNG_LO,        -- Individual Pmnt [SPRSNG_LOAN]
    SNODUN_INT,       -- No dunning int. [SNODUNN_INTEREST]
    XHIDE_SM,         -- Hide flow type [XHIDE_SM]
    VORGTYP,          -- Activity Cat. [VORGTYP_LO]
    VEDEFFZ,          -- Rel.CDefEInt [VEDEFFZ]
    VJAHREFFZ,        -- Yearly Eff.Interst [VJAHREFFZINS]
    CLI_RELEVANT,     -- CLI-Relevant [TB_CLI_RELEVANT]
    CONTAB_RELEVANT,  -- Rel.f.Cond.Tab. [TB_FICO_CONTAB_RELEVANT]
    PRIMARY KEY (MANDT, RANTYP, SBEWART)
);