1. Home
  2. Resources
  3. SAP Tables
  4. TZPAB - Financial Assets Management product types

SAP Table TZPAB

Financial Assets Management product types

TZPAB (Financial Assets Management product types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TZPAB to other SAP tables.

TZPAB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
GSART Product Type VVSART TZPA CHAR 3 0
SKOGRP Condition Group SKOGRP NUMC 3 0
SFDLEV Not used OVERW2 CHAR 2 0
APLAN Cash management update period in years VVAPLAN NUMC 2 0
AUSWA Financial Assets Management field selection string VVFEAUS CHAR 100 0
AARCHI Retention period in archive in years VVAARCHI NUMC 2 0
SVERDI Summarization indicator VVSVERDI CHAR 1 0
0 No
1 Yes
AVERDI Uncompressed period in years VVAVERDI NUMC 2 0
NUMKR Number range NUMKR CHAR 2 0
JEINBEHALT Indicator for withholding of amount during disbursement VVJEINBE CHAR 1 0
X Selection character
NULL Blank
SEFFMETH Effective Interest Method (Financial Mathematics) SEFFMETH NUMC 1 0
1 PAngV
2 AIBD/ISMA
3 Braess
4 Moosmueller
5 US method
6 EU Act/365
8 EU 30.42/365
9 Linear
SZBMETH Interest Calculation Method SZBMETH CHAR 1 0
1 360E/360
B 360E/365
F 360/360 (ISDA)
H 360/365 (ISDA)
7 360/360
2 Act/360
E Act/364
3 Act/365
4 Act/366
5 Act/ActP (ICMA)
6 Act/ActY (ISDA)
G Act/ActE (AFB)
A ActW/252
D 365/360
C 365/365
I 360E/ActY
8 *365/360
9 *365.25/360
P 1/1
J m+act/360
K m+30/360
0 Not Specified
SDISEIN Type of Discount Withholding SDISEIN CHAR 1 0
1 Total with first disbursement
2 Proportionate per partial disbursement
3 Total with last disbursement
PDISLIMIT Discount limit accrued PDISLIMIT DEC 10 7
SSOLIST Plan/Actual principle VVSSOLIST CHAR 1 0
0 Planned Principle
1 Actual Principle - Retain Annuity Pmnt Installment
2 Actual Principle - Increase Annuity Pmnt Installment
4 Incoming Payment Principle
5 Payment Plan Principle
SBUHAL Setting for FI posting BUHAL CHAR 1 0
1 SAP Banking: No operative usage, no FI posting
2 Actual records in subledger, no FI posting (not loans!)
3 Actual records in subledger, FI posting with customer
4 Actual records in subledger, posting in FI without customer
VVRANLWI1 No. of the secondary index description for class data VVRANLWI TWX1 NUMC 2 0
VVRANLWI2 No. of the secondary index description for class data VVRANLWI TWX1 NUMC 2 0
JAUSWA Control whether field selection from TZPA or TZPAB is used VVJAUSWA CHAR 1 0
0 No
1 Yes
ANRSTELL Number of characters in asset number VVANRSTELL NUMC 2 0
SKOMPNAM Component name key VVSKOMPNAM TZN02 CHAR 3 0
ZLSCH Payment Method DZLSCH T042Z CHAR 1 0
SZLAVER Payment block for processing open items VVSZLAVER T008 CHAR 1 0
SZVDEB Payment summarization level VVSZVDEB NUMC 2 0
01 Customer
02 Finance project
03 Contract
SDEBAUT Automatic customer indicator VVSDEBAUT CHAR 1 0
NULL No
X Yes
SBUST Posting control key VVSBUST TZB09 NUMC 2 0
SZEGEN Generate incoming payment immediately SZEGEN TD21 NUMC 2 0
SEFFM2 Effective Interest Method (Financial Mathematics) SEFFMETH NUMC 1 0
1 PAngV
2 AIBD/ISMA
3 Braess
4 Moosmueller
5 US method
6 EU Act/365
8 EU 30.42/365
9 Linear
SZKEY Indicator for Control of Incoming Payment Distribution VVSZKEY TVZ01 NUMC 2 0
MNUMKR Number range NUMKR CHAR 2 0
VVSHBEB Special G/L Indicator for Withholding Amounts VVSHBEB T074U CHAR 1 0
BESCHL Decision-making active indicator BESCHL CHAR 1 0
NULL No
X Yes
JZWJAHR Payment form refers to effective from date of condition VVJZWJAHR CHAR 1 0
X Yes
NULL No
SZSPZE Blocking reason for incoming payment postprocessing VVZSPZE T008 CHAR 1 0
SINKKOKO Inclusive indicator for the end of the fixed period VVSINKKOKO CHAR 1 0
X Yes
NULL No
SABGRENZ Loan Discount Accrual/Deferral Method VVSABGRD CHAR 1 0
0 Acc. to flow type
1 Linear
2 Proportional to interest
9 None or manual
SFEST Indicator for Control of Fixed Contract VVFESTKZ CHAR 1 0
0 Fixed contract possible
1 Only manual fixed contract
2 No fixed contract
JORIG Posting system indicator for borrower's note loans BUCHSYS NUMC 1 0
1 Gross
2 Net
DSART Planning type DSART T037 CHAR 2 0
JAUSZVI Default Value for Inclusive Indicator for Interest Val.Date VVJAUSZVI CHAR 1 0
X Selection character
NULL Blank
SMANSP Dunning block for customer account payments to third-party SMANSP T040S CHAR 1 0
STAXGEN Indicator for tax generation STAXGEN CHAR 1 0
X Yes
NULL No
SDUNNCMP Summarization Level for Dunning Letter SDUNNCMP CHAR 2 0
NULL Loan contract
FP Finance project
BO Main borrower
SDUNNACT Dunning Active SDUNNACT CHAR 1 0
X Yes
NULL No
SDUNOINF Dunning History Cannot Be Changed SDUNOINF CHAR 1 0
X Yes
NULL No
SDUNPOST Posting Variant for Dunning Charges/Interest fr. Dunning Run SDUNPOST CHAR 1 0
NULL No posting of dunning charges and interest
1 Smallest contract number of dunning summarization level
2 Individual using flag on contract
SKOFIAKT Account determination ID for reversal SKOFIAKT CHAR 1 0
0 No active account determination
1 Active account determination for reconcil. or principal acct
2 Active account determination for G/L / clearing account
3 Active account determination for all accounts
SHISTAKT Indicator for CML Reference Unit SHISTAKT CHAR 1 0
1 No data written to payment ref. unit in CML per value date
2 Data written by value date to payment reference unit in CML
SSTORNOEBENEZEV Reversal level for reversing incoming payments SSTORNOEBENEZEV CHAR 1 0
1 Only reversal of the selected document
2 Reversal of all related incoming payments for this contract
3 Reversal of all related incoming pmnts across all contracts
JPAYMENTREQ Payment Details Active JPAYMENTREQ CHAR 1 0
X Yes
NULL No
SREVALEXCL Price gains w/o proportionate gains from deferral write-back VVSREVALEXCL CHAR 1 0
X Yes
NULL No
SBOTERM Unscheduled Repayment: Indicator for Shortening End of Term SBOTERM CHAR 1 0
1 Term will be shortened
2 Adjusted payment instalment, condition will be added
3 No effect
SPACUKY Currency Key WAERS TCURC CUKY 5 0
SBOINCL Unscheduled Repayment: Default Value for Inclusive Indicator SBOINCL CHAR 1 0
X Selection character
NULL Blank
ZLSCH_OI_RE Payment Method for Reactivated Open Items TB_ZLSCH_OI_RE T042Z CHAR 1 0
ZAHLS_OI_RE Payment Block for Reactivated Open Items TB_ZAHLS_OI_RE T008 CHAR 1 0
COM_VAL_CLASS General Valuation Class TPM_COM_VAL_CLASS TRGC_COM_VALCL NUMC 4 0
MONTHS_BR Analysis Period Returned Direct Debits in Months TB_MONTHS_BR NUMC 2 0
FLG_NON_ACCRUAL Non-Accrual Status Permitted TB_FLG_NON_ACCRUAL CHAR 1 0
X Yes
NULL No
ST_NON_ACC Dunning Level From which Non-Accrual Status Applies TB_NON_ACCRUAL_START NUMC 1 0
MABER Dunning Area MABER CHAR 2 0
ZAHLS_IA Payment on Request TB_ZAHLS_IA T008 CHAR 1 0
MARKUP Put Back Key Date in Position Management TB_MARKUP NUMC 2 0
MAHNA Dunning Procedure MAHNA CHAR 4 0
AUSWA_B Financial Assets Management field selection string VVFEAUS CHAR 100 0
ZAHLS_NAD Blocking reason for new auto debit (SEPA direct debit) TB_PAYMENT_BLOCK_AUTODEBIT T008 CHAR 1 0
BROUNDUNIT Default Rounding Unit for Amounts TB_BROUNDUNIT_PRE DEC 13 7
SROUND Default Value for Round. Ctgy (Round up, Down or Number Rdg) TB_SROUND_PRE CHAR 1 0
NULL Round to the Nearest
- Round Down
+ Round Up
DCALLEND_OFF Provision Period in Months TB_DCALLEND_OFF NUMC 2 0
CHK_COND Checkbox: Check for Condition Item Changes CHK_COND CHAR 1 0
NULL No
X Yes

TZPAB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TZPAB BUKRS TZPAB MANDT T001 Company Codes MANDT
TZPAB BUKRS TZPAB BUKRS T001 Company Codes BUKRS
TZPAB COM_VAL_CLASS TZPAB COM_VAL_CLASS TRGC_COM_VALCL General valuation class COM_VAL_CLASS
TZPAB COM_VAL_CLASS TZPAB MANDT TRGC_COM_VALCL General valuation class MANDT
TZPAB DSART TZPAB MANDT T037 Planning Types MANDT
TZPAB DSART TZPAB DSART T037 Planning Types DSART
TZPAB GSART TZPAB MANDT TZPA Financial Assets Management Product Types MANDT
TZPAB GSART TZPAB GSART TZPA Financial Assets Management Product Types GSART
TZPAB MANDT TZPAB MANDT T000 Clients MANDT
TZPAB SBUST * TZB09 Posting control table RANTYP
TZPAB SBUST TZPAB SBUST TZB09 Posting control table SBUST
TZPAB SKOMPNAM TZPAB MANDT TZN02 Number components MANDT
TZPAB SKOMPNAM TZPAB SKOMPNAM TZN02 Number components SKOMPNAM
TZPAB SMANSP TZPAB SMANSP T040S Blocking reasons for dunning notices MANSP
TZPAB SMANSP TZPAB MANDT T040S Blocking reasons for dunning notices MANDT
TZPAB SPACUKY TZPAB SPACUKY TCURC Currency Codes WAERS
TZPAB SPACUKY TZPAB MANDT TCURC Currency Codes MANDT
TZPAB SZEGEN TZPAB MANDT TD21 Reasons for generating incoming payments immediately MANDT
TZPAB SZEGEN * TD21 Reasons for generating incoming payments immediately RANTYP
TZPAB SZEGEN TZPAB SZEGEN TD21 Reasons for generating incoming payments immediately SZEGEN
TZPAB SZKEY TZPAB MANDT TVZ01 Control of incoming payments MANDT
TZPAB SZKEY TZPAB SZKEY TVZ01 Control of incoming payments SZKEY
TZPAB SZLAVER TZPAB MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
TZPAB SZLAVER TZPAB SZLAVER T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
TZPAB SZSPZE TZPAB SZSPZE T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
TZPAB SZSPZE TZPAB MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
TZPAB VVRANLWI1 TZPAB MANDT TWX1 Class data sec. index numbers MANDT
TZPAB VVRANLWI1 TZPAB VVRANLWI1 TWX1 Class data sec. index numbers VVRANLWI
TZPAB VVRANLWI2 TZPAB VVRANLWI2 TWX1 Class data sec. index numbers VVRANLWI
TZPAB VVRANLWI2 TZPAB MANDT TWX1 Class data sec. index numbers MANDT
TZPAB VVSHBEB TZPAB MANDT T074U Special G/L Indicator Properties MANDT
TZPAB VVSHBEB 'D' T074U Special G/L Indicator Properties KOART
TZPAB VVSHBEB TZPAB VVSHBEB T074U Special G/L Indicator Properties UMSKZ
TZPAB ZAHLS_IA TZPAB MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
TZPAB ZAHLS_IA TZPAB ZAHLS_IA T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
TZPAB ZAHLS_NAD TZPAB MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
TZPAB ZAHLS_NAD TZPAB ZAHLS_NAD T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
TZPAB ZAHLS_OI_RE TZPAB MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
TZPAB ZAHLS_OI_RE TZPAB ZAHLS_OI_RE T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
TZPAB ZLSCH TZPAB MANDT T042Z Payment Methods for Automatic Payment MANDT
TZPAB ZLSCH * T042Z Payment Methods for Automatic Payment LAND1
TZPAB ZLSCH TZPAB ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
TZPAB ZLSCH_OI_RE TZPAB ZLSCH_OI_RE T042Z Payment Methods for Automatic Payment ZLSCH
TZPAB ZLSCH_OI_RE TZPAB MANDT T042Z Payment Methods for Automatic Payment MANDT
TZPAB ZLSCH_OI_RE * T042Z Payment Methods for Automatic Payment LAND1