Step 3 - Map Excel columns and cells to SAP fields

Step 3 - Map Excel columns and cells to SAP fields

In our example, you should be presented with screen similar to one in front. If you right click on one of the rows in the Mapper, you should see more options. Mapper displays what you did in recording. It also allows you to easily map SAP fields to various values.  You perform mapping using 'Mapping Type' and 'Map Value' columns. Mapper has two views 'Simple' and 'Advanced'. Currently you are in 'Advanced View' which displays more columns and rows as compared to 'Simple View'. Once you select a view, it remembers your selection.

2017-08-28_151812

 

The fields will be automatically mapped as shown below:

 

Step_3_Screen_2

 

To manually change mapping just click on the drop-down in 'Mapping Type' column.

 

Step_3_Screen_3

 

 

 

Next

Step 4 Save File

See Also

Dynamic Field Mapping from Excel to SAP