To manually map fields, drag in the direction that the data will go. If you are uploading data from Excel to SAP, drag from Excel to the Mapper.
- Click a cell in the Excel preview column where you want to enter the data and drag it to the field row in the Mapper.
- Repeat for each field that you want to map to the data file.
To map multiple fields at a time, select the rows in the Mapper, click a cell in the Excel preview, and then drag to the selected Mapper rows. Studio maps all the selected rows.
- Click Save and save the file.
If you change the default file names, do not exceed 128 characters. Files with names that are longer than 128 characters cannot be submitted to Evolve from Studio.
To prevent the data file headers from being overwritten, Studio automatically locks the headers. If you want to change the mapping, click Unlock Headers.
After you map the script, the next step is to Submit the script for review. Or see the information below for other mapping options.
For some Fiori apps like Application Job Templates the mapper shows raw data after recording and the value needs to be updated in the particular field for successful upload.
Other ways to map fields
Change the mapping direction to Upload to SAP, and then do one of the following:
- For column-based mapping: Click the value in the Mapper row, click the
drop-down arrow, click the column that you want, and then click Go.
To see more columns, check the Show unmapped columns box. If you scroll to the end of the list and want to see additional columns, click the Load More Columns button.
Note: The column selector is automatically set to map the field before the selected column, but you have two other choices. At the top of the column selector box, you can click Replace, or you can click Preserve, which is how you map multiple fields to a single column.
Change the mapping direction
- Select the field row in the Mapper.
- On the ribbon, on the Map tab, click Map Direction.
- Click the direction you want:
- Upload to SAP
- Fixed Value Upload: These are constant values, where the same
value is used in every uploaded record. For example, Company Code might
be a fixed value, whereas the Material Number or Employee ID will likely
change for each record that is uploaded. When a field is set as Fixed Value Upload, additional settings are available, depending on the field:
- Clear Header from Column removes the header from the data file, but does not remap the fields.
- Clear All Data from Column removes the header and all values in the column, but does not remap the fields.
- Delete Column removes the header and data from the data file and remaps the fields.
- No Change in Column unmaps the field without making any changes to the data file.
Add or remove fields
- Click the View tab, and click Expert View.
- Check the Disabled Fields box to view the fields that have not been enabled.
- Select the field, and then check the box in the Enable column, or click the Map tab and then click Enabled on the ribbon.
Change the mapping
- Be sure that the headers are not locked.
- Drag from the Excel preview column to the field row in the Mapper.
Studio shows the changes in red.
By default, the field is inserted before the selected column, and the other fields are shifted.
If you want to replace the previously mapped field, click the drop-down arrow, and then click Replace.
If you want to map two fields to the same column, click the drop-down arrow, and then click Preserve.
- To commit the changes, click anywhere in the Mapper or the Excel preview.
Restore the scripts
- Be sure that the headers are not locked.
- Click Restore Mapping.
- Remap the fields.
Validation
When you create a script, you can ensure that anyone who runs the solution first validates the data in the accompanying data file before posting it. If you turn on validation, you do not need a separate validation sheet. Validation is ON by default.
Validate is not available for all SAP Fiori® apps, so Allow Validation will be enabled only for those where it is available. Any validation errors appear in the validation log column. When you turn on validation, Studio adds a Validate Log column to the data file.
Turn on validation
- Click the Map tab, and then click Allow Validation.
To turn validation off, click Allow Validation again.
- Map the Validate Log field in the Mapper to the row you want in the data
file.
Validation errors will be shown in the Validate Log column.
Validate: This will provide a success or errors messages for SAP Fiori® apps that support validation. It checks the entire document including all line items and ensure that credits and debits are balanced.
Field Mapping and Data Handling
- Integer Values Display: In the "Business Partner" app, fields may show integer values instead of actual values due to network traffic. Manually adjust these mappings to reflect correct display values.
- Field Order in Mapper: The order of fields under a header in the Mapper window is based on the metadata sequence.
- Description Length: Only the first 50 characters of descriptions are uploaded.
In some applications a success message is received in validate logs even for invalid data. In this case Validation does not include logical validation of data.
The data and time displayed in Manage Scheduling Worklist application is as per the system's local date and time. The format to add data through Excel Addin or Automate Studio run tab excel would be - M/dd/yyyy hh:mm:ss
Advanced mapping features
In the Mapper, you can also create, add conditions, specify which values are allowed for a field, and add transforms to adjust data. For more information, see the following topics: