SAP table TZPAB (Financial Assets Management product types)

SAP table TZPAB has 3 primary key fields being MANDT,BUKRS,GSART.

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
BUKRS Company Code CHAR 4 0 T001 BUKRS
GSART Product Type CHAR 3 0 TZPA VVSART
SKOGRP Condition Group NUMC 3 0 SKOGRP
SFDLEV Not Used CHAR 2 0 OVERW2
APLAN Cash Management Update Period in Years NUMC 2 0 VVAPLAN
AUSWA Financial Assets Management field selection string CHAR 100 0 VVFEAUS
AARCHI Retention period in archive in years NUMC 2 0 VVAARCHI
SVERDI Summarization indicator CHAR 1 0 VVSVERDI
AVERDI Uncompressed period in years NUMC 2 0 VVAVERDI
NUMKR Number Range CHAR 2 0 NUMKR
JEINBEHALT Indicator for withholding of amount during disbursement CHAR 1 0 VVJEINBE
SEFFMETH Effective Interest Method (Financial Mathematics) NUMC 1 0 SEFFMETH_NEW
1 PAngV (Until 09/01/2000)
2 ICMA
3 Braess
4 Moosmueller
5 US Treasury
6 EU Act/365
7 Bond formula
8 EU 30.42/365
9 Linear
SZBMETH Interest Calculation Method CHAR 1 0 SZBMETH
0 Not Specified
1 360E/360
2 act/360
3 act/365
4 act/366
5 act/actP (ICMA)
6 act/actY (ISDA)
7 360/360
8 30.42E/360
9 *365.25/360
A actW/252
B 360E/365
C 365/365
D 365/360
E act/364
F 360/360 (ISDA)
G act/actE (AFB)
H 360/365 (ISDA)
I 360E/actY
J m+act/360
K m+30/360
L 360/360 (German)
M act/365P
N act/365L
P 1/1
Q act/actEP (AFB)
R act/365.25
S act/365Y
T act/act[M]
U actW/actW[M]
SDISEIN Type of Discount Withholding CHAR 1 0 SDISEIN
1 Total with first disbursement
2 Proportionate per partial disbursement
3 Total with last disbursement
PDISLIMIT Discount limit accrued DEC 10 7 PDISLIMIT
SSOLIST Plan/Actual principle CHAR 1 0 VVSSOLIST
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 CHAR 1 0 BUHAL
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 NUMC 2 0 TWX1 VVRANLWI
VVRANLWI2 No. of the Secondary Index Description for Class Data NUMC 2 0 TWX1 VVRANLWI
JAUSWA Control whether field selection from TZPA or TZPAB is used CHAR 1 0 VVJAUSWA
ANRSTELL Number of characters in asset number NUMC 2 0 VVANRSTELL
SKOMPNAM Component name key CHAR 3 0 TZN02 VVSKOMPNAM
ZLSCH Payment Method CHAR 1 0 T042Z DZLSCH
SZLAVER Payment block for processing open items CHAR 1 0 T008 VVSZLAVER
SZVDEB Payment summarization level NUMC 2 0 VVSZVDEB
01 Customer
02 Finance project
03 Contract
SDEBAUT Automatic customer indicator CHAR 1 0 VVSDEBAUT
SBUST Posting Control Key NUMC 2 0 TZB09 VVSBUST
SZEGEN Generate Incoming Payment Immediately NUMC 2 0 TD21 SZEGEN
SEFFM2 Effective Interest Method (Financial Mathematics) NUMC 1 0 SEFFMETH
1 PAngV (Until 09/01/2000)
2 ICMA
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 NUMC 2 0 TVZ01 VVSZKEY
MNUMKR Number Range CHAR 2 0 NUMKR
VVSHBEB Special G/L Indicator for Withholding Amounts CHAR 1 0 T074U VVSHBEB
BESCHL Decision-making active indicator CHAR 1 0 BESCHL
JZWJAHR Payment form refers to effective from date of condition CHAR 1 0 VVJZWJAHR
SZSPZE Blocking reason for incoming payment postprocessing CHAR 1 0 T008 VVZSPZE
SINKKOKO Inclusive indicator for the end of the fixed period CHAR 1 0 VVSINKKOKO
SABGRENZ Loan Discount Accrual/Deferral Method CHAR 1 0 VVSABGRD
0 Acc. to flow type
1 Linear
2 Proportional to interest
8 SAC Net
9 None or manual
SFEST Indicator for Control of Fixed Contract CHAR 1 0 VVFESTKZ
0 Fixed contract possible
1 Only manual fixed contract
2 No fixed contract
JORIG Posting system indicator for borrower's note loans NUMC 1 0 BUCHSYS
1 Gross
2 Net
DSART Planning type CHAR 2 0 T037 DSART
JAUSZVI Default Value for Inclusive Indicator for Interest Val.Date CHAR 1 0 VVJAUSZVI
SMANSP Dunning block for customer account payments to third-party CHAR 1 0 T040S SMANSP
STAXGEN Indicator for tax generation CHAR 1 0 STAXGEN
SDUNNCMP Summarization Level for Dunning Letter CHAR 2 0 SDUNNCMP
Loan contract
BO Main borrower
FP Finance project
SDUNNACT Dunning Active CHAR 1 0 SDUNNACT
SDUNOINF Dunning History Cannot Be Changed CHAR 1 0 SDUNOINF
SDUNPOST Posting Variant for Dunning Charges/Interest fr. Dunning Run CHAR 1 0 SDUNPOST
SKOFIAKT Account determination ID for reversal CHAR 1 0 SKOFIAKT
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 CHAR 1 0 SHISTAKT
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 CHAR 1 0 SSTORNOEBENEZEV
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 CHAR 1 0 JPAYMENTREQ
SREVALEXCL Price gains w/o proportionate gains from deferral write-back CHAR 1 0 VVSREVALEXCL
SBOTERM Unscheduled Repayment: Indicator for Shortening End of Term CHAR 1 0 SBOTERM
SPACUKY Currency Key CUKY 5 0 TCURC WAERS
SBOINCL Unscheduled Repayment: Default Value for Inclusive Indicator CHAR 1 0 SBOINCL
ZLSCH_OI_RE Payment Method for Reactivated Open Items CHAR 1 0 T042Z TB_ZLSCH_OI_RE
ZAHLS_OI_RE Payment Block for Reactivated Open Items CHAR 1 0 T008 TB_ZAHLS_OI_RE
COM_VAL_CLASS General Valuation Class NUMC 4 0 TRGC_COM_VALCL TPM_COM_VAL_CLASS
MONTHS_BR Analysis Period Returned Direct Debits in Months NUMC 2 0 TB_MONTHS_BR
FLG_NON_ACCRUAL Non-Accrual Status Permitted CHAR 1 0 TB_FLG_NON_ACCRUAL
ST_NON_ACC Dunning Level From which Non-Accrual Status Applies NUMC 1 0 TB_NON_ACCRUAL_START
MABER Dunning Area CHAR 2 0 * MABER
ZAHLS_IA Payment on Request CHAR 1 0 T008 TB_ZAHLS_IA
MARKUP Put Back Key Date in Position Management NUMC 2 0 TB_MARKUP
MAHNA Dunning Procedure CHAR 4 0 * MAHNA
AUSWA_B Financial Assets Management field selection string CHAR 100 0 VVFEAUS
USE_DIFF_CUSTOMER Post to different customer account CHAR 1 0 FVD_USE_DIFFERENT_CUSTOMER
SFIMA_SETUP_CC Settings for FiMa Connection (Company Code dependent) INT1 3 0 TB_SFIMA_SETUP_CC
SHOW_COND_ITEMS_SCREEN Show Additional Condition Items Screen CHAR 1 0 TB_CONDITION_ITEMS_SCREEN
REV_DISB_SET_ACCOUNT Set Account for Reversal of Cleared Disbursements NUMC 1 0 TB_REV_DISB_SET_ACCOUNT
REV_DISB_SET_DEFAULT Set Default Account for Reversal of Cleared Disbursements NUMC 1 0 TB_REV_DISB_SET_DEFAULT
REV_EXCL_IOA Exclude Flows from IOA Calculation from Reversal ? CHAR 1 0 TB_REV_EXCL_IOA
IOA_WITH_RFR Enable IOA calculation with Risk-free Rates CHAR 1 0 TB_IOA_WITH_RFR
FLG_DCAC_OI Sort Open Items based on Loan Classification CHAR 1 0 TB_FLG_OI_DCAC
FLG_NEG_INT Enhanced support of negative interest CHAR 1 0 TB_FLG_NEG_INT
ZAHLS_NAD Blocking reason for new auto debit (SEPA direct debit) CHAR 1 0 T008 TB_PAYMENT_BLOCK_AUTODEBIT
BROUNDUNIT Default Rounding Unit for Amounts DEC 13 7 TB_BROUNDUNIT_PRE
SROUND Default Value for Round. Ctgy (Round up, Down or Number Rdg) CHAR 1 0 TB_SROUND_PRE
DCALLEND_OFF Provision Period in Months NUMC 2 0 TB_DCALLEND_OFF
CHK_COND Checkbox: Check for Condition Item Changes CHAR 1 0 CHK_COND

TZPAB foreign key relationships

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