Skip to Content
0
Former Member
May 30, 2008 at 11:06 AM

Problem with the field-symbols

32 Views

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