TZPA SAP (Financial Assets Management Product Types) Table details
Dictionary Type: Table
Description: Financial Assets Management Product Types
Description: Financial Assets Management Product Types
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 custDisplay/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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
GSART | Product Type | VVSART | CHAR | 3 | VVSART | SAN | VVSART_APPL_BAS | ||
RANTYP | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
SANLF | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
SKOGRP | Condition Group | SKOGRP | NUMC | 3 | TZK04 | SKOGRP | |||
SFDLEV | Not used | OVERW2 | CHAR | 2 | CHAR2 | ||||
APLAN | Cash management update period in years | VVAPLAN | NUMC | 2 | NUM02 | ||||
SAKTPAS | Indicator: Asset/Liability Transaction | VVSAKTPAS | CHAR | 1 | VVSAKTPAS | ||||
AUSWA | Financial Assets Management field selection string | VVFEAUS | CHAR | 100 | TEXT100 | ||||
NUMKR | Number range | NUMKR | CHAR | 2 | CHAR2 | ||||
JREFER | Reference data indicator | JREFER | CHAR | 1 | JANEI | ||||
JEINBEHALT | Indicator for withholding of amount during disbursement | VVJEINBE | CHAR | 1 | KENZX | ||||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
SDISEIN | Type of Discount Withholding | SDISEIN | CHAR | 1 | SDISEIN | ||||
PDISLIMIT | Discount limit accrued | PDISLIMIT | DEC | 10(7) | DEC3_7 | ||||
SSOLIST | Calculation using actual principle (or debit) | SSOLIST | CHAR | 1 | CHAR1 | ||||
VVRANLWI1 | No. of the secondary index description for class data | VVRANLWI | NUMC | 2 | TWX1 | VVRANLWI | |||
VVRANLWI2 | No. of the secondary index description for class data | VVRANLWI | NUMC | 2 | TWX1 | VVRANLWI | |||
SZPA | Interest per disbursement | SZPA | CHAR | 1 | VVZPA | ||||
SORDER | Borrower's note via order management | VVSORDER | CHAR | 1 | XFELD | ||||
SREVAL | Determine price gain taking account of accruals/deferrals | VVSREVAL | CHAR | 1 | XFELD | ||||
DSART | Planning type | DSART | CHAR | 2 | T037 | DSART | FFA | ||
SASGNCOMP | Assign product type to TR-TM component | VVSASSIGNCOMP | CHAR | 1 | XFELD | ||||
SREVALEXCL | Price gains w/o proportionate gains from deferral write-back | VVSREVALEXCL | CHAR | 1 | XFELD | ||||
SCOLLATER | Collateral active | SCOLLATERAL | CHAR | 1 | XFELD | ||||
SREALEST | Objects Active | SREALESTATE | CHAR | 1 | XFELD | ||||
SUSEREXIT | User exit 14 active | SUSEREXIT | CHAR | 1 | XFELD | ||||
DRAWNART | Product Type of the Drawn Bond | DRAWN_PRODUCTTYPE | CHAR | 3 | TZPA | VVSART | SAN | VVSART | |
DRAWNTEXT | Additional Text for the Class of Drawn Positions | DRAWNTEXT | CHAR | 10 | TEXT10 | ||||
.INCLU--AP | 0 | ||||||||
SPRODUCT | Check Against Underlying Product | SPRODUCT | CHAR | 1 | T_FVD_PRODUCT | ||||
SFASTENTRY | Creation Only Permitted Via Process Consumer Loan' | SFASTENTRY | CHAR | 1 | XFELD | ||||
SLIVEINS | Credit Life Insurance Active | SLIVEINS | CHAR | 1 | XFELD | ||||
SDISBURSE | Disbursement Permitted Only Via Loan | SDISBURSE | CHAR | 1 | XFELD | ||||
SDEFERRAL | Deferral Active | SDEFERRAL | CHAR | 1 | XFELD | ||||
SARREARCAP | Capitalization of Overdue Items Active | SARREARCAP | CHAR | 1 | X | ||||
SNOTICE | Payoff for Consumer Loans Active | SNOTICE | CHAR | 1 | XFELD | ||||
SNOTICE_LENDER | Notice for Consumer Loans Active | SNOTICE_LENDER | CHAR | 1 | XFELD | ||||
SCAPITALTRANSFER | Capital Transfer Active | SCAPITALTRANSFER | CHAR | 1 | XFELD | ||||
SBODISBACTIVE | Business Operation Disbursement Active | SBODISBACTIVE | CHAR | 1 | XFELD | ||||
SAUTOPAYPP | Automatic Payment Postprocessing Active | SAUTOPAYPP | CHAR | 1 | XFELD | ||||
SEXTDUNING | Extended Dunning Active | SEXTDUNNING | CHAR | 1 | XFELD | ||||
SRELEASE | Start Release Only if Product Breached | SRELEASE | CHAR | 1 | XFELD | ||||
SESCROW | Escrow Active | SESCROW | CHAR | 1 | XFELD | ||||
SINSURANCE | Indicator: Insurance Active for Product Type | SUSINSURANCE | CHAR | 1 | XFELD | ||||
SNO_CONDITIONS | Indicator Do Not Create Conditions for This Product Type | SNO_CONDITIONS | CHAR | 1 | XFELD | ||||
CMS | Link to CMS Relevant for Transaction Type | TB_GSART_CMS | CHAR | 1 | FLAG | ||||
.INCLU--AP | 0 | ||||||||
SIOA | IOA Active | TB_IOA_ACTV | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
SLPG | Limit Product Group | TB_SLPG | CHAR | 3 | ATLPG | T_SLPG | TB_SLPG | ||
.INCLU--AP | 0 | ||||||||
IC_PROD_TYPE | Product Type Investor Contract | TB_IC_PROD_TYPE | CHAR | 1 | TZIC | T_IC_TYPE | |||
.INCLU--AP | 0 | ||||||||
REFRATE | Flag to activate/deactivate the multi-int. rate during disb. | TB_REFRATE_CMLCHN | CHAR | 1 | FLAG | ||||
.INCLU--AP | 0 | ||||||||
RES_TIME_VALUE | Residence Time Value | TB_RES_TIME_VALUE | NUMC | 3 | T_RES_TIME_VALUE | ||||
RES_TIME_UNIT | Residence Time Unit | TB_RES_TIME_UNIT | CHAR | 6 | T_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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects