Hi all,
i am unable to delete the data in the internal table.
i am sending the code.
*----
BEGIN OF t_oprtn,
budat LIKE afru-budat,
vornr LIKE afru-vornr,
grund LIKE afru-grund,
gmein LIKE afru-gmein,
gmnga LIKE afru-gmnga,
expfl(1),
END OF t_oprtn,
FIELD-SYMBOLS: <fs_collect> TYPE STANDARD TABLE.
FIELD-SYMBOLS: <fs_wa_collect> TYPE ANY.
CREATE DATA i_collect TYPE STANDARD TABLE OF t_oprtn
WITH DEFAULT KEY.
CREATE DATA wa_collect TYPE t_oprtn.
ASSIGN i_collect->* TO <fs_collect>.
ASSIGN wa_collect->* TO <fs_wa_collect>.
SELECT abudat avornr agrund aarbid astokz darbpl a~aufnr
bplnbez cmaktx agmnga agmein
INTO TABLE i_final
FROM afru AS a INNER JOIN afko AS b
ON aaufnr = baufnr
INNER JOIN makt AS c
ON bplnbez = cmatnr
INNER JOIN crhd AS d
ON aarbid = dobjid
WHERE a~budat IN s_budat
LOOP AT i_final INTO wa_final.
MOVE-CORRESPONDING wa_final TO <fs_wa_collect>.
COLLECT <fs_wa_collect> INTO <fs_collect>.
ENDLOOP
how to write a delete statement for - <fs_collect>.
*----
Plz tell me the delete statement where GMNGA is '0'. " GMNGA IS A CONFIRM QUANTITY.
*----
Plz reply its urgent.
Edited by: hari prasad on May 30, 2008 1:15 PM
Edited by: hari prasad on May 30, 2008 1:20 PM