SAP VZZKOPO Table condition items Table
Overview
VZZKOPO is a standard SAP S/4HANA table that stores Table condition items data. There are total 134 fields in the VZZKOPO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VZZKOPO belongs to Treasury and Risk Management (FIN-FSCM-TRM) module and is located in the package R/3 application development for Financial Assets Management (FVV).
In addition, following links provide an overview of foreign key relationships, if any, that link VZZKOPO to other SAP tables and standard CDS views available based on VZZKOPO table in S/4HANA 2020.
Techincal Settings of VZZKOPO
Below are technical details of the table VZZKOPO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VZZKOPO Fields
The following table gives you an overview of the fields available in VZZKOPO
| 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 | |
| RKEY2 | Key part 2 | RKEY2 | CHAR | 8 | |
| RKEY3 | Key part 3 | RKEY3 | CHAR | 8 | |
| DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | |
| NLFD_ANG | Offer consecutive number | NLFD_ANG | NUMC | 3 | |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | TZK01 | NUMC | 4 |
| DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | |
| NSTUFE | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | |
| SSTATI | Status of data record | SSTATI | NUMC | 2 | |
| PKOND | Percentage rate for condition items | PKOND | DEC | 10 | |
| BKOND | Condition Item Currency Amount | BKOND | CURR | 13 | |
| SWHRKOND | Currency of Condition Item | SWHRKOND | TCURC | CUKY | 5 |
| SBASIS | Calculation base reference | VVSBASIS | TZFB | CHAR | 4 |
| SZSREF | Reference Interest Rate | SZSREF | T056R | CHAR | 10 |
| SZSREFVZ | +/- sign / reference interest rate operator | SZSREFVZ | CHAR | 1 | |
| PFLUCT | Fluctuation margin | TFM_PFLUCT | DEC | 10 | |
| AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | |
| ATTRHY | Frequency in Days | ATTRHY | NUMC | 3 | |
| SZAWS | Payment form (at start of period mid-period at period end) | SZAWS | NUMC | 1 | |
| RDIVNR | Dividend coupon number | RDIVNR | NUMC | 3 | |
| JNULLKON | Condition Form | JNULLKON | CHAR | 1 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 |
| JBMONAT | Indicator for calculating amount per month | JBMONAT | CHAR | 1 | |
| DVALUT | Calculation Date | DVALUT | DATS | 8 | |
| DFAELL | Due date | DFAELL | DATS | 8 | |
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| ZLSCH | Payment Method | DZLSCH | T042Z | CHAR | 1 |
| BVTYP | Partner bank type | BVTYP | CHAR | 4 | |
| MABER | Dunning Area | MABER | T047M | CHAR | 2 |
| SPARTNR | Business Partner Number | BP_PARTNR_NEW | BUT000 | CHAR | 10 |
| RKONT | Quota number | RKONT | NUMC | 6 | |
| SVULT | Month-End Indicator for Calculation Date | VVSBULT | CHAR | 1 | |
| SFULT | Month-End Indicator for Due Date | SFULT | CHAR | 1 | |
| SVKALRI | Field is no longer used | VVSNVER1 | CHAR | 1 | |
| SFKALRI | Calculation of periods with flexible valid-to date? | VVSFKALRI | CHAR | 1 | |
| AVGSTAGE | Number of working days for value date | AVGSTAGE | NUMC | 2 | |
| AFGSTAGE | Number of working days to due date | AFGSTAGE | NUMC | 2 | |
| SVKALZUS | Field is no longer used | VVSNVER1 | CHAR | 1 | |
| SFKALZUS | Field is no longer used | VVSNVER1 | CHAR | 1 | |
| SKALID | Factory calendar | SKALID | TFACD | CHAR | 2 |
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| JSOFVERR | Immediate settlement | JSOFVERR | CHAR | 1 | |
| DALLGEM | General date | DALLGEM | DATS | 8 | |
| SZEGEN | Generate Incoming Payment Immediately | SZEGEN | TD21 | NUMC | 2 |
| SBUST | Posting control key | VVSBUST | TZB09 | NUMC | 2 |
| SKOPO | Detailed identification for condition items | VVSKOPO | TZK07 | NUMC | 2 |
| SALTKOND | Bracket condition for alternative conditions | VVSALTKOND | NUMC | 4 | |
| SZINSANP | Cross-referenced condition grp for interest rate adjustment | VVSZINSANP | NUMC | 4 | |
| SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | |
| SFORMREF | Formula reference for the cash flow calculator | VVSFORMREF | AT30 | CHAR | 4 |
| SVARNAME | Description of variables in cash flow calculator | VVSVARNAME | CHAR | 4 | |
| SVWERK | Shift calculation date to working day | VVSVWERK | NUMC | 1 | |
| SVMETH | Method for determining the next value date | VVSVMETH | NUMC | 1 | |
| SFWERK | Shift due date to working day | VVSFWERK | NUMC | 1 | |
| SFMETH | Method for determining the next due date | VVSFMETH | NUMC | 1 | |
| DPKOND | Fixing Date of Percentage Rate from Condition | VVDPKOND | DATS | 8 | |
| AZGSTAGE | Number of working days for interest fixing | AZGSTAGE | NUMC | 2 | |
| SZKALRI | Calendar direction for interest rate fixing | SZKALRI | CHAR | 1 | |
| DZSREF | Date fixing for benchmark interest rate in cash flow | VVDZSREF | DATS | 8 | |
| SKALID2 | Calendar ID 2 (valid in connection with calendar ID 1) | VVSKALID2 | TFACD | CHAR | 2 |
| SKALID3 | Calendar ID 3 (valid in connection with calendar ID 1) | VVSKALID3 | CHAR | 2 | |
| SKALID4 | Calendar ID 4 (valid in connection with calendar ID 1) | VVSKALID4 | CHAR | 2 | |
| SKALID5 | Calendar ID 5 (valid in connection with calendar ID 1) | VVSKALID5 | CHAR | 2 | |
| JGESUCHT | Int. indicator for alternative calculations | VVJGESUCHT | CHAR | 1 | |
| KURS1 | Exchange rate | KURSF | DEC | 9 | |
| BBASIS | Calculation Base Amount | BBASIS | CURR | 13 | |
| SZWERK | Shift to Working Day for Interest Fixing Date | VVSZWERK | NUMC | 1 | |
| SFINCL | Inclusive Indicator for Due Date | VVSFINCL | NUMC | 1 | |
| SRUNDVORF | Rounding of interim results for prepayments | VVSRUNDVF | NUMC | 1 | |
| SZWKEY | Payment form with adjustment days | VVSZWKEY | TDZW | CHAR | 2 |
| SFVMETH | Update Method for Calculation Date/Due Date | TB_SFVMETH | NUMC | 2 | |
| SDWERK | Working Day Shift for Payment Date | TB_SDWERK | NUMC | 1 | |
| SBERECH | Grace Period Interest Method | SBERECH | CHAR | 1 | |
| JPROZR | Percentage Calculation | TB_JPROZR | CHAR | 1 | |
| SZEITANT | Indicator for Pro Rata Temporis Calculations | VVSZEITANT | NUMC | 1 | |
| SFANT | Indicator for due date-related FiMa calculations | VVSFANT | NUMC | 1 | |
| SFRANZ | Shift Due Date | TFMSFRANZ | NUMC | 1 | |
| KBKOND | Condition amount independent of currency | VVKBKOND2 | DEC | 19 | |
| SBASFIX | Indicator for fixing calculation base | TFMSBASFIX | NUMC | 1 | |
| MANSP | Dunning Block | MANSP | T040S | CHAR | 1 |
| ZAHLS | Payment Block Key | DZLSPR | T008 | CHAR | 1 |
| BKONDQM | Currency amount per area unit | BKONDQM | CURR | 13 | |
| JAREA | Rental on basis of area? | VVJAREA | CHAR | 1 | |
| SFLART | Area type | SFLART | TIV08 | NUMC | 4 |
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | |
| AVGSTAGEVZ | +/- sign for number of working days for value date | AVGSTAGEVZ | CHAR | 1 | |
| AFGSTAGEVZ | +/- sign for number of working days for due date | AFGSTAGEVZ | CHAR | 1 | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 |
| JEXPOZINS | Type of Compound Interest Calculation | TFM_SINTCOMP | CHAR | 1 | |
| KOSTL | Cost center of internal contract | RECNKOSTL | CHAR | 10 | |
| GFZLSCH | Payment method for credit memos | RECNGFZLSCH | CHAR | 1 | |
| ZLSPR | Payment Block Key | DZLSPR | T008 | CHAR | 1 |
| SROUND | Rounding Category | TFM_SROUND | CHAR | 1 | |
| SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | |
| BMWST | Value-added tax amount included | BMWST | CURR | 13 | |
| XCROSS | Gross amount indicator | RECNXCROSS | CHAR | 1 | |
| PPAYMENT | Payment Rate | TFM_PPAYMENT | DEC | 11 | |
| AMMRHYZV | Interest Settlement Frequency for Exponential Interest Calc. | TFM_AMMRHYZV | NUMC | 2 | |
| PKOND2 | Percentage Rate for Condition Items | PKOND2 | DEC | 15 | |
| FACTOR_TYPE | Factor Type | TB_FACTYPE | CHAR | 10 | |
| SROUNDFACTOR | Rounding Category of a Factor | TFM_SROUNDFACTOR | CHAR | 1 | |
| ROUNDDECFACTOR | Number of Rounding Decimal Places for a Factor | TFM_ROUNDDECFACTOR | INT1 | 3 | |
| JEXPOINTFACTOR | Exponential Interest Calculation with Factor | TFM_JEXPOINTFACTOR | CHAR | 1 | |
| SROUNDBASEFACTOR | Rounding Category of a Base Factor | TFM_SROUNDBASEFACTOR | CHAR | 1 | |
| ROUNDDECBASEFACTOR | Number of Rounding Decimal Places for a Base Factor | TFM_ROUNDDECBASEFACTOR | INT1 | 3 | |
| SROUNDRATEFACTOR | Rounding Category of Interest Factor | TFM_SROUNDRATEFACTOR | CHAR | 1 | |
| ROUNDDECRATEFACTOR | Number of Rounding Decimal Places for Interest Factor | TFM_ROUNDDECRATEFACTOR | INT1 | 3 | |
| JAVGCAP | Use Upper Limit of Average Interest Rate | TFM_JAVGCAP | CHAR | 1 | |
| PAVGCAP | Upper Limit of Average Interest Rate | TFM_PAVGCAP | DEC | 15 | |
| JAVGFLOOR | Use Lower Limit of Average Interest Rate | TFM_JAVGFLOOR | CHAR | 1 | |
| PAVGFLOOR | Lower Limit of Average Interest Rate | TFM_PAVGFLOOR | DEC | 15 | |
| PAVGSPREAD | Average Interest Rate Spread | TFM_PAVGSPREAD | DEC | 15 | |
| SROUNDAVGINTEREST | Rounding Category of Average Interest Rate | TFM_SROUNDAVGINTEREST | CHAR | 1 | |
| ROUNDDECAVGINTEREST | Number of Rounding Decimal Places for Average Interest Rate | TFM_ROUNDDECAVGINTEREST | INT1 | 3 | |
| SAVGWEIGHT | Weighting Category of Interest Rate | TFM_SWEIGHT | CHAR | 1 | |
| SFACTORRESET | Event for Resetting Factor Calculation | TFM_SFACTORRESET | CHAR | 1 | |
| MNDID | Unique Reference to Mandate for each Payee | SEPA_MNDID | CHAR | 35 | |
| RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | |
| SEXCLGUEL | Exclusive indicator for start date of condition position | TFMSEXCLKP | NUMC | 1 | |
| SULTGUEL | Month-end indicator for start date of condition position | TFMSULT_KP | CHAR | 1 | |
| A_AMTMIN | Minimum Amount to Be Capitalized | TB_FICO_AAMTMIN | CURR | 13 | |
| A_AMTMAX | Maximum Amount to Be Capitalized | TB_FICO_AAMTMAX | CURR | 13 | |
| SSCHMETH | Calculation Method for Auto Debit Amount | TB_SSCHMETH | CHAR | 1 | |
| BAUDAMNT | Amount | TB_BAUDAMNT | CURR | 13 | |
| A_PAYDAY | Model Calculation: Day of Installment Payment (1-31) | TB_MODEL_PAYDAY | NUMC | 2 | |
| RCO | Bus. Operation No. (Installment Plan Change: Consumer Loan) | TB_MODEL_RCO | CHAR | 15 | |
| BROUNDUNIT | Rounding Unit for Amounts | TB_BROUNDUNIT_A | DEC | 13 | |
| BBASISUNIT | Base Unit for Rounding | TFM_BBASISUNIT | CURR | 17 | |
| GPDAYS | Tolerance Days for Grace Period | TB_GPDAYS_CMLCHN | NUMC | 2 | |
| IND_IOAGP | Indicator for IOA/GP condition item | TB_IOAGP_CMLCHN | CHAR | 1 | |
| DISBRATE | Disbursement Rate | TB_DISBRATE_CMLCHN | NUMC | 1 |
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 VZZKOPO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VZZKOPO | BUKRS | 1: 1 | T001 |
| VZZKOPO | KUNNR | 1: CN | KNA1 |
| VZZKOPO | LIFNR | 1: CN | LFA1 |
| VZZKOPO | MABER | 1: CN | T047M |
| VZZKOPO | MANDT | 1: 1 | T000 |
| VZZKOPO | MANSP | : | T040S |
| VZZKOPO | MWSKZ | 1: CN | T007A |
| VZZKOPO | SBASIS | 1: CN | TZFB |
| VZZKOPO | SBUST | 1: CN | TZB09 |
| VZZKOPO | SFLART | 1: CN | TIV08 |
| VZZKOPO | SFORMREF | 1: CN | AT30 |
| VZZKOPO | SKALID | 1: CN | TFACD |
| VZZKOPO | SKALID2 | 1: CN | TFACD |
| VZZKOPO | SKOART | 1: CN | TZK01 |
| VZZKOPO | SKOPO | 1: CN | TZK07 |
| VZZKOPO | SPARTNR | 1: CN | BUT000 |
| VZZKOPO | SWHRKOND | 1: 1 | TCURC |
| VZZKOPO | SZEGEN | 1: CN | TD21 |
| VZZKOPO | SZSREF | 1: CN | T056R |
| VZZKOPO | SZWKEY | 1: CN | TDZW |
| VZZKOPO | ZAHLS | : | T008 |
| VZZKOPO | ZLSCH | 1: CN | T042Z |
| VZZKOPO | ZLSPR | 1: CN | T008 |