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
.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).
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
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.
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
.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.
These views are built on the business object.
POS transaction
Material
Plant
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
.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.
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 |
---|---|
| 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 CurrentUnrestrictedStock = "UnrestrictedStock" - "UnprocessedSalesQuantity" |
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').
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