The file is composed by three four tabs.
Only the last tab has tabs "base" and "pivot" have to be updated thanks to a BW query.
Status colour Blue title Step 1
I open a SAP transaction MB51.
Fill in the:
- Plant
- Movement types copy from the IAC template
- Period being controlled
Status colour Blue title Step 2
- Select the detail list by clicking on
Status colour Blue title Step 2
I select the query
BW - Critical Material Movements (core query)
Comment: the technical name of the query is BW_QRY_ODS_IC01_0003
3
Being in the detail list
- Select the correct layout
1a. Settings
1b. Layout
1c. Choose - Select the following layout: /IAC 03.07
- Validate by clicking on
Status colour Blue title Step 3
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.
4
Save to excel
- Go to
1a. List
1b. Export
1c. Spreadsheet - Select from all Available formats: 10Excel (in office 2007 xslx format)
- Confirm the location of the extraction in your PC
- Name the file
- Validate
Status colour Blue title Step 4
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)
5
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 Step 4
Status colour Blue title Step 5
I remove the filter in the amount criteria
6
Refresh Pivot table
- Update the pivot table and comment if the amount is above 1 500 €
- Check if inventory discrepancies are only validated by the FRA
| Viewtracker | ||
|---|---|---|
|