Show TOC

 View Grouping: MRP-Relevant Stock Information

 

The views in this grouping are used to provide stock quantities for article location combinations that are relevant for the selected material replenishment planning (MRP) types. You define relevant MRP types in Customizing under Start of the navigation path SAP Customer Activity Repository Next navigation step POS Data Management Next navigation step POS Inbound Processing Next navigation step Integration with Other SAP Components Next navigation step SAP Forecasting and Replenishment Next navigation step Activate F&R Replenishment Types End of the navigation path.

The views in this grouping combine unrestricted stock data accessed from a source SAP ERP with the unprocessed sales data stored in the POSDW/TLOGUS table in SAP Customer Activity Repository. The resulting real-time stock data can be consumed from a connected replenishment system, such as SAP Forecasting and Replenishment (SAP F&R).

Structure

Report Query Views

The MRP Relevant Stock Aggregated (MRPRelevantStockAggregated) view is included in this view grouping. This view is used to provide stock quantities for article location combinations that are relevant for the selected material replenishment planning (MRP) types.

Caution Caution

MRPRelevantStockAggregated is a view that is intended to be used as a template and is not intended for productive use. It includes an extensive set of characteristics, measures and master data that may not be required for your business and that, as a result, can unnecessarily slow down the performance of the query view. Therefore, you can use the MRPRelevantStockAggregated as a template to build several smaller, targeted query views which consume the reuse views listed below.

End of the caution.
Reuse Views

This view grouping contains the following main reuse views:

  • MRP Relevant Stock By Types (MRPRelevantStockByTypes)

    This view displays stock quantities for all stock types usually required by a replenishment system for article location combinations. Article location combinations are restricted to only relevant MRP types as defined in Customizing under Start of the navigation path SAP Customer Activity Repository Next navigation step POS Data Management Next navigation step POS Inbound Processing Next navigation step Integration with Other SAP Components Next navigation step SAP Forecasting and Replenishment Next navigation step Activate F&R Replenishment Types End of the navigation path.

  • Material (Material)

    This view obtains master data regarding the material group from SAP ERP for Retail.

  • Plant (Plant)

    This view obtains master data regarding the plant from SAP ERP for Retail.

  • Unit of Measure Name (UnitOfMeasureName)

    This view provides master data, such as names of the units of measure.

Business Objects

These views are built on the business object.

  • POS transaction

  • Material

  • Plant

Measures and Attributes

Some important measures and attributes are:

  • MRP Relevant Stock Aggregated (MRPRelevantStockAggregated) view

    • The view provides general data such as the article identifier, article base unit of measure, and article location.

    • MovementTypeQualifier

      Specifies the movement type. Only the stock movement type (4000) is considered, all other movement types are filtered out.

    • SummedStockQuantity

      Total stock quantity of all stock types that have been defined as relevant for transfer to SAP F&R. You define relevant stock types in SAP ERP Customizing under Start of the navigation path Integration with Other SAP Components Next navigation step Forecasting and Replenishment Next navigation step Define Stock Types End of the navigation path.

  • MRP Relevant Stock By Types (MRPRelevantStockByTypes) view

    • The view provides general data such as location type and time zone.

    • MRP Type

      Controls which procedure is to be used to plan material replenishment and which MRP parameters can be entered when maintaining a material master record.

    • Physical Inventory Blocked Flag

      Specifies whether the stock for material is blocked due to physical process of inventory counting.

    • This view includes several calculated measures for obtaining stock quantities, such as stock in transit, stock in transfer, blocked stock, restricted consignment stock.

Calculation of Measures

To interpret the MRP-relevant stock information, it is important to understand the calculation of certain measures included in this view grouping:

Measure

Explanation of Calculation

CurrentUnrestrictedStock

The current unrestricted stock quantity is the difference between the unrestricted stock data obtained from SAP ERP and the unprocessed sales data stored in the POSDW/TLOGUS table in SAP Customer Activity Repository.

CurrentUnrestrictedStock = "UnrestrictedStock" - "UnprocessedSalesQuantity"

Filters

The views use the following filters:

  • MRP Relevant Stock Aggregated (MRPRelevantStockAggregated) view filters the following:

    • Movement type (FRE_BWART is 4000). Only the stock movement type is considered, other movement types are disregarded.

  • MRP Relevant Stock By Types (MRPRelevantStockByTypes) view filters the following:

    • Only articles that are not marked for deletion are considered (LVORM != 'X' ).

    • Only active MRP types are considered (FR_ACTIVE = 'X').

Used Tables and Views

The views select data from the following tables:

  • /POSDW/TLOGUS (unprocessed sales movements for articles) — SAP Customer Activity Repository

  • T006A (unit of measure) — SAP ERP for Retail

  • T001W (plants/branches) — SAP ERP for Retail

  • MARA (general material data) — SAP ERP for Retail

  • MAKT (material descriptions) — SAP ERP for Retail

  • MARD (storage location data for material) — SAP ERP for Retail

  • MARC (plant data for material) — SAP ERP for Retail

  • ADRC (address data) — SAP ERP for Retail

  • /POSDW/MRPFR (MRP Types That Are Relevant for SAP F&R) — SAP Customer Activity Repository

  • FRE_TS_REL_ST (relevant stock types for F&R transfer) — SAP ERP for Retail