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