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

 

 

 

I remove the filter in the amount criteria