SAP Tabel TZB0A (Definition of flow types)

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

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

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
RANTYP Contract Type CHAR 1 0 RANTYP
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
SBEWART 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
H Credit Posting
S Debit Posting
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
0 None or manual
1 Linear
2 Proportional to interest
3 Financial mathematics
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
01 Prepayments
02 Advance payments
03 Qualified overpayment
04 Other overpayment
05 Transfer qualified overpayment
06 Transfer other overpayment
07 Refund by bank transfer
08 Transfer advance payment
09 Reimbursement
SBUST Posting Control Key NUMC 2 0 TZB09 VVSBUST
SVORGKZ Activity indicator for debit/credit control NUMC 2 0 VVSVORGKZ
01 Receivable
02 Outgoing payment
03 Payable
04 Incoming payment
05 Expense
06 Revenue
07 Internal debit posting
08 Internal credit posting
09 Cost center debit to internal general contract
10 Cost center credit to internal general contract
11 General contract debit
12 General contract credit
SAKTPAS Indicator: Asset/Liability Transaction CHAR 1 0 VVSAKTPAS
0 Asset Transaction
1 Liabilities Transaction
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
Withholding Rule According to Product Type / Company Code
1 No Withholding Amount
2 Amount Withheld
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
0001 Accruals/Deferrals: Credit
0002 Accruals/Deferrals: Debit
0003 Write-Down: Credit
0004 Write-Down: Debit - Not Supported
0005 Reduce Receivable on G/L Account - Not Supported
0006 Reduce Credit Balance on G/L Account (IPP)
0007 IP from Clearing Advance Payments/Overpayments: Credit
0008 OP from Clearing Adv.Pmnts/Overpmnts: Debit - Not Supported
0009 Disbursement: Credit
0010 Disbursement: Debit
0011 Withholding: Credit
0012 Withholding: Debit
0013 Indiv. Value Adjustm.: Debit
0014 Indiv. Value Adjustm.: Credit
0015 Debit Position
0016 Credit Position
0017 Reduce Overpayment: Debit
0018 Reduce Overpayment: Credit - Not Supported
0019 Reduce Advance Payment: Debit
0020 Reduce Advance Payment: Credit - Not Supported
0021 Commission: Debit
0022 Commission: Credit
0023 Other Posting: Debit
0024 Other Posting: Credit
0025 Overpayment: Credit
0026 Overpayment: Debit - Not Supported
0027 Capital Transfer: Credit
0028 Capital Transfer: Debit
0029 Waiver: Credit
0030 Waiver: Debit - Not Supported
0031 Advance Payment: Credit
0032 Advance Payment: Debit - Not Supported
0033 Incoming Payment
0034 Outgoing Payments
0035 Drawing: Credit
0036 Drawing: Debit - Nicht Unterstützt
0037 Reduce Disbursement: Debit
0038 Reduce Disbursement: Credit
0039 Refund
0040 Transfer to G/L Account: Debit - Not supported
0041 Transfer to G/L Account: Credit (IPP)
0042 Transfer Value Date: Debit
0043 Transfer Value Date: Credit - Not Supported
0044 Balance Sheet Transfer: Debit
0045 Balance Sheet Transfer: Credit
0046 Rate Gain
0047 Rate Loss
0048 Payoff: Debit
0049 Payoff: Credit
0051 Clearing for Credit Posting
0052 Allocation to Debit Position
0053 Transfer Accrual and Deferral Debit
0054 Transfer Accrual and Deferral Credit
0055 Reduce Position of Loan Receivables
0056 Reduce Third-Party Capital - Not Supported
0057 Revenue Calculated - Not Supported
0058 Revenue Agreed
0059 Revenue Collected
0061 Clearing for Debit Posting
0062 Allocation to Credit Position
0063 Assumed Payment Clearing Debit
0064 Assumed Payment Clearing Credit - Not Supported
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

TZB0A foreign key relationships

Table Field Check Table Check Field
0 TZB0A SBEWAGRP TZB10 Flow type groups check table SBEWAGRP
1 TZB0A SBEWZITI TZB03 Flow categories SBEWZITI
0 TZB0A SBUST TZB09 Posting control table SBUST
1 TZB0A SZEGEN TD21 Reasons for generating incoming payments immediately MANDT
1 TZB0A SZEGEN TD21 Reasons for generating incoming payments immediately SZEGEN