cancel
Showing results for 
Search instead for 
Did you mean: 

Query to see all BP's with a special price for an item

Former Member
0 Kudos

Hi There,

I'm currently still learning the product and have been tasked with finding this out, so please bear with me and let me know if there is further information that is required.

I have a customer running SAP B1 2007 who wishes to produce a report detailing all of the BP's that have a special price for an item.

Therefore it would ideally show the item number, all BP's who have a special price and what that price is.

Is there a standard report that can be run for this? Or would a query have to be defined?

Any help would be appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

AFAIK, no standard report for this. But need not to worry, you just need


SELECT ItemCode,CardCode,Price FROM OSPP ORDER BY ItemCode,CardCode

above simple query to cater your need.

Best Regards,

Hendry Wijaya

Former Member
0 Kudos

Exactly what I was after.

Thanks for your help much appreciated

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Welcome you post on the forum.

Try:

SELECT ItemCode,CardCode,Price FROM OSPP T0

WHERE T0.ItemCode = '[%0\]'

ORDER BY ItemCode,CardCode

Thanks,

Gordon