Mapping

Now we will tell Process Runner how to connect SAP fields to Excel fields. What data from Excel should be sent to SAP and to which field. We will also tell Process Runner where to place customer information that it receives from SAP once a call is made. This process is called Mapping as we are mapping and connecting data elements between Excel and SAP.

1.Select Mapper and select field titled CUSTOMERNO in "Parameter Name" column or Customer Number 1 in "Description" column.

•Set Mapping Type to Excel To SAP.

•Presuming we have list of our customer numbers in column A in Excel, Assign Map Value to A.

•Switch to advance view and go to Dynamic Skip column. In here for CUSTOMERNO field set Add leading zeroes and Length to 10 as it accepts 10-digit field. This will ensure that whatever the customer number (less than 10 digit) in column A, it will append leading zeroes so it becomes a 10-digit code.

2.Here's how our iBook should look like. We have listed all the customer numbers in column A.

3.Select Name 1 (Description column) and Set

•Mapping Type to SAP to Excel  - this will place Customer Name1 field from SAP to Excel.

•Map Value to B  - this will place Customer Name1 in column B.

Similarly map other fields also.

We are done mapping all the fields between Excel and SAP. We indicated that take customer number from Column A in Excel and execute this BAPI. Once SAP returns the result, place selected fields to various columns in Excel.        

Now we are ready to execute this BAPI.

Next:

Run