To ensure that anyone who runs your script first validates the data in the data file before posting it, you can turn on validation.
For SAP Fiori® Transactional App scripts, use the local system date format.
Validation checks the data row-by-row and checks the document as a whole.
Validate
When data validation is turned on, you do not need a separate validation sheet.
Turn on data validation
- On the Map tab, click Allow Validation.
- Studio automatically adds the Validate Log field to the Mapper and maps it to the data file.
Validate the data against the script's rules
Click Check Data to check that the data meets all the script's requirements for required fields and allowed values. You do not need to be logged on to SAP.
Validate the data against SAP
Errors are returned against the entire document, and the results are written back to the Header cell.
You must be logged on to SAP. You can log on from the lower left area of the status bar on the Run tab.
Next, validate the line items against SAP.
- On the Run tab, click Validate.
- Correct any errors or make changes.
- Click Run to upload the data.
Studio gives you additional validation options. Click the arrow below the Validate button to do any of the following:
- Validate Specified Range
- Validate First 5 Transactions
- Validate Error Rows and Unprocessed Rows
- Validate Only Error Rows
-
Validate Only Unprocessed Rows
Note: When you click Validate Only Unprocessed Rows, the setting can be changed only by the script developer. Runners cannot change this setting.
Validating data in loops
In an Excel data file, validation checks all line items, and the validation log messages appear on header cell for the individual line items.
Validating linked scripts
You can run validation on linked scripts in the following configurations:
- Column-based mapping in Excel.
- Linked scripts with same types of data files
-
Validate: Checks if all prerequisites are met without running on the SAP Server. If any validation or check fails, it returns false with an error message. If everything is fine, it returns success (not the actual SAP message).
-
Run: First validates the request, then posts the actual data to SAP.
Test the script
After you run validation, you can test the script by running it on a non-production server.
On the Run tab, click Test and select the run options that you want.
The results of the test will be displayed in the yellow bar.