The user also need the price and customer name to be in the report.
---
Table required:
A005 - Own Customized Customer Material sales pricing data from VK11
KONP - Conditions (Item) (standard SAP)
KNA1 - General Data in Customer Master (standard SAP)
Tools to used:
SAP Query - SQ01
1. Create Infoset using Direct read of table
2. Join table using the Query Extras feature.
Joining A005 with KNA1
Joining A005 with KONP
That is it.
The rest are just field selection which is pretty easy
to figure out.
Enjoy SAP Query.
