topic Re: select statement for today's date in Application Development and Automation Discussions

select statement for today's date

Former Member — Fri, 18 Jul 2008 23:50:20 GMT

Hi,

I need to write a select query which fetches all the entries of a table for today's date , how do i do it pls..

Re: select statement for today's date

former_member190578 — Sat, 19 Jul 2008 00:52:55 GMT

Select * from DDIC-Table into...... "whatever" (field, internal table, structur)

where FIELD = sy-datum.....


.... endselect. (if necessary and/or it makes sense)

I prefer "into internal table.... " for more than one record.

regards Jurgen

Edited by: Jürgen Hartwig on Jul 19, 2008 2:53 AM

Re: select statement for today's date

Former Member — Sat, 19 Jul 2008 01:24:48 GMT

example..

you can use in where condition...

select * vbak
 into table it_vbak
 where audat = sy-datum

Re: select statement for today's date

former_member125931 — Sat, 19 Jul 2008 03:09:51 GMT

HI,

Take any date field from your TABLE,then in where condition DATE(fieldname) = SY-DATUM.

example :

select MANR WERKS MMSTD from MARC

where MMSTD = sy-datum.

Re: select statement for today's date

Former Member — Sat, 19 Jul 2008 04:26:11 GMT

Hi,

Plz find the Date field of your particular table and in the select query check it with sy-datum.

select * from <table>

into <i_tab>

where <date-field> EQ sy-datum.

Regards

Sumit Agarwal

Re: select statement for today's date

Former Member — Sat, 19 Jul 2008 04:33:14 GMT

Hi,

Write

Select * from <table> into table itab where <date_field> eq SY-DATUM.

Sy-datum is current system date.

Regards,

Sujit

Re: select statement for today's date

Former Member — Sat, 19 Jul 2008 04:45:18 GMT

hi sandeep,

In your select query in the WHERE CLAUSE use sy-datum

Eg,

select * 
   from <table name>
   into <work area>
where < date field > = sy-datum.

Best of luck,

Bhumika

Re: select statement for today's date

Former Member — Sat, 19 Jul 2008 05:06:49 GMT

Types : Begin of ty_mara ,

matnr type mara-matnr,

mbrsh type mara-matnr,

Meins type mara-meins,

End of ty_mara.

Data : It_mara type standard table of ty_mara ,

wa_mara type ty_mara.

Select matnr

mbrsh

meins

from mara

into table it_mara

where ersda eq sy-datum.

It will give the output what u expected.

Re: select statement for today's date

Former Member — Sat, 19 Jul 2008 06:26:07 GMT

Hi Sandeep,

Try this code :

SELECT <field-names to retrieve>
   FROM <database table name>
    INTO  TABLE <internal table name>
WHERE <date field name> eq sy-datum.

This will fetch all the records with today's date.

Regards,

Swapna.

Re: select statement for today's date

Former Member — Sat, 19 Jul 2008 06:58:41 GMT

hi check this..

tables:pa0002 .

data: begin of itab occurs 0,

pernr like pa0002-pernr,

begda like pa0002-begda,

endda like pa0002-endda.

end of itab .

select pernr

begda

endda

from pa0002

into table itab

where begda = sy-datum.

loop at itab.

write:/ itab-pernr,itab-begda,itab-endda.

endloop.

Re: select statement for today's date

Former Member — Sat, 19 Jul 2008 07:09:40 GMT

Hi,

SELECT <field-names to retrieve>

FROM <database table name>

INTO TABLE <internal table name>

WHERE <date field name> eq sy-datum.

SELECT * FROM <database table name>

INTO TABLE <internal table name>

WHERE <date field name> eq sy-datum.

this statement will fetch all the data's from your database table with respect to your date field. use parameter or select option to get the field value...then finally use

loop at <itab>

write: / <itab-field>.

endloop.