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

I open a data source or a workbook.



I select the query 

BW - Critical Material Movements (core query)

Comment: the technical name of the query is BW_QRY_ODS_IC01_0003




I run the query

1. Enter the mandatory information that is to say at least the calendar day. 

2. Enter detail information like the company code, the plant code to obtain the information that you are interested in.



I obtain the report and I justify the highlighted amount in the appropriate column

Comment: There is an automatic filter to obtain only the amount to be justify but it can be removed (see next step)



I remove the filter in the amount criteria