Basic Information
| Application | GSV - Global Spent Visibility |
|---|---|
| Query Name | PCA 01 : Material source list |
| Query Technical Name | BW_QRY_ODS_SSUP_PCA_010000 |
| Info Provider Name | SOURCE OF SUPPLY |
| Info Provider Technical Name | ODS_SSUP |
| Usage type | Direct execution in Analyzer |
| Expected users | Purchasing family |
Purpose of this query
This indicator allows to see for each material :
- The existing PIR (Purchasing Info Record) with the validity period start and end date of the condition in progress or the last one.
- The contract lines with the validity period start and end dates of the contract header.
Variables screen
Several variables are available in the report to allow filtering. None are mandatory.
- Deletion Flag source of supply: Flag that defines if the PIR and Contract have been flagged for deletion. By default equal to '#' (not flagged for deletion).
By default, the PIR and contracts with a deletion flag are out of the perimeter but you can change that in the variables prompt.
Filters
- Material Deletion Flag <> Yes : Report excludes all deleted materials
- Material Type = Finished/Raw/Semi-Finished materials + Industrial supplies + General Supplies + Packaging (ZMAT + ZERS + ZHIB + ZVER)
Characteristics
By default the report is displayed by Purchase Organisation, Country, Site and Source of Supply Deletion Flag
| Characteristic | Definition |
|---|---|
| Material Plant | |
| Plant | |
| Type Source of supply | |
| Contract | |
| Purchasing Info Record | |
| PIR: Material group | |
| Flow origin | |
| Infotype | |
| DCF / Material group | |
| Validity Per. Start | |
| Validity period end | |
| Supplier RCS Code | |
| Material Status | |
| Material type | |
| Item of Princ. Agmt. | |
| RCS / Purchase Organisation | |
| Country (of plant) | |
| Site (of plant) | |
| Deletion Flag Source of supply |
Key Figures
Definition
- Number of Records : Number of materials
- Number records with source supply : Number of materials with a source of supply in the Contract/Purchase Info Record.
- Number records without source supply : Number of materials with no source of supply.
Conditions
Note that there is a condition active by default in this query. Condition "Number records with source supply = 1". With this condition active only the materials with a source of supply are displayed. This condition is only applied if displaying by Material Plant / Plant / Type source of supply.
The best way to get IT support is to use the new
Service One Platform.