topic Re: Delete statement in Application Development and Automation Discussions

Delete statement

Former Member — Fri, 13 Apr 2007 17:14:34 GMT

Hi folks,

the following statement is not working.

DELETE GT_DELIVERY_DATA WHERE WADAT_IST NOT IN R_WADATO.

GT_DELIVERY_DATA -

internal table

wadat_ist -

date

r_wadato -

date range.

thanks in advance

rao

Re: Delete statement

Former Member — Fri, 13 Apr 2007 17:21:04 GMT

Try,

DELETE GT_DELIVERY_DATA WHERE WADAT_IST <> R_WADATO.

Shreekant

Re: Delete statement

Former Member — Fri, 13 Apr 2007 17:26:02 GMT

how r u populating R_WADATO?

Re: Delete statement

Former Member — Fri, 13 Apr 2007 17:26:52 GMT

Try this:

SORT GT_DELIVERY_DATA BY WADAT_IST.

DELETE GT_DELIVERY_DATA WHERE WADAT_IST NOT IN R_WADATO.

or try this:

SORT GT_DELIVERY_DATA BY WADAT_IST.

DELETE GT_DELIVERY_DATA WHERE WADAT_IST GE R_WADATO-LOW AND WADAT_IST LE R_WADATO-HIGH

Thanks,

SKJ

Re: Delete statement

Former Member — Fri, 13 Apr 2007 17:31:12 GMT

try this way...

SORT GT_DELIVERY_DATA BY WADAT_IST.

DELETE GT_DELIVERY_DATA WHERE WADAT_IST NOT IN R_WADATO.

Re: Delete statement

Former Member — Fri, 13 Apr 2007 17:32:27 GMT

the best thing would be to filter in the select query itself.

check this

R_WADATO-SIGN = 'E'.

R_WADATO-OPTION = 'EQ'.

R_WADATO-LOW = 'your date'.

APPEND R_WADATO.

R_WADATO-LOW = 'your date'.

APPEND R_WADATO.

in the select query,

select (........)

where WADAT_IST IN R_WADATO.

Shreekant

Re: Delete statement

suresh_datti — Fri, 13 Apr 2007 17:36:36 GMT

You have to use delete FROM on itabs.. ie

DELETE FROM GT_DELIVERY_DATA WHERE WADAT_IST NOT IN R_WADATO.

~Suresh

Re: Delete statement

Former Member — Fri, 13 Apr 2007 17:42:44 GMT

Hi Suresh,

this program compiled fine for me,

REPORT Z_TEST.

data:

begin of fs_date,

erdat type erdat,

end of fs_date,

i_date like table of fs_date.

ranges:

r_date for vbak-erdat.

DELETE i_date where erdat not in r_date.

Re: Delete statement

suresh_datti — Fri, 13 Apr 2007 17:47:05 GMT

Yes.. its the other way round.. DELETE from dbtab & delet itab.

sorry .. hey I can blame it on Friday the 13th!

~Suresh

Re: Delete statement

Former Member — Fri, 13 Apr 2007 17:50:10 GMT

You can try to change the NOT IN logical expression to the following:

DELETE GT_DELIVERY_DATA WHERE WADAT_IST lt R_WADATO-LOW or WADAT_IST gt R_WADATO-HIGH.

See if this works.

Points are always welcome!!

Re: Delete statement

Former Member — Fri, 13 Apr 2007 17:55:12 GMT

check this program, it works absolutely fine,

REPORT Z_TEST2.

data:

begin of fs_date,

erdat type erdat,

end of fs_date,

i_date like table of fs_date.

ranges:

r_date for vbak-erdat.

r_date-sign = 'I'.

r_date-option = 'BT'.

r_date-low = '20070101'.

r_date-high = '20070413'.

APPEND r_date.

select erdat

into table i_date

from vbak.

delete adjacent duplicates from i_date comparing erdat.

DELETE i_date where erdat not in r_date.

loop at i_date into fs_Date.

write:/ fs_date-erdat.

endloop.