Solution : https://service.sap.com/sap/support/notes/552922 (SAP Service marketplace login required)
Summary :
In SAP, deletion of old R/3 document data from APO database, especially from table /SAPAPO/SDFIELD which contains between 10 and 100 million records, faces performance challenges. The large volume in selection data hampers the abilities of the deletion report run by /SAPAPO/SDORDER_DEL. To alleviate these issues, the SAP note suggests a source code revision alongside the implementation of new selection parameters within the designated program. This adjustment involves populating the selection text for variables and initiating modifications that enable deletion in manageable blocks, therefore enhancing both deletion performance and data handling efficiency in the APO system.
Key words :
terms report /sapapo/sdorder_del reason, option 'delete table /sapapo/sdfield', apo database tables due, prerequisites table /sapapo/sdfield, 100 millions records drastically decreases, newly created selection parameters, large selection data volumes, table /sapapo/sdfield, program /sapapo/sdorder_del, source code correction
Related Notes :
| 553476 | Composite SAP note: Report /sapapo/sdorder_del |