The new wiki link for this data flow is here:

Technical Documentation - Procurement - SPRINT report

Please update the new doc there and no longer here.

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

Table of Contents

maxLevel	3

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	Image Modified


Rows/Columns	Image Modified


Value Display	Image Modified


Planning	Image Modified


Extended	Image Modified

Variables

Definitions

Variable Name	Info-object	Selection Type	Required	Description/Explanation
PO Creation Date	C_PO_ITM__0ERDAT	Interval	YES	Choose interval on PO creation date
Vendor Zone (PUR)	C_VENDID__C_PZONE	Selection Option	No


Country Attribut Purch. Zone	C_ORIGCTY__C_PZONE	Selection Option	No


Source System	0LOGSYS	Several Single Values	No


Company code	C_COMPCDE	Selection Option	No


Site	C_PSITE	Selection Option	No


Plant	C_PLANT	Selection Option	No


Material	C_MATNR2	Selection Option	No


Material Group	C_MAT_GRP	Selection Option	No


Material Type	C_MATNR2__C_MAT_TYP	Selection Option	No


Purchasing Group	C_PUR_GRP	Selection Option	No


Purchase Organisation	C_PUR_ORG	Selection Option	No


Vendor PRS	C_VENDID__C_VENDPRS	Selection Option	No


Vendor	C_VENDID	Several Single Values	No


Vendor Country	0COUNTRY	Selection Option	No


Vendor Class	C_VENDID__C_VENCLS	Several Single Values	No


PO Number	0DOC_NUM	Selection Option	No


PO Item Category	C_PO_ITM__C_PSTYP	Selection Option	No


Purchase Doc Type	C_BSART	Selection Option	No


Capex flag	C_WBS_EL2__C_WBSE_TP	Single value	No


Purchase Request	C_PURRQT	Selection Option	No


SAP Contract	C_AGRNBR	Selection Option	No


Purch. Inforecord (PIR)	C_PURIFR	Selection Option	No


Domain	C_DOMAIN	Selection Option	No


Segment	C_SEGT	Selection Option	No


Order Acknowl. Reqrm	C_PO_ITM__C_KZABS	Single Value	No


PO Item Created by	C_PO_ITM__OCREATEDBY	Selection Option	No


PO Origin of Needs	C_PO_ITM__C_ORICDE	Selection Option	No


PO Created By	C_PO_ITM__0USERNAME	Selection Option	No


Global Business Unit	C_SUBACT2__CPFCTR1_2	Selection Option	No

Variable Sequence

Filters

Object

Filter Value

Explanation

InfoProvider

= C_PURRQI

= CR_PUSL1

= CR_PUSL2

= CR_PUSL3


Vendor	<> [P000000000 - P999999999]


Vendor Class	<> S

Vendor Account Group

<> KRED

<> PERS

<> Z012

<> Z013

<> ZSET

<> ZZCP

<> ZZPE

Key figures

Image RemovedImage Added

1.

01 Global Lead-time PREQ to PO

05% of Electronic PO Creation-Auto

Description

1.01 Global Lead-time PREQ to PO (A)

Calculation rule detail

Ratio	is composed by KF or CKF or RKF	With Restriction
A	BW_CKF_MV_PROVG_0028 (B) Global Lead-time to transform a PREQ into PO	Variables: Image Removed
B	K_EDACDE / (BW_RKF_MV_PROVG_0027 (C) + BW_RKF_MV_PROVG_0028 (D))	C_PURRQI__C_NPFPREQ (PR non conform) = # C_PURRQT <> #
C	BW_CKF_MV_PROVG_0009 (E) Nb of PO items	C_PURRQI__C_NPFPREQ (PR non conform) = # C_PURRQT <> #
D	BW_CKF_MV_PROVG_0009 (E) Nb of PO items	C_PURRQI__C_NPFPREQ (PR non conform) = X
E	1 aggr by summation on C_PO_ITM

1.01 Lead-time: PO - Conform PREQ

Description

1.01 Lead-time: PO - Conform PREQ (A)

Calculation rule detail

05 % of Electronic PO Creation-Auto = ( Auto-PO Creation (ME29, ME59N) (A) + Auto-PO Creation (Non E-Catalogue) (B) ) %A ( Auto-PO Creation (ME59, ME59N) (A) + Auto-PO Creation (Non E-Catalogue) (B) + Auto-PO Creation (E-Catalogue) (C) + Auto-PO Creation (Manual) (D) )

1.05% of Electronic PO Creation-Electronic

Description

1.05 % of Electronic PO Creation-Electronic = Auto-PO Creation (E-Catalogue) (C) %A ( Auto-PO Creation (ME29, ME59N) (A) + Auto-PO Creation (Non E-Catalogue) (B) + Auto-PO Creation (E-Catalogue) (C) + Auto-PO Creation (Manual) (D) )

1.05% of Manual PO Creation

Description

