topic Re: Delete entries from a table in Application Development and Automation Discussions

Delete entries from a table

Former Member — Wed, 25 Jun 2008 07:57:34 GMT

hi gurus,

i have a specification to create a report using

select-options: apoid,

material,

location to.

parameters: days.

user want to delete entries from the internal table

where system date to 5 or 10 days left.

internal table is user created like zaplo

plz provide me code or some specific information .

i will give points

fields of table are

ORDID

SCHEDID

MATNR

LOCTO

LFMNG

LFDAT

LOCFR

RQMNG

RQDAT

PRCKZ

BLKSTK

OPPDELQTY

ZZAPOLOGMOD

ZZFLAGURGENT

ZZAPOTTYPE

ZZNDAYS_L_TIME

plz help me

thanks jayant.

Re: Delete entries from a table

rainer_hbenthal — Wed, 25 Jun 2008 07:59:39 GMT

forget points, send money. Then i will do the work for you.

Re: Delete entries from a table

Former Member — Wed, 25 Jun 2008 08:00:22 GMT

Hi,

Check the below code....

lv_date = sy-datum - days.

DELETE itab WHERE <Comparision field> LE lv_date.

Rgds,

Bujji

Re: Delete entries from a table

vinod_vemuru2 — Wed, 25 Jun 2008 08:07:07 GMT

Hi Jayant,

First thing be clear about your requirement so that it will take less time to understand who ever reads ur query. If it is complex to understand ur problem itself then nobody will spend more time in finding solution for u.

Coming to ur query...

Do u want to delete data from internal table or database table?

If it is data base then use DELETE statement.

DELETE urztable WHERE conditions.

If it is internal table

DELETE ur internaltable WHERE conditions/FROM wa.

Thanks,

Vinod.