Mapper Settings - Map Excel Columns and Cells to SAP Fields

Your mapping should reflect as below in Simple View.

✓Click on Advance view in Mapper toolbar. A more detailed view of Mapper will be displayed.

✓Now we will be using Process Runner Start – End Loop Mapping Mechanism to assign advanced mapping types.

✓Find the occurrence of Create Item in SAPMV45A – 4001 (4.0 Screen Container for Overview Screens)

✓ Set the Start Loop.

      Automatically a new row with mapping type Start Loop & End Loop will be added in the Mapper. On the Block Type for Start Loop and set Block Type to “On Value - Ignore Blank” & "Block Value to A“.

Set Block Type to Header+Line Item Value for Material Number & Cumulative Order Quantity in Sales Units.

Verify the Mapper settings as shown below in the screen. Click on Run.

Next:

Run and Validation