1. SAP Tutorial
  2. CO Module

CKML1 SAP table for – Material Ledger Period Totals Records (Release 3.xx)

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

SAP CKML1 table

Table CKML1 technical data

TableCKML1
Data storingMaterial Ledger Period Totals Records (Release 3.xx)
ModuleCO
ComponentCO-PC
SAP PackageCKML
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • PVPRS_1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • WEWRT_3VA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • REKUMVA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • REWRT_1VA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • REWRT_2VA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • REWRT_3VA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVWEKUMVA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVWEW_1VA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVWEW_2VA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVWEW_3VA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVREKUMVA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • PVPRS_2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • LVREW_1VA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVREW_2VA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVREW_3VA
    Its data type is P (Packed number (number with fixed number of decimal places)) 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
  • 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
  • XKONCHK
    Its data type is C (Character String) with field length 1
  • PVPRS_3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • XINIT
    Its data type is C (Character String) with field length 1
  • LBKUM
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SALK3_1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SALK3_2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SALK3_3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SALKV_1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SALKV_2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SALKV_3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • 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
  • KZ_ABGER
    Its data type is C (Character String) with field length 1
  • .INCLU-O
    Its include structure/component is is CKI_ABR_ML
  • WEKUMO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WEWRT_1O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WEWRT_2O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WEWRT_3O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • REKUMO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • REWRT_1O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • REWRT_2O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • REWRT_3O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MATLED
    Its a key field. Its data type is C (Character String) with field length 4
  • LVREKUMO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVREW_1O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVREW_2O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVREW_3O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUKUMO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUABW_1O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUABW_2O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUABW_3O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVABW_1O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVABW_2O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BDATJ
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • LVABW_3O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVWEKUMO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVWEW_1O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVWEW_2O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVWEW_3O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUOME_1O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUOME_2O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUOME_3O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUUMB_1O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUUMB_2O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • POPER : Posting Period in Financial Accounting
    Its a key field. Its data type is N (Character String with Digits Only) with field length 3
  • ZUUMB_3O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVPVP_1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • LVPVP_2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • LVPVP_3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • .INCLU-A
    Its include structure/component is is CKI_ABR_ML
  • WEKUMA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WEWRT_1A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WEWRT_2A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WEWRT_3A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • REKUMA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • UNTPER
    Its a key field. Its data type is N (Character String with Digits Only) with field length 3
  • REWRT_1A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • REWRT_2A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • REWRT_3A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVREKUMA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVREW_1A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVREW_2A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVREW_3A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUKUMA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUABW_1A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUABW_2A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • STPRS_1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZUABW_3A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVABW_1A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVABW_2A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVABW_3A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVWEKUMA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVWEW_1A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVWEW_2A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LVWEW_3A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUOME_1A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUOME_2A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • STPRS_2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZUOME_3A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUUMB_1A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUUMB_2A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUUMB_3A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUOMP_1O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZUOMP_2O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZUOMP_3O
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZUOMP_1A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZUOMP_2A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZUOMP_3A
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • STPRS_3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZUOMMO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ZUOMMA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • PEINH_1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PEINH_2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PEINH_3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • UMKUMO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • UMKUMA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WEKUMVA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WEWRT_1VA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WEWRT_2VA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8

    • CKML1 related tables

    • MLARC_IDX : Index for ML Document
    • MLBECR : Material Ledger Currency Table for GR/IR relevant transact.
    • MLPPF : Material Ledger Document: Field Groups (Posting Periods)
    • MLBECR : Material Ledger Currency Table for GR/IR relevant transact.
    • MLAUF : Material Ledger Item Table for Order History
    • CKMI1 : Index for Accounting Documents for Material
    • MLWERE : Conversion Table between Purchasing and Material Ledger
    • MLHD : Material Ledger Document: Header
    • CKMLKALNR : Material Ledger: Cost Estimate Number Control
    • CKMLHD : Material Ledger: Header Record
    • CKMLCR : Material Ledger: Period Totals Records Values
    • MLFG : Material Ledger Document: Field Groups
    • MLPP : Material Ledger Document: Posting Periods and Quantities
    • CKMLKALNR : Material Ledger: Cost Estimate Number Control
    • CKMLO : Material Ledger: Organizational Jobs
    • MLBE : Material Ledger FS Item Table for GR/IR relevant transaction
    • MLBEH : Material Ledger FS Item Table for GR/IR relevant transaction
    • MLIT : Material Ledger Document: Items
    • MLORDERHIST : Conversion Table for Order History
    • CKMLCR : Material Ledger: Period Totals Records Values

    CKML1 related t.ransaction codes under SAP package CKML

    • CKMJ : Display Organizational Measures
    • CKMDISPTAB : Technical View of ML Master Data
    • CKM3 : Material Price Analysis
    • CKMG_RUN : Allow Closing Entries for Run
    • CKMTOPSTOCKVAL : Materials w/ Highest Inventory Value
    • CKMARCHSPL : Archiving Actl Cost Comp. Split Recs
    • CKMF_RUN : Allow Price Determination for Run
    • CKMDISPACT : Technical Activity Type View
    • CKMC : Consistency Check for a Material
    • CKMDISPDOC : Technical View ML Document
    • CKMI : Post Closing
    • CKMLXPRA46A : Postprocessing Report for 46A-XPRA
    • CKMS : Material Ledger Docs for Material
    • CKMADJUST : Reconcil. with Bal. Sheet Acct in FI
    • CKMB : Display Material Ledger Document
    • CKMLPOH : Order History Display
    • CKM3OLD : Material Price Analysis
    • CKM3VERYOLD : Display Material Ledger Data
    • OMX4 : Number Range Maintenence: ML-DOCU.
    • CKMPROTDIS : Display Log

    Related References

    Related Tutorials

    CKMLCR SAP table for – Material Ledger: Period Totals Records Values

    CKMLCR table in SAP CO (Product Cost Controlling in CO) module. This tables is used for storing data of Material...

    CKMLPP SAP table for – Material Ledger Period Totals Records Quantity

    CKMLPP table in SAP CO (Product Cost Controlling in CO) module. This tables is used for storing data of Material...

    CKMLCRWIP SAP table for – Material Ledger: WIP Period Records (Values)

    CKMLCRWIP table in SAP CO (Product Cost Controlling in CO) module. This tables is used for storing data of Material...

    COFIT SAP table for – Totals Records for Reconciliation Ledger

    COFIT table in SAP CO (Overhead Cost Controlling in CO) module. This tables is used for storing data of Totals...

    CKMLPPWIP SAP table for – Material-Ledger: Period Records WIP (Quantities)

    CKMLPPWIP table in SAP CO (Product Cost Controlling in CO) module. This tables is used for storing data of Material-Ledger:...

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

    CKML2 table in SAP CO (Product Cost Controlling in CO) module. This tables is used for storing data of Material...

    CKMLPRKEPH SAP table for – Material Ledger: Cost Component Split (Elements) for Prices

    CKMLPRKEPH table in SAP CO (Product Cost Controlling in CO) module. This tables is used for storing data of Material...

    «
    »