The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work.

Remove the sections that are not relevant.

Description

SPRINT - PtP: ReadSoft Cycle Time (Core Query)

Technical NameBW_QRY_MV_RDSF01_0003

Application

SPRINT - PtP

Info-provider

MV_RDSF01

Usage type

Direct execution in analyser

Expected users


Workbook/Query General Description

Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.

General parameters

Global properties

TabScreenshotComment
Display 
Rows/ColumnsThere is a suppreession of rows with zero values because query uses a counter of KPI "counter" to take into account only last version of cockpits documents, then there is no need to values = 0
Value Display 
Planning 
Extended 

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

Source System

0LOGSYS

Several Single Value

No

Choose source system.

Last step dateC_DAT_ACTIntervalYesChoose interval of last step date (applied on all query).
Creation Date0CALDAYIntervalNoChoose date interval.
Posting Month/Year0CALMONTHSelection OptionNoChoose posting month date.
Global Business UnitC_SUBACT2__CPFCTR1_2Selection OptionNoChoose GBU.
Zone (PUR)C_COMPCDE__C_PZONESelection OptionNoChoose zone.
Company codeC_COMPCDESelection OptionNoChoose company code.
SiteC_PLANT__C_PSITESelection OptionNoChoose site.
PlantC_PLANTSelection OptionNoChoose spant.
Supplier DomainC_CREDID__C_DOMAINSingle ValueNoChoose supplier domain.
Supplier SegmentC_SEGTSelection OptionNoChoose segment.
Supplier ClassC_VENCLSSeveral Single ValuesNoChoose supplier class.

Variable Sequence

Filters

ObjectFilter ValueExplanation

Workflow ID

C_WC_ID

<> # 

InfoProvider

0INFOPROV

= CR_RDSF1

= CR_RDSF2

 

Supplier Class

C_CREDID__C_VENCLS

<> S 

Supplier

C_CREDID

<> [P000000000 - PZZZZZZZZZ] 

Supplier Account Group

C_CREDID__0ACCNT_GRPV

<> KRED

<> PERS

<> Z012

<> Z013

<> ZSET

<> ZZCP

<> ZZPE

 

Add screenshot if relevant

Key figures

2.01 % Documents Overdue

Description

2.01 % Documents Overdue: Percentage of Document Not Posted < Ref.Date (A) on Document Not Posted (B).

Calculation rule detail

Ratiois composed by KF or CKF or RKFWith Restriction
A

BW_CKF_MV_RDSF01_0001

Document not posted

Variable Reference Date on info object Net Due Date (ONETDUEDATE)
B

BW_CKF_MV_RDSF01_0001

Document not posted

 

BW_CKF_MV_RDSF01_0001 (B) = BW_RKF_MV_RDSF01_0001 (C) + BW_RKF_MV_RDSF01_0002 (D)

Document not posted (B) = Document not posted (1srt rule) (C) + Document not posted (2nd rule) (D)

Ratiois composed by KF or CKF or RKFWith Restriction
C

BW_CKF_MV_RDSF01_0002

Nb Cockpit Doc.

C_STATUS = 1; 2
D

BW_CKF_MV_RDSF01_0002

Nb Cockpit Doc.

C_STATUS = 6; 7

0AC_DOC_NO = #

BW_CKF_MV_RDSF01_0002 (E) = K_COUNTER with aggrgation by summation on C_DOCNO.

Nb Cockpit Doc. (E) = Counter  with aggrgation by summation on Cockpit Doc. Nb.

2.02 % Documents Received Overdue

Description

2.02 % Documents Received Overdue: Percentage of Documents Received Overdue (A) on all document (Counter)  (B).

Calculation rule detail

 

Ratiois composed by KF or CKF or RKFWith Restriction
A

BW_CKF_MV_RDSF01_0002 

Nb Cockpit Doc.

C_FLGOVD (Flag Overdue) = X

 

BW_CKF_MV_RDSF01_0002 (E) = K_COUNTER with aggrgation by summation on C_DOCNO.

Nb Cockpit Doc. (E) = Counter  with aggrgation by summation on Cockpit Doc. Nb.

2.04 % Rejected Documents

Description

2.04 % Rejected Documents: Percentage of Rejected Documents (A) on Nb Cockpit Doc (B).

Calculation rule detail

 

Ratiois composed by KF or CKF or RKFWith Restriction
A

BW_CKF_MV_RDSF01_0002 

Nb Cockpit Doc.

C_STATUS = 13

 

BW_CKF_MV_RDSF01_0002 (B) = K_COUNTER with aggrgation by summation on C_DOCNO.

Nb Cockpit Doc. (B) = Counter  with aggrgation by summation on Cockpit Doc. Nb.

2.05 Scanning Cycle Time

Description

2.05 Scanning Cycle Time: Division of Scanning cycle time (A) by Nb Cockpit Doc (B).

