Skip to Content
0
Former Member
Nov 28, 2006 at 11:22 AM

deleting internal table

20 Views

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