1. Home
  2. Resources
  3. SAP Tables
  4. TZPA - Financial Assets Management Product Types

SAP Table TZPA

Financial Assets Management Product Types

TZPA (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 TZPA to other SAP tables.

TZPA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
GSART Product Type VVSART CHAR 3 0
RANTYP Contract Type RANTYP CHAR 1 0
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
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
SANLF Product Category SANLF TZAF NUMC 3 0
SKOGRP Condition Group SKOGRP TZK04 NUMC 3 0
SFDLEV Not used OVERW2 CHAR 2 0
APLAN Cash management update period in years VVAPLAN NUMC 2 0
SAKTPAS Indicator: Asset/Liability Transaction VVSAKTPAS CHAR 1 0
0 Asset Transaction
1 Liabilities Transaction
AUSWA Financial Assets Management field selection string VVFEAUS CHAR 100 0
NUMKR Number range NUMKR CHAR 2 0
JREFER Reference data indicator JREFER CHAR 1 0
0 No
1 Yes
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 Calculation using actual principle (or debit) SSOLIST CHAR 1 0
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
SZPA Interest per disbursement SZPA CHAR 1 0
X Interest per disbursement
NULL Int.pmnt due date method
SORDER Borrower's note via order management VVSORDER CHAR 1 0
X Yes
NULL No
SREVAL Determine price gain taking account of accruals/deferrals VVSREVAL CHAR 1 0
X Yes
NULL No
DSART Planning type DSART T037 CHAR 2 0
SASGNCOMP Assign product type to TR-TM component VVSASSIGNCOMP 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
SCOLLATER Collateral active SCOLLATERAL CHAR 1 0
X Yes
NULL No
SREALEST Objects Active SREALESTATE CHAR 1 0
X Yes
NULL No
SUSEREXIT User exit 14 active SUSEREXIT CHAR 1 0
X Yes
NULL No
DRAWNART Product Type of the Drawn Bond DRAWN_PRODUCTTYPE TZPA CHAR 3 0
DRAWNTEXT Additional Text for the Class of Drawn Positions DRAWNTEXT CHAR 10 0
SPRODUCT Check Against Underlying Product SPRODUCT CHAR 1 0
NULL No Check
X Against Product Version when Contract Created
A Against Current Product Version
SFASTENTRY Creation Only Permitted Via Process Consumer Loan" SFASTENTRY CHAR 1 0
X Yes
NULL No
SLIVEINS Credit Life Insurance Active SLIVEINS CHAR 1 0
X Yes
NULL No
SDISBURSE Disbursement Permitted Only Via Loan SDISBURSE CHAR 1 0
X Yes
NULL No
SDEFERRAL Deferral Active SDEFERRAL CHAR 1 0
X Yes
NULL No
SARREARCAP Capitalization of Overdue Items Active SARREARCAP CHAR 1 0
X Yes
NULL No
SNOTICE Payoff for Consumer Loans Active SNOTICE CHAR 1 0
X Yes
NULL No
SNOTICE_LENDER Notice for Consumer Loans Active SNOTICE_LENDER CHAR 1 0
X Yes
NULL No
SCAPITALTRANSFER Capital Transfer Active SCAPITALTRANSFER CHAR 1 0
X Yes
NULL No
SBODISBACTIVE Business Operation Disbursement Active SBODISBACTIVE CHAR 1 0
X Yes
NULL No
SAUTOPAYPP Automatic Payment Postprocessing Active SAUTOPAYPP CHAR 1 0
X Yes
NULL No
SEXTDUNING Extended Dunning Active SEXTDUNNING CHAR 1 0
X Yes
NULL No
SRELEASE Start Release Only if Product Breached SRELEASE CHAR 1 0
X Yes
NULL No
SESCROW Escrow Active SESCROW CHAR 1 0
X Yes
NULL No
SINSURANCE Indicator: Insurance Active for Product Type SUSINSURANCE CHAR 1 0
X Yes
NULL No
SNO_CONDITIONS Indicator Do Not Create Conditions for This Product Type SNO_CONDITIONS CHAR 1 0
X Yes
NULL No
CMS Link to CMS Relevant for Transaction Type TB_GSART_CMS CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
SIOA IOA Active TB_IOA_ACTV CHAR 1 0
X Yes
NULL No
SLPG Limit Product Group TB_SLPG ATLPG CHAR 3 0
IC_PROD_TYPE Product Type Investor Contract TB_IC_PROD_TYPE TZIC CHAR 1 0
REFRATE Flag to activate/deactivate the multi-int. rate during disb. TB_REFRATE_CMLCHN CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
RES_TIME_VALUE Residence Time Value TB_RES_TIME_VALUE NUMC 3 0
001 Value should be within the specified range
RES_TIME_UNIT Residence Time Unit TB_RES_TIME_UNIT CHAR 6 0
Days Days
Months Months
Years Years

TZPA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TZPA DRAWNART TZPA MANDT TZPA Financial Assets Management Product Types MANDT
TZPA DRAWNART TZPA DRAWNART TZPA Financial Assets Management Product Types GSART
TZPA DSART TZPA MANDT T037 Planning Types MANDT
TZPA DSART TZPA DSART T037 Planning Types DSART
TZPA IC_PROD_TYPE TZPA IC_PROD_TYPE TZIC Product Type Investor Contract IC_PROD_TYPE
TZPA MANDT TZPA MANDT T000 Clients MANDT
TZPA SANLF TZPA SANLF TZAF Product categories SANLF
TZPA SKOGRP TZPA MANDT TZK04 Condition Groups MANDT
TZPA SKOGRP TZPA RANTYP TZK04 Condition Groups RANTYP
TZPA SKOGRP TZPA SKOGRP TZK04 Condition Groups SKOGRP
TZPA SLPG TZPA MANDT ATLPG Limit Product Group MANDT
TZPA SLPG TZPA SLPG ATLPG Limit Product Group SLPG
TZPA VVRANLWI1 TZPA VVRANLWI1 TWX1 Class data sec. index numbers VVRANLWI
TZPA VVRANLWI1 TZPA MANDT TWX1 Class data sec. index numbers MANDT
TZPA VVRANLWI2 TZPA MANDT TWX1 Class data sec. index numbers MANDT
TZPA VVRANLWI2 TZPA VVRANLWI2 TWX1 Class data sec. index numbers VVRANLWI