Symptom
There are several CDS views available for standard cost estimates.
Check help portal page for more details:
CDS Views for Inventory Accounting
It's not clear how the CDS views are connected and what is the logic to fetch cost estimate data.
Environment
SAP S/4HANA Cloud Public Edition
Cause
There are several CDS views available:
I_ProductCostEstimate
I_ProductCostEstimateItem
I_ProductCostEstimateDEX
I_ProductCostEstimateItemDEX
Resolution
For multi-level cost estimate, the data for items are nested level by level.
For example, you have BOM level like below:
- Finished Material F
-- Raw Material R1 & R2
If you want to check the item data for cost estimate of material F, sub-item R1 & R2, you need to:
First find header data in I_ProductCostEstimate for material F.
With key field COSTESTIMATE, find corresponding item details in item view I_ProductCostEstimateItem.
Get the relevant TRANSFERCOSTESTIMATE data, and with the same key, search again in the item view I_ProductCostEstimateItem to get the item detail information.
Keywords
Cost estimate, CDS view, PIR, info record, supplier. , KBA , CO-PC-PCP-2CL , Product Cost Planning (Public Cloud) , Problem