OPEN ORDERS RECEIPTS...

[Former Member]

Hi,

I have build a Tree Control to display

Materials and all the Suppliers to this Material. When User klick on Material,this Material Node shows all Suppliers for this Material as 2nd Hierarchy.

How can we gather all OPEN ORDERS / RECEIPTS ( Amount and

Value ) distributed to the 12 Months of the actual Year

depending on ONE SUPPLIER.

Schematic wiil be like this;

Supplier Month Open Orders Receipts Count and Value

-

---

-

---

-

---

-

---

Bros ltd. JAN 1000 15000 1125000 USD

FEB

MAR

...

...

...

DEC

and second Question is;

How can we gather Information about Stock, Receipts, and demand distibuted to the 52 Calender WEEKS of the actual Year depending on ONE SUPPLIER?

Schematic here like This;

Projections Supplier 1.Week Quantity and Value 2.Week...

-

---

-

---

-

---

-

---

Inventory Bros Ltd 10 Pcs 100 USD

Receipt Bros Ltd 120 Pcs 1200 USD

Demand Bros Ltd 100 Pcs 1000 USD

Thank You for your Replies in Advance.

Best Regards

Beserithan Malabakan

[Former Member]

Hi,

I have build a Tree Control to display

Materials and all the Suppliers to this Material. When User klick on Material,this Material Node shows all Suppliers for this Material as 2nd Hierarchy.

How can we gather all OPEN ORDERS / RECEIPTS ( Amount and

Value ) distributed to the 12 Months of the actual Year

depending on ONE SUPPLIER.

Schematic wiil be like this;

Supplier Month Open Orders Receipts Count and Value

-

---

-

---

-

---

-

---

Bros ltd. JAN 1000 15000 1125000 USD

FEB

MAR

...

...

...

DEC

and second Question is;

How can we gather Information about Stock, Receipts, and demand distibuted to the 52 Calender WEEKS of the actual Year depending on ONE SUPPLIER?

Schematic here like This;

Projections Supplier 1.Week Quantity and Value 2.Week...

-

---

-

---

-

---

-

---

Inventory Bros Ltd 10 Pcs 100 USD

Receipt Bros Ltd 120 Pcs 1200 USD

Demand Bros Ltd 100 Pcs 1000 USD

Thank You for your Replies in Advance.

Best Regards

Beserithan Malabakan

[former_member181966]

How can we gather all OPEN ORDERS / RECEIPTS ( Amount and

Value ) distributed to the 12 Months of the actual Year

depending on ONE SUPPLIER.

-You can get RECEIPTS from table MSEG and MKPF . Movement types are 101 and 102 . you’ll get value ( Dmbtr ) as well as Qty ( menge ) for certain time period . If I’m not missing you`ll get AUFNR ( P.O) on 101 and 102.

Also see the IS ( S031,S032,& S033)

How can we gather Information about Stock, Receipts, and demand distibuted to the 52 Calender WEEKS of the actual Year depending on ONE SUPPLIER?

-You can get the supplier name from ISO or PO . you can see tables MARD for stock and Receipts you cn take from MSEG and MKPF.

Pl..refer reports MC.1,MC.9 and also MB5b,MB51 etc

Hope this’ll give you idea!!

<b>Pl... award the points.</b>

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

[Former Member]

Hi Saquib,

what do you mean with 'Also see the IS ( S031,S032,& S033)' ?

Thanks!

Bye

[former_member181966]

They are Information’s structures for materials . They have the collective data for material on the basis of month and year. Just see these information structures are populating in your system or not.

MM reports Mc.1, MC.9 and MC.XX (XX is number) use these IS .

Thanks

Saquib Khan

[Former Member]

Hi,

is there no Way to find out the Infos via Function Modules or BAPIs?

Regards

Beserithan

[Former Member]

I mean to find out the Open Quantity and Receipts via BAPI or Functionmodule...

Beserithan

[Former Member]

If you mean the outstanding qtuy to be delivered you will have to calculate that your self using the ordered qty from EKPO and the delivered qty in EKBE. You can join these tables using the document no. and the line item no.. EKPO will also have the material no. I don't there is a FM that will give you this info.

Regards,

Ravi

[Former Member]

and how to find the receipts, which is given through mb51 transaction.

[Former Member]

I guess it would have created a material document, with a specific movement type. Look at BSEG table with the PO number.

Regards,

Ravi

[Former Member]

Hi Mala ,

<b>receipts</b>qty is calculated by List of Movement Types ,So first u have to list of all the movement types which comes under Receipts ,i cannnt give bcos its vary company to company.

with that movement tyeps u have to get the qty frm MSEG+MKPF.

in MB51 program search for BWART range table and for MSEG also.

Regards

Prabhu