TZB0A
Definition of flow types
TZB0A is an SAP database table in S/4HANA. Definition of flow types. It contains 37 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CmmdtyHdgFinInstrTransFlwCat | view_entity | inner | BASIC | Commodity Fin Transaction Flow Categories |
| I_FinTransFlowType | view | from | BASIC | Financial Transaction Flow Type |
Fields (37)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 |
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]
PRIMARY KEY (MANDT, RANTYP, SBEWART)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA