SQ02 - Duplicates in JOIN VBAK - VBAP

[Former Member]

Hi everybody,

I have to produce a query which outputs header data from VBAK .

As a further column I also need for each document the sum of the taxes (VBAP-MWSBP).

But if I put VBAP in the JOIN definition of SQ02 I get as many records as positions.. which is not correct.

Is thare any way I can solve it?

Thanks,Christian

[Former Member]

Hi everybody,

I have to produce a query which outputs header data from VBAK .

As a further column I also need for each document the sum of the taxes (VBAP-MWSBP).

But if I put VBAP in the JOIN definition of SQ02 I get as many records as positions.. which is not correct.

Is thare any way I can solve it?

Thanks,Christian

[RaymondGiuseppi]

Look at <a href="http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVQUE/BCSRVQUE.pdf">SAP Query (BC-SRV-QUE)</a>

1 - keep your query and create a display variant with a level of summarization

2 - remove the table join, and define VBAP as a structure, managing yourself the selection and grouping of data in a small abap routine.

Regards

[Former Member]

Thank you,

I'll try and let you know (and reward you eventually..)

[Former Member]

Solved!

[Former Member]

Hi Christian,

I know this post is going back many years....but how did you resolve this issue?

I am new to SAP queries and very limited knowledge of ABAP code

Thanks

[Former Member]

Raymond's response if excellent, IMHO, but in this case, you may want to obtain the aid of an ABAP guy to get and summarize VBAP for you...since the relationship of VBAK to VBAP is typically one to many, a join would resut  in a row of VBAK for every VBAP row....