Skip to Content
0
Former Member
Aug 02, 2007 at 09:09 AM

Can Any one write code for this report in ALV , i have the fun spec Please

22 Views

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 S’Loc: LGORT

Central S’Loc Stock: MBWBEST where LGORT = input LGORT i.e. for Central S’Loc.

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 S’Loc 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.