SAP Query Report For SALES-DELIVERY-BILLING integrating view

[Former Member]

DEAR SD GURUS,

Business Requirement:-

1. Sales document number-sales document type-delivery document number-delivery document type-billing document number-billing document type

I have given bellow table for joint

Listed Field- VBAK-LIKP-VBRK 

Selection field-  VBRK

Sorted field- VBAK-LIKP-VBRK 

with Sold to party as common field but showing multiple combination for one billing number of delivery and one delivery number of sales order

where am i wrong ? Suggest me!

your answer will be appreciable to us. Thanks in advanced!

Regards,

Rupesh Kancharlawar

[Former Member · Accepted solution]

Hi,

Get the data as follows :

1. Join VBAK,VBAP and get VBELN,POSNR,AUART(DOCUMENT TYPE)

2, Join LIKP,LIPS and pass VBAK-VBELN to LIPS-VGBEL and  VBAP-POSNR to LIPS-VGPOS and     get LIKP-VBELN, LIPS-POSNR and LIKP-LFART(delivery type)

3.  Join VBRK,VBRP and pass LIKP-VBELN to VBRP-VGBEL and LIPS-POSNR to VBRP-VGPOS

and get VBRK-VBELN and VBRP-POSNR and VBRK-FKART (invoice Type.)

Regards,

Chandu

[Former Member]

Use VBFA table for document flow. Link your Sales document to Delivery and Billing in this table.

[Former Member]

Hello,

In VBFA table we can either preceding or subsequent documents can see.

how can we see sales-delivery and billing in a row or integrated combination by using SQVI

please share common field in between VBAK,LIKP AND VBRP

Regards,

Rupesh

[Former Member]

Hi Rupesh

You can join VBAK to VBFA and VBFA to LIKP and VBFA to VBRK.

Or else check the logic by Chandu

[Former Member]

Dear Bheem,

Which common field "do we have to take from these table?"

Regards,

Rupesh