topic Re: how to write the select in Application Development and Automation Discussions

how to write the select

Former Member — Mon, 04 Aug 2008 14:09:23 GMT

i am writting a selection and i want to select from the table HRP1001 only the rows that created this year

i wrote

select *

into itab

from hrp1001

where concatenate begda(4) eq sy-datum(4).

why its not working ?

Re: how to write the select

Former Member — Mon, 04 Aug 2008 14:11:45 GMT

try with following code.

select *

into itab

from hrp1001

where begda0(4) eq sy-datum0(4).

Re: how to write the select

Former Member — Mon, 04 Aug 2008 14:22:09 GMT

Hi,

Data:w_date type sy-datum.

Concatenate sy-datum+0(4) '%' into w_date.

Simply write:

SELECT * from HRP1001
        into table itab 
     where BEGDA like w_date.

Regards,

Sujit

Re: how to write the select

Former Member — Mon, 04 Aug 2008 14:58:28 GMT

Hi Ami,

concatenate and partial field selection are not part of Open SQL. You could use a pattern:


concatenate sy-datum(4) '%' into lw_year_pattern.
select * into itab
         from hrp1001
        where begda like lw_year_pattern.

or you could use between, probably more efficient:


lw_date_from = lw_date_to = sy-datum.
lw_date_from+4(4) = '0101'.
lw_date_to+4(4) = '1231'.
select * into itab
         from hrp1001
        where begda between lw_date_from and lw_date_to.

Good luck,

Gert.

Re: how to write the select

Former Member — Mon, 04 Aug 2008 15:01:00 GMT

Well, BEGDA is not the date created.

Rob

Re: how to write the select

Former Member — Tue, 05 Aug 2008 04:44:24 GMT

hi,

u have to take LDATE logical date .. between begda and ennda...

make use of offset to 0(4) represents year field.s

Regards..

Raju Mummidi

Re: how to write the select

Former Member — Tue, 05 Aug 2008 04:47:27 GMT

Good Gert Beukema,

Syed Tayab Shah