topic Re: SELECT statement not working in Application Development and Automation Discussions

SELECT statement not working

Former Member — Mon, 20 Jul 2009 21:47:43 GMT

I have a select statement it is not working properly

SORT i_bom_temp BY idnrk.

DELETE ADJACENT DUPLICATES FROM i_bom_temp COMPARING idnrk.

SELECT bdart matnr werks bdmng INTO TABLE i_resb

FROM resb

FOR ALL ENTRIES IN i_bom_temp

WHERE

matnr = 'RSG67FG'.

matnr = i_bom_temp-idnrk.

RESB has 24 table entries for the material. The SELECT statement featched me 2 entries. If i hard code the material it gives me all 24 entries in the material

Very weired.

Any suggestions.

Thanks,

Re: SELECT statement not working

Former Member — Mon, 20 Jul 2009 22:15:25 GMT

One thing I noticed is that it is giving only uniques combination in output.

Thanks

Re: SELECT statement not working

Former Member — Mon, 20 Jul 2009 22:15:42 GMT

u need to do type casting of material..means data element for two material fields seems to be different..

use FM CONVERSION_EXIT_ALPHA_INPUT to convert into teaget data type of material then do the select statement..

cheers

Re: SELECT statement not working

Former Member — Mon, 20 Jul 2009 22:18:31 GMT

Once I had the same problem ..

what is internal table type for matnr?

regards

Re: SELECT statement not working

Former Member — Mon, 20 Jul 2009 22:29:37 GMT

If I do in loop than working fine. Doing select for each material. Very weired. PLEASE GIVE SUGGESTIONS.

LOOP AT i_bom_temp INTO k_bom_2.

SELECT bdart matnr werks bdmng INTO TABLE i_resb

FROM resb

FOR ALL ENTRIES IN i_bom_temp_2

WHERE

bdart IN r_bdart AND
matnr = '55-24612-3'.

matnr = k_bom_2-idnrk.

ENDLOOP.

Re: SELECT statement not working

former_member156446 — Mon, 20 Jul 2009 22:35:46 GMT


>   SORT i_bom_temp BY idnrk.
>   DELETE ADJACENT DUPLICATES FROM i_bom_temp COMPARING idnrk.
>  If not i_bom_temp[] is initial. "<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
>   SELECT bdart matnr werks bdmng INTO TABLE i_resb
>    FROM resb
>    FOR ALL ENTRIES IN i_bom_temp
>    WHERE
> *         matnr = 'RSG67FG'.
>          matnr = i_bom_temp-idnrk.
> endif.
or try to use before coming into the select..CONVERSION_EXIT_MATN1_RANGE_I

Re: SELECT statement not working

Former Member — Mon, 20 Jul 2009 22:41:54 GMT

Joy-

The first one did not work.

Whst will the FM CONVERSION_EXIT_MATN1_RANGE_I

do???

Thanks,

Re: SELECT statement not working

former_member156446 — Mon, 20 Jul 2009 22:59:03 GMT

It will convert the value into Matnr format.. say 1234 would be converted to Char18 of Matnr

Re: SELECT statement not working

Former Member — Mon, 20 Jul 2009 23:01:03 GMT

Soved the issue on own. Thanks a lot for all your suggestions and help.

Put all the materials in RANGE and then used RANGE in SELECT statement instead of FOR ALL ENTRIES.

Thanks,

Re: SELECT statement not working

former_member156446 — Mon, 20 Jul 2009 23:02:56 GMT

hmm Using range tables would be a pit on performance... so make sure its not performance critical Object.

Re: SELECT statement not working

Former Member — Tue, 21 Jul 2009 02:51:14 GMT

Hi,

Have you selected all the primary keys of 'RESB' table, if not put all the key fields in your select statement, else you will

get wrong result.

When ever using for all entries, do select all primary keys.

Tks,

Krishna..