date field

22 Views

Hi,

I have a requirement where in which I have to add date field in the selection screen.I have used select-options: s_date for sy-datum to add date field in the selection-screen.But now I am able to select only present and future dates from the drop down menu in the selection screen.If I want to select past dates also then I have to use the date field from some table.Already in the program they have used

select-options: s_edatu FOR gs_z_vorders-edatu NO-DISPLAY,

s_budat FOR gs_mkpf-budat NO-DISPLAY,

s_date FOR gs_plaf-tered NO-DISPLAY,

s_date1 FOR gs_plaf-tered NO-DISPLAY,

s_date2 FOR gs_plaf-tered NO-DISPLAY,

s_date3 FOR gs_plaf-tered NO-DISPLAY,

s_date4 FOR gs_plaf-tered NO-DISPLAY,

s_date5 FOR gs_plaf-tered NO-DISPLAY,

s_date6 FOR gs_plaf-tered NO-DISPLAY,

s_date15 FOR gs_plaf-tered NO-DISPLAY.

Now if I enter date in the selection-screen I should be able to get data from both mkpf and plaf tables.How can I do that?

Regards,

Hema