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 list by clicking on
Status colour Blue title Step 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 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 5
I remove the filter in the amount criteria
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 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 | ||
|---|---|---|
|