topic Re: code for fetching delivery date in Application Development and Automation Discussions

code for fetching delivery date

Former Member — Fri, 07 Apr 2006 09:09:14 GMT

Dear friends,

Please help in the code for fetching the delivery date & planned date of delivery for the materials upon entering the Sales Order Number.

Thanks,

Nishu

Re: code for fetching delivery date

Former Member — Fri, 07 Apr 2006 09:14:42 GMT

hi nishu,

use table <b>VBAK</b>--sales document no -- VBELN

deliver date -- VDATU

and use <b>LIKP</b> for the actual delivery date..

reward if useful..

Message was edited by: Ashok Kumar Prithiviraj

Re: code for fetching delivery date

Former Member — Fri, 07 Apr 2006 09:23:38 GMT

Hi,

READ LIPS table with the Sales order and get the delivery number and with the delivery number go to LIKP table and get lFDAT (delivery date)and WADAT(planned Delivery date).

select vbeln
       from lips
       into l_vbeln
       where vgbel = salesorder
          and vgpos = salesorderitem.
if sy-subrc = 0.
select wadat
       lfdat
       into (d1 , d2)
       from likp
       where vbeln = l_vbeln.

endif.

Regards

vijay

Re: code for fetching delivery date

Former Member — Fri, 07 Apr 2006 09:29:47 GMT

select-option : s_vbeln like vbeln.

Select VDATU DAT_FZAU from vbak

where vbeln in s_vbeln.

Thanks,

Susmitha