The CKMLDUVCO table in SAP ERP or S/4HANA stores Usage Differences for Each Account Assignment Object data. There are total 25 fields in CKMLDUVCO table. The Usage Differences for Each Account Assignment Object 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 CKMLDUVCO table. It is in no longer used, now CO_ML_DUV (CKMLDUV) ABAP package and is part of the Actual Costing/Material Ledger (CO-PC-ACT) module.
SAP CKMLDUVCO Table Fields
Following is the list of fields that are available in SAP CKMLDUVCO table. The primary key fields of the table are MANDT (Client), IBLNR (Physical Inventory Document), GJAHR (Fiscal Year), ZEILI (Line Number), POSNR (Sequence Number for Distribution to Account Assign. Objects).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| IBLNR | Physical Inventory Document | IBLNR | CHAR (10) | |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| ZEILI | Line Number | DZEILE | NUMC (3) | |
| POSNR | Sequence Number for Distribution to Account Assign. Objects | POSNR_D | NUMC (6) | |
| MEINS | Base Unit of Measure | MEINS | * | UNIT (3) |
| MENGE_VERB | Quantity Withdrawn From Orders | MENGE_VERB | QUAN (13) | |
| MENGE_PROG | Quantity Calculated by Distribution Run | MENGE_PROG | QUAN (13) | |
| MENGE | Quantity with Sign | MENGEV | QUAN (13) | |
| MBLNR | Number of a Material/FI Document | DUV_BELNR | CHAR (10) | |
| MJAHR | Fiscal Year of the Document | DUV_GJAHR | NUMC (4) | |
| ZEILE | Item Within a Document | DUV_POS | NUMC (4) | |
| DISTRIB | Distribution Indicator | DISTRIB_D | CHAR (1) | |
| KOKRS | Controlling Area | KOKRS | * | CHAR (4) |
| KOSTL | Cost Center | KOSTL | * | CHAR (10) |
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | * | NUMC (12) |
| KDAUF | Sales Order Number | KDAUF | * | CHAR (10) |
| KDPOS | Item number in Sales Order | KDPOS | NUMC (6) | |
| AUFNR | Order Number | AUFNR | * | CHAR (12) |
| AUFPS | Order item number | AUFPS | CHAR (2) | |
| KSTRG | Cost Object | KSTRG | * | CHAR (12) |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC (10) | |
| APLZL | General counter for order | CO_APLZL | * | NUMC (8) |
| OBJNR | Object number | J_OBJNR | * | CHAR (22) |
| AUF_MATNR | Material No.of Material Produced by Product.Order (product) | AUF_MATNR | * | CHAR (40) |
