Inventory CDS View with S/4 HANA

[RaviDave]

Introduction:

In this blog, we will try to explore and understand the Quantity and Value of CDS views available in the S/4 HANA Inventory Management modules and how can it be leveraged to address the client-specific requirement. Below are some examples of requirements:

• Creating a custom inventory aging report for batch manage materials or


• Adding additional fields in inventory reports like product hierarchy, Purchasing group, MRP controller or


• Interface Inventory snap to downstream or compliance systems.

ECC Vs S/4 HANA:

Below are the commonly used ECC tables to extract the quantity and value information. To extract the Inventory data from the system, one has to query MARA, MARD, MCHB, MKOL, MSSA, MSKU, MSKA, MSLB, and MSRD tables to consolidate inventories and combine with MBEW and EBEW to see the values.

With S/4 HANA, SAP has provided a CDS view that can be leveraged to query and build additional logic on top of it. One of the views is ISLOWNOMOMATC.

ECC Vs S/4 HANA

As shown below, while querying CDS view: ISLOWNOMOMATC, developer can pass the P_KeyDate as today's date (or system date), P_NumberOfDays = 0, P_InvenotryConsumption = 0 and P_DisplayCurrency = USD (if you local currency is CAD or EUR or different than USD)

ISLOWNOMOMATC

After querying the table, you will have below data points available in one go:

• As you can see below, you can directly get the quantity and value of inventory for all the stock types (Unrestricted-Use Stock, Stock in Quality Inspection, Returns, Stock Transfer (Storage Location), Stock Transfer (Plant), Stock in Transit, Blocked Stock, Restricted-Use Stock, Tied Empties, Valuated Goods Receipt Blocked Stock) and special stocks (Customer Consignment, Vendor Consignment, Sales Order Stock - MTO).


• Same CDS view has material number, plant, storage location, quantity, value in company code currency, value in display currency, material group and description, material type and description, plant name, last consumption date and posting date.


• It has Days w/o Consumption and Days without Posting as well (this is very helpful for inventory aging reporting. Not that this is per batch if materials are batch managed).

ISLOWNOMOMATC

Conclusions:

• By using the Inventory CDS view: ISLOWNOMATC provided by SAP will provide quick, faster, and reliable inventory information.


• Same CDS view has material number, plant, storage location, quantity, value in company code currency, value in display currency, material group and description, material type and description, plant name, last consumption date and posting date.


• CDS View: ISLOWNOMOMATC is being used for standard Fiori tile: Slow or Non-Moving Materials (Fiori App ID: F2137).


• Apart from ISLOWNOMATC, SAP has provided CDS View: F0MMIM_MATSTVAL and CSTOCKQUANVALCUR for Inventory and value as well. Standard Fiori tile: Stock – Multiple Materials (Fiori App ID: F1595) uses those CDS(s) views.

Reference:

• Current Stock Quantity and Value (Consumption)

 

If you find my blog useful, please like and share your feedback in the comments below and follow me for more content like above.