Skip to Content
0
Former Member
Feb 21, 2009 at 03:59 AM

Stock with vendors

36 Views

Hi Experts,

I am doing a report on stock with subcontractors,

I am facing a problem to find the opening stock with the vendor's.

My requirement is:

Main parts (MSEG-MATNR where BWART EQ '101' & '102' and also( ekpo-pstyp eq '3' and *ekpo-bstyp eq 'L' *).

And then the sub parts or raw materials sent to subcontractors: stpo-idnrk.

Now I need to calculate opening stock for this stpo-idnrk from mseg-bwart where bwart in 541,542,543 and 544. is (541-542-543+544 gives the opening stock).

Here for single parts(mseg-matnr) there may be many sub parts(stpo-idnrk) and I need to calculate opening stock for each and every sub parts.

If there is only single sub part I am getting the opening stock correctly but if there are multiple subparts the answers are repeating based on the main material. Please advice.

Thanks

Karthik.