Query Item List with Special Sell Price

Dear All,

I am needing to write a query that will generate the following information:

• Business Partner Code
• Business Partner Name
• Item Code (i.e. will be items we sell to the BP)
• Item Name
• Standard Cost
• Sell Price
• Discount - ie the % entered in Special Price Screen
• Special Sell Price - after the discount (if any is recorded against the BP)

Will appreciate the assistance.

Regards

Raj