SAP TZPA Table in S/4 HANA - Financial Assets Management Product Types
TZPA is a standard SAP Table which is used to store Financial Assets Management Product Types data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TZPA table(ECC)
Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: TZPA
TZPA table structure field list
Below is the full TZPA field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
| GSART | Product Type | VVSART | CHAR | 3(0) | VVSART | SAN | VVSART_APPL_BAS | GSART | ||
| RANTYP | Contract Type | RANTYP | CHAR | 1(0) | RANTYP | |||||
| SANLF | Product Category | SANLF | NUMC | 3(0) | TZAF | VVSANLF | ||||
| SKOGRP | Condition Group | SKOGRP | NUMC | 3(0) | TZK04 | SKOGRP | ||||
| SFDLEV | Not Used | OVERW2 | CHAR | 2(0) | CHAR2 | |||||
| APLAN | Cash management update period in years | VVAPLAN | NUMC | 2(0) | NUM02 | |||||
| SAKTPAS | Indicator: Asset/Liability Transaction | VVSAKTPAS | CHAR | 1(0) | VVSAKTPAS | |||||
| AUSWA | Financial Assets Management field selection string | VVFEAUS | CHAR | 100(0) | TEXT100 | |||||
| NUMKR | Number range | NUMKR | CHAR | 2(0) | CHAR2 | |||||
| JREFER | Reference data indicator | JREFER | CHAR | 1(0) | JANEI | |||||
| JEINBEHALT | Indicator for withholding of amount during disbursement | VVJEINBE | CHAR | 1(0) | KENZX | |||||
| SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1(0) | SEFFMETH | |||||
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1(0) | SZBMETH | |||||
| SDISEIN | Type of Discount Withholding | SDISEIN | CHAR | 1(0) | SDISEIN | |||||
| PDISLIMIT | Discount limit accrued | PDISLIMIT | DEC | 10(7) | DEC3_7 | |||||
| SSOLIST | Calculation using actual principle (or debit) | SSOLIST | CHAR | 1(0) | CHAR1 | |||||
| VVRANLWI1 | No. of the Secondary Index Description for Class Data | VVRANLWI | NUMC | 2(0) | TWX1 | VVRANLWI | ||||
| VVRANLWI2 | No. of the Secondary Index Description for Class Data | VVRANLWI | NUMC | 2(0) | TWX1 | VVRANLWI | ||||
| SZPA | Interest per disbursement | SZPA | CHAR | 1(0) | VVZPA | |||||
| SORDER | Borrower's note via order management | VVSORDER | CHAR | 1(0) | XFELD | |||||
| SREVAL | Determine price gain taking account of accruals/deferrals | VVSREVAL | CHAR | 1(0) | XFELD | |||||
| DSART | Planning type | DSART | CHAR | 2(0) | T037 | DSART | FFA | |||
| SASGNCOMP | Assign product type to TR-TM component | VVSASSIGNCOMP | CHAR | 1(0) | XFELD | |||||
| SREVALEXCL | Price gains w/o proportionate gains from deferral write-back | VVSREVALEXCL | CHAR | 1(0) | XFELD | |||||
| SCOLLATER | Collateral active | SCOLLATERAL | CHAR | 1(0) | XFELD | |||||
| SREALEST | Objects Active | SREALESTATE | CHAR | 1(0) | XFELD | |||||
| SUSEREXIT | User exit 14 active | SUSEREXIT | CHAR | 1(0) | XFELD | |||||
| DRAWNART | Product Type of the Drawn Bond | DRAWN_PRODUCTTYPE | CHAR | 3(0) | TZPA | VVSART | SAN | VVSART | GSART | |
| DRAWNTEXT | Additional Text for the Class of Drawn Positions | DRAWNTEXT | CHAR | 10(0) | TEXT10 | |||||
| CASH_FLOW_CALC | Securities Cash Flow Calculation | TPM_SEC_CASH_FLOW_CALC | CHAR | 2(0) | TPM_SEC_CASH_FLOW_CALC | |||||
| .INCLU--AP | 0(0) | |||||||||
| SPRODUCT | Check Against Underlying Product | SPRODUCT | CHAR | 1(0) | T_FVD_PRODUCT | |||||
| SFASTENTRY | Creation Only Permitted Via Process Consumer Loan' | SFASTENTRY | CHAR | 1(0) | XFELD | |||||
| SLIVEINS | Credit Life Insurance Active | SLIVEINS | CHAR | 1(0) | XFELD | |||||
| SDISBURSE | Disbursement Permitted Only Via Loan | SDISBURSE | CHAR | 1(0) | XFELD | |||||
| SDEFERRAL | Deferral Active | SDEFERRAL | CHAR | 1(0) | XFELD | |||||
| SARREARCAP | Capitalization of Overdue Items Active | SARREARCAP | CHAR | 1(0) | X | |||||
| SNOTICE | Payoff for Consumer Loans Active | SNOTICE | CHAR | 1(0) | XFELD | |||||
| SNOTICE_LENDER | Notice for Consumer Loans Active | SNOTICE_LENDER | CHAR | 1(0) | XFELD | |||||
| SCAPITALTRANSFER | Capital Transfer Active | SCAPITALTRANSFER | CHAR | 1(0) | XFELD | |||||
| SBODISBACTIVE | Business Operation Disbursement Active | SBODISBACTIVE | CHAR | 1(0) | XFELD | |||||
| SAUTOPAYPP | Automatic Payment Postprocessing Active | SAUTOPAYPP | CHAR | 1(0) | XFELD | |||||
| SEXTDUNING | Extended Dunning Active | SEXTDUNNING | CHAR | 1(0) | XFELD | |||||
| SRELEASE | Start Release Only if Product Breached | SRELEASE | CHAR | 1(0) | XFELD | |||||
| SESCROW | Escrow Active | SESCROW | CHAR | 1(0) | XFELD | |||||
| SINSURANCE | Indicator: Insurance Active for Product Type | SUSINSURANCE | CHAR | 1(0) | XFELD | |||||
| SNO_CONDITIONS | Indicator Do Not Create Conditions for This Product Type | SNO_CONDITIONS | CHAR | 1(0) | XFELD | |||||
| CMS | Link to CMS Relevant for Transaction Type | TB_GSART_CMS | CHAR | 1(0) | FLAG | |||||
| NEW_CHARGES | Show new charges in workplace | TB_SHOW_NEW_CHARGES | CHAR | 1(0) | XFELD | |||||
| .INCLU--AP | 0(0) | |||||||||
| SIOA | IOA Active | TB_IOA_ACTV | CHAR | 1(0) | XFELD | |||||
| .INCLU--AP | 0(0) | |||||||||
| SLPG | Limit Product Group | TB_SLPG | CHAR | 3(0) | ATLPG | T_SLPG | TB_SLPG | |||
| .INCLU--AP | 0(0) | |||||||||
| AUSWA_TRM | Financial Assets Management field selection string | VVFEAUS | CHAR | 100(0) | TEXT100 | |||||
| SEFFMETH_NEW | Effective Interest Method (Financial Mathematics) | SEFFMETH_NEW | NUMC | 1(0) | SEFFMETH_NEW | |||||
| .INCLU--AP | 0(0) | |||||||||
| IC_PROD_TYPE | Product Type Investor Contract | TB_IC_PROD_TYPE | CHAR | 1(0) | TZIC | T_IC_TYPE | ||||
| .INCLU--AP | 0(0) | |||||||||
| REFRATE | Flag to activate/deactivate the multi-int. rate during disb. | TB_REFRATE_CMLCHN | CHAR | 1(0) | FLAG | |||||
| .INCLU--AP | 0(0) | |||||||||
| FLG_PL | Flag - Integration with FS-PM / FS-CD is active | FVD_EI_PM | CHAR | 1(0) | BOOLE | |||||
| .INCLU--AP | 0(0) | |||||||||
| RES_TIME_VALUE | Residence Time Value | TB_RES_TIME_VALUE | NUMC | 3(0) | T_RES_TIME_VALUE | |||||
| RES_TIME_UNIT | Residence Time Unit | TB_RES_TIME_UNIT | CHAR | 6(0) | T_RES_TIME_UNIT | |||||
| .INCLU--AP | 0(0) | |||||||||
| NUMKR_LOT_NO | Number Range Interval for TRQ Lot Numbers | TPM_NUMKR_LOT_NO | CHAR | 2(0) | CHAR2 |
Search for further information about these or an SAP related objects