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.

 

[jlazarte]

Hi Ravi!

Thanks for this information.

Do you know some CDS to allow me see the same FIORI information related transaction MB52?  Could share?

Thanks!

Best regards

Javier

[RaviDave]

Hi Javier,

Thank you for asking. Yes Fiori tile: Stock - Multiple Materials (APP ID: F1595) is UI5 Fiori tile for Fiori and gives almost similar view/data as MB52. Hope it helps !!!

 

Regards,

Ravi.

[todocalle4]

Hi Javier,

Thank you for answer.

Please can you help me with the name of the CDS that Stock - Multiple Materials (APP ID: F1595) works with.

At the moment I don't have access to FIORI only to eclipse.

[RaviDave]

Hi David,

Please try CDS: CSTOCKQUANVALCUR.

 

 

Regards,

Ravi.

[former_member865877]

Thank you for sharing !! This is helpful when extracting the Inventory data from S/4 HANA for reporting or sending the inventory snap to downstream systems.

 

Regards,

Smit.

[former_member865881]

This article is very help, we recently used for one of our inventory report development.

[former_member866377]

VERY important blog for anyone coding for Fiori or HANA as beginner

[pierrick_78]

HI !

very interesting.

I wanted to know if by any means it would be possible to drill down to Equipment number ? (in order to have the value of each equipment)

 

Thanks

Pierrick

[dankanv45]

Thank you for the Inventory CDS view it comes in handy for building the reports

[andrewd179]

Hi thanks for the nice blog in new features.

[loumui]

very good document , as i am new to CDS view this document made me to learn this concept