Wednesday, 4 November 2020

MB5L Transaction CDS View Equivalent

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.

SAP ABAP CDS, SAP ABAP Tutorial and Material, SAP ABAP Learning, SAP ABAP Certifications, SAP ABAP Study Materials

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

SAP ABAP CDS, SAP ABAP Tutorial and Material, SAP ABAP Learning, SAP ABAP Certifications, SAP ABAP Study Materials

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

SAP ABAP CDS, SAP ABAP Tutorial and Material, SAP ABAP Learning, SAP ABAP Certifications, SAP ABAP Study Materials

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

SAP ABAP CDS, SAP ABAP Tutorial and Material, SAP ABAP Learning, SAP ABAP Certifications, SAP ABAP Study Materials

SAP ABAP CDS, SAP ABAP Tutorial and Material, SAP ABAP Learning, SAP ABAP Certifications, SAP ABAP Study Materials

Propagate ValuationClass field in Current material price by cost estimate views

SAP ABAP CDS, SAP ABAP Tutorial and Material, SAP ABAP Learning, SAP ABAP Certifications, SAP ABAP Study Materials

SAP ABAP CDS, SAP ABAP Tutorial and Material, SAP ABAP Learning, SAP ABAP Certifications, SAP ABAP Study Materials

SAP ABAP CDS, SAP ABAP Tutorial and Material, SAP ABAP Learning, SAP ABAP Certifications, SAP ABAP Study Materials

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

SAP ABAP CDS, SAP ABAP Tutorial and Material, SAP ABAP Learning, SAP ABAP Certifications, SAP ABAP Study Materials

SAP ABAP CDS, SAP ABAP Tutorial and Material, SAP ABAP Learning, SAP ABAP Certifications, SAP ABAP Study Materials

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

SAP ABAP CDS, SAP ABAP Tutorial and Material, SAP ABAP Learning, SAP ABAP Certifications, SAP ABAP Study Materials

No comments:

Post a Comment