SQVI

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