Handling Data Records with Errors
On the Update tab page in the data transfer process (DTP), the error handling settings allow you to control how the system responds if errors occur in the data records when data is transferred from a DTP source to a DTP target.
For a data transfer process (DTP), you can specify how you want the system to respond when data records contain errors. If you activate error handling, all records with errors are written to a request-based database table (PSA table) known as the error stack. You can use a special data transfer process, the error DTP, to update the records to the target.
Temporary storage is available after each processing step of the DTP request. This allows you to find out which processing step the error occurred in.
The following table provides an overview of where checks for data records with errors can be run:
| Where does the check take place? | Examples of Data Records with Errors |
|---|---|
|
In the transformation |
Field contains invalid characters or lowercase characters Error during conversion Error during currency translation A routine returns a return code <> 0 Characteristic value is not found for master data Error while reading master data Customer-specific formula results in error |
|
When data is updated to the master data table or text table |
Invalid characters in key or navigation attribute If no SID exists for the value of the navigation attribute If no language field is defined for texts Inplausible "from" and "to" dates Duplicate data records (duplicate keys) Overlapping and invalid time intervals |
|
When data is updated to the InfoCube |
If no SID exists for the characteristic value |
|
When checking referential integrity of an InfoObject against master data tables or DataStore objects |
If no SID exists for the characteristic value |
You create an error DTP for an active data transfer process on the Update tab page. You run it directly in the background or include it in a process chain so that you can schedule it regularly in the context of your process chain. The error DTP uses the full update mode to extract data from the error stack (in this case, the source of the DTP) and transfer it to the target defined by you in the data transfer process.