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 
MateriaC_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

 

Add screenshot if relevant

Key figures

Key Figure 1

Description

Text/name of the variable and explanation

Calculation rule detail

Quantity x Price

Text Replacement Variable

If relevant, add the text replacement rule used for the key figure

Currency Conversion

Exchange Rate Type : Ex ZRH0

Currency : Variable, or fixed currency used

Time Reference : Current date / Based on infoobject X / Variable

Unit Conversion

Unit : Variable or fixed unit

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 
 0CALYEARPO Line Creation Year 
 0CALQUARTERPO Line Creation Year/Quarter 
 0CALMONTHPO Line Creation Year/Month 
 0CALWEEKPO Line Creation Year/Week 
 C_PO_ITM__C_ORICDEPO Need Origin 
 0STAT_DATEPO Statistics Date 
 C_PURRQTPurchase Request (PREQ) 
 C_PURRQIPREQ Item 
 0DOC_NUMPurchase Order (PO) 

Cells

If you have 2 structures and special cells calculations, explain here.

Conditions

If you have conditions, explain here.

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement
Ex : Excl if <=10 Yes/No Sales Value Greater Than 10 Ex : All Independently
      

Exceptions

If you have conditions, explain here.

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Ex : Red if <=10 Yes/NoBad 3 Lesser Than 10