Basic Information

Application	GSV - Global Spent Visibility
Query Name	CVA 02_00_00 - Invoiced purchasing turnover (MM)	Query Technical Name	BW_QRY_MPR_PUR03_CVA_020000	Info Provider Name	Purchasing Data and Historical PO
Info Provider Technical Name	MPR_PUR03
Usage type	Direct execution in Analyzer
Expected users	Purchasing family

Purpose of this query

The Report allows to get an overview of RCS Purchase Order (PO History) according to the posting date of the PO:

Invoiced quantities and Invoiced values
Invoiced subsequent quantities and Invoiced subsequent values
Invoiced delivery costs quantities and delivery costs values
Average price : invoiced
Consumption consignment & pipeline quantities and values

Consignment/pipeline is from the Material Movements so Purchasing Organisation doesn't exist. You can use the GBU.

Due to the displayed dimensions by default, the advised period of time to run the query is the month.

Variables screen

Several variables are available in the report to allow filtering. Some are mandatory :

Time (mandatory)* : Based on the posting dates of the accounting documents (Invoices).
Target Currency (mandatory)* : Some key figures will be converted to the selected currency. Note that both local and selected currency will be displayed.

All other variables are not mandatory and correspond to characteristics described below.

Although the "Company" variable is not mandatory, if you have only access to Asia Pacific entities, it is mandatory to select the list of companies. Otherwise no data will be displayed.

Convert Unit* : By default BW displays in base unit, but by selecting a unit in this variable you can ask BW to convert to a single unit. More on quantity conversion here.

Filters

* endors*: Only Standard Vendors (Z010) are included. Non standard (governements for taxes for example) are excluded.
Item Category* : Excludes consignment/Pipeline items (Item Category <> 2 Consignment)

Characteristics

By default the report doesn't display any characteristic. All be below are available to be added in the report (Free characteristics)

Main Axis of Analysis	Characteristic	Definition
Accounting data	Local currency	Currency of the company
Profit Center	Profit center of the PO
Purchase Order Currency	PO currency
Support of costs	Support of costs of the PO
WBS Element	WBS element of the PO
Business Organisation	Global Business Unit	GBU according the Purchase Order. Caution : if there is not purchase order (consignment) this filter should not be used
Business Unit	Business Unit is a part of GBU dedicated to a market
GBU from Material	GBU dimension based on the profit center of the material allowing the allocation of the spend
Geographical	Plant	Plant of the PO
Zone (of the company)	Zone of the company
Human Organisation	Login (Created by)	RCS ID who created the Invoice document
PO: Created by	RCS ID who created the Purchasing document
Legal organisation	Company code	Company code of the PO
Material	Order unit	Order Unit
Product/Services	Material	RCS material code of the PO
Purchasing Organisation	DSF / Domain	Purchasing Domain from the DSF Segmenteur (Purchasing structure)
DSF / Material group	Material group from the Purchase Order corresponding to the Family of the DSF Segmenteur
DSF / Segment	Purchasing Segment from the DSF Segmenteur (Purchasing structure)
RCS Purchasing Document	Purchase Requisition number	Purchase request number
Purchase Requisition Item	Purchase request item number
PO: Line Item	Item of the PO
PO: Number	Number of the PO
PO: Purchasing group	RCS Purchasing group code of the PO's requester
RCS / Purchase Organisation	Purchasing Organisation of the PO
Requesting entity / Requester	Requester of the PO
Shopping Card Number	Shopping Card Number from Bip
RCS System	System need origin	The system used to express the need
Supplier	Internal supplier	Supplier belonging to Rhodia
Supplier Rhodia Grouping	Grouping of the Vendor
Supplier RCS Code	PO Vendor
Certification date	North America data concerning the positive discrimination law
Minority indicator	North America data concerning the positive discrimination law
Time	Calendar day	Calendar day of the posting date of the invoice
Calendar Year/Week	Calendar year/week of the posting date of the invoice
Calendar Year/Month	Calendar year/month of the posting date of the invoice
Calendar Year/Quarter	Calendar year/quarter of the posting date of the invoice
Calendar Year	Calendar year of the posting date of the invoice
PO Data	Item Category	Key defining how the procurement of a material or service item is controlled. The item category determines the field selection and whether any additional data screens are shown. In addition, it determines whether a goods receipt or invoice receipt is to f
Material group	Key that you use to group together several materials or services according to he purchasing hierarchy
Material type	Key that assigns the material to a group of materials such as raw materials, operating supplies or trading goods. The material type defines certain attributes of the material and has important control functions. The main type : ZMAT = Raw material
It.cate purch doc.	Specifies whether accounting for an item is to be effected via an auxiliary account (such as a cost center). The account assignment category determines which account assignment data (such as cost center, account number and so on) is necessary for the item

Key Figures

Definition

The quantity key figure is displayed in Base Unit if no conversion unit is selected when running the query. Otherwise BW tries to convert all to the selected unit.

Total Invoiced Qty (Qty Unit)* : Total invoiced quantity (without delivery costs) = invoiced quantity + invoiced consignment quantity (in convert unit)
Invoiced quantity (Qty Unit) : Invoiced quantity (in convert unit)
Invoiced Consignment Qty (Qty Unit) : Invoiced consignment quantity in convert unit

Value key figures exist in 3 versions :Target Currency (Currency selected in prompt), Internal Currency, Order Currency.

Total Invoiced Turnover*: invoiced value + invoiced consignment + subsequent turnover + delivery costs
Invoiced Turnover : Invoiced value coming from the Purchase Order
Invoiced Consignment Value : invoiced consignment value
Delivery Cost Turnover : Invoiced delivery cost related to the delivery costs
Subsequent Del. Cost : Subsequent delivery costs = delivery costs which are not excepted
Subsequent Turnover : Subsequent invoices = invoices which are not excepted

Currency Conversion

Some of the key figures are in "Curr" meaning "Local Currency" (Legal Entity/Company currency) but others are on "Target Currency". These will show the amounts converted from local currency to the currency selected in the query prompt.

The conversion in this queries applies the CAR3 exchange rate available at the Posting date of the invoice (FI Document Posting Date).

Conditions

Note that there is a condition active by default in this query. Condition "not all key figures equal to 0" basically filters out all rows where all key figures are empty. This is a technical condition that should not be de-activated.