VKMI SAP table for – Log for Updating Open Credit Values (S066, S067)

Here we would like to draw your attention to VKMI table in SAP. As we know it is being mainly used with the SAP LO-LIS (Logistics Information System (LIS) in LO) component which is coming under LO module (Logistics). VKMI is a SAP standard transparent table used for storing Log for Updating Open Credit Values (S066, S067) related data in SAP. It comes under the package MCS.

SAP VKMI table

Table VKMI technical data

TableVKMI
Data storingLog for Updating Open Credit Values (S066, S067)
ModuleLO
ComponentLO-LIS
SAP PackageMCS
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP VKMI Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in VKMI table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • ERDAT : Date on which the record was created
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AEDAT : (8-character) Date for SYST
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SRTF2 : Next record counter in EXPORT/IMPORT data tables
    Its a key field. Its data type is X (Byte string) with field length 4
  • CLUSTR : Length field for user data in EXPORT/IMPORT tables
    Its data type is X (Byte string) with field length 2
  • CLUSTD : Data field for IMPORT/EXPORT database tables
    Its data type is X (Byte string) with field length 2886
  • RELID : Region in IMPORT/EXPORT Data Table
    Its a key field. Its data type is C (Character String) with field length 2
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is VKMI_KEY
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • DATUM : System Date
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • UZEIT : System Time
    Its a key field. Its data type is T (Time (Time: HHMMSS)) with field length 6
  • KKBER
    Its a key field. Its data type is C (Character String) with field length 4
  • KNKLI
    Its a key field. Its data type is C (Character String) with field length 10
  • VBTYP
    Its a key field. Its data type is C (Character String) with field length 1