Skip to Content
0

Query for sales order and partner

Jan 16, 2017 at 02:58 PM

78

avatar image

Hi all,

I want a report that shows the sales order number, position number with malerial and quantity / net value, sold-to-party and ship-to-party

I did a query ( join VBAK -> VBUK -> VBAP -> VBEP). From VBAK, paralell, I linked VBAK -> VBPA -> KNA1 -> KNVP.

Is there any way to have the sold-to-party and ship-to-party in the same row? Would be something like this:

O.Number | Position | Material | Qty | Net Value | SoldParty | ShipParty
1000010 | 10 | 2002 | 2 | 17,00 | 176353 | 9636
1000010 | 20 | 2766 | 1 | 322,00 | 176353 | 9636
1000034 | 10 | 2488 | 1 | 25,00 | 100923 | 100923


I am not an ABAP programmer, but I would be able to insert some codes in the InfoSet (if I know what).

Thanks,

Jacare

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jürgen L Jan 19, 2017 at 09:20 AM
1

Add the KNVP again as alias table, take the sold to from the KNVP and the ship-to from the Alias table.

Share
10 |10000 characters needed characters left characters exceeded
Jacare Croco Jan 19, 2017 at 01:13 PM
0

Hi Jürgen,

Thanks!

Share
10 |10000 characters needed characters left characters exceeded