Report on Fast Moving Item with Comparison
Table of Contents
Team: Materials Management
2. Functional Design
The requirement is to have a report for the Fast Moving Items of a particular store along with the comparison of Main Store stock and the defined store stock. The report will be after comparing the current stock with reorder level.
A Z table will be maintained for storing the relation between the stores (central sub store) along with reorder levels.
2.3 Detailed Functional Requirements
2.3.1 Selection Criteria / User Interface
Screen Field Name
(i.e., field label, not the technical name)
(Alphanumeric, text, date, etc.)
(Mandatory, display only, input)
WERKS Alphanumeric Mandatory Plant
MATNR Multiple Selection range Numeric Input Material
LGORT - Multiple Selection range Alphanumeric Mandatory Storage Location
LGORT Alphanumeric Mandatory Central Storage Location
Materials Below Reorder Level
A Z table named as ZMMFASTMOV has to be created as per the following details.
Plant Material Storage Location Reorder Level
MSEG-WERKS MSEG-MATNR MSEG-LGORT MSEG-MENGE
Key Field Key Field Key Field Input
Z_WERKS Z_MATNR Z_LGORT Z_MBWBEST
A Z Transaction Code named as ZMMFASTMOV to maintain the Table has to be created.
Once the Z table has been maintained a Z Report will run as follows.
The selection screen will have the parameters as above.
There will be Radio Buttons as shown above.
Based on the selection screen data will be fetched from table S032 as follows:
Z Table ZMMFASTMOV SO32 Table
Plant: Z_WERKS WERKS
Material: Z_MATNR MATNR
Storage Location: Z_LGORT LGORT
Reorder Level: Z_MBWBEST
Current Stock: MBWBEST where LGORT = Z_LGORT
Central SLoc: LGORT
Central SLoc Stock: MBWBEST where LGORT = input LGORT i.e. for Central SLoc.
☒ Batch ☒ Interactive
☒ Background ☒ Foreground
☒ Ad Hoc
All Stores users
126.96.36.199 Reporting Period
188.8.131.52 Process Flow
As explained above.
2.3.3 SAP Transaction and/or scenario
2.3.4 SAP Standard/Custom Tables
184.108.40.206 Report Layout
Plant Material Storage Location
Reorder Level Current Stock Central S' Loc. Central SLoc Stock
Case1 Materials Below Reorder Level
M011 2000000215 MKK1 100 80 MSS1 500
Case2 All Materials
M011 2000000215 MKK1 100 200 MSS1 500
220.127.116.11 Header Data
1. Run date:
3. Storage Location
4. Selection Radio Button Description.
18.104.22.168 Report Columns
22.214.171.124 Line Item Data
As per Storage location if Multiple Selection given and on Material Code.
2.3.7 Page Breaks
2.3.8 Interactive Capabilities
Z Table ZMMFASTMOV to be maintained by the user through the respective Transaction.