How to report on purchasing conditions on material level?

[Kmatth]

We need an important piece of reporting: purchasing conditions on material level.

Some more detailed info:

• We customized in purchasing an additional Access Sequence (for transport costs) with condition table (501): Purch.Org./Material
• We create purchasing conditions on Purch.Org./Material level for statistical reasons. These are representing the planned transport costs.
• We need to compare those (statistical) purchasing conditions with the actual invoiced costs for transport costs

So, it’s crucial that we can report with CDS views on which planned cost (purchasing condition) is in the system for material X within Purch.Org. XXXX.

The closest we get, is using CDS view ‘I_PurgPrcgConditionRecord’ and then we get condition records with prices, but without indication of the material. For that, we need an additional join with a CDS view holding that access sequence or condition table. But we can’t find that.

Question 1: is there a way to join CDS views, so we can get the desired result? If yes, with which CDS view?

Question 2: if there’s no CDS view to realize this, what are the alternative options to realize this?

[Mark_W]

We helped you to accept the answer, since there were no updates after 7 days.

You can unaccept it anytime if you have further questions.

[junaidalam · Accepted solution]

Hi kmattheys - Can you please provide some more info on the above topic. Would you like to compare the Planned cost in the PO and the unplanned delivery cost in Supplier Invoice.

Regards,

Junaid