topic Re: Select query not working in Application Development and Automation Discussions

Select query not working

former_member357209 — Fri, 06 Jul 2012 06:17:46 GMT

SELECT guid ptype FROM /rpm/item_d INTO TABLE int_guid
WHERE external_id IN so_itemn.

SELECT request_no item_guid group_guid row_key part_number
part_req_action part_rel_action
FROM zplpartlist_view INTO TABLE int_req_data
FOR ALL ENTRIES IN int_guid
WHERE request_no IN so_reqno
AND item_guid = int_guid-guid
AND part_number IN so_partn.

LOOP AT int_req_data INTO wa_req_data.
MOVE-CORRESPONDING wa_req_data TO wa_output.

READ TABLE int_guid INTO wa_guid WITH KEY guid = wa_req_data-item_guid.
wa_output-ptype = wa_guid-ptype.
append wa_output to int_output.

i am getting a dump form this code,,pls help

Moderator Message: Please use a proper subject line and do not post your whole query in it. Please do some research before posting and provide more details.

Message was edited by: Kesavadas Thekkillath

Re: Select query not working

former_member196490 — Fri, 06 Jul 2012 06:24:32 GMT

What is the dumo that you are getting

Re: Select query not working

Former Member — Fri, 06 Jul 2012 09:13:48 GMT

Hi Prasanth,

Can you please post the error which you are getting?

Re: Select query not working

former_member357209 — Fri, 06 Jul 2012 10:20:44 GMT

field symbols missing...........................actually got the error,,,,,,,,,,thanks

Re: Select query not working

venkateswaran_k — Fri, 06 Jul 2012 10:25:07 GMT

In your select query

SELECT guid ptype FROM /rpm/item_d INTO TABLE int_guid
WHERE external_id IN so_itemn.

Use INTO CORRESPONDING FIELDS OF TABLE instead of INTO TABLE

SELECT guid ptype FROM /rpm/item_d INTO CORRESPONDING FIELDS OF TABLE int_guid
WHERE external_id IN so_itemn.

Regards,

Venkat

Re: Select query not working

Former Member — Fri, 06 Jul 2012 10:37:58 GMT

hi prasanth,

Please check the structure of int_guid. its structure should have fields "guid and ptype" IN THE SAME ORDER IN WHICH YOUR ARE USING IN SELECT QUERY. and avoid using "into corrorsponding fields of table " statement because it reduces the performance of the program. also try to use the key work "client specified"

typically your select query would look like this.

SELECT guid ptype FROM /rpm/item_d CLIENT SPECIFIED INTO TABLE int_guid
WHERE MANDT = SY-MANDT

AND external_id IN so_itemn.

Regards

Uday