Skip to Content

Sales and Purchase in ONE view

Hi All-

I am trying to define a rule or extraction logic to see if I can pull Sales data/ Sales Amount and the corresponding Vendor information from whom the Products were purchased.

For example:

I purchase a Material "A" from Vendor "A-Vendor" for a certain amount and then sell it to customer through Sales Orders.

I have the material list and want to build a report or atleast define logic where I can have Vendor info. and Sales amounts in the same view. How do I tie the Sales data (VBAP) for Materials to fetch the corresponding Vendor info. from where it was purchased in a single view?

Any help will be greatly appreciated


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 09, 2018 at 04:27 PM

    Unless you have not more info which you did not share with us, I can just say that you can't have it if you did not do a Make/Buy-to-order process.

    With neutral warehouse stock you can just assume something, but it is never really a fact.

    See my blog How old is my stock / from which vendor is my stock

    Add comment
    10|10000 characters needed characters exceeded

    • As Juergen said, unless you use batch management, there is no way to say that this particular car was purchased from this particular vendor and sold to this particular customer.

      If there is an assumption that there is always only one vendor for material (and it never changes?) then I guess you could make up such report by looking up the vendor number (LIFNR) by Material in a purchasing info record or whenever you'd maintain that cross-reference. You'd probably also need Plant or some kind of Sales Org / Purchasing Org linkage.

      But, as Juergen correctly noted, this would be very much assumption-based and may be inaccurate. Also I'm not quite sure what value such report would even provide. What metrics would you obtain from this? The material from such and such vendor is not selling well? Hm, you only have one vendor anyway, so what are you going to do about it? Stop selling Fords altogether? You don't need vendor number for this IMHO.

      Think about it.