The CKMLDUVACT table in SAP ERP or S/4HANA stores Distribution of Activity Differences: Single Rcords & Status data. There are total 22 fields in CKMLDUVACT table. The Distribution of Activity Differences: Single Rcords & Status 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 CKMLDUVACT table. It is in Distribution of Inventory and Activity Differences (CO_ML_DUV) ABAP package and is part of the Distribution of Usage Variances (CO-PC-ACT-DUV) module.
SAP CKMLDUVACT Table Fields
Following is the list of fields that are available in SAP CKMLDUVACT table. The primary key fields of the table are MANDT (Client), OBJNR (Object number), GJAHR (Fiscal Year), BELNR (Document Number: Actitity Entry for Distribution).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| OBJNR | Object number | J_OBJNR | * | CHAR (22) |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| BELNR | Document Number: Actitity Entry for Distribution | CKMLDUV_BELNR | NUMC (10) | |
| DATE_FROM | Start Date of the Distribution Interval | SDAT_DIST | DATS (8) | |
| DATE_TO | End Date for Distribution | EDAT_DIST | DATS (8) | |
| MENGE | Total Quantity Confirmed in One Time Interval | MENGE_GES | QUAN (15) | |
| MEINS | Base Unit of Measure | MEINS | * | UNIT (3) |
| REC_USER | User Name | SYUNAME | CHAR (12) | |
| REC_DATE | System Date | SYDATUM | DATS (8) | |
| REC_TIME | TIME Data Element for SYST | SYTIME | TIMS (6) | |
| STATUS | Status of Usage Variance Distribution | CKDUV_STATUS | CHAR (2) | |
| NO_DIST | No Distribution Indicator | CKDUVN_ND | CHAR (1) | |
| BUDAT | Posting Date of Distribution | BUDATUM_DIST | DATS (8) | |
| METER | Counter Reading at Time of Entry | METER | QUAN (13) | |
| METER_MEINS | Base Unit of Measure | MEINS | * | UNIT (3) |
| INTNUM | Internal Counter | CKDUVN_INTNUM | NUMC (4) | |
| DIFF_QUANT_TOTAL | Total Difference Quantity: Determined from Distribution Run | MENGE_PROG_TOTAL | QUAN (13) | |
| APLID | Error Management in the Application | CM_APLID | * | CHAR (4) |
| PROTNR | Error Management Number | CMF_NR | NUMC (12) | |
| IS_REVERSAL | Indicator: Reversal Document | CKMLDUV_IS_REVERSAL | CHAR (1) | |
| BELNR_REF | Create Document Number for Redistribution | DUVN_BELNR_REF | NUMC (10) |
