Description	SPRINT - PtP: Prov. Non-Conform PREQ Analysis (Core Query)
Technical Name	BW_QRY_MV_PROVG_0002
Application	SPRINT - PtP
Info-provider	MV_PROVG
Usage type	Direct execution in analyser
Expected users

Workbook/Query General Description

This query is a split of core query BW_QRY_MV_PROVG_0001.

General parameters

Global properties

Tab	Screenshot	Comment
Display	$TECHNO - BI TEAM > SPRINT - PtP: Prov. Non-Conform PREQ Analysis (Core Query) /!\ Obsolete /!\ > image2016-6-23 17:56:30.png$
Rows/Columns	$TECHNO - BI TEAM > SPRINT - PtP: Prov. Non-Conform PREQ Analysis (Core Query) /!\ Obsolete /!\ > image2016-6-23 17:56:50.png$
Value Display	$TECHNO - BI TEAM > SPRINT - PtP: Prov. Non-Conform PREQ Analysis (Core Query) /!\ Obsolete /!\ > image2016-6-23 17:57:9.png$
Planning	$TECHNO - BI TEAM > SPRINT - PtP: Prov. Non-Conform PREQ Analysis (Core Query) /!\ Obsolete /!\ > image2016-6-23 17:57:41.png$
Extended	$TECHNO - BI TEAM > SPRINT - PtP: Prov. Non-Conform PREQ Analysis (Core Query) /!\ Obsolete /!\ > image2016-6-23 17:57:58.png$

Variables

Definitions

Variable Name	Info-object	Selection Type	Required	Description/Explanation
Purchase Request Creation Date	C_PURRQI__C_DA_DATE	Interval	YES	Choose interval of request creation date
Vendor Zone (PUR)	C_VENDID__C_PZONE	Selection Option	No
Country Attribut Purch. Zone	C_ORIGCTY__C_PZONE	Selection Option	No

Variable Sequence

$TECHNO - BI TEAM > SPRINT - PtP: Prov. Non-Conform PREQ Analysis (Core Query) /!\ Obsolete /!\ > image2016-6-23 17:58:48.png$

Filters

Object	Filter Value	Explanation
Ex : Status of the trading partner	Ex : <> 1	Ex : Exclude intercompanies

Add screenshot if relevant

Key figures

Key Figure 1

Description

Text/name of the variable and explanation

Calculation rule detail

Quantity x Price

Text Replacement Variable

If relevant, add the text replacement rule used for the key figure

Currency Conversion

Exchange Rate Type : Ex ZRH0

Currency : Variable, or fixed currency used

Time Reference : Current date / Based on infoobject X / Variable

Unit Conversion

Unit : Variable or fixed unit

Characteristics

Location	Info-object Name	Info-object Text	Explanation (if needed)
Free/Row/Column	0COUNTRY	Country	Country of the customer

Cells

If you have 2 structures and special cells calculations, explain here.

Conditions

If you have conditions, explain here.

Condition Name

Active

By default

Key Figure

(Structure)

Operator

Value

Characteristic Assignement

Ex : Excl if <=10

Yes/No

Sales Value

Greater Than

10

Ex : All Independently

Exceptions

If you have conditions, explain here.

Exception Name

Active

By default

Alert Level

Operator

Value

Other parameters

(if different from default)

Ex : Red if <=10

Yes/No

Bad 3

Lesser Than

10