(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. Acknowlegment Analysis (Core Query)

Technical NameBW_QRY_MV_PROVG_0003

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 Schedule Line Delivery Date

0SCL_DELDAT

Interval

YES

Choose interval of PO Schedule Line Delivery 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.06 % of PO Ack. Collected

Description

1.06% of PO Ack. Collected: percentage of Ack. Date < SLD <> 0 (A) on Nb PO Ack. Flag (B)

Calculation rule detail

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

BW_CKF_MV_PROVG_0013 (C)

Acknowlegment Date less than Sched. Line Delivery date <> 0

 Variables:


B

BW_RKF_MV_PROVG_0007 (D)

Nb of PO lines without PREQ

Variables:

C

K_ADLSLD aggr by C_PO_ITM

Acknowlegment Date less than Sched. Line Delivery date

<> 0
D

BW_CKF_MV_PROVG_0009 (E)

Nb of PO Items

OINFOPROV = CR_PUSL1

OINFOPROV = CR_PUSL2

OINFOPROV = CR_PUSL3

C_PO_ITM__C_KZABS (Order Acknowl. Reqm) = X

ESum 1 aggr by C_PO_ITM

! Warning:

Key figure K_ADLSLD (with others) is 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