Report ZRD_SDORDER_DEL and the table /SAPAPO/SCHEDLIN
I am in the process of reducing the amount of data in our SCM database using the report /SAPAPO/ZRD_SDORDER_DEL.
The report should be deleting data in the /SAPAPO/SCHEDLIN table but the summary report shows that 0 records have been deleted.
I have run an SQL trace on the report and it shows that it trying to delete records in the SCHEDLIN table using the GUID column. Getting the GUID value from the trace and using this value in the ITEM_GUID my queries returns 2 records.
I am a Basis consultant so I don't know the business process/linkage for the tables utilised by this report. The SCHEDLIN table has approx 110 million rows & I am concerned that these records will be orphaned by the /SAPAPO/ZRD_SDORDER_DEL report and never deleted.
Should this report be using the ITEM_GUID to delete these records?
Thanks in advance.