The aim of Purchasing query is to provide users with a transversal view in qty/value of Packaging Materials purchasing in WP1 and PF1at following steps:
- Agreements & Info Records
- Orders
- Good Receipts (GR)
- Invoice Receipts (IR)
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
- PO Qty: Ordered qty in PO UoM & in Material base UoM
- PO value: Ordered value in PO Currency & in Local (Company code) currency or in any Target currency if entered in prompt
- PO Unit Price: Ordered value in Local curr. / Ordered qty in PO UoM & Ordered value in Local curr. / Ordered qty in PO UoM
Where to find corresponding data in SAP ?
Display the Purchase order with ME23N - Display Purchase Order. In the header, the PO Qty (1) & PO Unit Price (3) can be displayed.
PO UoM vs Material base UoM
- PO UoM = Unit of mesure maintained in the Purchase order
- Material base UoM = Unit of mesure maintained in the Material master data (MM03 - Display Material - Purchasing view)
Goods Receipt
GR qty: Quantity received in PO UoM & in Material base UoM
GR value: Quantity received in PO Currency & in Local (Company code) currency or any Target currency if entered in prompt
GR unit price: GR value in Local curr. / GR qty in PO UoM & GR value in Local/Target curr. / GR qty in PO UoM
GR Price diff.: difference between GR value and standard value
of stock entry, in PO & Local or Target curr., when posted in GR doc.
Standard value = GR qty * Material standard price
Where to find corresponding data in SAP ?
Display the Purchase order with ME23N - Display Purchase Order & open the tab "Purchase Order History" to see the goods receipt.
Invoice Receipt
- IR qty: Invoice receipt in PO UoM & in Material base UoM
- IR value: Invoice receipt in PO Currency & in Local (Company code) currency or any Target currency if entered in prompt
- IR unit price: Invoice value in Local curr. / IR qty in PO UoM & IR value in Local/Target curr. / IR qty in PO UoM
- IR Price diff.: difference between GR value and standard value of stock entry, in PO & Local or Target currency, when posted in IR doc.
Standard value = IR qty * Material standard price
Where to find corresponding data in SAP ?
Display the Purchase order with ME23N - Display Purchase Order & open the tab "Purchase Order History" to see the invoice receipt.
The best way to get IT support is to use the new
Service One Platform.