CKMLPR SAP table for – Material Ledger: Prices

Here we would like to draw your attention to CKMLPR 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). CKMLPR is a SAP standard transparent table used for storing Material Ledger: Prices related data in SAP. It comes under the package CKML.

SAP CKMLPR table

Table CKMLPR technical data

TableCKMLPR
Data storingMaterial Ledger: Prices
ModuleCO
ComponentCO-PC
SAP PackageCKML
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • PPRDZ
    Its data type is N (Character String with Digits Only) with field length 3
  • PDATZ
    Its data type is N (Character String with Digits Only) with field length 4
  • BWVA1
    Its data type is C (Character String) with field length 3
  • VERS1
    Its data type is N (Character String with Digits Only) with field length 2
  • ZPLPR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • FPLPX
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZBWST
    Its data type is C (Character String) with field length 1
  • KALKL
    Its data type is C (Character String) with field length 1
  • PPRDL
    Its data type is N (Character String with Digits Only) with field length 3
  • PDATL
    Its data type is N (Character String with Digits Only) with field length 4
  • 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
  • BWVA2
    Its data type is C (Character String) with field length 3
  • VERS2
    Its data type is N (Character String with Digits Only) with field length 2
  • LPLPR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • LPLPX
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • LBWST
    Its data type is C (Character String) with field length 1
  • KALKV
    Its data type is C (Character String) with field length 1
  • PPRDV
    Its data type is N (Character String with Digits Only) with field length 3
  • PDATV : Valid-From Date
    Its data type is N (Character String with Digits Only) with field length 4
  • BWVA3
    Its data type is C (Character String) with field length 3
  • VERS3
    Its data type is N (Character String with Digits Only) with field length 2
  • CURTP : Currency type and valuation view
    Its a key field. Its data type is C (Character String) with field length 2
  • VPLPR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • VPLPX
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • CBWST
    Its data type is C (Character String) with field length 1
  • SET_BY_MARKING
    Its data type is C (Character String) with field length 1
  • EIBDATJ
    Its data type is N (Character String with Digits Only) with field length 4
  • EIPOPER
    Its data type is N (Character String with Digits Only) with field length 3
  • EIPRICE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CKI_CKMLPR
  • PEINH : Price unit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • ZPRSDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ZKPRS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • KALKZ
    Its data type is C (Character String) with field length 1