Delivery numbers based on VBUP status

[Former Member]

Hello Gurus,

I have a requirement to pick the delivery numbers of a sales order based on the picking and goods movement in VBUP table.

I need to pick the delivery numbers of a sales order which picking status as A in VBUP.

Delivery numbers with picking status b or c and goods movement status A.

Could you tell the tables using which I can get the same.

Thanks and Regards,

Pavan P.

[Former Member]

hi,

you can fetch the data from vbuk and then from vbfa to get the sales orders.

saurabh

[Former Member]

U can pass the sale order number from vbup table to VBFA table and get the Delivery number

[Former Member]

but how wud I know the delivery status????

lets say a sales order has four deliveries....

one is with Picking Status = ‘A’

two r with with Picking Status = ‘B’ or ‘C’ (VBUP.KOSTA) and Goods Movement Status = ‘A’ (VBUP.WBSTA)

one is with Goods Movement Status = ‘B’ or ‘C’ (VBUP.WBSTA)

I need to find out the four delivery numbers as per their status...

Could u tell me the tables which can help me with this...

Thanks and Regards,

Pavan P.

[Lakshmipathi]

Hi Pavan

Do with <b>SQVI</b> Table join VBFA and VBUP.

Thanks

G.Lakshmipathi