Monday, May 6, 2024

SAP Table ACDOCA_M_EXTRACT – ACDOCA Extract Table for Material Ledger

ACDOCA_M_EXTRACT is a standard SAP table in SAP ECC (or) S/4HANA which stores ACDOCA Extract Table for Material Ledger data. There are total 31 fields in ACDOCA_M_EXTRACT table.This blog post provides key technical details of SAP table ACDOCA_M_EXTRACT, including its availability across SAP S/4HANA versions and the list of CDS views for ACDOCA_M_EXTRACT table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Material Ledger – Database Layer (FINS_ML_DB)
Technical Component Actual Costing/Material Ledger (CO-PC-ACT)

SAP ACDOCA_M_EXTRACT Table Fields

The following is the list of fields that are available in SAP ACDOCA_M_EXTRACT table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
RCLNT Client MANDT MANDT CLNT (3)
RLDNR Ledger in General Ledger Accounting FINS_LEDGER FINS_LEDGER CHAR (2)
RBUKRS Company Code BUKRS BUKRS CHAR (4)
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR CK_KALNR NUMC (12)
FISCYEARPER Period/Year JAHRPER JAHRPER NUMC (7)
BELNR Accounting Document Number BELNR_D BELNR CHAR (10)
DOCLN Six-Character Posting Item for Ledger DOCLN6 DOCLN6 CHAR (6)
MATNR Material Number MATNR MATNR CHAR (40)
BWKEY Valuation area BWKEY BWKEY CHAR (4)
BWTAR Valuation Type BWTAR_D BWTAR CHAR (10)
RYEAR General Ledger Fiscal Year GJAHR_POS GJAHR NUMC (4)
POPER Posting period POPER POPER NUMC (3)
ML_SOBKZ Special Stock Indicator SOBKZ SOBKZ CHAR (1)
ML_KDAUF Sales Document Number of Valuated Special Inventory MLMAT_KDAUF VBELN CHAR (10)
ML_KDPOS Sales Document Item Number of Valuated Special Inventory MLMAT_KDPOS POSNR NUMC (6)
ML_LIFNR Supplier of Valuated Special Inventory MLMAT_LIFNR LIFNR CHAR (10)
ML_PSPNR WBS Element (internal) of Valuated Special Inventory MLMAT_PSPNR PS_POSNR NUMC (8)
VMSL Valuation quantity VQUAN1_12 MENGV12 QUAN (23)
HSL Amount in Company Code Currency FINS_VHCUR12 WERTV12 CURR (23)
KSL Amount in Global Currency FINS_VKCUR12 WERTV12 CURR (23)
OSL Amount in Freely Defined Currency 1 FINS_VOCUR12 WERTV12 CURR (23)
VSL Amount in Freely Defined Currency 2 FINS_VVCUR12 WERTV12 CURR (23)
BSL Amount in Freely Defined Currency 3 FINS_VBCUR12 WERTV12 CURR (23)
CSL Amount in Freely Defined Currency 4 FINS_VCCUR12 WERTV12 CURR (23)
DSL Amount in Freely Defined Currency 5 FINS_VDCUR12 WERTV12 CURR (23)
ESL Amount in Freely Defined Currency 6 FINS_VECUR12 WERTV12 CURR (23)
FSL Amount in Freely Defined Currency 7 FINS_VFCUR12 WERTV12 CURR (23)
GSL Amount in Freely Defined Currency 8 FINS_VGCUR12 WERTV12 CURR (23)
HVKWRT Value at Sales Price in Local Currency MLHVKWRT WERTV12 CURR (23)
SDM_VERSION SilentDataMigration: Version Field for ML Tables FINS_ML_SDM_VERSION FINS_ML_SDM_VERSION CHAR (2)
ACDOC_EEW_DUMMY Dummy function in length 1 DUMMY DUMMY CHAR (1)

Availability

