Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

{toc}

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

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.
/warning

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.