code for fetching delivery date

[Former Member]

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

[Former Member]

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

[former_member188685]

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

[former_member184569]

select-option : s_vbeln like vbeln.

Select VDATU DAT_FZAU from vbak

where vbeln in s_vbeln.

Thanks,

Susmitha