SQVI Report

[former_member609634]

Dear All,

I am trying to crate an SQVI report, where I want to join sales order line item, delivery line item data and also to get the batch from the line item of the delivery. Could you pls advise me how to do it ?

Rgds,

Indrajit

[sarthak_mohantysd]

Hello indrajit,

For the generation pf SQVI report, you can use the following field for Joining.

1. sales order line item ---> VBAP-VBELN and use POSNR field for multiple line item.

2. delivery line item ---> LIPS-VBELN and use POSNR field for multiple line item.

3. batch ---> LIPS-CHARG.

Regards,

Sarthak

[Lakshmipathi]

Try table joining VBAP with LIPS

thanks

G. Lakshmipathi