(warning)     (warning)     (warning)     (warning)

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.

(warning)    (warning)     (warning)     (warning)


Description

SPRINT - PtP: Prov. Non-Conform PREQ Analysis (Core Query)

Technical NameBW_QRY_MV_PROVG_0002

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

Purchase Request Creation Date

C_PURRQI__C_DA_DATE

Interval

YES

Choose interval of request 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

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.02 % Non-Conform PREQ

Description

1.02 % Non-Conform PREQ (A): percentage of Nb of Non-COnform PREQ header level (B) on Nb of PREQ header level (C)

Calculation rule detail

A = BW_CKF_MV_PROVG_0002 = B / C

BW_CKF_MV_PROVG_0002: 


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

BW_RKF_MV_PROVG_0002 (D)

Nb of Non-Conform PREQ



D

BW_CKF_MV_PROVG_0029 (C)

Nb of PREQ header level

C_PURRQI__C_NFPREQ (PR Non-Conform) = X

OINFOPROV = C_PURRQI

BW_CKF_MV_PROVG_0029 (C) = sum 1 aggr. by C_PURRQT (Pur. requsision Nb.)

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