at following steps:
|
It mainly includes Purchase orders data (with Creation date greater than 01.2018)
- Packaging items are filtered according to Material Valuation Class: WP1 Z110 (GL Account 31000300) and PF1 Z051 (2110110000)
PO items w/o a Material (i.e. only assigned to a Material Group) are excluded from the report |
- Both PO items for stock entry (see Acct Assignment Category #) and PO items assigned to a CO object like a Cost Center, a Maint. Order… (see <> #) are taken into accounts
- Additional Delivery costs are included in GRs/IRs valuation
It also includes FIGL data:
- Consignment GRs/IRs w/o a PO (with a Posting date greater than 01.2018)
=> Same filter based on Material Val. Class in KOS/KBS FI items (see accounts WP1 40100380 / PF1 2320000000)
- Price diff. on GRs/IRs (with a Posting date greater than 01.2018) - To get Standard values in addition with POs values
=> Same filter based on Material Val. Class in PRD/AKO FI items (see accounts WP1 98151982 / PF1 6091311100)
Data update 
- Purchase orders data: once a day in the morning (French time)
=> Sources are the same than the ones used in SPRINT - Solvay Purchasing Reporting INTelligence
- FI data: at least 3 times a day
Access the workbook
The workbook to be used is BW_WBK_SCRE_0002 – Pack. Purchasing analysis (Core Workbook)
=> Go to Analysis for Office in excel
=> Click "Open Workbook"
Run the workbook
It is mandatory to enter:
- Conso view (2) : enter 1 to apply the legal entity consolidation rate or 0 not to take the consolidation rate into consideration
- Calendar Month/Year (3) : MM.YYYY : Document fiscal period (Purchase order creation date / Goods Receipt posting date / Invoice Receipt posting date)
It is also possible to enter:
- a Company Code (4)
- a Plant (5)
- a PRS Company code (6)
- Target Curr. for conversion (7) : the exchange rate used is CAR3 (same as SPRINT - Solvay Purchasing Reporting INTelligence)
- BFC GBU (8)
Click "OK"
The report is displayed with :
- The company code
- The plant
- PO Nb & PO Item (=Purchase order)
- The list of materials
- Agreements & Info Records
- Ordered
- Goods receipt
- Invoice receipt
Agreements & Info Records
Agreement Unit price (in local & target currency)
- Info record Unit price (in local & target currency)
Not all Purchase orders are created with reference to an Agreement/InfoRecord |
Where to find corresponding data in SAP ?
Display the Purchase order with ME23N - Display Purchase Order. In the header:
1. Double click on "Outline agreement" to display Contract (= transaction ME33K - Display Contract)
2. Double click on "Info rec." to display Info Record (= transaction ME13 - Display Info Record)
Ordered
Agreement Unit price (in local & target currency)
- Info record Unit price (in local & target currency)
Not all Purchase orders are created with reference to an Agreement/InfoRecord |
