To build a purchasing report, it is important to understand the main structuring data implemented in SPRINT.
The below information is aimed to help you.
Table of content
A1310 - Global Purchasing Segmentation
Segment Management is a strategic process for managing the purchase of goods and services. It aligns business goals and customer requirements with supply market capability and maximizes long-term value for the organization.
The purpose of the new Global Purchasing Segmentation project is to classify our purchases and related sources, to ensure the integration of data into a single reference matrix and to transfer the information to all the tools accordingly. This will be achieved by using a 3-level hierarchy consisting of Domain, Segment and Material Group. The Domain and Segment hierarchy is designed to be common and unique forsuppliers and items (goods and services). Suppliers are assigned to one segment according to preponderant spend. Items (goods and services) are assigned to one Material Group based on the category of purchase.
Once the target model was defined, the segmentation was reviewed with and agreed upon by the Domain networks, and validated at the end of 2013. All updates introduced since this date have been revalidated by purchasing, general ledger and tax.
For more information : GPS SITE
A1320 - PRS Supplier Code
PRS is one dedicated SAP environment (based on PF1) which aim is to unify some structural information as segmentation, suppliers… :
A1330 - CAPEX flag
If you want to analyze only CAPEX spend : please select CAPEX in the CAPEX flag field available in the prompt :
If you want to analyze the split between CAPEX and OPEX, please let the field blank in the prompt and launch the query with the different criteria needed.
In the query :
Drag and drop the CAPEX flag available as a dimension:
How to read the results ?
OPEX comes from both the OPEX related to projects (10 757 346€) and the OPEX without project s(3 221 3030 162€) = 3 232 060 508€
A1340 - Internal Suppliers
By default, SPRINT includes the A, B and C class suppliers and the not assigned class suppliers at vendor and/or creditor level in the prompt :
But, the Solvay Internal Suppliers are excluded by default.To include them, select the Creditor and Vendor class “G” and launch the query :
A1350 - Exchange rate
In some SPRINT queries, we can use the field “Target currency” to select the currency we want to have in our report.
SPRINT exchange rate is based on CAR3 which is the Cumulated monthly mean :
Formula :
MMC = (MM1 + MM2 + MM3 + ... + MMn)/n