Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

code for fetching delivery date

Former Member
0 Kudos
108

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos
63

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

3 REPLIES 3

Former Member
0 Kudos
64

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
Active Contributor
0 Kudos
63

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
Active Contributor
0 Kudos
63

select-option : s_vbeln like vbeln.

Select VDATU DAT_FZAU from vbak

where vbeln in s_vbeln.

Thanks,

Susmitha