When loading data to the SAP target tables, the rows can be rejected either by the writer or by the SAP target tables. The writer rejects the rows if there is a data conversion error or if you try to inset, update, or delete rows without configuring the session properties. The PowerCenter Integration Service writes the rejected rows into the reject file.

When the SAP target table rejects a row during normal mode, the SAP transport module sends the data to PowerCenter Integration Service. The PowerCenter Integration Service writes the reject data to the reject file. If SAP rejects data during bulk mode, the PowerCenter Integration Service does not writes the bad data to the reject file. It updates the session log with the number of rows in the packet rejected by SAP.

Each row indicates if the row is set for update, insert, or delete by marking U, I, or D at the beginning of each row. Every row in the reject file has either INFA or SAP indicating where the row was rejected.

The PowerCenter Integration Service creates the reject file based on the target instance.

The following sample reject file shows the SAP and INFA indicators: