Query with tables VEPVG, VBAK, VBAP AND KONV

[Former Member]

hi all,

I have a requirement, that is Open Sale Orders which is having Special Discount. I am trying to write a Query, But KONV table is not coming into the joins. my execution plans is bellow

VEPVG --> VBAK vbak-knumv = konv-knumv and konv-kschl = Special Discount

VBAP

Please explain me, how to design the query with conditions.

Thanks & Regards,

Srinivas

[former_member487858]

Hi,

Have you referred this help document.

http://help.sap.com/printdocu/core/Print46c/EN/data/pdf/BCSRVQUE/BCSRVQUE.pdf

Regards - Shree

[Former Member]

Thank you