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

Compare with Current View Page History

« Previous Version 7 Next »

 

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 



  • No labels