SAP Knowledge Base Article - Preview

3231662 - Why to Delete the Inactive Budget Records From the System ?


When an update operation is performed on a existing Budget, the existing version becomes inactive and a new version of the budget is created as per the update. Since update on Budget happens very frequently, the number of inactive version of the Budget are higher. And for few customers each Budget has more than 25k line items. Such inactive versions do occupy the DB table rows and once the max threshold on the DB table reaches no more update operation will be allowed on Budget.
So we have to move the inactive versions of the Budget (for which there is no reference found in any documents like requisition) to an temporary table. This moved data will be deleted once the temporary table reaches the maximum threshold.



KBA , BNS-ARI-PUR , Purchasing , 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.