Description

SPRINT - PtP: PO Messages Follow-up (Core Query)

Technical NameBW_QRY_MV_PUMS1_0001

Application

SPRINT - PtP

Info-provider

MV_PUMS1

Usage type

Direct execution in analyser

Expected users


Workbook/Query General Description

 

General parameters

Global properties

TabScreenshotComment
Display
 
Rows/Columns
 
Value Display
 
Planning
 
Extended

 

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

PO Creation Date

0DOC_DATE

Interval

YES

Choose interval on PO creation date

Vendor Zone (PUR)C_VENDID__C_PZONEAuthorization / Selection OptionNo 
Source System0LOGSYSCustomer exit / Several single valuesNo 
Message date0CALDAYIntervalYes 
Global Business UnitC_SUBACT2__CPFCTR1_2Authorization / Selection OptionNo 
Zone (PUR)C_COMPCDE__C_PZONEAuthorization / Selection OptionNo 
Company codeC_COMPCDEAuthorization / Selection OptionNo 
Company CountryC_COMPCDE__0COUNTRYSelection OptionNo 
SiteC_PLANT__C_PSITESelection OptionNo 
PlantC_PLANTAuthorization / Selection OptionNo 
Purchasing GroupC_PUR_GRPSelection OptionNo 
Purchase OrganisationC_PUR_ORGSelection OptionNo 
Purchase Doc CategoryC_BSTYPSelection OptionNo 
Purchase Doc TypeC_BSARTSelection OptionNo 
PO NumberC_EBELNSelection OptionNo 
PO Created ByC_PO_ITM__0USERNAMESelection OptionNo 

Variable Sequence

Filters

ObjectFilter ValueExplanation
InfoProvider

= C_PUMS1

= C_PUMS2

= C_PUMS3

 
0Calday= # 
Vendor Class<> S 
Vendor Account Group

<> KRED

<> PERS

<> Z012

<> Z013

<> ZSET

<> ZZCP

<> ZZPE

 
Vendor<> [P000000000 - PZZZZZZZZZ] 

 

Key figures

Message Status

Description

% of PO with Electronic Msg

Description

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

BW_RKF_MV_PUMS1_0001 (C)

Nb of Electronic 1rst Msg

 
C

BW_CKF_MV_PUMS1_0001 (B)

Nb of PO

B1 aggragtion by summation with reference Purch Order number - C_EBELN 

% of PO with Fax Msg

Description

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

BW_CKF_MV_PUMS1_0001 (B)

Nb of PO

B1 aggragtion by summation with reference Purch Order number - C_EBELN 

% of PO with Fax Msg

Description

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

BW_CKF_MV_PUMS1_0001 (B) - (BW_RKF_MV_PUMS1_0001 (C) + BW_RKF_MV_PUMS1_0002 (D))

Nb of PO - ( Nb of electronic 1rst Msg + Nb of Fax 1rst Msg )

 
B1 aggragtion by summation with reference Purch Order number - C_EBELN 
C

BW_CKF_MV_PUMS1_0001 (B)

Nb of PO

C

BW_CKF_MV_PUMS1_0001 (B)

Nb of PO

 

Characteristics

Location
Info Object Name
Info Object Text
Explanation (If needed)
FreeC_NAUTOAutomatique Message 
FreeC_COMPCDECompany 
FreeC_AENDEChange message flag 
FreeC_LOEKZDeletion indicator in PO 
FreeC_VSZTPDispatch time 
FreeC_FPOMSGFirst PO Message 
FreeC_SUBACT2__CPFCTR1_2Global Business Unit 
FreeC_MANUEManual Message 
Free0CALDAYMessage Date 
Free0BPARTNERMessage Partner 
Free0PART_FUNCTMessage Partner Function 
FreeC_VSTATMessage Status 
FreeC_NACHAMessage Transmission Medium 
FreeC_MTYPEMessage Type 
Free0CALMONTHMessage Year/Month 
FreeC_PLANTPlant 
Free0DOC_DATEPO Creation Date 
FreeC_EBELNPO Number 
FreeC_UHRVRProcessing Time 
FreeC_BSTYPPurchasing Doc Categ 
FreeC_BSARTPurchasing Type 
FreeC_COMPCDE__C_PZONEZone (PUR) 
FreeC_PLANT__C_PSITESite 
FreeC_VENDIDVendor 
FreeC_VENDID__C_VENCLSVendor Class 
FreeC_VENDID__C_DOMAINVendor Domain 
FreeC_VENDID__C_VENDPRSVendor PRS 
FreeC_VENDID__C_SEGTVendor Segment 
FreeC_PUR_ORGPurchase Organisation 
FreeC_ORICDEPO Origin of Needs 
Free0USERNAMEPO Created User 
FreeC_PUR_GRPPurchasing Group 
Free0LOGSYSSource System 
FreeC_COMPCDE__0COUNTRYCountry of the Company 
FreeC_VENDID__0COUNTRYVendor Coutnry 

 

Conditions

Condition Name

Active

By default

Key Figure

(Structure)

Operator
Value
Characteristic Assignement