1.05 % of Manual PO Creation = Auto-PO Creation (Manual) (D) %A (Auto-PO Creation (ME29, ME59N) (A) + Auto-PO Creation (Non E-Catalogue) (B) + Auto-PO Creation (E-Catalogue) (C) + Auto-PO Creation (Manual) (D) )

Calculations rule detail

Ratio	is composed by KF or CKF or RKF	With Restriction
A	BW_

CKF

RKF_MV_PROVG_

0003

0022 (

B

A1)

Lead

Auto-

time to transform into PO a conform PREQ

PO Creation (ME59, ME59N)	Image Added
A1

Variables:

Image Removed

B

BW_RKF_MV_PROVG_

0005

0011 (

C) +

E)

Nb of PO

Image Added

B

BW_RKF_MV_PROVG_

0027 (D)

C

K_EDACDE

Variation in days between request and purchase date

C_PURRQI__C_NPFPREQ (PR non conform) = #

0INFOPROV = CR_PUSL1

0INFOPROV = CR_PUSL2

0INFOPROV = CR_PUSL3

DBW_CKF

0024 (B1) Auto-PO Creation (Non E-Catalogue)	Variables: Image Added
B1	BW_RKF_MV_PROVG_0011 (E) Nb of PO	Image Added
C	BW_RKF_MV_PROVG_0026 (C1) Auto-PO Creation (E-Catalogue)	Image Added
C1	BW_RKF_MV_PROVG_

0009

0011 (E)

Nb of PO

items

C_PURRQI__C_NPFPREQ (PR non conform) = #

C_PURRQT <> #

E

1 aggr by summation on C_PO_ITM

1.08 Nb PO Item Created

Description

1.08 Nb PO Item Created (A)

Calculation rule detail

Image Added

D

BW_RKF_MV_PROVG_0025 (D1)

Auto-PO Creation (Manual)

Image Added

D1

BW_RKF

Ratio

is composed by KF or CKF or RKF

With Restriction

ABW_CKF

_MV_PROVG_

0009

0011 (

B

E)

Nb of PO

Items

Variables:

Image Added

Image Removed

E

B

Summation of 1 aggr. by

summation on C_PO_ITM

0DOC_NUM (BW: Document Number)

1.08

Back Office

Nb PO

Item

Created

Description

1.08 Back Office Nb PO Item Nb PO Created = Nb of PO BW-CKF_MV_PROVG_0011 (A)

Calculation rule detail

B

BW_CKF_MV_PROVG_0011 (C)

Nb of PO

Summation on C_PO_ITM__0CREATEDON (Item Creation Date).C1 aggregate

Ratio	is composed by KF or CKF or RKF	With Restriction
A

BW_RKF_MV_PROVG_0016 (B)

Back Office Nb PO

Variables:

Image Removed

Summation of 1 aggr. by 0DOC_NUM (BW: Document Number)

Image Added

1.08 Nb PO

Item -

E-Catalog

Description

1.08 Nb PO Item - E-Catalog Catalog (A)

Calculation

Calculations rule detail

Ratio	is composed by KF or CKF or RKF	With Restriction
A	BW_RKF_MV_PROVG_

0017

0029 (B)

Nb PO

Item

- E-Catalog

Variables:

Image Added

Image Removed

B

BW_

CKF

RKF_MV_PROVG_

0009

0011 (C)

Nb of PO

Items

Image Removed

Image Added
C	Summation of 1 aggr. by

summation on C_PO_ITM

0DOC_NUM (BW: Document Number)

1.08 Nb PO

Item

- Referenced Material in Stock

Description

1.08 Nb PO Item - Referenced Material Material in Stock (A)

Calculation

Calculations rule detail

Ratio	is composed by KF or CKF or RKF	With Restriction
A	BW_RKF_MV_PROVG_

0018

0031 (B)

Nb PO

Item

-

Referenced Material

Referenced Material in Stock

Variables:

Image Added

Image Removed

B

BW_

CKF

RKF_MV_PROVG_

0009

0011 (C)

Nb of PO

Items

Image Removed

Image Added
C	Summation of 1 aggr. by

summation on C_PO_ITM

0DOC_NUM (BW: Document Number)

1.08 Nb PO

Item

-

Goods & Services Non referenced Material

Referenced Material non in Stock

Description

1.08 Nb PO Item - Goods & Services Non referenced Material - Referenced Material non in Stock (A)

Calculation

Calculations rule detail

Ratio	is composed by KF or CKF or RKF	With Restriction
A	BW_RKF_MV_PROVG_

0020

0032 (B)

Nb PO

Item

Variables:

Image Removed

-

Goods & Services non referenced materials

Referenced Material non in Stock

Image Added

B

BW_

CKF

RKF_MV_PROVG_

0009

0011 (C)

Nb of PO

Items

Image Removed

Image Added
C	Summation of 1 aggr. by

summation on C_PO_ITM

