Description |
|---|
Number of Purchase orders and Purchase order items created split by PO Category:
Number of PO <> from sum of E-Catalog + Ref. Mat in stock + Ref. Mat non in stock + Goods & Service Non Ref. MatPO Volume details results can be analyzed by:
Date Reference:Purchase order : PO Creation date |
KPI Name | Definition |
# PO | Number of Purchase orders created |
# PO Items | Number of Purchase order items created |
Average Lines per PO | Average number of items per Purchase order |
# PO E-Catalog | Number of Purchase orders created with a PO Category = E-catalogue |
# PO Items E-Catalog | Number of Purchase order item created with a PO Category = E-catalogue |
# PO Ref. Material in Stock | Number of Purchase orders created with a PO Category = Ref. Material in Stock |
# PO Items Ref. Material in Stock | Number of Purchase order items created with a PO Category = Ref. Material in Stock |
# PO Ref. Material non in Stock | Number of Purchase orders created with a PO Category = Ref. Material non in Stock |
# PO Items Ref. Material non in Stock | Number of Purchase order items created with a PO Category = Ref. Material non in Stock |
# PO Service & Material non Ref | Number of Purchase orders created with a PO Category = Services & Material non Ref. |
# PO Item Service & Material non Ref | Number of Purchase order items created with a PO Category = Services & Material non Ref. |
| Source Information: BW (WP1 & PF1) | |
|---|---|
Core Query: | BW_QRY_MV_PROVG_0006 |
QV Query: | BW_QRY_MV_PROVG_0006 (PO) |
BW_QRY_MV_PROVG_0005 (PO Items) | |
BW Filters: | PO: |
Definition
- Percentage and number of purchase orders created by electronic, auto and manual
Auto PO: PO Created Transaction = Automatic Generation (a batch, job from SAP)
Electronic PO: PO Need Origin = Catalog via SRM7 (PO generated through PO request created in E-Catalog
Manual PO: PO Created Transaction = Create Purch. Order + Not Assigned
PO Need Origin <> Catalog via SRM7
-Based on PO Creation Date
Target: 20% for Electronic PO
KPI Name
Definition
Dimension available to split the data
Country
Plant
Legal Entity
Site
Domain
Zone
GBU
#Auto PO
#Auto PO Creation (ME59,ME59E)
Country
Plant
Legal Entity
Site
Domain
Zone
GBU
#Electronic PO
#Auto PO Creation (ECatalogue)
Country
Plant
Legal Entity
Site
Domain
Zone
GBU
#Electronic PO
#Auto PO creation (Manual)
Source Information: BW
BW Filters
-PO Transaction = ME21, ME21N, ME22, ME22N, ME23, ME23N, ME59, ME59N, ZBBP, # |
Purchasing document type = EC, EP, FO, NB, ZFO |
Deletion Flag = NO |
Condition: Order Value (EUR) <>0 |
Core Query:
BW_QRY_MV_PROVG_0006
QV Query:
QVSBS_BW_QRY_MV_PROVG_0005
PO Item:PO Transaction = ME21, ME21N, ME22, ME22N, ME23, ME23N, ME52, ME52N, ME53, ME53N, ME59, ME59N, ZBBP, # |
Specific Dimension name |
|---|
Refresh frequency
Monthly
Specific Dimensions
Dimension name
Comments
PO Created By | |
PO Category | E-Catalogue : PO Need Origin = 1Ref. Material in Stock : Material <> # + Account assignment code = #Ref. Material non in Stock : Material <> # + Account assignment code <> #Services & Material non Ref. : Material = # |
PO Item Critical | Y/N
|
VIP Supplier | Y/N (Vendor Attribute = VIP Vendor => Y=VIP ; N=#) |
Internal Suppliers | Y/N (Vendor Attribute = Class => Y=G ; N=the rest) |
Purchasing Group | |
Purchasing Organization | |