CKML2 SAP table for – Material Ledger Header Record (Release 3.xx)

Here we would like to draw your attention to CKML2 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). CKML2 is a SAP standard transparent table used for storing Material Ledger Header Record (Release 3.xx) related data in SAP. It comes under the package CKML.

SAP CKML2 table

Table CKML2 technical data

TableCKML2
Data storingMaterial Ledger Header Record (Release 3.xx)
ModuleCO
ComponentCO-PC
SAP PackageCKML
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • XSPRS
    Its data type is C (Character String) with field length 1
  • SPRSDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SPRSDAT_2
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SPRSDAT_3
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • XZPRS
    Its data type is C (Character String) with field length 1
  • ZPRSDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ZPRSDAT_2
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ZPRSDAT_3
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ZPLPR_1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZPLPR_2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • 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
  • ZPLPR_3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZKPRS_1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZKPRS_2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZKPRS_3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ABRECHUHR
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • MATLED
    Its a key field. Its data type is C (Character String) with field length 4
  • BWKEY : Valuation area
    Its data type is C (Character String) with field length 4
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • XABRECH
    Its data type is C (Character String) with field length 1
  • ABRECHDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • XABRERR
    Its data type is C (Character String) with field length 1