The file is composed by three tabs. Only the last tab has to be updated thanks to a BW query. 

I open a SAP transaction MB51.

Fill in the:

  1. Plant
  2. Movement types copy from the IAC template
  3. Period being controlled

 

 

 

  1. Select the detail list 

 

 

 

Being in the detail list

  1. Select the correct layout
  2. Layout: /IAC 03.07

 

 

Save to excel


  1. Go to list -> export - > Spreadsheet
  2. Select from all Available formats: 10Excel (in office 2007 xslx format)
  3. Confirm the location of the extraction in your PC

 

 

 

Copy data to IAC 03.07 to the template

Open the Excel template and copy paste in the “base” tab the data that you obtained in the SAP transaction as we have seen Step4