VVKKFOP SAP (Single Doc in Posting Data Interface) Table details
Dictionary Type: Table
Description: Single Doc in Posting Data Interface
Description: Single Doc in Posting Data Interface
Table field list including key, data, relationships and ABAP select examples
VVKKFOP is a standard SAP Table which is used to store Single Doc in Posting Data Interface data and is available within R/3 SAP systems depending on the version and release level.
The VVKKFOP table consists of various fields, each holding specific information or linking keys about Single Doc in Posting Data Interface data available in SAP. These include GSFNR (Business Transaction Number), BELNR (Transfer Document Number), LFDNB (Seq. Number - Single Document), BETRW (Amount in Transaction Currency with +/- Sign).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VVKKFOP 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 | Assigned to domain | MANDT | |||
GSFNR | Business Transaction Number | GSFNR_VK | CHAR | 16 | ALPHA | GSFNR_VK | |||
BELNR | Transfer Document Number | BELNR_VK | CHAR | 6 | ALPHA | BELNR_VK | |||
LFDNB | Seq. Number - Single Document | LFDNB_VK | NUMC | 3 | NUMC3 | ||||
BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
BUGRD | Posting Reason | BUGRD_VK | NUMC | 3 | TKKVBUGRD | BUGRD_VK | |||
HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4 | Assigned to domain | HVORG_KK | 8HV | ||
TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4 | Assigned to domain | TVORG_KK | |||
OPHVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4 | Assigned to domain | HVORG_KK | 8HV | ||
OPTVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4 | Assigned to domain | TVORG_KK | |||
FAEDN | Due date for net payment | FAEDN_KK | DATS | 8 | DATUM | ||||
FAEDS | Due Date for Cash Discount | FAEDS_KK | DATS | 8 | DATUM | ||||
FOKNZ | Subledger Item Indicator | FOKNZ_VK | CHAR | 1 | FOKNZ_VK | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
LNDSL | Country Key | LNDSL_VK | CHAR | 3 | T005 | LAND1 | LND | ||
PRGRP | Product Group | PRGRP_VK | CHAR | 2 | Assigned to domain | PRGRP_VK | |||
VKONT | Contract Account | VKONT_VK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | ||
GPART | Business Partner Number | GPART_KK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | |
EMGPA | Alternative Business Partner for Payments | EMGPA_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BUPA | |
EMADE | Address number in external system | BU_ADEXT | CHAR | 20 | BU_ADEXT | ||||
EMADR | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
EMBVT | Bank Details ID of Payee | EMBVT_KK | CHAR | 4 | CHAR4 | ||||
SPZAH | Lock Reason for Automatic Payment | SPZAH_KK | CHAR | 1 | Assigned to domain | SPZAH_KK | |||
SPZFD | Payment Lock Valid from | SPZFD_VK | DATS | 8 | DATUM | ||||
SPZTD | Payment lock valid to | SPZTD_VK | DATS | 8 | DATUM | ||||
PYMET | Payment Method | PYMET_KK | CHAR | 1 | Assigned to domain | PYMET_KK | |||
PYGRP | Grouping field for automatic payments | PYGRP_KK | CHAR | 10 | CHAR10 | ||||
INDYN | Key for Index/Dynamic Basis of an Insurance Contract | INDYN_VK | CHAR | 5 | INDYN_VK | ||||
INFAK | Index Value or Dynamic Factor-Insurance Contracts to Adjust | INFAK_VK | DEC | 8(3) | DEC5_3 | ||||
RBART | Legal Relationship Type | RBART_VK | CHAR | 2 | TKKVRBART | RBART_VK | VVA | ||
RBZNR | Number of Legal Relationship | RBZNR_VK | CHAR | 17 | RBZNR_VK | VVB | |||
VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
ABWRA | Alt. Legal Relationship Type | ABWRA_VK | CHAR | 2 | Assigned to domain | RBART_VK | |||
ABWRN | Alternative Classification Key | ABWRN_VK | CHAR | 17 | RBZNR_VK | ||||
VTRE2 | Additional Reference Information | VTRE2_KK | CHAR | 20 | ALPHA | VTREF_KK | |||
VGPART2 | Business Partner Number | GPART_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | |
ERGRA | Supplementary Legal Relationship Type | ERGRA_VK | CHAR | 2 | Assigned to domain | RBART_VK | |||
ERGRN | Supplementary Classification Key | ERGRN_VK | CHAR | 17 | RBZNR_VK | ||||
VTRE3 | Supplementary contract number | VTREF_VK | CHAR | 20 | ALPHA | VTREF_KK | |||
VGPART3 | Business Partner Number | GPART_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | |
STAKZ | Type of statistical item | STAKZ_KK | CHAR | 1 | STAKZ_KK | ||||
SKTPZ | Cash discount rate | SKTPZ_KK | DEC | 5(3) | PRZ23 | ||||
STPRZ | Insurance tax percentage | STPRZ_VK | DEC | 5(2) | DEC3_2 | ||||
GRKEY | Grouping Key for Displaying Open Items | GRKEY_KK | CHAR | 3 | CHAR3 | ||||
VERKZ | Item Can Only Be Cleared | VERKZ_KK | CHAR | 1 | VERKZ_KK | ||||
BEWAR | Transaction Type | RMVCT | CHAR | 3 | T856 | RMVCT | |||
VSARL_VX | Insurance Type | VSARL_VX | CHAR | 6 | Assigned to domain | ALPHA | VSARL_VX | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
ERKRS | Operating concern | ERKRS | CHAR | 4 | Assigned to domain | ERKRS | ERB | ||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
HKONT | General ledger account | HKONT_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAKO | |
GHKONT | G/L Account (for Business Partner Item) | GHKONT_VK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
ADKNZ | Additional Acct Assignments in BP Items as Well | ADKNZ_VK | CHAR | 1 | ADKNZ_VK | ||||
OPTXT | Item text | OPTXT_KK | CHAR | 50 | TEXT50 | ||||
LNDSL_VX | Country Where Risk Is Situated | LNDSL_VX | CHAR | 3 | TLXXLSL | LAND1 | SHLP_LNDSL_VX | ||
GSART_VX | Business Transaction Type | GSART_VX | CHAR | 2 | TLXXGSA | GSART_VX | SHLP_GSART_VX | ||
BSART_VX | In-Force Business Type | BSART_VX | CHAR | 2 | TLXXBSA | BSART_VX | SHLP_BSART_VX | ||
GZART_VX | Underwriting Type | GZART_VX | CHAR | 2 | TLXXGZA | GZART_VX | SHLP_GZART_VX | ||
SDART_VX | Type of Loss | SDART_VX | CHAR | 2 | TLXXSDA | SDART_VX | SHLP_SDART_VX | ||
SJAHR_VX | Year of loss | SJAHR_VX | CHAR | 4 | SJAHR_VX | ||||
MJAHR_VX | Reporting Year | MJAHR_VX | CHAR | 4 | MJAHR_VX | ||||
RSART_VX | Risk type | RSART_VX | CHAR | 2 | TLXXRSA | RSART_VX | SHLP_RSART_VX | ||
FUBER_VX | Insurance Functional Area | FUBER_VX | CHAR | 3 | TLXXFUB | FUBER_VX | SHLP_FUBER_VX | ||
BEBER_VX | Organizational area - insurance | BEBER_VX | CHAR | 3 | TLXXBEB | BEBER_VX | SHLP_BEBER_VX | ||
BSGRP_VX | In-Force Business Group for Pension Funds and Life Insurance | BSGRP_VX | CHAR | 3 | TLXXBSG | BSGRP_VX | SHLP_BSGRP_VX | ||
KONTT | Account Assignment Category | KONTT_KK | CHAR | 2 | Assigned to domain | KONTT_KK | |||
KONTL | Acct assnmnt string for industry-specific account assngments | KONTL_KK | CHAR | 50 | CHAR50 | ||||
FDGRP | Planning Group | FDGRP_KK | CHAR | 10 | Assigned to domain | ALPHA | FDGRP | FFG | |
FDZTG | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 | NUM2 |
Key field | Non-key field |
How do I retrieve data from SAP table VVKKFOP using ABAP code
The following ABAP code Example will allow you to do a basic selection on VVKKFOP to SELECT all data from the tableDATA: WA_VVKKFOP TYPE VVKKFOP.
SELECT SINGLE *
FROM VVKKFOP
INTO CORRESPONDING FIELDS OF WA_VVKKFOP
WHERE...
How to access SAP table VVKKFOP
Within an ECC or HANA version of SAP you can also view further information about VVKKFOP 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