CKMI1 SAP table for – Index for Accounting Documents for Material

Here we would like to draw your attention to CKMI1 table in SAP. As we know it is being mainly used with the SAP CO-PC (Product Cost Controlling in CO) component which is coming under CO module (Controlling). CKMI1 is a SAP standard transparent table used for storing Index for Accounting Documents for Material related data in SAP. It comes under the package CKML.

SAP CKMI1 table

Table CKMI1 technical data

TableCKMI1
Data storingIndex for Accounting Documents for Material
ModuleCO
ComponentCO-PC
SAP PackageCKML
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP CKMI1 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 CKMI1 table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SALK3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • VERPR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • STPRS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • BWKEY : Valuation area
    Its data type is C (Character String) with field length 4
  • DATUM : System Date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • UZEIT : System Time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • VBDATUM
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VBUZEIT
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WRBTR : Amount in document currency
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KALNR : Cost Estimate Number for Cost Est. w/o Qty Structure
    Its a key field. Its data type is N (Character String with Digits Only) with field length 12
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • KZBWS : Valuation of Special Stock
    Its data type is C (Character String) with field length 1
  • VKSAL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • VKWRT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BDATJ
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • POPER : Posting Period in Financial Accounting
    Its a key field. Its data type is N (Character String with Digits Only) with field length 3
  • AWTYP : Reference procedure
    Its a key field. Its data type is C (Character String) with field length 5
  • AWREF : Reference document number
    Its a key field. Its data type is C (Character String) with field length 10
  • AWORG : Reference organisational units
    Its a key field. Its data type is C (Character String) with field length 10
  • GLVOR : Business Transaction
    Its data type is C (Character String) with field length 4
  • LBKUM
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7