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