SAP VZZKOKO Table condition header Table
Overview
VZZKOKO is a standard SAP S/4HANA table that stores Table condition header data. There are total 81 fields in the VZZKOKO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VZZKOKO belongs to Treasury and Risk Management (FIN-FSCM-TRM) module and is located in the package TR - Objects from FVV in both Loans/Securities areas (FTVV).
In addition, following links provide an overview of foreign key relationships, if any, that link VZZKOKO to other SAP tables and standard CDS views available based on VZZKOKO table in S/4HANA 2020.
Techincal Settings of VZZKOKO
Below are technical details of the table VZZKOKO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VZZKOKO Fields
The following table gives you an overview of the fields available in VZZKOKO
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SANLF | Product Category | SANLF | NUMC | 3 | |
| RKEY1 | Key part 1 | RKEY1 | CHAR | 13 | |
| DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | |
| NLFD_ANG | Offer consecutive number | NLFD_ANG | NUMC | 3 | |
| SSTATI | Status of data record | SSTATI | NUMC | 2 | |
| SKOKOART | Type of Condition Header | SKOKOART | NUMC | 2 | |
| STILGRHY | Payment cycle | STILGRHY | NUMC | 2 | |
| STILGART | Repayment Type Indicator | STILGART | NUMC | 1 | |
| SDISEIN | Type of Discount Withholding | SDISEIN | CHAR | 1 | |
| KZAHLUNG | Pay-in/disbursement rate | KZAHLUNG | DEC | 10 | |
| BZAHLUNG | Pay-in/disbursement amount | BZAHLUNG | CURR | 13 | |
| SWHRZHLG | Currency of payment amount | SWHRZHLG | TCURC | CUKY | 5 |
| BZUSAGE | Commitment capital | BZUSAGE | CURR | 13 | |
| SWHRZUSA | Currency of commitment amount | SWHRZUSA | TCURC | CUKY | 5 |
| PEFFZINS | Effective Interest Rate | TB_EFF_RATE | DEC | 10 | |
| SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH_NEW | NUMC | 1 | |
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| SDISKO | Discounted | SDISKO | CHAR | 1 | |
| DKUEND | Date of notice | DKUEND | DATS | 8 | |
| SKUEND | Reason for Notice | SKUEND | TD04 | NUMC | 3 |
| DKUENDDG | Earliest Possible Date for Notice Given by the Lender | DKUENDDG | DATS | 8 | |
| DBLFZ | Start of Term | DBLFZ | DATS | 8 | |
| DBLFZ_ORIGIN | Original Term Start | DBLFZ_ORIGIN | DATS | 8 | |
| DELFZ | End of Term | DELFZ | DATS | 8 | |
| DRESAM | Reservation of Conditions On | DRESAM | DATS | 8 | |
| DRESBIS | Reservation of Conditions Until | DRESBIS | DATS | 8 | |
| DANGAM | Offer creation date | DANGAM | DATS | 8 | |
| DANGBIS | Offer Effective To | DANGBIS | DATS | 8 | |
| SANGVOR | Offer/Acceptance Reservation Indicator | SANGVOR | ATRESERVATION | NUMC | 2 |
| JANNAHME | Offer Acceptance Indicator | JANNAHME | CHAR | 1 | |
| SANNAHME | Type of offer acceptance indicator | SANNAHME | TD13 | NUMC | 2 |
| DANNAHME | Date of acceptance of offer | DANNAHME | DATS | 8 | |
| JVERTRAG | Indicator: Contract Created? | JVERTRAG | CHAR | 1 | |
| DVERTRAM | Contract creation date | DVERTRAM | DATS | 8 | |
| DVERTBIS | Return contract by | DVERTBIS | DATS | 8 | |
| PMANEFFZ | Internal Effective Interest Rate | TB_EFF_RATE_INT | DEC | 10 | |
| SEFFM2 | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | |
| SKUEGL | Notice Arrangement Lender | VVSKUEGL | TD28 | NUMC | 3 |
| RPNR | Activity number/rollover number | VVRPNR | NUMC | 8 | |
| DEFSZ | Date of fixed period end | VVDEFSZ | DATS | 8 | |
| DGES | Earliest Notice Date in acc. with the Legal Right of Notice | VVDGES | DATS | 8 | |
| SGESAUS | Legal Right of Notice Excluded | VVSGESAUS | CHAR | 1 | |
| SZKZ | Special int. ID for int. on arrears for remaining balance | VVSZKZ | TDSOZ | CHAR | 1 |
| NANGEBOT | Offer consecutive number | NLFD_ANG | NUMC | 3 | |
| SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | |
| ZVRHYEFF | Int.sttlmnt frequency for effective int.rate calc.in months | VVZVRHYEFF | NUMC | 3 | |
| PVGLEFFZ | Comparative Effective Interest | TB_EFF_RATE_COM | DEC | 10 | |
| SULTEFSZ | Month-end indicator for end of fixed period | VVSULTEFSZ | CHAR | 1 | |
| DABEFFZ | Date when calculation of effective rate starts | VVDABEFFZ | DATS | 8 | |
| DKUENDDN | Earliest Possible Date for Notice Given by the Borrower | VVDKUENDDN | DATS | 8 | |
| SKUEDN | Notice Arrangement Borrower | VVSKUEDN | TD29 | NUMC | 3 |
| SKUEART | Notice Type for the Loan | VVSKUEART | TD27 | NUMC | 3 |
| DMARKTZINS | ISB: Market Rate Date: Market Interest Rate for NPV Calc. | DMARKTZINS | DATS | 8 | |
| SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | |
| EDEFFZINS | Relevant for Closely Defined Effective Interest | TB_EFF_RATE_ED | DEC | 10 | |
| EDEFFMETH | Effective Interest Method - Acc. to EU Gdline Int.Statistics | EFFMETH | CHAR | 1 | |
| JAHREFFZINS | Relevant for Yearly Eff. Interest Acc Guideline 87/102/EU | TB_EFF_RATE_YEAR | DEC | 10 | |
| JAHREFFMETH | Effective Interest Method - Acc. to EU Gdline Int.Statistics | EFFMETH | CHAR | 1 | |
| PEFFZINS_ORIGIN | Original Effective Interest Rate | TB_EFF_RATE_ORIG | DEC | 10 | |
| PEFFZINS_ADD | Additional Effective Interest Rate | TB_EFF_RATE_ADD | DEC | 10 | |
| GROUP_ID | Grouping Procedure ID | VDML_GROUP_ID | * | NUMC | 6 |
| CLUSTER_NO | Cluster Number | VDML_CLUSTER_NUM | INT1 | 3 | |
| ORIG_CREDIT_SUM | Original Total Loan Amount | TB_VIEW_ORIGINAL_CREDIT_SUM | CURR | 13 | |
| DATE_REPAYMENT | Start Date for Repayment | TB_VIEW_DATE_REPAYMENT | DATS | 8 | |
| DATE_FIRST_RATE | Due Date for First Installment to Include a Repayment Amount | TB_VIEW_DATE_FIRST_RATE | DATS | 8 | |
| DAY_OF_PAYMENT | Day of Installment Payment | TB_VIEW_DAY_OF_PAYMENT | NUMC | 2 | |
| CLEARING_RATE | Amount for Final Loan Installment Payment | TB_VIEW_CLEARING_RATE | CURR | 13 | |
| EFF_INT_L_PYMNP | Effective Interest Rate for Last Change to Installment Plan | TB_MODEL_EFFECTIV_INTERSTS_PPC | DEC | 10 | |
| DEFF_INT_L_PYMNP | Key Date for Last Change to Installment Plan | TB_MODEL_DATE_LAST_PAYMENTPLAN | DATS | 8 | |
| CALCULATED_PARAM | Calculate Installment Amount or Number of Installments? | TB_MODEL_P_RATE_OR_TERM | CHAR | 4 | |
| CURR_CREDIT_SUM | Current Total Loan Amount | TB_VIEW_CURRENT_CREDIT_SUM | CURR | 13 | |
| BROUNDUNIT | Rounding Unit for Amounts | TB_BROUNDUNIT_A | DEC | 13 | |
| SROUND | Rounding Category (Round up Round Down or Number Rounding) | TB_SROUND_A | CHAR | 1 | |
| BOVERLIMIT | Drawing Tolerance as Amount | TB_COMP_OVERLIMIT_AMOUNT | CURR | 13 | |
| POVERLIMIT | Drawing Tolerance as a Percentage | TB_COMP_OVERLIMT_PERCENT | DEC | 10 | |
| CONTAB | Condition Table | TB_FICO_CONTAB | CHAR | 8 | |
| CONTAB_VERSION | Version Number for a Condition Table | TB_FICO_CONTAB_VERSION | NUMC | 4 | |
| TERM_PAYMENT | Category of Last Installment | TB_TERM_PAYMENT | CHAR | 1 | |
| PAPR_ORIGIN | Original U.S. Effective Interest Rate | TB_PAPR_ORIGIN | DEC | 10 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VZZKOKO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VZZKOKO | BUKRS | 1: 1 | T001 |
| VZZKOKO | MANDT | 1: 1 | T000 |
| VZZKOKO | SANGVOR | : | ATRESERVATION |
| VZZKOKO | SANNAHME | 1: CN | TD13 |
| VZZKOKO | SKUEART | : | TD27 |
| VZZKOKO | SKUEDN | : | TD29 |
| VZZKOKO | SKUEGL | : | TD28 |
| VZZKOKO | SKUEND | : | TD04 |
| VZZKOKO | SWHRZHLG | 1: 1 | TCURC |
| VZZKOKO | SWHRZUSA | 1: 1 | TCURC |
| VZZKOKO | SZKZ | 1: CN | TDSOZ |