Some SAP Fiori® apps require specific identifiers to be passed in API calls to push data to SAP. Users may need assistance in locating the required identifier for the corresponding field on the SAP Fiori® app to update records in SAP.
Using the Mapper
To address this need, a Lookup Columns property has been added
to the mapper for the relevant field.
- Select the recorded identifier field.
- Click Lookup Columns in the Properties pane.
Using the Run Feature
Users can select the identifier field in their Excel data file and click Lookup Columns. This will generate a list of data from which users can select the corresponding row and click OK to copy the data into the Excel file.
Note: The Lookup feature in Studio will only function if the app includes an option for
performing lookups. It may not work for static fields that lack a lookup option in
the SAP Fiori® app's user interface.