topic Re: Select Query in Application Development and Automation Discussions

Select Query

Former Member — Tue, 15 Jul 2008 07:28:34 GMT

I want to write a select query for getting data into an internal table. This query is based on a condition. The data from the zcycle_details custom table has two fields event_date and cycle_act_date. The data should be selected such that the event_date field value containing date shoudld be greater than cycle_act_date.

Re: Select Query

Former Member — Tue, 15 Jul 2008 07:32:15 GMT

do like this

if zcycle_details-event_date > zcycle_details-cycle_act_date

select x

into table XYZ

from zcycle_details

where

date1 = event_date

and

date2 = cycle_act_date

endif.

Cheers

Snehi

Edited by: snehi chouhan on Jul 15, 2008 9:32 AM

Re: Select Query

Former Member — Tue, 15 Jul 2008 07:33:05 GMT

Hi,

u can use

select event_date cycle_act_date from zcycle_details where event_date > cycle_act_date.

Hope it helps.

Anju

Re: Select Query

Former Member — Tue, 15 Jul 2008 07:33:56 GMT

If your z-table hasn't a very large number of hits u can write:

SELECT * FROM ZCYCLE_DETAILS INTO T_ZCYCLE_DETAILS.
  IF T_ZCYCLE_DETAILS-EVENT_DATE > T_ZCYCLE_DETAILS-CYCLE_ACT_DATE.
    APPEND  T_ZCYCLE_DETAILS.
  ENDIF.
ENDSELECT.

Max

Re: Select Query

Former Member — Tue, 15 Jul 2008 07:36:07 GMT

hi yogesh,

data: DATA: i_zcycle_details LIKE STANDARD TABLE OF zcycle_details .

select event_date

cycle_act_date

from zcycle_details

into i_zcycle_details .

loop at i_zcycle_details into wa_zcycle_details

if wa_zcycle_details - event_date > wa_zcycle_details - cycle_act_date.

write : wa_zcycle_details .

else.

exit.

endif.

endloop.

regards,

sandeep

Re: Select Query

Former Member — Tue, 15 Jul 2008 07:36:56 GMT

HI,

You can get all the details into table it_itab and delete the unwanted ones through the following code.

loop at it_itab where cycle_act_date GT event_date.
delete it_itab.
endloop.

delete it_itab where  cycle_act_date GT event_date.

Thanks,

Shailaja

Re: Select Query

Former Member — Tue, 15 Jul 2008 07:39:49 GMT

Hi,

write the select queary like this..

select *

from zcycle_details as a

into table i_cycle_details

where a_{event_date gt a}cycle_act_date.

Thanks,

Rajinikanth