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 is available in the
mapper for the relevant field. To use it:
- Select the recorded identifier field.
- Click Lookup Columns in the Properties pane.
Doing this will open a window that shows all the dependent fields. By selecting the relevant dependent fields, you can identify the required identifier.
When you use the SAP Fiori® Standard mode, you can use the
Filter option to filter the data that you want to retrieve. To do
that, perform the following:
- Select the entity from the Entity field.
- Choose the Relational Operator.
- Select the Excel column where you want to map the data.Note: In case, the Excel column is none, you need to provide Static Value.
- Click Finish to complete.
Using the Run Feature
Next, follow these steps:
- Select the identifier field in the Excel data file.
- Click Lookup Columns
- This will generate a list of data from which you can select the corresponding row.
- Click OK to copy the data into the Excel file.
Note: The Lookup feature in Studio will work only if the app has an option that allows
Lookups. It might not work for static fields that don't have a lookup option in the SAP
Fiori® app's user interface.