The SAP table ACDOCA_M_EXTRACT is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ACDOCA_M_EXTRACT table

The following is the list of ACDOCA_M_EXTRACT CDS views, which can also be used instead of ACDOCA_M_EXTRACT table based on your business requirements.

CDS View CDS View Type Description
I_PRODUCTMLACCOUNT BASIC Product: Val ML acc active core entity
P_CUSTOMERAVGQUANTITY BASIC Average Quantity for Customer
P_CUSTOMERORDER BASIC Customer and Order information
P_MATERIALINFO BASIC Material Info Stock Champion
P_MATVAL_MANAGE_BAL BASIC Base View for Mat.Val., Balances
P_MATVAL_MANAGE_BALTAB BASIC Base View for Mat.Val., Balances
P_MATVAL_MANAGE_BAL_SPLIT BASIC Base View for Mat.Val., Balances
P_MATVAL_MANAGE_PNV BASIC Prices and values for app Mat. Val. Manage
A_PRODUCTVALUATION COMPOSITE Valuation Area Data
A_PRODUCTVALUATIONACCOUNT COMPOSITE Valuation Account Data
I_ARUNANLYTSSUPDMNDOVWCUBE COMPOSITE Overview of Supply and Demand
I_ARUNANLYTSTOTSUPCUBE COMPOSITE Total Supply of all Document Types
I_CURRENTMATERIALVALUATIONS COMPOSITE Current Material Valuations
I_CURRENTMATLPRICEBYCOSTEST COMPOSITE Current material price by cost estimate
I_CUSTOMERORDERS COMPOSITE Customer and Order information
I_DEADSTOCKMATERIALCUBE COMPOSITE Dead Stock Material
I_MATERIALKPIFORCYCLECOUNTING COMPOSITE I View Material KPIs fory Cycle Counting
I_MATERIALVALUATIONS COMPOSITE Current Material Valuations
I_MATERIALVALUATIONSBYPERIODS COMPOSITE Material Valuations by Currtp/Period
I_PRODUCTVALUATION COMPOSITE Product Valuation
I_PRODUCTVALUATIONACCT COMPOSITE Product Valuation Account
I_PRODUCTVALUATIONPRICES_UNION COMPOSITE Product Valuation Prices Union
I_SLOWORNONMOVINGMATLCRCY COMPOSITE I_SlowOrNonMvngMatlCurr
I_SLOWORNONMOVINGMATLCUBE COMPOSITE Slow or Non-Moving Materials
I_SLOWORNONMOVINGMATLOPG COMPOSITE Slow or Non-Moving Materials object page
I_SLOWORNONMOVINGMATLOPGHDR COMPOSITE SlowNonMvgMaterial: Object Page Header
I_STKKPIGROUPINGDELTACOMPRN COMPOSITE Stock KPI Grouping of the Delta
I_STKKPITIMESERIESCOMPRNCUBE COMPOSITE Stock KPI Time series Comparison Cube
I_STOCKQUANTITYCURRENTVALUE COMPOSITE Current Stock Quantity and Value
I_STOCKQUANTITYVALUEBYTYPE COMPOSITE Stock Quantity and Value by Type
I_STOCKQUANTITYVALUETIMESERIES COMPOSITE Stock Quantity and Value time series
I_SUPDMNDALLDOCBATCHSTOCK COMPOSITE View for Batch Stock
I_SUPDMNDALLDOCBATSTKASSGC COMPOSITE Cube View for Batch Stock Assignment Details
I_SUPDMNDALLDOCBATSTKBSC COMPOSITE Basic View for Batch Stock
I_SUPDMNDALLDOCBATSTKC COMPOSITE Cube View for Batch Stock Details
I_SUPDMNDALLDOCNONBATCHSTOCK COMPOSITE View for Non Batch Stock
I_SUPDMNDALLDOCNONBATSTKASSGC COMPOSITE Cube View for Non Batch Stock Assignment Details
I_SUPDMNDALLDOCNONBATSTKBSC COMPOSITE Basic View for Non Batch Stock
I_SUPDMNDALLDOCNONBATSTKC COMPOSITE Cube View for Non Batch Stock Details
I_SUPDMNDALLDOCOVWCUBE COMPOSITE Cube View for Overview of Supply and Demand
I_SUPDMNDALLDOCPHYSSTK COMPOSITE View for Physical Stock
I_SUPDMNDALLDOCPHYSSTKASSGC COMPOSITE Cube View for Physical Stock Assignment Details
I_SUPDMNDALLDOCPHYSSTKC COMPOSITE Cube View for Physical Stock Details
I_SUPDMNDALLDOCSUPAMT COMPOSITE View for Supply of All Documents
I_SUPDMNDALLDOCSUPAMTCUBE COMPOSITE Cube view for Amount in Display Currency
I_SUPDMNDALLDOCSUPPLY COMPOSITE View for Supply of All Documents
I_SUPDMNDALLDOCTOTSUP COMPOSITE View for Total Supply of All Document Types
I_SUPDMNDALLDOCTOTSUPCUBE COMPOSITE Cube View for Total Supply of All Document Types
I_SUPDMNDOVWASSGMTCUBE COMPOSITE Supply Demand Overview Cube View(MDR)
I_SUPDMNDOVWBATCH COMPOSITE Basic view for Assign batches
I_SUPDMNDOVWCUBE COMPOSITE Supply Demand Overview Cube View
I_SUPDMNDOVWNOBATCH COMPOSITE Basic View for Non batch fix
I_SUPDMNDOVWPGTOTSUPC COMPOSITE Cube View for Total Supply of all Sources
I_SUPDMNDOVWSUPPLY COMPOSITE Basic view for Supply
I_SUPDMNDOVWTOTALSUPPLY COMPOSITE Basic View for Supply Overview
I_SUPDMNDOVWTOTALSUPPLYCUBE COMPOSITE Total Supply Cube View
P_BATCHINFO COMPOSITE Batch detail table
P_CURRENTMATLPRICEBYCOSTEST COMPOSITE Current material price by cost estimate
P_DEADSTKDATE_FINAL COMPOSITE Dead Stock in query period
P_DEADSTKDATE_FINAL2 COMPOSITE Dead Stock Final level 2
P_DEADSTKDATE_FINAL3 COMPOSITE Dead Stock Final level 3
P_DEADSTK_FINAL COMPOSITE dead stock final
P_DEADSTK_UNION COMPOSITE Dead stock information union
P_DEADSTK_UNI_V COMPOSITE dead stock final
P_MATERIALKPICNSMPNOFSTOCK COMPOSITE Consumption + Cons Value of Stock
P_MATERIALKPICONSUMPTION COMPOSITE Consumption + Cons Value of Material
P_MATERIALKPIFORCYCLECOUNTING COMPOSITE All KPIs of Material for Cycle Counting
P_MATERIALKPIQTYVALAVG COMPOSITE Quantity and VAlue + AVG of Material
P_MATERIALKPIQTYVALAVGOFSTOCK COMPOSITE Quantity and Value + AVG of Stocks
P_MATSTKQTYVALBYKEYDATE COMPOSITE SlowNonMovingMaterial: quant and value
P_MATSTKQTYVALBYKEYDATEMID COMPOSITE SlowNonMovingMaterial: quant and val mid
P_MATSTKQTYVALCUR1 COMPOSITE Current Stock Quantity and Value
P_MATSTKQTYVALCUR2 COMPOSITE Current Stock Quantity and Value
P_MATSTKQTYVALOVP2 COMPOSITE Stock Quantity and Value by Type OVP2
P_MATSTKQTYVALOVP3 COMPOSITE Stock Quantity and Value by Type
P_PLANTKPIFORCYCLECOUNTING COMPOSITE Plant KPIs For Cycle Counting
P_PRODUCTMLACCOUNTWD COMPOSITE Product ML Acocunt Union (draft)
P_PRODUCTVALUATIONWD COMPOSITE union
P_SALESVIEW_FS COMPOSITE Private Factsheet – Sales View
P_SLOWORNONMOVINGMATERIAL COMPOSITE Slow or Non-Moving Materials (Union)
P_SLOWORNONMOVINGMATL COMPOSITE SlowNonMovingMaterial: View for cube
P_SLOWORNONMOVINGMATLBOM COMPOSITE SlowNonMovingMaterials: BOM
P_SLOWORNONMOVINGMATLBOMOPG COMPOSITE SlowNonMovingMaterials object page: BOM
P_SLOWORNONMOVINGMATLFLOAT COMPOSITE SlowNonMovingMaterials: Float Values
P_SLOWORNONMOVINGMATLFLOATOPG COMPOSITE SlowNonMovingMaterials object page: Float Values
P_SLOWORNONMOVINGMATLINDEX COMPOSITE SlowNonMovingMaterials: Slow Moving Index
P_SLOWORNONMOVINGMATLINDEXOPG COMPOSITE SlowNonMovingMaterials object page: Slow Moving Index
P_SLOWORNONMOVINGMATLOPG COMPOSITE SlowNonMovingMaterial object page: View for cube
P_SLOWORNONMOVINGMATLOPGHDR COMPOSITE SlowNonMovingMaterial: Object Page Header
P_SLOWORNONMVGMATLFLOATOPGHDR COMPOSITE SlowNonMvgMaterial: Float values
P_SLOWORNONMVGMATLIDXOPGHDR COMPOSITE SlowNonMvgMaterial: Slow Moving Index
P_SLOWORNONMVGMATLOPGHDRAGGRGN COMPOSITE SlowNonMvgMaterial: Header Aggregation
P_SLOWORNONMVGMATLOPGHDRUNION COMPOSITE Slow or Non-Moving Materials (Union)
P_SLOWORNONMVGMATLOPGITMAGGRGN COMPOSITE SlowNonMvgMaterial: Item Aggregation
P_STKKPIASSIGNTOSINGLEPERIOD COMPOSITE Assign KPIs to reference period or previous period
P_STKKPIAVERAGEDELTACOMPRN COMPOSITE Stock KPI Calculation of the average delta
P_STKKPICALCULATEDELTACOMPRN COMPOSITE Stock KPI Calculation of the Delta for compared periods
P_STKKPILINKCOMPAREDPERIODS COMPOSITE Link reference period with previous period
P_STKKPITIMESERIESALLPERIODS COMPOSITE TimeSeries for all KPIs and all Periods
P_STKVALUEBYTYPE2 COMPOSITE Stock value by type level 2
P_STKVALUEBYTYPE3 COMPOSITE Stock value by type level 3
P_STKVALUEBYTYPE4 COMPOSITE Stock value by type level 4
P_STOCKQUANTITYVALUETS1 COMPOSITE Stock Quantity and Value time series
P_STOCKQUANTITYVALUETS2 COMPOSITE Stock Quantity and Value time series
P_SUPDMNDALLDOCBATSTKBSC COMPOSITE Basic View for Batch Stock
P_SUPDMNDALLDOCNONBATSTKBSC COMPOSITE Basic View for Non Batch Stock
P_SUPDMNDALLDOCOVW COMPOSITE Overview of Demand and Supply
P_SUPDMNDALLDOCPHYSSTK COMPOSITE View for Physical Stock Details
P_SUPDMNDALLDOCPHYSSTKASSG COMPOSITE View for Physical Stock Assignment Details
P_SUPDMNDOVWASSGMTCUBE COMPOSITE Supply Demand Overview Cube View
P_SUPDMNDOVWCUBE COMPOSITE Supply Demand Overview Cube View
C_ARUNANLYTSSUPDMNDOVWQRY CONSUMPTION Overview of Supply and Demand Query
C_ARUNANLYTSTOTSUPQRY CONSUMPTION Total Supply of all Document Types Query
C_BALANCESHEETVALUATION CONSUMPTION Balance Sheet Valuation Results
C_BR_REPORTINGINVENTORYCUBE CONSUMPTION EFD – H010 – L012 – Inventory Cube
C_BR_REPORTINGINVENTORYQUERY CONSUMPTION EFD-H010-L012 – Inventory Query
C_BR_RPTGINVTRYTOTAMOUNTCUBE CONSUMPTION EFD-H005-L012 – Invtry Total Amount Cube
C_BR_RPTGINVTRYTOTAMOUNTQUERY CONSUMPTION EFD-H005-L012 – Invtry Total Amount Qry
C_BR_RPTGUNITCNVRSNFACTORCUBE CONSUMPTION EFD-0220 – Unit Conversion Factor Cube
C_BR_RPTGUNITCNVRSNFACTORQUERY CONSUMPTION EFD-0220 – Unit Conversion Factor Query
C_BR_RPTGUNITOFMEASURECUBE CONSUMPTION EFD-0190 – Unit of Measure Cube
C_BR_RPTGUNITOFMEASUREQUERY CONSUMPTION EFD-0190 – Unit of Measure Query
C_BR_STATUTORYRPTGINVENTORY CONSUMPTION All Inventory Materials
C_DEADSTOCKMATERIALQRY CONSUMPTION Dead Stock Material Query
C_DEADSTOCKMATERIALYEARQRY CONSUMPTION Dead Stock Material Year Query
C_MATERIALINVENTORYPRICE CONSUMPTION Material Inventory Price
C_MATERIALKPIFORCYCLECOUNTING CONSUMPTION C View Material KPIs for Cycle Counting
C_MATLVALNMANAGE CONSUMPTION Material Valuations
C_MATLVALNMANAGEINVTRYVALN CONSUMPTION Prices and values over Per. and Curr.
C_PH_INVENTORYQUERY CONSUMPTION Ph Inventory Query Philippines
C_PH_STOCKQUERY CONSUMPTION Ph Stock Query Philippines
C_POSTEDMATLINVENTORYVALUATION CONSUMPTION Matl. Inventory Valuation After Posting
C_PRODUCTMLACCOUNT CONSUMPTION Product:Consumption for ML Account
C_PRODUCTVALUATION CONSUMPTION Consumption – Product Valuation
C_PRODUCTVALUATIONACCT CONSUMPTION Consumption Product Valuation Accounting
C_PRODUCTVALUATIONCOSTESTIMATE CONSUMPTION Consumption – Product Valuation Cost Estimate
C_PRODUCTVALUATIONFUTURE CONSUMPTION Consumption – Product Valuation Future Prices
C_PRODUCTVALUATIONPRICES CONSUMPTION Consumption – Product Valuation Prices
C_SALESVIEW_FS CONSUMPTION Consumption Factsheet – sales view facet
C_SLOWORNONMOVINGMATLOPG CONSUMPTION Slow or Non-Moving Materials object page
C_SLOWORNONMOVINGMATLOPGHDR CONSUMPTION SlowNonMvgMaterial: Object Page Header
C_SLOWORNONMOVINGMATLQRY CONSUMPTION Slow or Non-Moving Materials query
C_SLOWORNONMVNGMATLCURRQRY CONSUMPTION Slow or Non-Moving Materials Current Date Query
C_STKKPIGROUPCOMPARISON CONSUMPTION Stock KPI grouping of delta
C_STKKPITIMESERIESCOMPRNQRY CONSUMPTION Stock KPI Time series Comparison Query
C_STOCKQTYCURRENTVALUE_2 CONSUMPTION Current stock quantity and value
C_STOCKQUANTITYCURRENTVALUE CONSUMPTION Current Stock Quantity and Value
C_STOCKQUANTITYVALUEBYTYPE CONSUMPTION Stock Quantity and Value by Type
C_STOCKQUANTITYVALUELASTYEAR CONSUMPTION Stock Quantity and Value for last year
C_STOCKQUANTITYVALUETIMESERIES CONSUMPTION Stock Quantity and Value time series
C_SUPDMNDALLDOCBATSTKASSGQ CONSUMPTION Query View for Batch Stock Assignment Details
C_SUPDMNDALLDOCBATSTKQ CONSUMPTION Query View for Batch Stock Details
C_SUPDMNDALLDOCFILTER CONSUMPTION Filter View for Supply Demand Overview for All Documents
C_SUPDMNDALLDOCNONBATSTKASSGQ CONSUMPTION Query View for Non Batch Stock Assignment Details
C_SUPDMNDALLDOCNONBATSTKQ CONSUMPTION Query View for Non Batch Stock Details
C_SUPDMNDALLDOCOVWQRY CONSUMPTION Query View for Overview of Supply and Demand
C_SUPDMNDALLDOCPHYSSTKASSGQ CONSUMPTION Query View for Physical Stock Assignment Details
C_SUPDMNDALLDOCPHYSSTKQ CONSUMPTION Query View for Physical Stock Details
C_SUPDMNDALLDOCSUPAMTCUBEQRY CONSUMPTION Query View Amount demand in Display Curr
C_SUPDMNDALLDOCTOTSUPQRY CONSUMPTION Query View for Total Supply of All Document Types
C_SUPDMNDOVWASSGMTQUERY CONSUMPTION Supply Demand Overview
C_SUPDMNDOVWFLTR CONSUMPTION Filters For Supply Demand Overview
C_SUPDMNDOVWPGFLTR CONSUMPTION Supply and Demand Cockpit Filter
C_SUPDMNDOVWPGTOTSUPQ CONSUMPTION Consumption View for Total Supply of all Sources
C_SUPDMNDOVWQUERY CONSUMPTION Query View for Supply Demand Overview
C_SUPDMNDOVWTOTSUPQUERY CONSUMPTION Query View for Total Supply
C_SUPDMNDTOTPOQUERY CONSUMPTION Query View for Total Supply
C_UPLDMATERIALINVENTORYPRICE CONSUMPTION Uploaded Material Inventory Price
P_BR_REPORTINGITEM CONSUMPTION EFD – Product with Valuation and Plant
P_BR_REPORTINGMATERIAL CONSUMPTION EFD – Material Data
P_BR_REPORTINGPLANTMATERIAL CONSUMPTION EFD – Material per Plant
P_BR_RPTGFILLCESTBYMATERIAL CONSUMPTION EFD – Material with CEST by Code
P_BR_RPTGFILLCESTBYNCM CONSUMPTION EFD – Material with CEST by NCM
P_BR_RPTGINVENTORYVALUATION CONSUMPTION Inventory Valuation
P_BR_RPTGINVTRYBUSINESSPLACE CONSUMPTION Inventory – Business Place
P_BR_RPTGREPORTEDMATERIAL CONSUMPTION EFD – Reported Material
P_BR_RPTGREPORTEDMATLDATA CONSUMPTION EFD – Reported Material Data
P_BR_RPTGUOMAGGREGATION CONSUMPTION Unit of Measure Aggregation
P_INVTRYTURNOVERAVGSTKVALS CONSUMPTION Inventory Turnover Average Stock Values
P_INVTRYTURNOVERTMESERSAGGRGN CONSUMPTION Inventory Turnover Time Series Aggr
P_INVTRYTURNOVERTMESERSVALN CONSUMPTION Inventory Turnover Time Series Valuation
P_INVTRYTURNOVERVALUATION CONSUMPTION Inventory Turnover Valuation
P_RPTGMATERIALDATAAGGREGATION CONSUMPTION EFD – Material Data Aggregation