EWM: How to find the status of Outbound Delivery

[Former Member]

Hi all,

I want to create WO from Outbound Delivery, 1st, I have to find out the 'NOT COMPLETED' outbound delivery. i don't know how to find the status, which tables stores the status? or how i can get the status from a FM/BAPI?

Thanks.

[Former Member · Accepted solution]

Dear,

You can use T.Code VL06O -

---

> List outbound Delivery ---> Status -Out. Del. for find incomplete delivery.

Table Name : VBUK

Regards,

Sandip

[Former Member]

Thanks

[koen_durnez]

Tables with info:

/SCDL/DB_PROCI_O: outbound delivery items

/SCDL/DB_PROCH_O: outbound delivery header

Class you could use:

/SCWM/CL_DLV_MANAGEMENT_PRD (method query).

Then get output parameters of method QUERY:

- ET_HEADERS: header data (table type: /SCWM/DLV_HEADER_OUT_PRD_TAB)

- ET_ITEMS: item data (table type: /SCWM/DLV_ITEM_OUT_PRD_STR)

And read this parameters into a linetype with reference to:

- header: /SCWM/DLV_HEADER_OUT_PRD_STR

- item: /SCWM/DLV_ITEM_OUT_PRD_STR (status for items is in this sturcture.

Cheers,

Koen.

[Former Member]

hi,

i have similar problem like this....

i have to trigger this start condiotion based on three conditions.... i am unable to get data through this query thing...

Can you help me on this??

I am getting values in the tables u mentioned.

Action will be triggered by outbound delivery order status change:

1. Picking planned status at header level changed after warehouse order creation/cancellation (corresponds to Focus2 status 0 u2013 Forecast);:

u2022 from u201CNot startedu201D to u201CCompletedu201D and back from u201CNot startedu201D to u201CPartially completedu201D and back ;

u2022 from u201CPartially completedu201D to u201CCompletedu201D and back;

2. Picking status changed at header level after execution each of warehouse order in drop location (corresponds to Focus2 status 1 - BeginPicked);

u2022 from u201CNot startedu201D to u201CPartially completedu201D and back;

3. Picking 559582status changed at header level after execution of last warehouse order in drop location (corresponds to Focus2 status 2 - Picked):

u2022 from u201CNot startedu201D to u201CCompletedu201D and back;

u2022 from u201CPartially completedu201D to u201CCompletedu201D and back;

[former_member641333]

how shall we pass the input parameter?

I only have the delivery number

[Former Member]

Well to see the not completed OBD you can either go to /scwm/prdo transaction if you know the delivery or go to /scwm/mon transaction to find out such deliveries. Programatically if you want to see if the delivery picking is complete or not, the table that you refer to is /scdl/db_status and the status that you are looking for is genearlly defined in customizing, the path for which is in SCM box, EWM->Cross process setting->delivery processing->status management->define status profile.

Hope this helps you.

Regards

Navin