Delete entries from a table

[Former Member]

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.

[Former Member]

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.

[rainer_hbenthal]

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

[Former Member]

Hi,

Check the below code....

lv_date = sy-datum - days.

DELETE itab WHERE <Comparision field> LE lv_date.

Rgds,

Bujji

[vinod_vemuru2]

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.