Report for Special pricing condition than Std discount???

[Former Member]

Hi Everyone,

Is there a standard report in SD where I can track all the sales orders where in a special pricing condition was given to the customer instead of the standard discount structure? if not, how do I create one?

Thanks a lot!

Swapna

[Former Member · Accepted solution]

there is no standard report like that...

you can engage abapers for z-rep

or

build simple sap query using tables VBAK,VBAP,KONV, KONP

(use VBAK-KNUMV for KONV-KNUMH)

[Former Member · Accepted solution]

Thx Warwick!

What do you mean by "build simple sap query using tables VBAK,VBAP,KONV". Could you please explain? Thx!

[Former Member · Accepted solution]

you need to use tranz SQ03,SQ02,SQ01

start from SQ02 - build your info-set (func.area)

use "table join" for VBAK...

then run SQ03

then SQ01

play in DEV

[Lakshmipathi · Accepted solution]

Dear Swapna

In continuation to the suggestion given by Warwick, you can also use Query SQVI and Table Join the above tables to generate the required report.

Thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Thanks for your answers Warwick and Lakshipathi! Appreciate it.

Swapna