| Table of Contents |
|---|
Basic Information
| Application | GSV - Global Spent Visibility |
|---|---|
| Query Name | GFR 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 |
|---|
| Table of Contents |
|---|
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)
| Characteristic | Definition |
|---|---|
| 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.