Mapper Settings - Map Excel Columns and Cells to SAP Fields

Mapper Settings - Map Excel Columns and Cells to SAP Fields

Your mapping should reflect in a Simple View as shown below.

 

Recording-VA01-Transaction-New-5

 

1.Click on 'Advance View' in Mapper toolbar. A more detailed view of Mapper will be displayed.

 

Recording-VA01-Transaction-New-advance-view

 

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

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

4.Set the 'Start Loop' from the drop-down menu of 'SAPMV45A – 4001' screen name.

 

Recording-VA01-Transaction-New-6

 

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

 

Recording-VA01-Transaction-New-7

 

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

 

Recording-VA01-Transaction-New-8

 

7.Once you are done with mapper settings, click on 'Run'.

 

 

Next

Run and Validation