The CKMLAVRDOCIT table in SAP ERP or S/4HANA stores Lines for Cumulation Posting Document data. There are total 70 fields in CKMLAVRDOCIT table. The Lines for Cumulation Posting Document 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 CKMLAVRDOCIT table. It is in Material Ledger Alternative Valuation Run (CO_ML_AVR) ABAP package and is part of the Alternative Valuation Run (CO-PC-ACT-AVR) module.
SAP CKMLAVRDOCIT Table Fields
Following is the list of fields that are available in SAP CKMLAVRDOCIT table. The primary key fields of the table are MANDT (Client), BELNR (Document Number of a Closing Document for Cumulation), KJAHR (Year in Which Closing Document for Cumulation Was Saved), POSNR (Accounting Document Line Item Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| BELNR | Document Number of a Closing Document for Cumulation | CKCUM_BELNR | CHAR (10) | |
| KJAHR | Year in Which Closing Document for Cumulation Was Saved | CKCUM_KJAHR | NUMC (4) | |
| POSNR | Accounting Document Line Item Number | POSNR_ACC | NUMC (10) | |
| URZEILE | Original Item in Material or Invoice Document | CK_URZEILE | NUMC (6) | |
| KALN1 | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC (12) | |
| BUSTW | Posting String for Values | BUSTW | CHAR (4) | |
| VORSL | Transaction/event key for account determination | VORSL | CHAR (3) | |
| FELDN | Name of field | FELDN | CHAR (16) | |
| KOMOK | Account Modification | KOMOK | CHAR (3) | |
| LOGVO | Logical Transaction | LOGVO | CHAR (6) | |
| MATNR | Material Number | MATNR | CHAR (40) | |
| BWKEY | Valuation area | BWKEY | T001K | CHAR (4) |
| BWTAR | Valuation Type | BWTAR_D | CHAR (10) | |
| MAT_KDAUF | Sales order number of valuated sales order stock | MAT_KDAUF | CHAR (10) | |
| MAT_KDPOS | Sales Order Item of Valuated Sales Order Stock | MAT_KDPOS | NUMC (6) | |
| MAT_PSPNR | Valuated Sales Order Stock WBS Element | MAT_PSPNR | NUMC (8) | |
| KZBWS | Valuation of Special Stock | KZBWS | CHAR (1) | |
| SOBKZ | Special Stock Indicator | SOBKZ | T148 | CHAR (1) |
| BKLAS | Valuation Class | BKLAS | T025 | CHAR (4) |
| BSCHL | Posting Key | BSCHL | TBSL | CHAR (2) |
| PPRCTR | Partner Profit Center | PPRCTR | CHAR (10) | |
| HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR (4) | |
| SGTXT | Item Text | SGTXT | CHAR (50) | |
| MONAT | Fiscal period | MONAT | NUMC (2) | |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| BUDAT | Posting Date in the Document | BUDAT | DATS (8) | |
| BLART | Document Type | BLART | T003 | CHAR (2) |
| BLDAT | Document Date in Document | BLDAT | DATS (8) | |
| VORGN | Transaction Type for General Ledger | VORGN | CHAR (4) | |
| BEKNZ | Debit/credit indicator | BEKNZ | CHAR (1) | |
| BWMOD | Valuation Grouping Code | BWMOD | CHAR (4) | |
| PERIV | Fiscal Year Variant | PERIV | CHAR (2) | |
| KTOPL | Chart of Accounts | KTOPL | CHAR (4) | |
| KTOSL | Transaction Key | KTOSL | CHAR (3) | |
| KOART | Account type | KOART | CHAR (1) | |
| KSCHL | Condition type | KSCHL | CHAR (4) | |
| SAKNR | G/L Account Number | SAKNR | SKA1 | CHAR (10) |
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR (1) | |
| HKONT | General Ledger Account | HKONT | CHAR (10) | |
| STATUS | Delta Posting Status from AVR | STATUS_AVR_DELTA_POST | CHAR (4) | |
| KOKRS | Controlling Area | KOKRS | * | CHAR (4) |
| KOSTL | Cost Center | KOSTL | * | CHAR (10) |
| LSTAR | Activity Type | LSTAR | CHAR (6) | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | * | NUMC (8) |
| KSTRG | Cost Object | KSTRG | * | CHAR (12) |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC (10) | |
| APLZL | Internal counter | CIM_COUNT | NUMC (8) | |
| NPLNR | Network Number for Account Assignment | NPLNR | * | CHAR (12) |
| AUFNR | Order Number | AUFNR | * | CHAR (12) |
| AUPOS | Sales Document Item | POSNR_VA | * | NUMC (6) |
| KDAUF | Sales Order Number | KDAUF | * | CHAR (10) |
| KDPOS | Item number in Sales Order | KDPOS | NUMC (6) | |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC (10) | |
| BUKRS | Company Code | BUKRS | CHAR (4) | |
| GSBER | Business Area | GSBER | * | CHAR (4) |
| WERKS | Plant | WERKS_D | CHAR (4) | |
| PRCTR | Profit Center | PRCTR | CHAR (10) | |
| PRZNR | Business Process | CO_PRZNR | * | CHAR (12) |
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR (8) | |
| DABRZ | Reference date for settlement | DABRBEZ | DATS (8) | |
| VBUND | Company ID of Trading Partner | RASSC | * | CHAR (6) |
| AWREF_REV | Reversal: Reference Document No. of Document to Be Reversed | AWREF_REV | CHAR (10) | |
| AWORG_REV | Reversal: Reference Organizations of Document to Be Reversed | AWORG_REV | CHAR (10) | |
| STATUS_IT | Status of Cumulation Closing Document | CKMLAVRDOC_STATUS | CHAR (2) | |
| BELNR_POST | Document Number of a Closing Document for Cumulation | CKCUM_BELNR | CHAR (10) | |
| KJAHR_POST | Year in Which Closing Document for Cumulation Was Saved | CKCUM_KJAHR | NUMC (4) | |
| BELNR_REV | Document Number of a Closing Document for Cumulation | CKCUM_BELNR | CHAR (10) | |
| KJAHR_REV | Year in Which Closing Document for Cumulation Was Saved | CKCUM_KJAHR | NUMC (4) | |
| REVERSAL_ITEM | Reversal Item | CKMLAVRDOC_REVERSAL_ITEM | CHAR (1) |
