Ship to party

[Former Member]

Guys,

Points guaranteed for every sensible response.

Need your help. I am trying to get the ship to party and delivery date + delivery quantity in below table joint-

VBAP joined with VBEP

VBAP joined with VBAK

VBAK joined with VBPA

But, I am not getting ship to party in the final join despite giving WE and SH in the selection option.

Pl suggest a way out.

regards,

rahul.

[Former Member · Accepted solution]

Hi

I will suggest that write a program which goes for the document flow and pick up the ship to party from the sales order. once pick up this then you can add the given logic to the program.

thanks

Kuntla

[Former Member]

Assuming that you already have sales order number( number range ), try the following :

You can pass the sales order number and Partner function as WE in VBPA table..this will give you all ship to party related sales records..

Then go to VBEP table and pass the above sales order related data ( sales number as well as POSNR ).

You shall get the delivery date and corresponding quantity.

Hope it works out fine.