SAP Note 894294 - /sapapo/sdorder_del: Performance and advice (as of SCM 4.0)

Component : Sales - Global Available-to-Promise

Solution : https://service.sap.com/sap/support/notes/894294 (SAP Service marketplace login required)

Summary :
This SAP Note updates users about changes and utilization strategies for the /sapapo/sdorder_del report applicable from SCM 4.0 onwards. It details revised selection options specifically for 'Delete on Database' and performance optimizations. Users are warned of potential long runtimes and ABAP runtime errors like SQL error 1555 or TIME_OUT when accessing specific tables. For optimal performance, creating secondary indices and avoiding simultaneous report runs during high system activity is recommended. Parameter selection should be thoughtful, using multiple runs to manage data effectively and isolate performance issues.

Key words :
sd order tables include additional information, longer processes sales order data, database sales orders' tab page, deleting obsolete mapping entries, respective table primary key, composite sap note 553476see, /sapapo/sdorder_del report optimally, /sapapo/obref reference table, /sapapo/posmapn tableall entries, /sapapo/cval_i/sapapo/creq_i

Related Notes :

977743Report /SAPAPO/SDORDER_MIGRATE fails with dump
931502Performance of /SAPAPO/DELETE_PRODUCTS
705901/SAPAPO/SDORDER_DEL: New selection screen as of SCM 4.0
553476Composite SAP note: Report /sapapo/sdorder_del
546459/sapapo/sdorder_del: Performance and recommendations