Overview
ACDOCA_M_EXTRACT is a standard SAP S/4HANA table that stores ACDOCA Extract Table for Material Ledger data. There are total 31 fields in the ACDOCA_M_EXTRACT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ACDOCA_M_EXTRACT belongs to Actual Costing/Material Ledger (CO-PC-ACT) module and is located in the package Material Ledger - Database Layer (FINS_ML_DB).
In addition, following links provide an overview of foreign key relationships, if any, that link ACDOCA_M_EXTRACT to other SAP tables and standard CDS views available based on ACDOCA_M_EXTRACT table in S/4HANA 2020.
Techincal Settings of ACDOCA_M_EXTRACT
Below are technical details of the table ACDOCA_M_EXTRACT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ACDOCA_M_EXTRACT Fields
The following table gives you an overview of the fields available in ACDOCA_M_EXTRACT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|
| 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 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ACDOCA_M_EXTRACT
Other References