Findig Stock (Min/Max Inventory )

[Former Member]

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)

[Former Member · Accepted solution]

Hi ,

*(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).

-

---

><b>tables are MARAMARCMARD/H based on the requirement.</b>

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.

---> <b>Based on the requiment u have to USE SD table from invoice u can get the total sales of a given palnt ->VBRK+VBRP.</b>

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)

---><b>check table EKKOEKPOE* for PO+PR.</b>

Regards

Prabhu

[Former Member]

hi

good

go through this weblog i hope this ll help you to solve your problem

/people/lutz.morrien3/blog/2004/10/01/all-sap-business-one-formtypes-at-one-look

thanks

mrutyun^