TZPA SAP (Financial Assets Management Product Types) Table details

Dictionary Type: Table
Description: Financial Assets Management Product Types




ABAP Code to SELECT data from TZPA
Related tables to TZPA
Access table TZPA




Table field list including key, data, relationships and ABAP select examples

TZPA is a standard SAP Table which is used to store Financial Assets Management Product Types data and is available within R/3 SAP systems depending on the version and release level.

The TZPA table consists of various fields, each holding specific information or linking keys about Financial Assets Management Product Types data available in SAP. These include GSART (Product Type), RANTYP (Contract Type), SANLF (Product Category), SKOGRP (Condition Group).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = TZPAT


SAP TZPA table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
GSARTProduct Type VVSARTCHAR3VVSARTSANVVSART_APPL_BAS
RANTYPContract Type RANTYPCHAR1RANTYP
SANLFProduct Category SANLFNUMC3TZAFVVSANLF
SKOGRPCondition Group SKOGRPNUMC3TZK04SKOGRP
SFDLEVNot used OVERW2CHAR2CHAR2
APLANCash management update period in years VVAPLANNUMC2NUM02
SAKTPASIndicator: Asset/Liability Transaction VVSAKTPASCHAR1VVSAKTPAS
AUSWAFinancial Assets Management field selection string VVFEAUSCHAR100TEXT100
NUMKRNumber range NUMKRCHAR2CHAR2
JREFERReference data indicator JREFERCHAR1JANEI
JEINBEHALTIndicator for withholding of amount during disbursement VVJEINBECHAR1KENZX
SEFFMETHEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
SDISEINType of Discount Withholding SDISEINCHAR1SDISEIN
PDISLIMITDiscount limit accrued PDISLIMITDEC10(7) DEC3_7
SSOLISTCalculation using actual principle (or debit) SSOLISTCHAR1CHAR1
VVRANLWI1No. of the secondary index description for class data VVRANLWINUMC2TWX1VVRANLWI
VVRANLWI2No. of the secondary index description for class data VVRANLWINUMC2TWX1VVRANLWI
SZPAInterest per disbursement SZPACHAR1VVZPA
SORDERBorrower's note via order management VVSORDERCHAR1XFELD
SREVALDetermine price gain taking account of accruals/deferrals VVSREVALCHAR1XFELD
DSARTPlanning type DSARTCHAR2T037DSARTFFA
SASGNCOMPAssign product type to TR-TM component VVSASSIGNCOMPCHAR1XFELD
SREVALEXCLPrice gains w/o proportionate gains from deferral write-back VVSREVALEXCLCHAR1XFELD
SCOLLATERCollateral active SCOLLATERALCHAR1XFELD
SREALESTObjects Active SREALESTATECHAR1XFELD
SUSEREXITUser exit 14 active SUSEREXITCHAR1XFELD
DRAWNARTProduct Type of the Drawn Bond DRAWN_PRODUCTTYPECHAR3TZPAVVSARTSANVVSART
DRAWNTEXTAdditional Text for the Class of Drawn Positions DRAWNTEXTCHAR10TEXT10
.INCLU--AP 0
SPRODUCTCheck Against Underlying Product SPRODUCTCHAR1T_FVD_PRODUCT
SFASTENTRYCreation Only Permitted Via Process Consumer Loan' SFASTENTRYCHAR1XFELD
SLIVEINSCredit Life Insurance Active SLIVEINSCHAR1XFELD
SDISBURSEDisbursement Permitted Only Via Loan SDISBURSECHAR1XFELD
SDEFERRALDeferral Active SDEFERRALCHAR1XFELD
SARREARCAPCapitalization of Overdue Items Active SARREARCAPCHAR1X
SNOTICEPayoff for Consumer Loans Active SNOTICECHAR1XFELD
SNOTICE_LENDERNotice for Consumer Loans Active SNOTICE_LENDERCHAR1XFELD
SCAPITALTRANSFERCapital Transfer Active SCAPITALTRANSFERCHAR1XFELD
SBODISBACTIVEBusiness Operation Disbursement Active SBODISBACTIVECHAR1XFELD
SAUTOPAYPPAutomatic Payment Postprocessing Active SAUTOPAYPPCHAR1XFELD
SEXTDUNINGExtended Dunning Active SEXTDUNNINGCHAR1XFELD
SRELEASEStart Release Only if Product Breached SRELEASECHAR1XFELD
SESCROWEscrow Active SESCROWCHAR1XFELD
SINSURANCEIndicator: Insurance Active for Product Type SUSINSURANCECHAR1XFELD
SNO_CONDITIONSIndicator Do Not Create Conditions for This Product Type SNO_CONDITIONSCHAR1XFELD
CMSLink to CMS Relevant for Transaction Type TB_GSART_CMSCHAR1FLAG
.INCLU--AP 0
SIOAIOA Active TB_IOA_ACTVCHAR1XFELD
.INCLU--AP 0
SLPGLimit Product Group TB_SLPGCHAR3ATLPGT_SLPGTB_SLPG
.INCLU--AP 0
IC_PROD_TYPEProduct Type Investor Contract TB_IC_PROD_TYPECHAR1TZICT_IC_TYPE
.INCLU--AP 0
REFRATEFlag to activate/deactivate the multi-int. rate during disb. TB_REFRATE_CMLCHNCHAR1FLAG
.INCLU--AP 0
RES_TIME_VALUEResidence Time Value TB_RES_TIME_VALUENUMC3T_RES_TIME_VALUE
RES_TIME_UNITResidence Time Unit TB_RES_TIME_UNITCHAR6T_RES_TIME_UNIT

Key field Non-key field



How do I retrieve data from SAP table TZPA using ABAP code

The following ABAP code Example will allow you to do a basic selection on TZPA to SELECT all data from the table
DATA: WA_TZPA TYPE TZPA.

SELECT SINGLE *
FROM TZPA
INTO CORRESPONDING FIELDS OF WA_TZPA
WHERE...

How to access SAP table TZPA

Within an ECC or HANA version of SAP you can also view further information about TZPA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!