ACDOCA_M_EXTRACT table in SAP ERP or S/4HANA stores ACDOCA Extract Table for Material Ledger data. There are total 31 fields in ACDOCA_M_EXTRACT table. The ACDOCA Extract Table for Material Ledger table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ACDOCA_M_EXTRACT table. It is in Material Ledger – Database Layer (FINS_ML_DB) ABAP package and is part of the Actual Costing/Material Ledger (CO-PC-ACT) module.
SAP ACDOCA_M_EXTRACT Table Fields
Following is the list of fields that are available in SAP ACDOCA_M_EXTRACT table. The primary key fields of ACDOCA Extract Table for Material Ledger table in SAP are RCLNT (Client), RLDNR (Ledger in General Ledger Accounting), RBUKRS (Company Code), KALNR (Cost Estimate Number for Cost Est. w/o Qty Structure), FISCYEARPER (Period/Year), BELNR (Accounting Document Number), DOCLN (Six-Character Posting Item for Ledger).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| RCLNT | Client | MANDT | CLNT(3) | |
| RLDNR | Ledger in General Ledger Accounting | FINS_LEDGER | CHAR(2) | |
| RBUKRS | Company Code | BUKRS | CHAR(4) | |
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC(12) | |
| FISCYEARPER | Period/Year | JAHRPER | NUMC(7) | |
| BELNR | Accounting Document Number | BELNR_D | CHAR(10) | |
| DOCLN | Six-Character Posting Item for Ledger | DOCLN6 | CHAR(6) | |
| MATNR | Material Number | MATNR | CHAR(40) | |
| BWKEY | Valuation area | BWKEY | CHAR(4) | |
| BWTAR | Valuation Type | BWTAR_D | CHAR(10) | |
| RYEAR | General Ledger Fiscal Year | GJAHR_POS | NUMC(4) | |
| POPER | Posting period | POPER | NUMC(3) | |
| ML_SOBKZ | Special Stock Indicator | SOBKZ | CHAR(1) | |
| ML_KDAUF | Sales Document Number of Valuated Special Inventory | MLMAT_KDAUF | CHAR(10) | |
| ML_KDPOS | Sales Document Item Number of Valuated Special Inventory | MLMAT_KDPOS | NUMC(6) | |
| ML_LIFNR | Supplier of Valuated Special Inventory | MLMAT_LIFNR | CHAR(10) | |
| ML_PSPNR | WBS Element (internal) of Valuated Special Inventory | MLMAT_PSPNR | NUMC(8) | |
| VMSL | Valuation quantity | VQUAN1_12 | QUAN(23) | |
| HSL | Amount in Company Code Currency | FINS_VHCUR12 | CURR(23) | |
| KSL | Amount in Global Currency | FINS_VKCUR12 | CURR(23) | |
| OSL | Amount in Freely Defined Currency 1 | FINS_VOCUR12 | CURR(23) | |
| VSL | Amount in Freely Defined Currency 2 | FINS_VVCUR12 | CURR(23) | |
| BSL | Amount in Freely Defined Currency 3 | FINS_VBCUR12 | CURR(23) | |
| CSL | Amount in Freely Defined Currency 4 | FINS_VCCUR12 | CURR(23) | |
| DSL | Amount in Freely Defined Currency 5 | FINS_VDCUR12 | CURR(23) | |
| ESL | Amount in Freely Defined Currency 6 | FINS_VECUR12 | CURR(23) | |
| FSL | Amount in Freely Defined Currency 7 | FINS_VFCUR12 | CURR(23) | |
| GSL | Amount in Freely Defined Currency 8 | FINS_VGCUR12 | CURR(23) | |
| HVKWRT | Value at Sales Price in Local Currency | MLHVKWRT | CURR(23) | |
| SDM_VERSION | SilentDataMigration: Version Field for ML Tables | FINS_ML_SDM_VERSION | CHAR(2) | |
| ACDOC_EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR(1) |
