Map fields in Excel - Automate_Studio

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.

Note: If you already have a workbook that contains all the data, you can open that workbook and map it.

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.
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 Run: Upload the mapped data to SAP. Or see the information below for other mapping options.

Note: For records that are in draft mode in any SAP Fiori® app, the delete functionality does not work.

Upload fields that display dialogs, like file attachment dialogs (where a file path needs to be provided), do not get recorded in the mapper. For SAP Fiori® Transactional app, all the filter fields edited while recording the script are not displayed in the mapper.

For some Fiori apps like Application Job Templates the mapper shows JSON 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.
1. On the ribbon, on the Map tab, click Map Direction or Fixed Value Upload.
Click the direction you want:
- 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.
- Upload to SAP
- Download from SAP
  Note: This feature is available in SAP Fiori® Standard mode only.

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: For example, in the Business Partner app, fields may show integer values instead of actual values due to network traffic. Manually adjust these mappings to reflect the 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.

For SAP Fiori® Transactional App scripts, Validate checks if all prerequisites are met but doesn't actually connect to the SAP server. If any validation fails, it returns false with an error message; otherwise, it returns success without the actual SAP response.

The Run action first validates the request, then posts the actual data to SAP.

Additional properties in SAP Fiori® Standard mode

SAP Fiori® Standard mode offers following additional script properties:

PayloadType indicates where the data is sent in a request:
- Use QueryParameter when the value is included in the URL.
- Use JSONParameter when the value is part of the request body in JSON format.
Recording Mode - It will be Basic or Standard based on the Recording Mode you chose.
OData Batch Processing - This option is selected by default and is used to group multiple OData requests into a single network call. Uncheck this option only after you receive confirmation from the Precisely support team.
Custom Success message - Use this property to specify a custom success message, such as Done or Data Saved. By default, the value is ${{default_sap_message}}, which means the message returned by SAP will be shown.

Restriction: The long text functionality is not available in SAP Fiori^® Basic and Standard modes.

Map fields in Excel - Automate_Studio - Latest