SAP Table

TZB0A Definition of flow types

SAP table TZB0A has 3 primary key fields being MANDT,RANTYP,SBEWART.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

TZB0A columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyRANTYP Contract Type CHAR 1 0 RANTYP
KeySBEWART Flow Type CHAR 4 0 SBEWART
SBEWAGRP Flow type group CHAR 2 0 TZB10 SBAGRP
SBEWZITI Flow category CHAR 4 0 TZB03 SBEWZITI
SSOLHAB Debit/credit indicator CHAR 1 0 VVSSOLHAB
JZINSBAS Flow in interest base CHAR 1 0 JZINSBAS
JZINSZPT Interest date CHAR 1 0 JZINSZPT
JRESALD Transaction for remaining balance NUMC 2 0 RSALD
XBUCHK Posting short text CHAR 4 0 XBUCHK
JBUCKZ Transaction is to be posted CHAR 1 0 BUCKZ
JFDBUC Relevant to Cash Management CHAR 1 0 FDBUC
JEFFZI Part of effective interest rate calculation CHAR 1 0 EFFZI
SABGRENZ Accrual/deferral method NUMC 1 0 VVSABGRENZ
SEFFZIVZ +/- sign for effective interest rate calculation CHAR 1 0 VVSEFFZIVZ
JSTOCK Premium reserve fund-relevant indicator CHAR 1 0 VVJSTOCK
SZEGEN Generate Incoming Payment Immediately NUMC 2 0 TD21 SZEGEN
JZIABBA Interest-based accruals/deferrals indicator CHAR 1 0 VVJZIABBA
SBERFIMA Calculation category for cash flow calculator CHAR 4 0 AT40 SBEWFIMA
SFIBU Control entry of overpayment and advance payment data CHAR 2 0 VVSFIBU
SBUST Posting Control Key NUMC 2 0 TZB09 VVSBUST
SVORGKZ Activity indicator for debit/credit control NUMC 2 0 VVSVORGKZ
SAKTPAS Indicator: Asset/Liability Transaction CHAR 1 0 VVSAKTPAS
JVGLEFFZ Effective int.-relevant comparative effective int. CHAR 1 0 VVJVGLEFFZ
JEFFZI2 Effective int.-relevant internal effective interest CHAR 1 0 VVJEFFZI2
SEINBEHALT Flag for Withholding Amount on Disbursement CHAR 1 0 VVSEINBE
SWPTERM Securities forward dealings indicator CHAR 1 0 VVSWPTERM
SABGV Accrual/deferral procedure CHAR 1 0 TB_SABGV
SZADRI Payment to third-party CHAR 1 0 SZADRI
SPAYRQ Payment request allowed CHAR 1 0 TB_SPAYRQ
SPRSNG Individual payment required CHAR 1 0 TB_SPRSNG
SNODUNN No dunning for flow type CHAR 1 0 SNODUNN
SSIGN Direction of Flow CHAR 1 0 TB_SSIGN
SPAYRQ_LO Payment Request Allowed CHAR 1 0 SPAYRQ_LOAN
SPRSNG_LO Individual Payment Required CHAR 1 0 SPRSNG_LOAN
SNODUN_INT Dunning Interest Not Calculated CHAR 1 0 SNODUNN_INTEREST
XHIDE_SM Hide flow in account statement as default CHAR 1 0 XHIDE_SM
VORGTYP Activity Category (Posting Area) CHAR 4 0 VORGTYP_LO
VEDEFFZ Relevant for Closely Defined Effective Interest CHAR 1 0 VEDEFFZ
VJAHREFFZ Relevant for Yearly Effective Interest acc. Reg 87/102/EMG CHAR 1 0 VJAHREFFZINS
CLI_RELEVANT Relevant for Credit Life Insurance CHAR 1 0 TB_CLI_RELEVANT
CONTAB_RELEVANT Relevant for Condition Table CHAR 1 0 TB_FICO_CONTAB_RELEVANT
/ Relationships

TZB0A foreign keys.

Table Field Check Table Description Check Field
TZB0A SBEWAGRP TZB10 Flow type groups check table SBEWAGRP
TZB0A SBEWZITI TZB03 Flow categories SBEWZITI
TZB0A SBUST TZB09 Posting control table SBUST
TZB0A SZEGEN TD21 Reasons for generating incoming payments immediately MANDT
TZB0A SZEGEN TD21 Reasons for generating incoming payments immediately SZEGEN
Back to SAP tables