The Transaction ID Finds Corrupt Data and Saves You Time

  • by Abhijit Ghate, SAP-Certified Solution Consultant
  • Shreekant W. Shiralkar, Global Head, SAP Analytics CoE, Tata Consultancy
  • August 11, 2010
Re-initializing the delta queue is a time-consuming, resource-intensive activity, but it is necessary to maintain the data integrity and accuracy of information. Follow step-by-step instructions for an alternative process that avoids the re-initialization, yet maintains the data integrity and accuracy of information.
Key Concept
The delta queue is a data store in the source system into which data records are written in the form of Logical Units of Work (LUWs). Use transaction RSA7 to view the data in the delta queue.

When you have corrupt data, delta loads may fail in the source system during extraction. To address the complex problem of corrupt data, the most common solution is to do a complete re-initialization of the data. Completely re-initializing the data, though clean, has several disadvantages, such as it requires a significant amount of time and effort and system downtime. This downtime has financial repercussions in terms of data availability as well as the inability to post transactions during lengthy downtimes.

A quicker and less resource-intense solution to address corrupt data is to use the information the TIDs supply. (If you are unfamiliar with TIDs, refer to the sidebar “Understanding the TID.”) Because every purchase order has a corresponding TID, you can identify and segregate the corrupted purchase order data by displaying the delta queue using transaction RSA7. Identify the corrupted records by looking up the contents of the delta queue. Change the display variants to select Host ID, Process ID, Time, and Counter fields.

Abhijit Ghate

Abhijit Ghate has a bachelor’s degree in electronics engineering and more than 10 years of SAP experience in BI and ABAP, encompassing various industry verticals, spanning several implementation and support projects. He is an SAP-certified solution consultant and is ITIL V3 Foundation-certified as well.

See more by this author

Shreekant W. Shiralkar

Shreekant W. Shiralkar is a senior management professional with experience on leading and managing business functions as well as technology consulting. He has authored best selling books and published many white papers on technology. He also holds patents for innovations. Presently he is global head of the SAP Analytics Centre of Excellence at Tata Consultancy.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.