Missing Follow-On Documents

Due to some SAP program errors, the invoice verification documents (LIV document in Material Management application) are created without follow-up document in accounting component (no accounting document generated in SAP). Sometime, they are also created without any entry in the purchase order history. Continue reading

Data Inconsistency after Upgrade to SAP HANA SPS09 Revision 90

If the data in your SAP HANA database shows inconsistent data after your database was upgraded from a previous SAP HANA revision to revision 90. Databases installed with SAP HANA revision 90 are not affected as long as no data backups created with an older revision are restored with SAP HANA revision 90.

SAP HANA Support Package Stack (SPS) 09 uses a new implementation for the delta part of column tables. The first load of a column table with SPS09 performs a migration of old the delta part into the new delta part. This migration can write inconsistent data to the new delta if the old delta contains statement rollbacks. The inconsistent data can be missing records, missing updates as well as duplicate records.

The HANA data consistency check routine CHECK_TABLE_CONSISTENCY can find duplicate records. However, other inconsistencies caused by the issues described in SAP note 2105764 cannot be identified with SAP HANA revision 90. Continue reading

How to Export Batch Input Session Log

What is Batch Input Session?

A batch input session is a group of transactions that are provided with user data via a program. These transactions are saved as a lot in a batch input session. This batch input session can be run at a later time in the online system. Changes are made to the database when the session is run. With batch input session, large amounts of data can be entered into the SAP System in a short period of time.

Sometime, we need to investigate the messages/errors that may occurred during the session run. If you need to download or export the log from your batch input session (SM35 transaction) for verifying the errors occurred instead of scrolling through the output log but it is not possible in log detail screen.

However, you can export your batch input logs to the local files for verifying, sorting easier in two ways. The following steps demonstrate how to export session log to your PC.

Export Batch Input Logs to External File (local)


Continue reading

Held or Parked Document Deletion

If you found the case that there are some documents in the system that cannot be processed by standard SAP transaction anymore due to those documents for which the purchase order has been changed.

These types of documents can be deleted with program Z_MRM_DELETE_PP which is attached in Note 501905. You have to implemented the program in your SAP system, and then proceed as follows to delete the parked or on hold documents.

Continue reading