Calculation rule detail

 

BW_CKF_MV_RDSF01_0002 (B) = K_COUNTER with aggrgation by summation on C_DOCNO.

Nb Cockpit Doc. (B) = Counter  with aggrgation by summation on Cockpit Doc. Nb.

2.08% First Time Match

Description

2.08 % First Time Match: Percentage of Document Posted Without WC (A) on all Documents Posted (B)

Calculation rule detail

Ratiois composed by KF or CKF or RKFWith Restriction
A

BW_CKF_MV_RDSF01_0002 (C)

Nb Cockpit Doc.

C_STATUS = 3

C_FGRSWC = #

 

B

BW_CKF_MV_RDSF01_0002 (C)

Nb Cockpit Doc.

C_STATUS = 3

BW_CKF_MV_RDSF01_0002 (C) = K_COUNTER with aggrgation by summation on C_DOCNO.

 

2.12 Posting Cycle Time

Description

2.12 Posting Cycle Time: Division of Posting cycle time (A) by Nb Cockpit Doc (B).

Calculation rule detail

 

Ratiois composed by KF or CKF or RKFWith Restriction
A

K_PTNGPT

Posting Cycle Time

C_STATUS = 3

 

BW_CKF_MV_RDSF01_0002 (B) = K_COUNTER with aggrgation by summation on C_DOCNO.

Nb Cockpit Doc. (B) = Counter  with aggrgation by summation on Cockpit Doc. Nb.

2.13 WF Cycle Time (In Days)

Description

2.13 WF Cycle Time(In Days):  Web Cycle in days (A) <> 0 multiplied by Web Cycle in Days (A) more (Web Cycle in Days (A) == 0   multiplied by Current Day - Web Cycle Date (B) ).

Calculation rule detail

 

Ratiois composed by KF or CKF or RKFWith Restriction
A

K_WBCD

Web Cycle in Days

C_DATEWC (Web cycle date) <> #

 

B 

 

Characteristics

LocationInfo-object NameInfo-object TextExplanation (if needed)
FreeC_DOCTYPAccount Document Type 
Free0AC_DOC_NOAccounting Document Nb 
Free0ALLOC_NMBRAllocation Nb 
Free0BLINE_DATEBaseline Date 
Free0CALDAYPosting Date 
Free0CALYEARPosting Year 
Free0CALMONTHPosting Month/Year 
Free0CALWEEKPosting Week/Year 
Free0CLEAR_DATEClearing Date 
FreeC_COMPCDECompany 
FreeC_COMPCDE__0COUNTRYCountry of the Company 
Free0DOC_DATEDocument Date 
Free0FISCYEARFiscal year 
Free0FISCPERFiscal year / period 
FreeC_FAEINVFlag Automatic and Electronic Invoices 
FreeC_FLGOVDFlag Overdue 
FreeC_SUBACT2__CPFCTR1_2Global Business Unit 
Free0REF_DOC_NOInvoice Nb 
Free0NETDUEDATENet Due Date 
FreeC_PMNTTRMPayment Terms 
FreeC_PLANTPlant 
FreeC_PUR_ORGPurchase Organisation 
FreeC_PUR_GRPPurchasing Group 
FreeC_DTSCANScanning Date 
FreeC_PLANT__C_PSITESite 
Free0LOGSYSSource System 
FreeC_STATUSStatus 
FreeC_CREDIDSupplier 
FreeC_VENDCOMSupplier (Company view) 
FreeC_CREDID__0COUNTRYSupplier Country 
FreeC_CREDID__C_DOMAINSupplier Domain 
FreeC_VENDCOM__0PMNTTRMSSupplier Payment Terms (Co) 
FreeC_CREDID__C_SEGTSupplier Segment 
FreeC_COMPCDE__C_PZONEZone (PUR) 
FreeC_DOCNOCockpit Doc. Nb 
FreeC_DATEWCWeb Cycle Date 
FreeC_FGRSWCFlag Web Cycle (Y/N) 
Free0AEDATModification Date 
FreeC_FIMMFLGFlag FI or MM Doc. 
FreevC_CREDID__C_VENCLSSupplier Class 
FreeC_CREDID__C_ENTRPSupplier Internal Flag 
Free0CREATEDONCreation Date 
FreeC_SAPDOCNCockpit SAP Doc Num 
FreeC_DAT_REJDate of rejection 
FreeC_DAT_ACTLast step date 
FreeZREJCODERejection Code 
FreeC_WC_USERWEB CYCLE user 
FreeC_WC_IDWorkflow ID 
FreeC_WCSTATUWorkflow status 
FreeC_CPDOCTPIC doc type 

Conditions

If you have conditions, explain here.

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement
Counter <> 0YesCounterNot equal0All characteristics in the drilldown Independcy