SAP Knowledge Base Article - Preview

2345820 - IBP: How to Purge Data from the Reporting and Staging Tables After Data Integration

Symptom

When importing data to SAP IBP, you encounter issues due to old or obsolete data in the reporting or staging tables. Errors include:  

  • Transaction rolled back by an internal error: maximum number of rows per table or partition reached 

  • SQL Error: SOPINTEG_SUMRIZ_BATCH_RPT 

Note: The data in this SAP Knowledge Base Article (KBA) are sample data or originate from SAP internal or demo systems. Any resemblance to real data is purely coincidental. 


Read more...

Environment

  • SAP Supply Chain Management (SCM)
  • SAP Sales and Operations Planning (SCM-SOP)
  • SAP Integrated Business Planning(IBP)

Product

SAP Integrated Business Planning all versions ; SAP Sales and Operations Planning (SAP SOP) all versions

Keywords

SAP IBP, STAGCLEANUP, global, parameter, reporting, staging, table, import, data, IBP, SOP, manage global configurations, integration, /IBP/R_PURGE_DI, PURGE_DI, SOPINTEG_SUMRIZ_BATCH_RPT, SQL, error, unique, constraint  , KBA , SCM-IBP-INT , Integration , SCM-SOP , Sales & Operations Planning , Problem

About this page

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

Search for additional results

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