Description

SPRINT - PtP: Prov. PO Item Analysis (Core Query)

Technical NameBW_QRY_MV_PROVG_0005

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

TabScreenshotComment
Display 
Rows/Columns 
Value Display 
Planning 
Extended 

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

PO Item Creation Date

C_PO_ITM__0CREATEDON

Interval

YES

Choose interval on PO Item creation date

Vendor Zone (PUR)C_VENDID__C_PZONESelection OptionNo 
Country Attribut Purch. Zone C_ORIGCTY__C_PZONESelection OptionNo 
Source System0LOGSYSSeveral Single ValuesNo 
Company codeC_COMPCDESelection OptionNo 
SiteC_PSITESelection OptionNo 
PlantC_PLANTSelection OptionNo 
MaterialC_MATNR2Selection OptionNo

 

Material GroupC_MAT_GRPSelection OptionNo 
Material TypeC_MATNR2__C_MAT_TYPSelection OptionNo 
Purchasing GroupC_PUR_GRPSelection OptionNo 
Purchase OrganisationC_PUR_ORGSelection OptionNo 
Vendor PRSC_VENDID__C_VENDPRSSelection OptionNo 
VendorC_VENDIDSeveral Single ValuesNo 
Vendor Country0COUNTRYSelection OptionNo 
Vendor ClassC_VENDID__C_VENCLSSeveral Single ValuesNo 
PO Number0DOC_NUMSelection OptionNo 
PO Item CategoryC_PO_ITM__C_PSTYPSelection OptionNo 
Purchase Doc TypeC_BSARTSelection OptionNo 
Capex flagC_WBS_EL2__C_WBSE_TPSingle valueNo 
Purchase RequestC_PURRQTSelection OptionNo 
SAP ContractC_AGRNBRSelection OptionNo 
Purch. Inforecord (PIR)C_PURIFRSelection OptionNo 
DomainC_DOMAINSelection OptionNo 
SegmentC_SEGTSelection OptionNo 
Order Acknowl. ReqrmC_PO_ITM__C_KZABSSingle ValueNo 
PO Item Created byC_PO_ITM__OCREATEDBYSelection OptionNo 
PO Origin of NeedsC_PO_ITM__C_ORICDESelection OptionNo 
PO Created ByC_PO_ITM__0USERNAMESelection OptionNo 
Global Business UnitC_SUBACT2__CPFCTR1_2Selection OptionNo 

Variable Sequence

Filters

ObjectFilter ValueExplanation
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

 

Add screenshot if relevant

Key figures

1.01 Global Lead-time PREQ to PO

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:

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

 

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

BW_CKF_MV_PROVG_0003 (B)

Lead-time to transform into PO a conform PREQ

 Variables:

B

BW_RKF_MV_PROVG_0005 (C) + 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

D

