You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

 

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

 

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_CKF_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_CKF_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_CKF_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 - Referenced Material non in Stock

Description

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

Calculation rule detail

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

BW_CKF_MV_PROVG_0019 (B)

Nb PO Item - Referenced Material non in Stock

 Variables:

B

BW_CKF_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



  • No labels