SELECT a~matnr
a~werks
a~lgort
a~charg
a~clabs
a~cinsm
a~cspem
b~meins
FROM mchb AS a INNER JOIN mara AS b
ON amatnr = bmatnr
INTO TABLE i_inventory_check
FOR ALL ENTRIES IN i_mch1
WHERE b~matnr EQ i_mch1-matnr AND
a~lgort IN (c_one , c_two, c_three).
*Looping the i_inventory_check to get the storage location 0003 values.
LOOP AT i_inventory_check INTO wa_inventory_check.
IF wa_inventory_check-lgort EQ c_three AND
wa_inventory_check-werks EQ c_us .
MOVE: wa_inventory_check-matnr TO wa_inve_three-matnr,
wa_inventory_check-werks TO wa_inve_three-werks,
wa_inventory_check-lgort TO wa_inve_three-lgort,
wa_inventory_check-charg TO wa_inve_three-charg,
wa_inventory_check-clabs TO wa_inve_three-clabs,
wa_inventory_check-cinsm TO wa_inve_three-cinsm,
wa_inventory_check-cspem TO wa_inve_three-cspem,
wa_inventory_check-meins TO wa_inve_three-meins.
APPEND wa_inve_three TO i_inve_three.
ENDIF.
ENDLOOP.
I NEED TO DELTE THE VALUES IN INTERNAL TABLE COMPARING I_INVE_THREE