cancel
Showing results for 
Search instead for 
Did you mean: 

SQVI

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Lakshmipathi
Active Contributor
0 Kudos

In SQVI, only certain sequences will generate report though you have related fields in multiple tables. So try table joining in the following sequence.

KNVV + VBAK + VBRK + MVKE

thanks

G. Lakshmipathi

Former Member
0 Kudos

Thankyou so much for the reply, i am gone try this sequence also, but i just through with the query and the sequence that worked was

KNVV-VBAK-MVKE-VBRK.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello,

concatenate VBAK and KNVV by customer number . check

Thanks

RK

Former Member
0 Kudos

In addition to that take help from ABEPer to write a code

Thanks

RK

Former Member
0 Kudos

concatenate VBAK and KNVV by customer number ?

Former Member
0 Kudos

why is the need to write an Abaper Code for this simple query?