TZB0A
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)
| 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 (42)
| 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 | ||||
| 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)
);
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