1.12 Nb of PO Item without PREQ

0DOC_NUM (BW: Document Number)

1.08 Nb PO - Goods & Services Non Referenced Material

Description

1.12 08 Nb of PO Item without PREQ PO - Goods & Services Non Referenced Material (A)

Calculation

Calculations rule detail

Ratio	is composed by KF or CKF or RKF	With Restriction
A	BW_RKF_MV_PROVG_

0001

0030 (B)

Nb

of PO lines without PREQ

Variables:

PO - Goods & Services non Referenced Material

Image Added

Image Removed


B	BW_RKF_MV_PROVG_

0009

0011 (C)

Nb of PO

Items

Image Removed

Image Added
C	Summation of 1 aggr. by

summation on C_PO_ITM

1.13 PO Unit Price - PREQ Unit Price

Description

1.13 PO Unit Price - PREQ Unit Price (A)

Calculation rule detail

Ratio	is composed by KF or CKF or RKF	With Restriction
A	BW_CKF_MV_PROVG_0022 (B) PO Unit Price - PREQ Unit Price (Round)	Variables: Image Removed
B	((TRUNC(BW_CKF_MV_PROVG_0005 (C))==0) AND (ABS(ABS(FRAC(BW_CKF_MV_PROVG_0005 (C))>0.009))BW_CKF_MV_PROVG_0005 (C) + (TRUNC(BW_CKF_MV_PROVG_0005 (C))<>0)BW_CKF_MV_PROVG_0005 (C)
C	NODIM( BW_CKF_MV_PROVG_0001 (D) - BW_CKF_MV_PROVG_0004 (E) ) )
D	NODIM (K_PCDEDD) Purchase Order price (O. Curr) Key figure from multiprovider
E	NODIM(NDIV0( K_PRICEDA / K_PEI_DA )) Keys figures from multiprovider Price in pur requisi / price unit (pur req)

1.13 PO Unit Price - PIR Unit Price

Description

1.13 PO Unit Price - PIR Unit Price (A)

Calculation rule detail

Ratio	is composed by KF or CKF or RKF	With Restriction
A	BW_CKF_MV_PROVG_0023 (B) PO Unit Price - PIR Unit Price (Round)	Variables: Image Removed
B	((TRUNC(BW_CKF_MV_PROVG_0021 (C))==0) AND (ABS(ABS(FRAC(BW_CKF_MV_PROVG_0021 (C))>0.009))BW_CKF_MV_PROVG_0021 (C) + (TRUNC(BW_CKF_MV_PROVG_0021 (C))<>0)BW_CKF_MV_PROVG_0021 (C)
C	NODIM( BW_CKF_MV_PROVG_0001 (D) - BW_CKF_MV_PROVG_0020 (E) ) )
D	NODIM (K_PCDEDD) Purchase Order price (O. Curr) Key figure from multiprovider
E	NODIM(NDIV0( K_PFIADL / K_NBGR )) Keys figures from multiprovider PIR unit price (O.Curr) Schedule date / Number of goods receipt

! Warning:

Some Key figures are not calculated in data flow, there isn't mapping between DSO schedule line and cube.

Image Removed

These keys figures are calculated in badi RSR_OLAP_BADI (Transaction SE18), implementation -> overview : ZVAR_IMPLT_MV_PROVG -> interface -> compute.

The calculation is done when some queries are executed.

Image Removed

Characteristics

Image Removed

0DOC_NUM (BW: Document Number)

Characteristics

Image Added

Image AddedImage Removed

Conditions

Condition Name	Active By default	Key Figure (Structure)	Operator	Value	Characteristic Assignement
Counter <> 0	Yes	Counter	Not equal	0	All characteristics in the drilldown Independcy

Page tree

Page History

Versions Compared

Old Version 2

New Version Current

Key

Workbook/Query General Description

General parameters

Global properties

Variables

Definitions

Variable Sequence

Filters

Key figures

1.

05% of Electronic PO Creation-Auto

Description

Calculation rule detail

1.01 Lead-time: PO - Conform PREQ

Description

Calculation rule detail

1.05% of Electronic PO Creation-Electronic

Description

1.05% of Manual PO Creation

Description

Calculations rule detail

1.08 Nb PO Item Created

Description

Calculation rule detail

1.08

Nb PO

Created

Description

Calculation rule detail

1.08 Nb PO

E-Catalog

Description

Calculations rule detail

1.08 Nb PO

- Referenced Material in Stock

Description

Calculations rule detail

1.08 Nb PO

-

Referenced Material non in Stock

Description

Calculations rule detail

1.08 Nb PO - Goods & Services Non Referenced Material

Description

Calculations rule detail

1.13 PO Unit Price - PREQ Unit Price

Description

Calculation rule detail

1.13 PO Unit Price - PIR Unit Price

Description

Calculation rule detail

! Warning:

Characteristics

Image Removed

Characteristics

Conditions