<?xml version='1.0' encoding='UTF-8'?><xwikidoc><web>
BW - Business Warehouse</web><name>
CVA-03-03-01 Receipt & Invoiced Quantity & Price</name><language>
</language><defaultLanguage>
en</defaultLanguage><translation>
0</translation><parent>
BW - Business Warehouse.BW GSV Global Spent Visibility</parent><creator>
xwiki:XWiki.DTONDA</creator><author>
xwiki:XWiki.DTONDA</author><customClass>
</customClass><contentAuthor>
xwiki:XWiki.DTONDA</contentAuthor><creationDate>
1377076523000</creationDate><date>
1377154726000</date><contentUpdateDate>
1377154726000</contentUpdateDate><version>
9.1</version><title>
CVA-03-03-01 Receipt & Invoiced Quantity & Price</title><template>
</template><defaultTemplate>
</defaultTemplate><validationScript>
</validationScript><minorEdit>

false</minorEdit><syntaxId>
xwiki/2.1</syntaxId><hidden>
false</hidden><content>{toc}

Basic Information

Application	GSV - Global Spent Visibility
Query Name	CVA 03_03_01 : Receipt/ Invoiced Quantity & Price (MM)	Query Technical Name	BW_QRY_MPR_PUR03_CVA_030301	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 the quantities and values of receipts and the quantities / values of invoices from RCS Purchase Order (PO History) according to the posting date :

Receipt quantities and Receipt values (goods & services)
Receipt delivery costs quantities and Receipt delivery costs values (available soon)
Invoiced quantities and Invoiced values
Invoiced subsequent quantities and Invoiced subsequent values
Invoiced delivery costs quantities and delivery costs values (available soon)
Average price : receipt and invoiced
Consumption consignment & pipeline quantities and values (caution : consignment/pipeline is inventory movement, don't use the RCS Purchasing Organisation

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, Goods Receipt).
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.

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

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.

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

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).
Del ind - PO = No* : Excludes deleted Purchase Orders.
Del ind - PO Item = Empty* : Excludes deleted Purchase Order items.

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 (1 - GBU)	GBU : dimension based on the profit center of the material allowing the allocation of the spend.
Business Unit (2 - Business Unit)	Business Unit is a part of GBU dedicated to a market
Geographical	Plant	Plant of the PO
Zone (of the company)	Zone of the company
Human Organisation	Login (Created by)	RCS ID who created the Purchase Order
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)
Contract	Contract	RCS Contract number used on the Purchase order to affect a price and condition
Contract: Condition group with	RCS condition group of the contract
Contract: Incoterms part 1	Incoterm from the RCS contract
Contract: Incoterms part 2	Location of incoterm of the contract
Contract: Purchasing group	RCS code of the buyer from the contract
Purchase Info Record	PIR: Number	Purchase info record number
Country of origin (PIR)	Origin country of the material from the Purchase Info Record
PIR: Condition group with vendor	Condition group from PIR
PIR: Incoterms 1	Incoterm from the RCS PIR
PIR: Incoterms 2	Location of incoterm of the PIR
PIR: Purchasing group	RCS code of the buyer from the PIR
Purchase Request	PR: Number	Purchase request number
PR: Requisition date	Date of the Purchase requisition
Purch. Request Item nb	Purchase request item number
Purchase Requisition nb	Purchase request number
Purchase Order	Country of origin (PO)	Origin country of the material from the Purchase Order
Document Date	Date of the Purchase Order
Order acknowledgment	Supplier confirmation used on the European RM workflow
PO: Header Text Ln 1	Header text of the PO
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
Purchasing doc categ	Category of PO
RCS / Purchase Organisation	Purchasing Organisation of the PO
Requesting entity / Requester	Requester of the PO
Shopping Card Number	Shopping Card Number from Bip
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 follow. List of item category Standard = 0 Consignment = 2 Subcontracting = 3 Service = 9

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
ZVER = Packaging
ZSER = Industrial services
ZERS = Industrial supplies
ZGEN = Generic code
ZHIB = General supplies

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.
RCS System	System need origin	The system used to express the need
Supplier	Alternative Payment terms by plant (LFM2)	Alternative payment terms according to the plant. If there is a particular payment terms for a plant, this dimension will display
Internal supplier	Supplier belonging to Rhodia
Payment Terms (LFM1)	Payment terms of the PO's vendor
Supplier Rhodia Grouping	Grouping of the Vendor
Supplier RCS Code	PO Vendor
Time	Posting day	Calendar day of the posting date
Posting Year/Week	Calendar year/week of the posting date
Posting Year/Month	Calendar year/month of the posting date
Posting Year/Quarter	Calendar year/quarter of the posting date
Posting Year	Calendar year of the posting date

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 Receipted Qty (Qty Unit)* : Total receipt quantity = receipt-return+consumed consignment/pipe (in convert unit)

Receipted Qty (Qty Unit) : Total receipt quantity = receipt-return(in convert unit)
Receipted Consignment Qty (Qty Unit) : Consumed consignment/pipe (in convert 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

info
In this query the Receipted/Invoiced Value key figures exist in 3 versions :Target Currency (Currency selected in prompt), Internal Currency, Order Currency.

By default only the Target currency key figure is displayed.
/info

Total Receipted Value*: Total receipt value = receipt-return+consumed consignment/pipe + delivery costs
Receipted Value : Total receipt value = receipt-return
Receipted Consignment Value : Consumed consignment/pipe in target currency
Receipted Delivery Cost : Total receipt value of the delivery costs
Average Reception Price : Average receipt price : total receipt value without del costs /Total receipt quantity in convert unit.
Av Rec. Price (without Del Cost) : Average receipt price : total receipt value /Total receipt quantity in convert unit. This indicator is the average TCO price

Total Invoiced Value*: Invoiced value + invoiced consignment + subsequent turnover + delivery costs
Invoiced Value : Invoiced value coming from the Purchase Order
Invoiced Consignment Value : invoiced consignment value
Delivery Cost Value : 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
Average Invoice Price : Average invoiced price = total invoiced value / Total invoiced quantity in convert unit

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.</content></xwikidoc>