topic Re: Problem with date range in Application Development and Automation Discussions

Problem with date range

Former Member — Mon, 22 Jan 2007 11:36:36 GMT

Hi Friends,

I want to write a select querry with the date limit example: want to select data till particular date, How can I write it. Can any one tell me how to tell me.

Thanx in advance

Line

Re: Problem with date range

Former Member — Mon, 22 Jan 2007 11:39:52 GMT

parameters : p_date like sy-datum

select field1 field2 into table itab from ztable where date LE p_date.

Re: Problem with date range

Former Member — Mon, 22 Jan 2007 11:41:16 GMT

Hi,

If this Date is a Select-option field then

Select field1 field 2 field 3 into table Itab from XXX

where Date in S_DATE.

If the date is not a Select-option, then

Select field1 field 2 field 3 into table Itab from XXX

where Date between DATE1 and DATE2.

Regards

Sudheer

Re: Problem with date range

Former Member — Mon, 22 Jan 2007 11:41:37 GMT

Hi,

You an write using relational operators.

select *
    into lt_mkpf
   from mkpf
 where budat LE p_date.

Regards

Bhupal Reddy

Re: Problem with date range

Former Member — Mon, 22 Jan 2007 11:41:43 GMT

Thanx for your reply,

I need to collect the data in the internal table till 31.03.2006 how can I write the select querry.

Thanx in advance,

Line

Re: Problem with date range

Former Member — Mon, 22 Jan 2007 11:43:05 GMT

You can add that condition in where statement.

For the standard tables date format is like YYYYMMDD.

so you can give like WHERE endda LE 20060331 . This will fetch upto required date.

Special cases check the date format in table and give it in where condition using less then (LE) or greater than(GE).

Yuvaram

Re: Problem with date range

Former Member — Mon, 22 Jan 2007 11:44:07 GMT

U can create two parameter: one for date from and one for date to.

PARAMETERS: P_FROM TYPE SY-DATUM,
                         P_TO      TYPE SY-DATUM.

AT SELECTION-SCREEN.

    IF P_TO < P_FROM.
       MESSAGE E208(00) WITH 'Dates are wrong'.
    ENDIF.

START-OF-SELECTION.

    SELECT * FROM <TABLE> WHERE DATE => P_FROM AND
                                                           DATE <= P_TO

Max

Re: Problem with date range

Former Member — Mon, 22 Jan 2007 11:45:38 GMT

Give your input for P_DATE as 31.03.2006

Re: Problem with date range

Former Member — Mon, 22 Jan 2007 11:49:56 GMT

use WHERE extension of select statemet.

tables: vbak.

parameters : s_date like sy-datum.

data: begin of itab occurs 0,

vbeln like vbak-vbeln,

erdat like vbak-erdat,

end of itab.

select vbeln erdat from vbak into table itab up to 5 rows WHERE erdat LT

s_date.

if sy-subrc eq 0.

loop at itab.

write:/ itab-vbeln, itab-erdat.

endloop.

endif.

Re: Problem with date range

Former Member — Mon, 22 Jan 2007 12:31:37 GMT

Hi,

How Can I assign date to the particular variable.

Line