Skip to Content

Query for sales order and partner

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 19, 2017 at 09:20 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2017 at 01:13 PM

    Hi Jürgen,

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded