Skip to Content
0
Former Member
May 01, 2009 at 04:40 AM

SQVI

30 Views

Hello All,

I am trying create a query with the following tables

VBAK + MVKE+ VBRK + KNVV

when i create with first 3 it is fine, i can execute the query, but when i add all 4 together it says the No Data Selected.

KNVV on it own bring results, but not with the joint table.

where could i go wrong ?

the selection field are Sales Area and Price List

these are the fields that i am looking for,

KNVV- Price list- Customer Number

VBAK- Order Number- Order Net Value- commission amount

VBRK- Bill Number- Bill Amount

MVKE- Product Hierarchy- Commission group

any suggestions are welcome