BW_CKF_MV_PROVG_0009 (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

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

BW_CKF_MV_PROVG_0009 (B)

Nb of PO Items

 Variables:

B

1 aggr by summation on C_PO_ITM

 

 

1.08 Back Office Nb PO Item

Description

1.08 Back Office Nb PO Item (A)

Calculation rule detail

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

BW_RKF_MV_PROVG_0016 (B)

Back Office Nb PO

 Variables:

B

BW_CKF_MV_PROVG_0011 (C)

Nb of PO

Summation on C_PO_ITM__0CREATEDON (Item Creation Date).
C1 aggregate by 0DOC_NUM (BW Document Number) 

1.08 Nb PO Item - E-Catalog

Description

1.08 Nb PO Item - E-Catalog (A)

Calculation rule detail

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

BW_RKF_MV_PROVG_0017 (B)

Nb PO Item - E-Catalog

 Variables:

B

BW_CKF_MV_PROVG_0009 (C)

Nb of PO Items

C

1 aggr by summation on C_PO_ITM

 

1.08 Nb PO Item - Referenced Material in Stock

Description

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

Calculation rule detail

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

BW_RKF_MV_PROVG_0018 (B)

Nb PO Item - Referenced Material in Stock

 Variables:

B

BW_CKF_MV_PROVG_0009 (C)

Nb of PO Items

C

1 aggr by summation on C_PO_ITM

 

1.08 Nb PO Item - Goods & Services Non referenced Material

Description

1.08 Nb PO Item - Goods & Services Non referenced Material (A)

Calculation rule detail

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

BW_RKF_MV_PROVG_0020 (B)

Nb PO Item - Goods & Services non referenced materials

 Variables:

B

BW_CKF_MV_PROVG_0009 (C)

Nb of PO Items

C

1 aggr by summation on C_PO_ITM

 

1.12 Nb of PO Item without PREQ

Description

1.12 Nb of PO Item without PREQ (A)

Calculation rule detail

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

BW_RKF_MV_PROVG_0001 (B)

Nb of PO lines without PREQ

 Variables:

B

BW_RKF_MV_PROVG_0009 (C)

Nb of PO Items

C

1 aggr by summation on C_PO_ITM


! Warning:

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

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.

 

Characteristics

LocationInfo-object NameInfo-object TextExplanation (if needed)
FreeC_COMPCDECompany code 
FreeC_ORIGCTYCountry of the Company 
FreeC_SUBACT2__CPFCTR1_2Global Business Unit 
FreeC_DATE_EMGood Receipt Date 
FreeC_MATNR2Material 
FreeC_MAT_GRPMaterial Group 
FreeC_MATNR2__C_MAT_TYPMaterial Type 
FreeC_PO_ITM__C_LABNROrder acknowledgment 
FreeC_PO_ITM__C_KZABSOrder Acknowl. Reqrm 
FreeC_PLANTPlant 
FreeC_PO_ITM__0USERNAMEPO Created By 
FreeC_PO_ITMPO Item 
Free0CALDAYPO Line Creation Date 
Free0HALFYEAR1PO Line Creation Halfyear 
Free0CALMONTH2PO Line Creation Month 
Free0CALQUART1PO Line Creation Quarter 
Free0CALYEARPO Line Creation Year 
Free0CALQUARTERPO Line Creation Year/Quarter 
Free0CALMONTHPO Line Creation Year/Month 
Free0CALWEEKPO Line Creation Year/Week 
FreeC_PO_ITM__C_ORICDEPO Need Origin 
Free0STAT_DATEPO Statistics Date 
FreeC_PURRQTPurchase Request (PREQ) 
FreeC_PURRQIPREQ Item 
Free0DOC_NUMPurchase Order (PO) 
FreeC_PUR_GRPPurchasing Group 
FreeC_PUR_ORGPurchase Organisation 
FreeC_PLANT__C_PSITESite 
FreeC_VENDIDVendor 
FreeC_VENDID__C_SEGTSegment 
FreeC_COMPCDE__C_PZONEZone (PUR) 
FreeC_PURRQI__C_NFPREQPREQ Non-Conform 
FreeC_PO_ITM__C_PSTYPPO Item Category 
FreeC_PO_ITM__C_LOEKZIPO Item Deletion Flag 
FreeC_PO_ITM__C_LOEKZPO Deletion Flag 
FreeC_PO_ITM__0ERDATPO Created Date 
FreeC_AGRNBRSAP Contract number 
FreeC_AGRITMSAP Contract Item 
Free0SCL_DELDATPO Schedule Line Delivery Date 
Free0ORDER_CURRPO Order Currency 
Free0PO_UNITOrder unit 
FreeC_BSARTPurchasing Doc. Type 
Free0INFO_TYPEInfotype 
FreeC_TYPCDEPO Line Type 
Free0LOC_CURRCYPO Local Currency 
Free0LOGSYSSource System 
FreeC_PURRQI__C_DA_DATEPREQ Creation Date 
FreeC_PURRQI__C_VALDATPREQ Release Date 
FreeC_PO_ITM__0CREATEDBYPO Item Created By 
FreeC_PO_ITM__0CREATEDONPO Item Creation Date 
FreeC_PO_ITM__C_DTPOACKDate of PO Acknowledgment 
FreeC_PO_ITM__0PO_STATUSPO Status 
FreeC_PO_ITM__C_TCODEPO Created Transaction 
FreeC_WBS_EL2__C_WBSE_TPCapex Flag 
FreeC_PO_ITM__C_KNTTP2Account Assignment Category 
FreeC_PURIFRPurchase Info Record (PIR) 
FreeC_PURRQI__C_PUR_GRPPREQ Purch. Group 
FreeC_DOMAINDomain 
FreeC_PLANT__0COUNTRYCountry of the Plant 
FreeC_PO_ITM__C_PRIOREQPO: Requirement Priority 
FreeC_PO_ITM__C_PRIOURGPO: Requirement Urgency 
FreeVendor ClassC_VENDID__C_VENCLS 
FreeVendor Group (PUR) CodeC_VENDID__C_GRPPUR 

Conditions

 

Condition Name

Active

By default

Key Figure

(Structure)

Operator
Value
Characteristic Assignement
Counter <> 0YesCounterNot equal0All characteristics in the drilldown Independcy