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 |
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 |  | |
| Rows/Columns |  | |
| Value Display |  | |
| Planning |  | |
| Extended |  |
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
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). |
| C | 1 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 |
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:
|
| 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:
|
| 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.
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
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 |