Skip to Content
0
Former Member
Feb 15, 2006 at 12:32 PM

STOCK POLICY ANALYSIS

24 Views

Hi All,

I need to develop a report to assess material commodities under their scope with respect to stock policy settings.

<u>REQUIREMENT</u>

Report will be used to analytically assess and provide decision making data to enable adjustments of SAP stock policy settings that would generate optimum settings for; MINIMUM STOCK, SAFETY STOCK, REORDER POINTS, ETC. Report will first be used for an initial review of current settings and then to be run on a monthly basis for on-going analysis and maintenance of optimum settings.

<u>Required Column Layout for Report:</u>

Material

Description

Plant-Specific Material Status

MRP Controller

Purchasing Group

Material Group

MRP Group

Procurement Type

Special Procurement

Base Unit of Measure

Planned Delivery Time

Moving Price

Standard Price

Price Unit

Safety Stock

Safety Time IND

Safety Time /ACT COV

Lot Size

Minimum Lot Size

MRP Type

Reorder Point

Rounding Value

<b>Total Plant Stock</b> – total plant stock in storage locations including stock in project elements and blocked stock.

<b>Monthly demand</b> - current and forward demand displayed in monthly columns, 12 columns for first 12 months demand and then remainder in column 13

<b>Monthly Usage</b> – historic monthly usage displayed in monthly columns, 12 columns for first 12 months usage and then remainder in column 13

<u>MY QUESTION</u>

1. Can BW’s Inventory management scenarios handle this or will it be easier to do it via ABAP?

2. If BW can, how do I go about it? Really don’t know where to start so any assistance would be well appreciated.

Thanks

Milind