Page tree

ApplicationGSV - Global Spent Visibility
Query NameGFR 01 : Number of suppliers (Panel / KPS)
Query Technical Name GSV_QRY__PANT_GFR_010000D
Info Provider Name Supplier classification : Panel + KPS Temp
Info Provider Technical Name ODS_PANT
Usage type Direct execution in Analyzer
Expected users Purchasing family

 

 

Purpose of this query

Count the total number of suppliers and allows to check the suppliers master data from the Purchasing Organisation view (Key is Purchasing Organisation + Supplier).

Variables screen

Selection is by Supplier code, DSF Segment, Country (of the supplier) and Supplier Status.

The supplier status is a flag that defines if the supplier was tagged for deletion :

  • # = Active
  • X = Flagged for Deletion

Variables screen

Selection is by Supplier code, DSF Segment, Country (of the supplier) and Supplier Status.

The supplier status is a flag that defines if the supplier was tagged for deletion :

  • # = Active
  • X = Flagged for Deletion

Filters

  • Vendors: Only Standard Vendors (Z010) are included. Non standard (governements for taxes for example) are excluded.
  • Class Number : only the Classes starting by "V001" are taken into account (V001_AP, V001_EU, V001_LA, V001_NA)

Characteristics

By default the report doesn't display any characteristic. All be below are available to be added in the report (Free characteristics) 

CharacteristicDefinition
Supplier RCS Code 
Supplier status / General view 
Supplier KPS 
Supplier segment 
Internal supplier 
Country of Supplier 
Class number 

Key Figures

  • Number of suppliers (Panel/KPS) : counts the number of suppliers.

The best way to get IT support is to use the new Service One Platform.