Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
uladzislau_pralat
Contributor
It is a common requirement to build custom reports base on MB5L transaction data (List of Stock Values: Balances). There is no CDS view equivalent to get this data. SAP offers  C_StockQuantityCurrentValue (Current Stock Quantity and Value) CDS view, but it is lacking Company Code and Account details. In my blog I explain how to add missing details to SAP standard CDS view.


As you can see from SAP documentation C_StockQuantityCurrentValue (Current Stock Quantity and Value) CDS view does not provide Company Code and G/L Account details


With some technical and functional knowledge it is easy to add missing details to standard view.


All it takes is to:

Create CDS view linking Company Code and G/L Account data



 

Propagate ValuationClass field in Current material price by cost estimate views




 

Lookup up Company Code and G/L Account data by ValuationArea and ValuationClass



 

Propagate Company Code and G/L Account in all subsequent CDS views


 

You can download CDS views from GitHub:

ZP_CompanyCodeGLAccount

ZP_CurrentMatlPriceByCostEst2

ZP_CurrentMatlPriceByCostEst1

ZI_CurrentMatlPriceByCostEst

ZI_MaterialStock

ZP_MatStkQtyValCur3

ZP_MatStkQtyValCur2

ZP_MatStkQtyValCur1

ZI_StockQuantityCurrentValue

ZC_StockQuantityCurrentValue
1 Comment