topic Re: Select query in Application Development and Automation Discussions

Select query

Former Member — Thu, 09 Aug 2007 15:05:13 GMT

Hi,

Can this select statement be changed with removing endselect.

SELECT partner INTO t_db_pos_match-partner

FROM ekun

WHERE dr_license = t_bp_obj-act-ekun-dr_license

AND partner NE t_bp_obj-act-ekun-partner.

SORT t_db_pos_match BY partner.

READ TABLE t_db_pos_match WITH KEY

partner = t_db_pos_match-partner BINARY SEARCH.

IF sy-subrc NE 0.

t_db_pos_match-match_type = '2'.

APPEND t_db_pos_match.

ELSE.

CLEAR: t_db_pos_match.

ENDIF.

ENDSELECT.

Please reply me.

Thanks,

Binay.

Re: Select query

Former Member — Thu, 09 Aug 2007 15:09:58 GMT

You should be able to read all the entries you are currently getting from the SELECT directly into an internal table and then loop through it and do the further processing then.

Rob

Re: Select query

Former Member — Fri, 10 Aug 2007 03:57:09 GMT

Hi,

try using the following code.

**********************************************************************

data t_temp like t_db_pos_match.

SELECT partner INTO corresponding fields of table t_temp

FROM ekun

WHERE dr_license = t_bp_obj-act-ekun-dr_license

AND partner NE t_bp_obj-act-ekun-partner.

loop at t_temp.

SORT t_db_pos_match BY partner.

READ TABLE t_db_pos_match WITH KEY

partner = t_temp-partner BINARY SEARCH.

IF sy-subrc NE 0.

t_temp-match_type = '2'.

APPEND t_temp to t_db_pos_match.

ELSE.

CLEAR: t_temp.

ENDIF.

endloop.

Re: Select query

seshatalpasai_madala — Fri, 10 Aug 2007 04:25:17 GMT

Hi,


SELECT partner INTO CORRESPONDING FIELDS OF TABLE t_db_pos_match-partner
FROM ekun
WHERE dr_license = t_bp_obj-act-ekun-dr_license
AND partner NE t_bp_obj-act-ekun-partner ORDER BY partner. "sort done by ORDER BY addition

*SORT t_db_pos_match BY partner. " TSort can also be done out side SELECT for that remove ORDER BY in above query
loop at t_db_pos_match where match_type <> '2'. " Delete where match_type not equal to 2.
delete t_db_pos_match.
endloop.

Regards,

Sesh

Re: Select query

Former Member — Fri, 10 Aug 2007 04:32:26 GMT

Hi Binay,

first get all the data into internal table,

if t_bp_obj [] is not initial.

select partner from ekun into table it_part for all entries in t_bp_obj where dr_license = t_bp_obj-act-ekun-dr_license

AND partner NE t_bp_obj-act-ekun-partner.

now u have data in it_part.

sort it_part by partner.

loop at it_part.

READ TABLE t_db_pos_match WITH KEY

partner = it_part-partner BINARY SEARCH.

IF sy-subrc NE 0.

it_part-match_type = '2'.

APPEND it_part.

ELSE.

CLEAR: it_part.

ENDIF.

please reward points to all helpful answers

kiran.M

Re: Select query

Former Member — Fri, 10 Aug 2007 09:25:08 GMT

yes

SELECT partner

INTO <u><b>table</b></u> t_db_pos_match-partner

FROM ekun

WHERE dr_license = t_bp_obj-act-ekun-dr_license

AND partner NE t_bp_obj-act-ekun-partner.

SORT t_db_pos_match BY partner.

READ TABLE t_db_pos_match WITH KEY

partner = t_db_pos_match-partner BINARY SEARCH.

IF sy-subrc NE 0.

t_db_pos_match-match_type = '2'.

APPEND t_db_pos_match.

ELSE.

CLEAR: t_db_pos_match.

ENDIF.

reward if usefull