08-02-2007 10:09 AM
Functional Design
Report on Fast Moving Item with Comparison
Table of Contents
:
Team: Materials Management
2. Functional Design
2.1 Overview
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)
Type
(Alphanumeric, text, date, etc.)
Attribute
(Mandatory, display only, input)
Description
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
All Materials
2.3.2 Processing
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.
Running Mode
☒ Batch ☒ Interactive
☒ Background ☒ Foreground
Frequency
☒ Scheduled
Period: daily/monthly/annually/
Other __________
☒ Ad Hoc
Distribution List
All Stores users
2.3.2.1 Reporting Period
Day
Month
Quarter
Year
Fiscal period
Fiscal year
Other
2.3.2.2 Process Flow
As explained above.
2.3.3 SAP Transaction and/or scenario
N/A
2.3.4 SAP Standard/Custom Tables
S032, ZMMFASTMOV.
2.3.5 Output
2.3.5.1 Report Layout
Standard ALV.
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
2.3.5.2 Header Data
1. Run date:
2. Plant:
3. Storage Location
4. Selection Radio Button Description.
2.3.5.3 Report Columns
2.3.5.4 Line Item Data
2.3.5.5 Totals
2.3.5.6 Footer
2.3.6 Sorting
As per Storage location if Multiple Selection given and on Material Code.
2.3.7 Page Breaks
2.3.8 Interactive Capabilities
2.3.9 Dependencies
Z Table ZMMFASTMOV to be maintained by the user through the respective Transaction.
08-02-2007 10:12 AM
hi
Please try this web app
i am sure you'll get what you want.
<b>http://alvrobot.com.ar/</b>
Cheers
Ravish Garg
<b>
*reward if of any help</b>
08-02-2007 10:13 AM
hey man....
u need to try something by urself. Only then somebody can help. Please refrain from posting the whole requirement.
anyways u can take help at http://www.sapmaterial.com/alv1.html
and check with these sample progs
Go thru these programs they may help u to try on some hands on
ALV Demo program
BCALV_DEMO_HTML
BCALV_FULLSCREEN_DEMO ALV Demo: Fullscreen Mode
BCALV_FULLSCREEN_DEMO_CLASSIC ALV demo: Fullscreen mode
BCALV_GRID_DEMO Simple ALV Control Call Demo Program
BCALV_TREE_DEMO Demo for ALV tree control
BCALV_TREE_SIMPLE_DEMO
BC_ALV_DEMO_HTML_D0100
Dinesh