Skip to Content
Technical Articles
Author's profile photo Chuanping Wang

Steps to delete SAP APO Material Location data

Due to some special circumstances, one customer need to split current SAP APO system to two systems. These two systems also need to cleanup redundant transaction and master data to run independently.

Here is general logic to cleanup data in APO system: Remove all transaction data from LiveCache first, then clean up related ATP SCM tables contents, and then delete master data.


  1.  Keep RFC connection between ERP and APO system works normally.
  2.  Deactivate related CIF models including transaction data and master data.
  3.  Check consistency between ERP and APO transaction data with transaction /SAPAPO/CCR. Because CIF model is deactivated, CCR show these records not in integration model, and these orders could be deleted from LiveCache.
  4. CCR delete stock very slow, and report /SAPAPO/DELETE_STOCK could be used. Use it carefully, and the report don’t check material in integration model.
  5. Set deletion indicator for material location in table /SAPAPO/MATLOC with transaction MASSD, and the object is PRODUCT.
  6. Delete ATP table contents in /SAPAPO/ORDAMI_I or /SAPAPO/MM_DOC with Report /SAPAPO/ZRD_SDORDER_DEL. To avoid deleting wrong data from system, this report is enhanced with only deleting order which material is marked with deletion indicator.
  7.  Delete PDS with transaction /SAPAPO/CULL_RTO_DEL
  8. Delete transportation lane for material assignments /SAPAPO/SCC_TL1
  9. Delete FFF class with transaction /INCMD/UI
  10. After removing all dependency for material, material location record could be removed with report /SAPAPO/DELETE_PRODUCTS



Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.