The CKMLMV005 table in SAP ERP or S/4HANA stores Consumption alternatives data. There are total 30 fields in CKMLMV005 table. The Consumption alternatives table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CKMLMV005 table. It is in Quantity Structure Tool (CKMLMV) ABAP package and is part of the Actual Costing/Material Ledger (CO-PC-ACT) module.
SAP CKMLMV005 Table Fields
Following is the list of fields that are available in SAP CKMLMV005 table. The primary key fields of the table are MANDT (Client), KALNR (Consumption Alternative).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| KALNR | Consumption Alternative | CKML_VALTNR | NUMC (12) | |
| OTYP | Object Type | CKML_OTYP | CHAR (2) | |
| BWKEY | Valuation area | BWKEY | CHAR (4) | |
| WERKS | Plant | WERKS_D | CHAR (4) | |
| MATNR | Material Number | MATNR | CHAR (40) | |
| BWTAR | Valuation Type | BWTAR_D | CHAR (10) | |
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR (1) | |
| KALNR_MAT | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC (12) | |
| VTYP | Process Category for Consumption | CKML_VTYP | CHAR (4) | |
| SORT_NAME | Sort String for Differentiating Procurement Alternatives | CKML_SORT_NAME | CHAR (10) | |
| NRULE | Controlling Level Key | CKML_NAME_RULE | CHAR (4) | |
| LOEKZ | Deletion Indicator | CKML_LOEKZ | CHAR (1) | |
| PWERK_ND | Plant | WERKS_D | * | CHAR (4) |
| PMATN_ND | Material Number | MATNR | CHAR (40) | |
| KOSTL_ND | Cost Center | KOSTL | * | CHAR (10) |
| KDAUF_ND | Sales Order Number | KDAUF | CHAR (10) | |
| KDPOS_ND | Item number in Sales Order | KDPOS | NUMC (6) | |
| KUNDE_ND | Sold-To Party | KUNAG | * | CHAR (10) |
| PSPNR_ND | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | * | NUMC (8) |
| KSTRG_ND | Cost Object | KSTRG | * | CHAR (12) |
| SAKNR_ND | G/L Account Number | SAKNR | * | CHAR (10) |
| OBJNR_ND | CO Account Assignment | CKML_OBJNR | * | CHAR (22) |
| PRCTR_ND | Profit Center | PRCTR | CHAR (10) | |
| GSBER_ND | Business Area | GSBER | * | CHAR (4) |
| BUKRS_ND | Company Code | BUKRS | CHAR (4) | |
| VBUND_ND | Company ID of Trading Partner | RASSC | * | CHAR (6) |
| SPEZ_NAME_ND | User-Defined Name for Procure.Alternatives/Consumpt.Alternat | CKML_SPEZ_NAME | CHAR (30) | |
| ERNAM | Created By | CKML_ERNAM | CHAR (12) | |
| ERDAT | Created On | CKML_ERDAT | DATS (8) |
