SAP table TZPA (Financial Assets Management Product Types)

SAP table TZPA has 2 primary key fields being MANDT,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
GSART Product Type CHAR 3 0 VVSART
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
SANLF Product Category NUMC 3 0 TZAF SANLF
SKOGRP Condition Group NUMC 3 0 TZK04 SKOGRP
SFDLEV Not Used CHAR 2 0 OVERW2
APLAN Cash Management Update Period in Years NUMC 2 0 VVAPLAN
SAKTPAS Indicator: Asset/Liability Transaction CHAR 1 0 VVSAKTPAS
0 Asset Transaction
1 Liabilities Transaction
AUSWA Financial Assets Management field selection string CHAR 100 0 VVFEAUS
NUMKR Number Range CHAR 2 0 NUMKR
JREFER Reference data indicator CHAR 1 0 JREFER
JEINBEHALT Indicator for withholding of amount during disbursement CHAR 1 0 VVJEINBE
SEFFMETH 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
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 Calculation using actual principle (or debit) CHAR 1 0 SSOLIST
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
SZPA Interest per disbursement CHAR 1 0 SZPA
SORDER Borrower's note via order management CHAR 1 0 VVSORDER
SREVAL Determine price gain taking account of accruals/deferrals CHAR 1 0 VVSREVAL
DSART Planning type CHAR 2 0 T037 DSART
SASGNCOMP Assign product type to TR-TM component CHAR 1 0 VVSASSIGNCOMP
SREVALEXCL Price gains w/o proportionate gains from deferral write-back CHAR 1 0 VVSREVALEXCL
SCOLLATER Collateral active CHAR 1 0 SCOLLATERAL
SREALEST Objects Active CHAR 1 0 SREALESTATE
SUSEREXIT User exit 14 active CHAR 1 0 SUSEREXIT
DRAWNART Product Type of the Drawn Bond CHAR 3 0 TZPA DRAWN_PRODUCTTYPE
DRAWNTEXT Additional Text for the Class of Drawn Positions CHAR 10 0 DRAWNTEXT
CASH_FLOW_CALC Securities Cash Flow Calculation CHAR 2 0 TPM_SEC_CASH_FLOW_CALC
1 Variable Dividend
SPRODUCT Check Against Underlying Product CHAR 1 0 SPRODUCT
SFASTENTRY Creation Only Permitted Via Process Consumer Loan" CHAR 1 0 SFASTENTRY
SLIVEINS Credit Life Insurance Active CHAR 1 0 SLIVEINS
SDISBURSE Disbursement Permitted Only Via Loan CHAR 1 0 SDISBURSE
SDEFERRAL Deferral Active CHAR 1 0 SDEFERRAL
SARREARCAP Capitalization of Overdue Items Active CHAR 1 0 SARREARCAP
SNOTICE Payoff for Consumer Loans Active CHAR 1 0 SNOTICE
SNOTICE_LENDER Notice for Consumer Loans Active CHAR 1 0 SNOTICE_LENDER
SCAPITALTRANSFER Capital Transfer Active CHAR 1 0 SCAPITALTRANSFER
SBODISBACTIVE Business Operation Disbursement Active CHAR 1 0 SBODISBACTIVE
SAUTOPAYPP Automatic Payment Postprocessing Active CHAR 1 0 SAUTOPAYPP
SEXTDUNING Extended Dunning Active CHAR 1 0 SEXTDUNNING
SRELEASE Start Release Only if Product Breached CHAR 1 0 SRELEASE
SESCROW Escrow Active CHAR 1 0 SESCROW
SINSURANCE Indicator: Insurance Active for Product Type CHAR 1 0 SUSINSURANCE
SNO_CONDITIONS Indicator Do Not Create Conditions for This Product Type CHAR 1 0 SNO_CONDITIONS
CMS Link to CMS Relevant for Transaction Type CHAR 1 0 TB_GSART_CMS
NEW_CHARGES Show new charges in workplace CHAR 1 0 TB_SHOW_NEW_CHARGES
SFIMA_SETUP Settings for FiMa Connection INT1 3 0 TB_SFIMA_SETUP
SIOA IOA Active CHAR 1 0 TB_IOA_ACTV
SLPG Limit Product Group CHAR 3 0 ATLPG TB_SLPG
AUSWA_TRM Financial Assets Management field selection string CHAR 100 0 VVFEAUS
SEFFMETH_NEW 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
SFIMAMETHOD Cash Flow Calculation CHAR 1 0 VVSFIMAMETHOD
Single Interest Conditions
1 Parallel Interest Conditions
IC_PROD_TYPE Product Type Investor Contract CHAR 1 0 TZIC TB_IC_PROD_TYPE
REFRATE Flag to activate/deactivate the multi-int. rate during disb. CHAR 1 0 TB_REFRATE_CMLCHN
FLG_PL Flag - Integration with FS-PM / FS-CD is active CHAR 1 0 FVD_EI_PM
RES_TIME_VALUE Residence Time Value NUMC 3 0 TB_RES_TIME_VALUE
RES_TIME_UNIT Residence Time Unit CHAR 6 0 TB_RES_TIME_UNIT
NUMKR_LOT_NO Number Range Interval for TRQ Lot Numbers CHAR 2 0 TPM_NUMKR_LOT_NO

TZPA foreign key relationships

Table Field Check Table Check Field
0 TZPA DRAWNART TZPA Financial Assets Management Product Types MANDT
0 TZPA DRAWNART TZPA Financial Assets Management Product Types GSART
1 TZPA DSART T037 Planning Types DSART
0 TZPA SANLF TZAF Product categories SANLF
1 TZPA SKOGRP TZK04 Condition Groups MANDT
0 TZPA VVRANLWI1 TWX1 Class data sec. index numbers MANDT
0 TZPA VVRANLWI1 TWX1 Class data sec. index numbers VVRANLWI
1 TZPA VVRANLWI2 TWX1 Class data sec. index numbers MANDT
1 TZPA VVRANLWI2 TWX1 Class data sec. index numbers VVRANLWI