Show TOC

Inventory Management Stock QuantityLocate this document in the navigation structure

Use

The following reuse views are included in this virtual data model:

Reuse view

Description

Fact view for final warehouse stock quantities

(MaterialWarehouseStockFacts)

The view provides central information about the material warehouse stock, including the storage location or the material stock category. This information is the basis for all query views that are used to analyze a valuated stock and non-valuated stock based on a specific warehouse perspective.

This virtual data model provides the prerequisites for answering the following business questions:

  • Where can I find information about quantities of a material stock at plant and storage location level – divided by different stock types?

    • Final warehouse stock quantities with joined name fields (MaterialWarehouseStockQuery)

    • Warehouse stock quantities without special stock for materials(MaterialNonSpecialWarehouseStockQuery)

  • What is the quantity of special stocks such as the inspection stock or the blocked stock?

    • Final warehouse stock quantities with joined name fields (MaterialWarehouseStockQuery)

  • What is the quantity of the unrestricted-use stock or the batch stock?

    • Final warehouse stock quantities with joined name fields (MaterialWarehouseStockQuery)

You can find examples of reports based on this virtual data model in the download area of SAP HANA Live for SAP Business Suite in SAP Service Marketplace.

Query Views

The following query views are included in this virtual data model:

  1. Final warehouse stock quantities with joined name fields (MaterialWarehouseStockQuery)

    This query view displays information about the sum of the valuated stock and non-valuated stock based on the goods movement and the selection criteria. This query view contains all stock types: the storage location stock and the special stocks.

    Important Measures:

    • Material warehouse stock quantity in material base unit (MatlWrhsStkQtyInMatlBaseUnit)

      This measure provides information on the aggregated sum of the warehouse stock quantity based on the selection criteria.

    Important Attributes:

    • Material Stock Type

    • Inventory Special Stock Type

    • Material Stock Category

    • Material Base Unit

  2. Warehouse stock quantities without special stock for materials (MaterialNonSpecialWarehouseStockQuery)

    This query view displays information about the sum of the valuated stock and the non-valuated stock based on the selected criteria. This query view is used specifically for the stock type “storage location stock”, that is, without the “special stocks”.

    Important Measures:

    • Material warehouse stock quantity in material base unit (MatlWrhsStkQtyInMatlBaseUnit)

      This measure provides information about the aggregated sum of the warehouse stock quantity based on the selected criteria.

    Important Attributes:

    • Material Stock Type

    • Material Stock Category

    • Material Base Unit

These views are built on the following business objects:

  • Material

The views select data from the following tables and views, for example:

  • T156C (Stock types and stock categories)

  • MARC (Plant data for material)

  • MARD (Storage location data for material)

  • MCHB (Batch stocks)