{
| Table of Contents |
|---|
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 :
...
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).
| Warning |
|---|
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.