Hi Friends Developing a report for max min inventory (stock ) the out put should be following 18
From One to eight i did it but dont know how to calculate the stocks forescast order quantities from existing requistion ,purchase order ,planned order, production order.
This is first time got this type of requirement in 7 months of abap carreer pls help me.
Answers will be awarded points.
*(1) Plant designation from Material Master (WERKS).
*(2) Material Number from Material Master (MATNR).
*(3) Description from Material Master (MAKTX).
*(4) Glass Type from Material Master (DISPO).
*(5) Unrestricted On-Hand from Material Master [or calculated] (LABST).
*(6) Blocked On-Hand from Material Master [or calculated] (SPEME).
*(7) Reorder Point from Material Master (MINBE).
*(8) Maximum Inventory from Material Master (MABST).
*****************************************************
(9) Calculate - Sales/Shipment Quantities 3-Months (back) from "today's" date.
(10) Calculate - Sales/Shipment Quantities 6-Months (back) from "today's" date.
(11) Calculate - Sales/Shipment Quantities 12-Months (back) from "today's" date.
(12) Calculate FY Forecast from CE2LMW1 Table.
(13) Calculate - Order quantities for next 3-Months.
(14) Calculate - Order quantities for next 6-Months.
(15) Calculate - Quantities from existing Requisitions -- DO NOT INCLUDE TRANSFER REQUIREMENTS.
(16) Calculate - Quantities from existing Purchase Orders (due & past-due) -- DO NOT INCLUDE TRANSFER ORDERS.
(17) Calculate - Quantities from existing Planned Orders.
(18) Calculate - Quantities from existing Production Orders (due & past-due)