hi all
here i m putting my coding but it is taking much time n i hav to break it and use diff loops for same coding.
To select WERKS, STLAN and STLAL from the table MAST into
i_bom by joining MAST and STKO on STLNR
SELECT mmatnr mwerks mstlan mstlal
INTO CORRESPONDING FIELDS OF TABLE i_bom
FROM mast
AS m
INNER JOIN stko
AS s
ON mstlnr EQ sstlnr
FOR ALL ENTRIES IN i_bom
WHERE m~matnr = i_bom-matnr AND
m~werks IN r_range_werks_pp AND
s~lkenz = space AND
s~loekz = space.
IF sy-subrc NE 0.
ENDIF.
ENDIF.