SQVI

[Former Member]

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

[Lakshmipathi · Accepted solution]

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 · Accepted solution]

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.

[Former Member]

Hello,

concatenate VBAK and KNVV by customer number . check

Thanks

RK

[Former Member]

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

Thanks

RK

[Former Member]

concatenate VBAK and KNVV by customer number ?

[Former Member]

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