topic Pick Date/Time in Application Development and Automation Discussions

Pick Date/Time

Former Member — Thu, 07 May 2009 19:42:23 GMT

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

Re: Pick Date/Time

Former Member — Fri, 08 May 2009 01:11:08 GMT

Hi Curtis,

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

Thanks & regards,

Dileep .C

Re: Pick Date/Time

Former Member — Mon, 11 May 2009 19:42:05 GMT

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

Re: Pick Date/Time

Former Member — Tue, 12 May 2009 01:30:37 GMT

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

Re: Pick Date/Time

Former Member — Tue, 12 May 2009 05:11:16 GMT

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)