Skip to Content
0
Jan 30, 2009 at 10:11 AM

XLR query expert question

31 Views

Here is a little challenge from a user. I am using B1 for Stock control and Stock forecasting. Until now we used a Microsoft Access Query to extract to Stock Consumption Quantity from SAP tables and this query works fine and it creates the Stock Consumtion and forecast report for our company. However, I am trying to achieve the same result by using XLR in SAP and I can get the Stock Quantity from the relevant A/R Invoice table and extract the Quantity value for a particular Stock Item ( say MRH001 = Shampoo )

However, MRH001 is also used as part of other Gift Packs and we use Production Order and Bill of Material, to make up these packs. So the Gift Pack is finally recorded as a new Stock Item called Pack1 which contains MRH001. So our total consumption of Shampoo (MRH001) is made up from sales of MRH001 itself + MRH001 sold as Pack1. So we need a way of finding out the total SALES of MRH001 and so far we could not find a way. Our Business Partner has also tried to come up with an idea but so far we could not crack this one.

To make things more complex, our Pack1 (which contains MRH001) can be included in another pack (say Pack2). So now we have Shampoo sales under 3 different product codes, MRH001, Pack1 and Pack2.

Any ideas from SAP experts?

Thanks

Robert