Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
RaviDave
Active Participant
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:

 

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

 
11 Comments
jlazarte
Explorer
0 Kudos
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
Active Participant
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
Discoverer
0 Kudos
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
Active Participant
0 Kudos
Hi David,

Please try CDS: CSTOCKQUANVALCUR.

 

 

Regards,

Ravi.
former_member865877
Discoverer
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
Discoverer
This article is very help, we recently used for one of our inventory report development.
VERY important blog for anyone coding for Fiori or HANA as beginner
pierrick_78
Explorer
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
Explorer
0 Kudos
Thank you for the Inventory CDS view it comes in handy for building the reports
andrewd179
Explorer

Hi thanks for the nice blog in new features.

loumui
Explorer
0 Kudos

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

Labels in this area