Welcome to the Global Spend Visibility documentation page.The page contains general information about GSV as well as links to the individual queries documentations.

Global Spend Visibility

The BW Application "GSV - Global Spend Visibility" is the main reporting application for the purchasing function.

It provides reports based on purchase orders, payables, stocks and vendor master data.

The reports are accessed via "Workbooks" only and can be found in the GSV role :

Support

Technical support is provided by IT but functional support and training is provided as follows :

• Europe : central Purchasing Systens & Tools team (Contact Maria Ferreira)
• Zones : Zone Performance & Quality teams

About authorizations

In the GSV application the data authorisations are restricted by the Company code.

Usually access is given in 2 ways :

• Worldwide access
• Asia Pacific Companies only access
  
  

Perimeter

Current Perimeter*

The GSV application includes all RCS data (coming from server WP1)..

The reports taking data from FIAP (Finance Account Payables) also include data from the Acetow ERP system.

Solvay*

Currently Solvay legacy ERP data (PF1) is not included.

History*

GSV also includes historical data from the Rare Earth SAP System REGIS (REC).

GSV Axes Documentation

Some of the analyis axes used in all queries in GSV need specific explanations :

• DSF (Domain, Segment, Family) and Purchasing Organisation

Integration with DIA Purchasing reporting in Solvay-Legacy BW

Currently Solvay-Legacy ERP data can only be reported on using the "DIA" (Direction Internationale des Achats) queries in the Solvay-Legacy BW (PQ1).

To help with integration some common language has been set between DIA and GSV :

• Suppliers (Global Ultimate DUNS)
• Products (related to Raw Materials)
• Site (Gathering of Plants in DIA queries and Plant in GSV queries)
• Zone (Gathering of Companies)
• Business Unit (Gathering of Plants in DIA queries and gathering of Profit centers and cost centers in GSV queries)
• Domain and Segment from Rhodia copied in DIA cube

Query/Workbooks Documentation

The documentation for all the GSV workbooks is included inside the BW Workooks directly.

In each GSV workbook you will find 2 sheets with the documentation :

Fiche Indicateur* contains the report documentation in French.
Indicator File* contains the report documentation in English.

In addition below are the links to the query documentation existing in the wiki :

Cartography and volume of activity (CVA)

These queries are focused on the volume an turnover of the activity. They are especially dedicated to buyers in order to the follow-up their suppliers and their activity perimeter. However they may interest procurement and supply chain divisions.

• CVA-01-00-00 Invoiced purchasing turnover (FI turnover)
• Invoiced Purchasing Turnover (MM)
• Receipt, Invoiced Quantity & Price (MM)

Purchasing and procurement process (PCA)

These queries are focused on the RCS documents related to the Purchasing and Procurement Process. They may interest buyers, procurement division and Supply Chain.

• Monitoring gaps payment (To be completed)
• Supplier payment term listing (Company view)
• PCA 07 Supplier payment term listing (Contract)
• Supplier payment term listing (Purchasing view)

Supplier Management (GFR)

These queries are focused on the suppliers in RCS. They allows to follow up the various view of suppliers and the link between the spend.

• Number of suppliers (general view)
• Number of suppliers (company view)
• Number of suppliers (OA view)
• Number of suppliers (Panel / KPS)

Purchasing and procurement performance (PAA)

These queries are focused on the performance of the procurement .

• PCA 01 Material source list

Supplier Performance (PFR)

These queries are focused on the performance of the suppliers. These queries should interest procurement but also buyers (Raw Material & Packaging)

Purchasing data quality (QDD)

These queries are focused on Purchasing data : material, contracts/PIR and suppliers. These queries should interest especially ODA division.

• QDD 01 01 01 Number of created PIR and contracts

Supplier Quality Management (SQM)

These queries are focused on Purchasing data : material, contracts/PIR and suppliers. These queries should interest especially Buyer and Procurement/ODA division.

• GSV - QM Notification Vendor Analysis

SRM

These queries are focused on the quality of the material/services of suppliers. These queries should interest especially Buyer and Purchasing Quality.

• BW - Shopping Cart Prices
• BW - Shopping Cart - Prices and Workflow

GSV FAQ

What is the difference between "Spend" and "Turnover" ?

There are 2 differences :

• 1. - Turnover includes 100% of expense of all entities, whereas Spend is reduced for the companies which are not 100% consolidated*

• Turnover : ZFR9 (Butachimie), 3865 (Solvay Energy Services), 1892 (GIE Salindres) included at 100%
• Spend : ZFR9 (Butachimie), 3865 (Solvay Energy Services), 1892 (GIE Salindres) included at 50%

2 - Spend excludes all Intercompany, Turnover includes intercompany There are multiple filters to make sure all is removed :

• Spend excludes the bellow purchase organisations

• Spend excludes Suppliers with "Internal Supplier" flag = Yes
• Spend+ excludes all purchases assigned to a "FICO - Intercompany Invoices" Cost Center+(Function of the Cost Center).

What is the difference between "Invoiced" and "Ordered" ?

"Invoiced" means that the report will show spend amounts as long as we have received the invoice :

• If a PO was created and goods receipt (GR) has been done, but the invoice has not been received then the "Invoiced" amount will be zero.
• "Invoiced" will include both the invoices amounts that correspond to a Purchase Order but also all the spend for invoices without Purchase Order (Example : employees claims, travel costs...)

"Ordered" means that the report will show spend amounts for all Orders that have been created, whatever the goods receipt is done and whatever the invoice is received.

• If a PO has been created but has no GR yet, the amount will still be included in "Ordered".
• If a PO has not been invoiced yet, the amount will still be included in "Ordered.

What is the meaning of "FI" and "MM" ?

"FI" means that the data comes from the Finance SAP Module, which contains all invoices.

"MM" means that the data comes from the Material Management SAP Module, which contains the purchase orders and material documents (GR).

Since FI and MM are 2 different databases, you will not find all the analysis axes in both.