topic Re: Query in loop....! in Application Development and Automation Discussions

Query in loop....!

sap_pak_lhr — Mon, 12 Jun 2023 11:01:12 GMT

HI all,

Can anybody tell me the alternative method to avoid query in loop.

Code: (Alternative Method is required).

DATA: vstlnr LIKE mast-stlnr.

LOOP AT stb1 INTO wa_stb1.
SELECT SINGLE stlnr FROM mast INTO vstlnr WHERE matnr = wa_stb1-idnrk.
wa_mast-stlnr = vstlnr.
append wa_mast to it_mast.

ENDLOOP.

Regards,

Re: Query in loop....!

Harish_Vatsa — Mon, 12 Jun 2023 17:51:23 GMT

Dear Shahzaib,
Can you please try the following:

DATA: lt_mast TYPE TABLE OF mast,
ls_mast LIKE LINE OF lt_mast.
SELECT matnr stlnr FROM mast INTO TABLE lt_mast FOR ALL ENTRIES IN stb1 WHERE matnr = stb1-idnrk.
LOOP AT stb1 INTO wa_stb1.
READ TABLE lt_mast INTO ls_mast WITH KEY matnr = wa_stb1-idnrk.
IF sy-subrc = 0.
wa_mast-stlnr = ls_mast-stlnr.
APPEND wa_mast TO it_mast.
ENDIF.
ENDLOOP.

Re: Query in loop....!

sap_pak_lhr — Tue, 13 Jun 2023 09:09:45 GMT

Thank u soo much for the guidence.

Re: Query in loop....!

Harish_Vatsa — Tue, 13 Jun 2023 10:58:11 GMT

Dear Shahzaib,

Happy to help you. Keep posting in SAP community.

Regards,

H.V.