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.