SAP VVKKMHIST Contract-Related Dunning History Table
Overview
VVKKMHIST is a standard SAP S/4HANA table that stores Contract-Related Dunning History data. There are total 42 fields in the VVKKMHIST table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VVKKMHIST 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 VVKKMHIST to other SAP tables and standard CDS views available based on VVKKMHIST table in S/4HANA 2020.
Techincal Settings of VVKKMHIST
Below are technical details of the table VVKKMHIST
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VVKKMHIST Fields
The following table gives you an overview of the fields available in VVKKMHIST
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | |
| MVLNR | Dunning Procedure Sequence Number | MVLNR_VK | NUMC | 3 | |
| BEARS | Editing Step in Dunning History | BEARS_VK | NUMC | 3 | |
| SLNR | Record no. in dunning procedure processing step | SLNR_VK | NUMC | 3 | |
| GPART | Business Partner Number | GPART_KK | FKKMAKO | CHAR | 10 |
| VKONT | Contract Account Number | VKONT_KK | FKKMAKO | CHAR | 12 |
| MAHNV | Dunning Procedure | MAHNV_KK | * | CHAR | 2 |
| MVTYP | Dunning Procedure Category | MVTYP_KK | * | CHAR | 2 |
| MVART | Type of dunning procedure | MVART_VK | CHAR | 1 | |
| MAHNS | Dunning Level | MAHNS_KK | * | NUMC | 2 |
| MSTYP | Dunning Level Category | MSTYP_KK | * | CHAR | 2 |
| MSNEU | New Dunning Level | MSNEU_VK | * | NUMC | 2 |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| MVSTA | Dunning Procedure Status | MVSTA_VK | CHAR | 2 | |
| MSDAT | Execution Date of Dunning Level | MSDAT_VK | DATS | 8 | |
| MNDAT | Earliest Execution Date of Next Dunning Run | MNDAT_VK | DATS | 8 | |
| MVVON | Dunning Procedure Start | MVVON_VK | DATS | 8 | |
| MVBIS | Dun Procedure End Date | MVBIS_VK | DATS | 8 | |
| PRGRP | Product Group | PRGRP_VK | * | CHAR | 2 |
| VSARK | Insurance Type | VSARL_VX | * | CHAR | 6 |
| WAERS | Currency Key | WAERS | * | CUKY | 5 |
| MSALM | Dunning Balance | MSALM_KK | CURR | 13 | |
| MSALH | Not used (formerly dunned amount in local currency) | UNUSED_KK | DEC | 13 | |
| ASALM | Down Payment Balance | ASALM_VK | CURR | 13 | |
| ASALH | Not used (formerly dunned amount in local currency) | UNUSED_KK | DEC | 13 | |
| RGEBM | Graduated charge for returns | RLGEB_KK | CURR | 13 | |
| RGEBH | Not used (formerly dunned amount in local currency) | UNUSED_KK | DEC | 13 | |
| GGEBM | Business Charge in Dunning Currency | GGEBM_VK | CURR | 13 | |
| GGEBH | Not used (formerly dunned amount in local currency) | UNUSED_KK | DEC | 13 | |
| AUSBL | Document Number that Triggers Dunning (Leading) Document | AUSBL_VK | DFKKOP | CHAR | 12 |
| OPUPK | Item Number in FI-CA Document | OPUPK_KK | DFKKOP | NUMC | 4 |
| OPUPZ | Subitem for a Partial Clearing in Document | OPUPZ_KK | DFKKOP | NUMC | 3 |
| OPUPW | Repetition Item in FI-CA Document | OPUPW_KK | DFKKOP | NUMC | 3 |
| FAEDN | Due date for net payment | FAEDN_KK | DATS | 8 | |
| FAEVON | Net due date of first current premium dunned | FAEVON_VK | DATS | 8 | |
| FAEBIS | Net due date of most recently dunned current premium | FAEBIS_VK | DATS | 8 | |
| LAUFD | Date ID | LAUFD_KK | FKKMAKO | DATS | 8 |
| LAUFI | Run ID | LAUFI_KK | FKKMAKO | CHAR | 6 |
| MAZAE | Counter for several dunning notices to a business partner | MAZAE_KK | FKKMAKO | NUMC | 6 |
| ROPBEL | Number of a FI-CA Document | OPBEL_KK | * | CHAR | 12 |
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 VVKKMHIST
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VVKKMHIST | AUSBL | : | DFKKOP |
| VVKKMHIST | GPART | : | FKKMAKO |
| VVKKMHIST | LAUFD | : | FKKMAKO |
| VVKKMHIST | LAUFI | : | FKKMAKO |
| VVKKMHIST | MAZAE | : | FKKMAKO |
| VVKKMHIST | OPUPK | : | DFKKOP |
| VVKKMHIST | OPUPW | : | DFKKOP |
| VVKKMHIST | OPUPZ | : | DFKKOP |
| VVKKMHIST | VKONT | : | FKKMAKO |