SAP VVKKFOPT Table for FS-CD Test Data of Structure VKKKFOP Table
Overview
VVKKFOPT is a standard SAP S/4HANA table that stores Table for FS-CD Test Data of Structure VKKKFOP data. There are total 72 fields in the VVKKFOPT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VVKKFOPT belongs to Collections/Disbursements (FS-CD) module and is located in the package FS-CD: Collections/Disbursements Functionality (ISCDFUN).
In addition, following links provide an overview of foreign key relationships, if any, that link VVKKFOPT to other SAP tables and standard CDS views available based on VVKKFOPT table in S/4HANA 2020.
Techincal Settings of VVKKFOPT
Below are technical details of the table VVKKFOPT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VVKKFOPT Fields
The following table gives you an overview of the fields available in VVKKFOPT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| GSFNR | Business Transaction Number | GSFNR_VK | CHAR | 16 | |
| BELNR | Transfer Document Number | BELNR_VK | CHAR | 6 | |
| LFDNB | Seq. Number - Single Document | LFDNB_VK | NUMC | 3 | |
| BETRW | Posting Amount with +/- Sign in CHAR Format | BETRG_VKC | CHAR | 27 | |
| BUGRD | Posting Reason | BUGRD_VK | * | NUMC | 3 |
| HVORG | Main Transaction for Line Item | HVORG_KK | * | CHAR | 4 |
| TVORG | Subtransaction for Document Item | TVORG_KK | * | CHAR | 4 |
| OPHVORG | Main Transaction for Line Item | HVORG_KK | * | CHAR | 4 |
| OPTVORG | Subtransaction for Document Item | TVORG_KK | * | CHAR | 4 |
| FAEDN | Due date for net payment | FAEDN_KK | DATS | 8 | |
| FAEDS | Due Date for Cash Discount | FAEDS_KK | DATS | 8 | |
| FOKNZ | Subledger Item Indicator | FOKNZ_VK | CHAR | 1 | |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| GSBER | Business Area | GSBER | * | CHAR | 4 |
| LNDSL | Country/Region Key | LAND1 | * | CHAR | 3 |
| PRGRP | Product Group | PRGRP_VK | * | CHAR | 2 |
| VKONT | Contract Account | VKONT_VK | * | CHAR | 12 |
| GPART | Business Partner | GPART_VK | * | CHAR | 10 |
| EMGPA | Alternative Business Partner for Payments | EMGPA_KK | * | CHAR | 10 |
| EMADE | Address number in external system | BU_ADEXT | CHAR | 20 | |
| EMBVT | Bank Details ID of Payee | EMBVT_KK | CHAR | 4 | |
| SPZAH | Lock Reason for Automatic Payment | SPZAH_KK | TFK008 | CHAR | 1 |
| SPZFD | Payment Lock Valid from | SPZFD_VK | DATS | 8 | |
| SPZTD | Payment lock valid to | SPZTD_VK | DATS | 8 | |
| PYMET | Payment Method | PYMET_KK | * | CHAR | 1 |
| PYGRP | Grouping field for automatic payments | PYGRP_KK | CHAR | 10 | |
| INDYN | Key for Index/Dynamic Basis of an Insurance Contract | INDYN_VK | CHAR | 5 | |
| INFAK | Index Value or Dynamic Factor in CHAR Format | INFAK_VKC | CHAR | 17 | |
| RBART | Legal Relationship Type | RBART_VK | * | CHAR | 2 |
| VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | |
| VTRE2 | Additional Reference Information | VTRE2_KK | CHAR | 20 | |
| VTRE3 | Supplementary contract number | VTREF_VK | CHAR | 20 | |
| VGPART2 | Business Partner Number | GPART_KK | * | CHAR | 10 |
| VGPART3 | Business Partner Number | GPART_KK | * | CHAR | 10 |
| STAKZ | Type of statistical item | STAKZ_KK | CHAR | 1 | |
| SKTPZ | Cash discount percentage rate | SKTPZ_VKC | CHAR | 11 | |
| STPRZ | Insurance tax percentage in CHAR format | STPRZ_VKC | CHAR | 11 | |
| GRKEY | Grouping Key for Displaying Open Items | GRKEY_KK | CHAR | 3 | |
| VERKZ | Item Can Only Be Cleared | VERKZ_KK | CHAR | 1 | |
| BEWAR | Transaction type | RMVCT | * | CHAR | 3 |
| VSARL_VX | Insurance Type | VSARL_VX | * | CHAR | 6 |
| KOSTL | Cost Center | KOSTL | * | CHAR | 10 |
| PRCTR | Profit Center | PRCTR | * | CHAR | 10 |
| ADKNZ | Additional Acct Assignments in BP Items as Well | ADKNZ_VK | CHAR | 1 | |
| OPTXT | Item text | OPTXT_KK | CHAR | 50 | |
| FDGRP | Planning Group | FDGRP_KK | * | CHAR | 10 |
| FDZTG | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 | |
| WWI00 | Component of the Version Number | CHAR2 | CHAR | 2 | |
| WWI01 | Component of the Version Number | CHAR2 | CHAR | 2 | |
| WWI02 | R/2 table | CHAR5 | CHAR | 5 | |
| WWI10 | Component of the Version Number | CHAR2 | CHAR | 2 | |
| WWI11 | 3-Byte field | CHAR3 | CHAR | 3 | |
| WWI12 | R/2 table | CHAR5 | CHAR | 5 | |
| WWI13 | Character field 8 characters long | CHAR8 | CHAR | 8 | |
| WWI20 | Component of the Version Number | CHAR2 | CHAR | 2 | |
| WWI30 | Component of the Version Number | CHAR2 | CHAR | 2 | |
| WWI40 | Character Field with Length 10 | CHAR10 | CHAR | 10 | |
| WWI50 | Field length 18 | CHAR18 | CHAR | 18 | |
| LNDSL_VX | Country Where Risk Is Situated | LNDSL_VX | TLXXLSL | CHAR | 3 |
| GSART_VX | Business Transaction Type | GSART_VX | TLXXGSA | CHAR | 2 |
| BSART_VX | In-Force Business Type | BSART_VX | TLXXBSA | CHAR | 2 |
| GZART_VX | Underwriting Type | GZART_VX | TLXXGZA | CHAR | 2 |
| SDART_VX | Type of Loss | SDART_VX | TLXXSDA | CHAR | 2 |
| SJAHR_VX | Year of loss | SJAHR_VX | CHAR | 4 | |
| MJAHR_VX | Reporting Year | MJAHR_VX | CHAR | 4 | |
| RSART_VX | Risk type | RSART_VX | TLXXRSA | CHAR | 2 |
| FUBER_VX | Insurance Functional Area | FUBER_VX | TLXXFUB | CHAR | 3 |
| BEBER_VX | Organizational area - insurance | BEBER_VX | TLXXBEB | CHAR | 3 |
| BSGRP_VX | In-Force Business Group for Pension Funds and Life Insurance | BSGRP_VX | TLXXBSG | CHAR | 3 |
| TESTTEXT | Graphic object type: description | NODE_TEXT | CHAR | 40 | |
| VVI91_ME | 3-Byte field | CHAR3 | CHAR | 3 |
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 VVKKFOPT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VVKKFOPT | BEBER_VX | : | TLXXBEB |
| VVKKFOPT | BSART_VX | : | TLXXBSA |
| VVKKFOPT | BSGRP_VX | : | TLXXBSG |
| VVKKFOPT | FUBER_VX | : | TLXXFUB |
| VVKKFOPT | GSART_VX | : | TLXXGSA |
| VVKKFOPT | GZART_VX | : | TLXXGZA |
| VVKKFOPT | LNDSL_VX | : | TLXXLSL |
| VVKKFOPT | RSART_VX | : | TLXXRSA |
| VVKKFOPT | SDART_VX | : | TLXXSDA |
| VVKKFOPT | SPZAH | 1: CN | TFK008 |