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.
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
No comments:
Post a Comment