TZPAB 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
TZPAB 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 TZPAB table consists of various fields, each holding specific information or linking keys about Financial Assets Management product types data available in SAP. These include BUKRS (Company Code), GSART (Product Type), SKOGRP (Condition Group), SFDLEV (Not used).. 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)
SAP TZPAB 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 | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
SKOGRP | Condition Group | SKOGRP | NUMC | 3 | Assigned to domain | SKOGRP | |||
SFDLEV | Not used | OVERW2 | CHAR | 2 | CHAR2 | ||||
APLAN | Cash management update period in years | VVAPLAN | NUMC | 2 | NUM02 | ||||
AUSWA | Financial Assets Management field selection string | VVFEAUS | CHAR | 100 | TEXT100 | ||||
AARCHI | Retention period in archive in years | VVAARCHI | NUMC | 2 | NUM02 | ||||
SVERDI | Summarization indicator | VVSVERDI | CHAR | 1 | JANEI | ||||
AVERDI | Uncompressed period in years | VVAVERDI | NUMC | 2 | NUM02 | ||||
NUMKR | Number range | NUMKR | CHAR | 2 | CHAR2 | ||||
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 | Plan/Actual principle | VVSSOLIST | CHAR | 1 | VVSSOLIST | ||||
SBUHAL | Setting for FI posting | BUHAL | CHAR | 1 | BUHAL | ||||
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 | |||
JAUSWA | Control whether field selection from TZPA or TZPAB is used | VVJAUSWA | CHAR | 1 | JANEI | ||||
ANRSTELL | Number of characters in asset number | VVANRSTELL | NUMC | 2 | NUM02 | ||||
SKOMPNAM | Component name key | VVSKOMPNAM | CHAR | 3 | TZN02 | VVSKOMPNAM | |||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
SZLAVER | Payment block for processing open items | VVSZLAVER | CHAR | 1 | T008 | ZAHLS | |||
SZVDEB | Payment summarization level | VVSZVDEB | NUMC | 2 | VVSZVDEB | ||||
SDEBAUT | Automatic customer indicator | VVSDEBAUT | CHAR | 1 | JANE | ||||
SBUST | Posting control key | VVSBUST | NUMC | 2 | TZB09 | VVSBUST | |||
SZEGEN | Generate incoming payment immediately | SZEGEN | NUMC | 2 | TD21 | SZEGEN | |||
SEFFM2 | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
SZKEY | Indicator for Control of Incoming Payment Distribution | VVSZKEY | NUMC | 2 | TVZ01 | VVSZKEY | |||
MNUMKR | Number range | NUMKR | CHAR | 2 | CHAR2 | ||||
VVSHBEB | Special G/L Indicator for Withholding Amounts | VVSHBEB | CHAR | 1 | T074U | UMSKZ | |||
BESCHL | Decision-making active indicator | BESCHL | CHAR | 1 | JANE | ||||
JZWJAHR | Payment form refers to effective from date of condition | VVJZWJAHR | CHAR | 1 | XFELD | ||||
SZSPZE | Blocking reason for incoming payment postprocessing | VVZSPZE | CHAR | 1 | T008 | ZAHLS | |||
SINKKOKO | Inclusive indicator for the end of the fixed period | VVSINKKOKO | CHAR | 1 | XFELD | ||||
SABGRENZ | Loan Discount Accrual/Deferral Method | VVSABGRD | CHAR | 1 | VVSABGRD | ||||
SFEST | Indicator for Control of Fixed Contract | VVFESTKZ | CHAR | 1 | VVFESTKZ | ||||
JORIG | Posting system indicator for borrower's note loans | BUCHSYS | NUMC | 1 | BUCHSYS | ||||
DSART | Planning type | DSART | CHAR | 2 | T037 | DSART | FFA | ||
JAUSZVI | Default Value for Inclusive Indicator for Interest Val.Date | VVJAUSZVI | CHAR | 1 | KENZX | ||||
SMANSP | Dunning block for customer account payments to third-party | SMANSP | CHAR | 1 | T040S | MANSP | |||
STAXGEN | Indicator for tax generation | STAXGEN | CHAR | 1 | XFELD | ||||
SDUNNCMP | Summarization Level for Dunning Letter | SDUNNCMP | CHAR | 2 | SDUNNCMP | ||||
SDUNNACT | Dunning Active | SDUNNACT | CHAR | 1 | XFELD | ||||
SDUNOINF | Dunning History Cannot Be Changed | SDUNOINF | CHAR | 1 | XFELD | ||||
SDUNPOST | Posting Variant for Dunning Charges/Interest fr. Dunning Run | SDUNPOST | CHAR | 1 | VDDUNPOST | ||||
SKOFIAKT | Account determination ID for reversal | SKOFIAKT | CHAR | 1 | SKOFIAKT | ||||
SHISTAKT | Indicator for CML Reference Unit | SHISTAKT | CHAR | 1 | SHISTAKT | ||||
SSTORNOEBENEZEV | Reversal level for reversing incoming payments | SSTORNOEBENEZEV | CHAR | 1 | SSTORNOEBENEZEV | ||||
JPAYMENTREQ | Payment Details Active | JPAYMENTREQ | CHAR | 1 | XFELD | ||||
SREVALEXCL | Price gains w/o proportionate gains from deferral write-back | VVSREVALEXCL | CHAR | 1 | XFELD | ||||
SBOTERM | Unscheduled Repayment: Indicator for Shortening End of Term | SBOTERM | CHAR | 1 | SBO_TERM | ||||
SPACUKY | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
.INCLU--AP | 0 | ||||||||
SBOINCL | Unscheduled Repayment: Default Value for Inclusive Indicator | SBOINCL | CHAR | 1 | KENZX | ||||
ZLSCH_OI_RE | Payment Method for Reactivated Open Items | TB_ZLSCH_OI_RE | CHAR | 1 | T042Z | ZLSCH | |||
ZAHLS_OI_RE | Payment Block for Reactivated Open Items | TB_ZAHLS_OI_RE | CHAR | 1 | T008 | ZAHLS | |||
COM_VAL_CLASS | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | TRGC_COM_VALCL | TPM_COM_VAL_CLASS | CVC | ||
MONTHS_BR | Analysis Period Returned Direct Debits in Months | TB_MONTHS_BR | NUMC | 2 | NUMC2 | ||||
FLG_NON_ACCRUAL | Non-Accrual Status Permitted | TB_FLG_NON_ACCRUAL | CHAR | 1 | XFELD | ||||
ST_NON_ACC | Dunning Level From which Non-Accrual Status Applies | TB_NON_ACCRUAL_START | NUMC | 1 | MAHNS | ||||
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
ZAHLS_IA | Payment on Request | TB_ZAHLS_IA | CHAR | 1 | T008 | ZAHLS | |||
MARKUP | Put Back Key Date in Position Management | TB_MARKUP | NUMC | 2 | NUM2 | ||||
MAHNA | Dunning Procedure | MAHNA | CHAR | 4 | Assigned to domain | MAHNA | |||
AUSWA_B | Financial Assets Management field selection string | VVFEAUS | CHAR | 100 | TEXT100 | ||||
.INCLU--AP | 0 | ||||||||
ZAHLS_NAD | Blocking reason for new auto debit (SEPA direct debit) | TB_PAYMENT_BLOCK_AUTODEBIT | CHAR | 1 | T008 | ZAHLS | |||
.INCLU--AP | 0 | ||||||||
BROUNDUNIT | Default Rounding Unit for Amounts | TB_BROUNDUNIT_PRE | DEC | 13(7) | TFMSRUNIT | ||||
SROUND | Default Value for Round. Ctgy (Round up, Down or Number Rdg) | TB_SROUND_PRE | CHAR | 1 | TFM_SROUND | ||||
DCALLEND_OFF | Provision Period in Months | TB_DCALLEND_OFF | NUMC | 2 | NUMC2 | ||||
.INCLU--AP | 0 | ||||||||
CHK_COND | Checkbox: Check for Condition Item Changes | CHK_COND | CHAR | 1 | JANE |
Key field | Non-key field |
How do I retrieve data from SAP table TZPAB using ABAP code
The following ABAP code Example will allow you to do a basic selection on TZPAB to SELECT all data from the tableDATA: WA_TZPAB TYPE TZPAB.
SELECT SINGLE *
FROM TZPAB
INTO CORRESPONDING FIELDS OF WA_TZPAB
WHERE...
How to access SAP table TZPAB
Within an ECC or HANA version of SAP you can also view further information about TZPAB 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