SAP VVKKFOP Single Doc in Posting Data Interface Table
Overview
VVKKFOP is a standard SAP S/4HANA table that stores Single Doc in Posting Data Interface data. There are total 71 fields in the VVKKFOP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VVKKFOP 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 VVKKFOP to other SAP tables and standard CDS views available based on VVKKFOP table in S/4HANA 2020.
Techincal Settings of VVKKFOP
Below are technical details of the table VVKKFOP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VVKKFOP Fields
The following table gives you an overview of the fields available in VVKKFOP
| 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 | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13 | |
| BUGRD | Posting Reason | BUGRD_VK | TKKVBUGRD | 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 Key | LNDSL_VK | T005 | CHAR | 3 |
| PRGRP | Product Group | PRGRP_VK | * | CHAR | 2 |
| VKONT | Contract Account | VKONT_VK | * | CHAR | 12 |
| GPART | Business Partner Number | GPART_KK | BUT000 | CHAR | 10 |
| EMGPA | Alternative Business Partner for Payments | EMGPA_KK | * | CHAR | 10 |
| EMADE | Address number in external system | BU_ADEXT | CHAR | 20 | |
| EMADR | Address Number | AD_ADDRNUM | * | CHAR | 10 |
| EMBVT | Bank Details ID of Payee | EMBVT_KK | CHAR | 4 | |
| SPZAH | Lock Reason for Automatic Payment | SPZAH_KK | * | 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-Insurance Contracts to Adjust | INFAK_VK | DEC | 8 | |
| RBART | Legal Relationship Type | RBART_VK | TKKVRBART | CHAR | 2 |
| RBZNR | Number of Legal Relationship | RBZNR_VK | CHAR | 17 | |
| VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | |
| ABWRA | Alt. Legal Relationship Type | ABWRA_VK | * | CHAR | 2 |
| ABWRN | Alternative Classification Key | ABWRN_VK | CHAR | 17 | |
| VTRE2 | Additional Reference Information | VTRE2_KK | CHAR | 20 | |
| VGPART2 | Business Partner Number | GPART_KK | * | CHAR | 10 |
| ERGRA | Supplementary Legal Relationship Type | ERGRA_VK | * | CHAR | 2 |
| ERGRN | Supplementary Classification Key | ERGRN_VK | CHAR | 17 | |
| VTRE3 | Supplementary contract number | VTREF_VK | CHAR | 20 | |
| VGPART3 | Business Partner Number | GPART_KK | * | CHAR | 10 |
| STAKZ | Type of statistical item | STAKZ_KK | CHAR | 1 | |
| SKTPZ | Cash Discount Percentage Rate | SKTPZ_KK | DEC | 5 | |
| STPRZ | Insurance tax percentage | STPRZ_VK | DEC | 5 | |
| 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 | T856 | CHAR | 3 |
| VSARL_VX | Insurance Type | VSARL_VX | * | CHAR | 6 |
| KOSTL | Cost Center | KOSTL | * | CHAR | 10 |
| PRCTR | Profit Center | PRCTR | * | CHAR | 10 |
| ERKRS | Operating concern | ERKRS | * | CHAR | 4 |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | |
| HKONT | General ledger account | HKONT_KK | * | CHAR | 10 |
| GHKONT | G/L Account (for Business Partner Item) | GHKONT_VK | * | CHAR | 10 |
| ADKNZ | Additional Acct Assignments in BP Items as Well | ADKNZ_VK | CHAR | 1 | |
| OPTXT | Item text | OPTXT_KK | CHAR | 50 | |
| 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 |
| KONTT | Account Assignment Category | KONTT_KK | * | CHAR | 2 |
| KONTL | Acct assnmnt string for industry-specific account assngments | KONTL_KK | CHAR | 50 | |
| FDGRP | Planning Group | FDGRP_KK | * | CHAR | 10 |
| FDZTG | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 |
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 VVKKFOP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VVKKFOP | BEBER_VX | : | TLXXBEB |
| VVKKFOP | BEWAR | : | T856 |
| VVKKFOP | BSART_VX | : | TLXXBSA |
| VVKKFOP | BSGRP_VX | : | TLXXBSG |
| VVKKFOP | BUGRD | 1: N | TKKVBUGRD |
| VVKKFOP | FUBER_VX | : | TLXXFUB |
| VVKKFOP | GPART | 1: N | BUT000 |
| VVKKFOP | GSART_VX | : | TLXXGSA |
| VVKKFOP | GZART_VX | : | TLXXGZA |
| VVKKFOP | LNDSL | : | T005 |
| VVKKFOP | LNDSL_VX | : | TLXXLSL |
| VVKKFOP | RBART | 1: N | TKKVRBART |
| VVKKFOP | RSART_VX | : | TLXXRSA |
| VVKKFOP | SDART_VX | : | TLXXSDA |