topic Re: select statement ? in Application Development and Automation Discussions

select statement ?

Former Member — Wed, 20 Jun 2007 23:09:32 GMT

i want to select a field from table.

In where condition between the 2 dates and another field is equal to some value.

how to write select statament.

please help..

Re: select statement ?

Former Member — Wed, 20 Jun 2007 23:12:24 GMT


SELECT FIELD
INTO W_FIELD
FROM TABLE
WHERE DATA BETWEEN W_DATE_1 AND W_DATE_2
AND FIELD2 EQ W_FIELD2.

Greetings,

Blag.

Re: select statement ?

Former Member — Wed, 20 Jun 2007 23:13:44 GMT

select * into itab

from <table>

where date_field ge low_date

and date_field le high_date

and field1 = some_value.

Re: select statement ?

Former Member — Wed, 20 Jun 2007 23:14:18 GMT

Hi,

Just refer to standard SAP help

SELECT carrid connid fldate

FROM sflight

INTO CORRESPONDING FIELDS OF TABLE sflight_tab

WHERE fldate BETWEEN sy-datum AND date

AND field2 = <Some value>.

Reward points if useful.

Regards,

Atish

Re: select statement ?

Former Member — Wed, 20 Jun 2007 23:14:27 GMT

can u please check below program for performance..

tables : mkpf.

data : it_mkpf type table of mkpf,

wa_mkpf type mkpf,

date type d.

date = '01/01/2005'.

select MBLNR from MKPF INTO CORRESPONDING FIELDS OF TABLE it_mkpf

where BLDAT between date and sy-datum and FRBNR = 'prfdy001'.

if sy-subrc = 0.

loop at it_mkpf into WA_MKPF.

write 😕 wa_mkpf-mblnr.

ENDLOOP.

endif.

Re: select statement ?

Former Member — Wed, 20 Jun 2007 23:17:19 GMT

Hi,

The code is not correct,

change it to

tables : mkpf.

data : it_mkpf type table of mkpf,

wa_mkpf type mkpf,

date type d.

select MBLNR from MKPF INTO CORRESPONDING FIELDS OF TABLE it_mkpf

where BLDAT between date and sy-datum and FRBNR = <b>'PRFDY001'</b>.

if sy-subrc = 0.

loop at it_mkpf into WA_MKPF.

write 😕 wa_mkpf-mblnr.

ENDLOOP.

endif.

and if you just want mblnr from the table then no need to select all other fields. Just select fields required + key fields. It will improve performance.

Reward points if useful.

Regards,

Atish