Skip to Content
Personal Insights
Author's profile photo Ravi Dave

Inventory CDS View with S/4 HANA

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

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

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:

 

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

 

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Javier Lazarte
      Javier Lazarte

      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

      Author's profile photo Ravi Dave
      Ravi Dave
      Blog Post Author

      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.

      Author's profile photo David Hurtado
      David Hurtado

      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.

      Author's profile photo Ravi Dave
      Ravi Dave
      Blog Post Author

      Hi David,

      Please try CDS: CSTOCKQUANVALCUR.

       

       

      Regards,

      Ravi.

      Author's profile photo Smit Patel
      Smit Patel

      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.

      Author's profile photo Ed Bean
      Ed Bean

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

      Author's profile photo Jason ski
      Jason ski

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

      Author's profile photo Pierrick Horpin
      Pierrick Horpin

      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

      Author's profile photo Dan K
      Dan K

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

      Author's profile photo Andrew Dama
      Andrew Dama

      Hi thanks for the nice blog in new features.

      Author's profile photo Ven Lui
      Ven Lui

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