SAP Knowledge Base Article - Preview

2116179 - Product Master Data Deletion and Archiving Master Data Tables in SCM APO

Symptom

  1. You are planning to delete or archive invalid/not-in-use master data e.g. products, location product combinations.
  2. You may want to use /SAPAPO/DELETE_PRODUCTS report and facing performance problems and very long runtime even with a 'time-out' dump at the end. Dump can consist of Runtime Error: DBIF_DSQL2_SQL_ERROR and Exception: CX_SY_NATIVE_SQL_ERROR
    The description of the dump can define: "Error occurred in the current database connection LCA". The cause of the dump comes from a timeout. The program exceeds the retention time of the consistent state of LiveCache.
  3. You are planning to archive /SAPAPO/MATKEY and /SAPAPO/MATLOC tables.

Read more...

Environment

  • SAP Supply Chain Management - All versions
  • SAP enhancement package for SAP Supply Chain Management - All versions
  • SAP SCM APO Master Data

Product

SAP Supply Chain Management all versions ; SAP enhancement package for SAP Supply Chain Management all versions

Keywords

Master Data Deletion, Product Deletion, Location Deletion, ProductLocation Deletion, /SAPAPO/DELETE_PRODUCTS, MATLOC Archive, MATKEY Archive , KBA , SCM-APO-MD , Master Data , SCM-BAS-MD-PR , Product , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.