Query in loop....!

[sap_pak_lhr]

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,

[Harish_Vatsa]

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.

[sap_pak_lhr]

Thank u soo much for the guidence.

[Harish_Vatsa]

Dear Shahzaib,

Happy to help you. Keep posting in SAP community.

--

Regards,

H.V.