Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DELETE_OLD_SNAP_RECORDS

Hello experts, I'm getting an error in this program!

form delete_old_snap_records.

data: reorg_date type d.

data: begin of delt occurs 20.

include structure snap_beg.

data: end of delt.

reorg_date = sy-datum - 28.

select distinct datum uzeit ahost uname modno mandt from snap_beg

up to 200 rows

into corresponding fields of table delt

where datum lt reorg_date and xhold <> 'X'

%_hints oracle 'INDEX("&TABLE&" "SNAP~DSX")'.

loop at delt.

<b>delete from snap</b>

where datum = delt-datum

and uzeit = delt-uzeit

and ahost = delt-ahost

and uname = delt-uname

and modno = delt-modno

and mandt = delt-mandt.

commit work.

endloop.

endform. "delete_old_snap_records

At the bolded area as delete from snap an error is occuring can you please help? This is a standard problem!

Thank you

Tatenda Chaibva

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question