SAP Actual Costing/Material Ledger Tables
Are you looking for the right table related to SAP Actual Costing/Material Ledger Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Actual Costing/Material Ledger (CO-PC-ACT) module.
Top 10 tables in Actual Costing/Material Ledger
| Table | Description |
|---|---|
| CKMLAB02 | Material Update Structure (Assignment to Valuation Area) |
| CKMLAGGREGATE | Aggregation Classes |
| CKML1 | Material Ledger Period Totals Records (Release 3.xx) |
| FCML_T_CUST_EDGE | ZML_CUSTOM_EDGE |
| MLEXTRACTTOOLLOG | Log for the execution of the ML ACDOCA extract tool |
| MLCRP | Material Ledger Document: Price Changes (Currencies, Prices) |
| MLPRKEKO | ML Document: Cost Component Split (Header)for Prices |
| T003L | Transaction Type for Material Ledger |
| FCML_COALLOC | CO: Activation of Allocations per Valuation View |
| FCML_T_EDGEEVENT | ZML_EDGEEVENT |
List of tables in Actual Costing/Material Ledger
| Table | Description |
|---|---|
| CKMLAB02 | Material Update Structure (Assignment to Valuation Area) |
| CKMLAGGREGATE | Aggregation Classes |
| CKML1 | Material Ledger Period Totals Records (Release 3.xx) |
| FCML_T_CUST_EDGE | ZML_CUSTOM_EDGE |
| MLEXTRACTTOOLLOG | Log for the execution of the ML ACDOCA extract tool |
| MLCRP | Material Ledger Document: Price Changes (Currencies, Prices) |
| MLPRKEKO | ML Document: Cost Component Split (Header)for Prices |
| T003L | Transaction Type for Material Ledger |
| FCML_COALLOC | CO: Activation of Allocations per Valuation View |
| FCML_T_EDGEEVENT | ZML_EDGEEVENT |
| FCML_T_CUST_PREP | ZML_CUST_PRZ_REP |
| MLAUFCRH | History table for summerized MLAUFCR data |
| MLDOCCCS | Material Ledger Document Cost Component Split |
| MLCR | Material Ledger Document: Currencies and Values |
| FCML_T_CUST_MREP | ZML_CUST_MAT_REP |
| FML_BACKPOST | Assigment of ignoring MM period block to Transactions |
| FCML_ACCMAP | Alternative Accounts for Material Ledger Postings |
| MLRUNLIST | Object List for Costing Run |
| MLPRICES_CCS | Cost Component Split of Prices |
| MLBECRLDH | Mat. Led. Cur Table for GR/IR rel. transact. icnl. Ledger |
| CKMLMV011 | Costing run: Object list |
| MLFG | Material Ledger Document: Field Groups |
| MLKEPHLD | ML Document: CCS (Elements) for Values per Ledger |
| TCKMLBNKSZ | Assignment of Delivery Costs Structure |
| CKMLRUNTYPET | Obsolete From Release 4.6A |
| FCMLREPCKMLPR | Correction for ML-Helpdesk: CKMLPR |
| FCML_MAT | ML Characteristics for Material (Selection Criteria) |
| FCML_ACCMAP_ACP | Alternative Accounts for Each Accounting Principle |
| CKMLHD_AGGR | Material Ledger: Header Record |
| TMLCCSSCOPETXT | Actual Cost Component Split: Split for Data Range (Texts) |
| CKMLPPWIP | Material-Ledger: Period Records WIP (Quantities) |
| FCML_CCS_REP | HDB Reporting Structure for ML |
| CKML_PRICE_SEND | Customizing Material Price Dispatch |
| FCML_NWG_CUST_M | FCML NWG user customizing setting, master data table |
| FCML_ACCONF | Configuration of HDB Accelerator |
| TCKM2 | Valuation Area Control Table |
| TMLCCSCR | Act.Cost Comp. Split: Data Range in Valuation Area (Curr) |
| MLIT | Material Ledger Document: Items |
| MLITMB | Material valuation document row information |
| FCML_ALT | Alternatives |
| MLPRKEPLDH | ML Document: CCS (Elements) for Prices per Ledger |
| CKMLV | Material Ledger Control Records |
| CKMLSCHEMAT | Description of Key Figure Scheme in Material Ledger |
| MLBE | Material Ledger FS Item Table for GR/IR relevant transaction |
| CKMLMV007A | Name formation (algorithms) |
| MLWIPIT | WIP Document in Material Ledger - Lines |
| CKMLPP | Material Ledger Period Totals Records Quantity |
| CKMLMV011F | Costing Run: Filter Table for Object List |
| MLCRPLD | Material Ledger Document: Price Change (Currencies, Prices) |
| MLAUFKEPHLDH | History table for summarized MLAUFKEPH data icnl. Ledger |
| CKMLKEKO | Material Ledger: Cost Component Split (Header) |
| FMLT_CURTP_ML | Material Ledger Currency Type Mapping related to ACDOC |
| MLPPF | Material Ledger Document: Field Groups (Posting Periods) |
| FCML_T_OBJTYPE | ZML_OBJECTTYPE_T |
| FMLT_INDX | INDX table for Material Ledger |
| MLARC_IDX | Index for ML Document |
| CKMLW | Material Ledger Currencies in Valuation Area |
| TCKM1 | Material Ledger Table |
| MLDOC_EXTRACT | Extract of Material Ledger Document |
| CKMLMV010 | Movement type group for ML update |
| CKMLMV001 | Procurement alternatives |
| CKMLPR | Material Ledger: Prices |
| CKMLCOPA | Assign Costing Key to Costing Run |
| MLCD | Material Ledger: Summarization Record (from Documents) |
| CKMLMV003 | Process model: Receipts / mixing strategies |
| MLAUFCRLDH | History table for summerized MLAUFCR data icnl. Ledger |
| MLBECR | Material Ledger Currency Table for GR/IR relevant transact. |
| MLDOC | Material Ledger Document |
| CKMLMV007RT | Name formation: Text for naming rule |
| CKMLLAHD | ML Activity Types: Header Record |
| MLAUFKEPHLD | ML: Cost Component Split for Order History icnl. Ledger |
| MLWR | (OBSOLETE) ML: line items of current period w/o UJE |
| MLWIPHD | WIP Document in Material Ledger - Header |
| CKML_SM_AC | Actual Costing Data for Schedule Manager |
| CKMLO | Material Ledger: Organizational Jobs |
| CKMLMV006T | Name for quantity structure types |
| MLDOC_EXT_LOC | Table for Lock Object for compression of MLDOC_EXTRACT |
| CKMLRSCHEMA | Key Figure Scheme in Material Ledger |
| MLBEKEPH | ML: Cost Comp. Split (Elements) for Purchase Order History |
| CKMLMV007T | Name formation (name of structure) |
| CKMLCUR | Text for currency type and valuation type |
| CKMLKON | Assignment of Modification Constants to Acct Assignmt Reason |
| CKMLMV016 | Quantity structure tool: Naming rule |
| FCMLREPMLBECR | Correction for ML-Helpdesk: MLBECR |
| CKMLPR_EB | Prices for Ending Inventory/Balance Sheet Valuation |
| CKMVFM_OUT | Output for the Value_Flow_Monitor, see SAP Note 912984 |
| MLMST | Material Ledger Document: Costing Run Header Data |
| TCKMHD | Description of Material Ledger Type |
| MLAUF | Material Ledger Item Table for Order History |
| BUS1017_MAPPING | BUS1017 key to GUID mapping |
| CKMLMV009T | Process Catagory (description) |
| CKMLMV007 | Name formation (structure table) |
| CKMLMV004 | Process model: Withdrawals |
| FCMLREPXBEW | Correction for ML-Helpdesk: EBEW, QBEW, OBEW |
| MLORDERHIST | Conversion Table for Order History |
| MLAUFKEPH | ML: Cost Component Split (Components) for Order History |
| FCML_T_OBJEVENT | ZML_OBJECTEVENT |
| MLBECRLD | Mat. Led. Cur Table for GR/IR rel. transact. icnl. Ledger |
| CKMLRUNPERIOD | Material ledger costing run for one month |
| BUS1016_MAPPING | BUS1016 key to GUID mapping |
| FCMLREPCKMLHD | Correction for ML-Helpdesk: CKMLHD |
| MLBEH | Material Ledger FS Item Table for GR/IR relevant transaction |
| CKMLMV_AUX_KALNR | Cost Estimate Numbers for Valuated Objects in QST |
| CKML_INDX_RUN | System table INDX |
| MLWERE | Conversion Table between Purchasing and Material Ledger |
| FCML_T_EVENT | ZML_EVENT_TEST - Test table for Events |
| FCML_T_SETTING | settings for RIA graphics |
| MLAUFKEPHH | History table for summarized MLAUFKEPH data |
| MLCRF | Material Ledger Document: Field Groups (Currencies) |
| CKMLWIPCUST | Customizing: WIP To Actual |
| CKMLMV005 | Consumption alternatives |
| CKMLRUNTYPE | Obsolete From Release 4.6A |
| FCML_REP | ML Reporting Structure |
| MLDOCCCS_EXTRACT | Extract of Material Ledger Document Cost Component Split |
| FCML_T_CUST_PRZ | ZML_CUSTOM_PRZ |
| CKMLMV011T | Filter hierarchies |
| CKMLMV016T | Quantity structure tool: Texts for naming rules |
| CKMLCT | Currency Types and Valuation Types in a Valuation Area |
| CKMLRUNTYPEBWKEY | Obsolete From Release 4.6A |
| MLPRKEPHLD | ML Document: CCS (Elements) for Prices per Ledger |
| FCMLREPMBEW | Correction for ML-Helpdesk: MBEW |
| FCML_COREVSETTL | CO Revaluation on Orders and Projects |
| FCML_MLCO | Control Table Transfer of ML Postings to CO |
| CKMLDUV | Distribution of Usage Diff.(Status for each ISEG entry) |
| MLDOC_DAAG_KALNR | Data Aging: kalnr for Data Aging (correction) |
| MLDOC_DAAG_CUS | Data Aging: Customizing for Material Ledger Documents |
| CKMLVARIANT | FIFO Costing Variant |
| CKMI1 | Index for Accounting Documents for Material |
| MLKEPH | ML Document: Cost Component Split (Elements) for Values |
| FCML_SEARCH | Saved search criteria |
| CKMVFM_EXTRACT | Transaction CKMVFM, Extracts, see SAP Note 912984 |
| CKMLMV004WIP | Process Model: Deductions WIP |
| CKMLMYMP | Periodic Receipt Values for Consumption Sequence Procedure |
| MLAUFCR | Material Ledger Currency Table for Order History |
| CKMLMV009 | Process Catagory |
| CKMLV_LOG | Logging table for activation of actual costing, CCS, etc. |
| CKMLMV013 | Assignment table: Process for production order |
| MLBECRH | Material Ledger Currency Table for GR/IR relevant transact. |
| CKMLMV015 | Naming rule assignment for materials (header) |
| MLCRFLD | Material Ledger Doc.: Field Groups (Currencies per Ledger) |
| FCML_NWG_COLUMN | For networkgraphic result list |
| CKMLPRKEKO | Material Ledger: Cost Component Split (Header) for Prices |
| MLPRKEKOLD | ML Document: CCS (Header) for Prices per Ledger |
| FCMLREPMLWERE | Correction for ML-Helpdesk: MLWERE |
| CKMLPRKEPH | Material Ledger: Cost Component Split (Elements) for Prices |
| FCMLREPCKMLCR | Correction for ML-Helpdesk: CKMLCR |
| MLWIPCOREF | WIP Document in Material Ledger - Reference to CO Documents |
| CKMVFM_BSEG_OUT | Display of FI Documents, Transaction CKMVFM, SAP Note 912984 |
| FCML_FIAACO | Control Table Transfer of Depreciation to CO |
| FCML_NWG_USER_VA | User's variants data table for NWG customizing master data |
| TCKMT | Material Ledger Type (Text Table) |
| CKMLLACR | ML Activity Type: Period Record/Currency Record |
| FCML_T_CUST_MCAT | ZML_CUST_MAT_CAT |
| CKMLKEV | Material Ledger: Cost Component Split (Control Record) |
| CKMLMV015Z | Naming rule assignment for materials for each procure. cat. |
| CKMLKEPH | Material Ledger: Cost Component Split (Elements) |
| FCMLREPMLBE | Correction for ML-Helpdesk: MLBE |
| BUS1018_MAPPING | BUS1018 key to GUID mapping |
| FCMLREPEKPO | Corrections for ML-Helpdesk: EKPO |
| CKMLCRWIP | Material Ledger: WIP Period Records (Values) |
| CKMLMV010T | Text for movement type groups for ML update |
| CKMLAB01 | Material Update Structure |
| MLAUFCRLD | Mat. Led. Currency Table for Order History icnl. Ledger |
| TCKMIT | Currency Types and Valuation Categories for Mat. Ledger Type |
| CKMLKALNR | Material Ledger: Cost Estimate Number Control |
| CKMLMV002 | Assignments material / procurement alternatives |
| CKMLMV012 | Costing run: Predecessor/successor model |
| FCML_T_TEXT | ZML_TEXT_TEST |
| MLPRKEPH | ML Document: Cost Component Split (Components)for Prices |
| CKML2 | Material Ledger Header Record (Release 3.xx) |
| CKMLMV014 | Assignment table: Procurement alternative for order |
| CKMLCR | Material Ledger: Period Totals Records Values |
| CKMLHD | Material Ledger: Header Record |
| MLPRICES | Price Data |
| FCMLREPHD | Correction for ML-Helpdesk: Header |
| CKMLMV001T | Texts for procurement alternatives |
| CKMLRUNPLANT | Organizational units in a material ledger costing run |
| FCMLREPCKMLPP | Correction for ML-Helpdesk: CKMLPP |
| MLCO | Material valuation document account assignment information |
| MLKEPLDH | ML Document: CCS (Elements) for Values per Ledger |
| MLAUFH | History table for summarized MLAUF data |
| CKMLSCHEMA | Definition of Key Figure Scheme in Material-Ledger |
| CKMLMV006 | Control data for the quantity structure types |
| TMLCCSHD | Act.Cost Comp. Split: Data Range in Valuation Area (General) |
| CKMLVARIANTT | Description of FIFO Costing Variant |
| CKMLLAPPWIP | Ml Activity Types: Period Records WIP (Quantities) |
| TMLCCSSCOPE | Actual Cost Component Split: Structure of Data Range |
| MLCRLD | Material Ledger Document: Currency per Ledger and Values |
| ACDOCA_M_EXTRACT | ACDOCA Extract Table for Material Ledger |
| MLHD | Material Ledger Document: Header |
| CKMLMVADMIN | General Control Parameters for Actual Costing |
| FCMLREPIT | Correction for ML-Helpdesk: Corrected Items |
| CKMLAB01T | Material Update Structure (Description) |
| CKMLMV007R | Name formation (naming rules) |
| MLPP | Material Ledger Document: Posting Periods and Quantities |
| CKMLKONT | Description for Account Assignment Reasons |
| CKMLDUVCO | Usage Differences for Each Account Assignment Object |
| CKMLLACRWIP | ML Activity Types: Period/ Currency Records WIP (Values) |
| CKMLLAPP | ML Activity Types: Period Records |
| TCKMLBNKS | Assignment of Other Account Key if Not to Activate |
| CKMLAB01Z | Material Update Structure (Line Assignment) |
| CKMLMV005T | Texts for consumption alternatives |
| CKMLCOCKPITSTATE | User Data for Actual Costing Costing Run |
| FCML_PROC | Business Processes |
| MLWRLD | (OBSOLETE)ML: line items of current period w/o UJE w/ ledger |
| FCML_T_CUST_MAT | ZML_CUSTOM_MAT |
| TDUV156 | Movement Types That Play a Role in Distribution |