| 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
- Vendors: 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).