{toc}

Basic Information

Application	GSV - Global Spent Visibility
Query Name	GFR 01 : Number of suppliers (OA view)	Query Technical Name	GSV_QRY_0VEN_PUROR_GFR_010000C	Info Provider Name	Vendor Number (Purchasing View)
Info Provider Technical Name	0VEN_PURORG
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, Purchasing Organisation and Purchasing group.

Filters

* endors*: Only Standard Vendors (Z010) are included. Non standard (governements for taxes for example) are excluded.

Characteristics

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

Characteristic	Definition
RCS / Purchase Organisation
Supplier RCS Code
supplier RCS code(purchasing view)
Supplier status / Purchasing organization view
Internal supplier
Purchasing group (Purchasing view)
Login (Created by)
Created On
Supplier status / General view
Vend: Cenl post bloc
Vend: Cent imp bloc

Key Figures

Number of suppliers (general view)*: counts the number of suppliers.
Number of suppliers (OA View)* : counts the number in the Purchasing Organisation view (if a supplier is in 2 purchasing organisations, it will be counted twice).