Pick Date/Time

[Former Member]

I'm not quite sure if this is the right place for this or not. I'm writing a RFC so that for whatever order I'm given, I need to return when the deliveries associated with the order were picked. I thought it would be in the VBFA table, but I don't see a type for Picking. I would also need to take into consideration returns, unpicking, etc.

If anyone can help point me in the right direction, I would greatly appreciate it.

Thanks,

Curtis

[Former Member]

Hi Curtis,

Ckeck the VBUK & VBUP tables which consists of Picking status of a SO order & All other your requirements.

Thanks & regards,

Dileep .C

[Former Member]

Thanks for the info. That does give me the status. Is there a place that keeps track of the date/time of when the delivery gets picked? I can see it in the delivery change log. I'm currently looking through the code now. Any other information would be greatly appreciated.

Thanks,

Curtis

[Former Member]

Hi Davis,

Check this VBEP & LIKP tables...

TDDAT   Transportation Planning Date
MBDAT	Material availability date
LDDAT	Loading Date
WADAT	Goods issue date

The above are from VBEP table used to check the scheduled Items. & 
The below are from LIKP tabe which is you looking for.

WADAT	Planned goods movement date
LDDAT	Loading Date
TDDAT	Transportation Planning Date
LFDAT	Delivery Date
KODAT	Picking Date

Thanks & regards,

Dileep .C

[Former Member]

Picking Date and Time in table LIKP. In LIKP u can find the delivery document pertaining to ur sales order no. The sales order no. is in the reference field XBLNR of LIKP, through that u can find what delivery is for what sales order and the corresponding pick date and time.

LIKP-KODAT (Pick Date)

LIKP-KOUHR (Picking Time)