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 Name | BW_QRY_MV_RDSF01_0003 |
Application | SPRINT - PtP |
Info-provider | MV_RDSF01 |
Usage type | Direct execution in analyser |
Expected users |
Workbook/Query General Description
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| Display |  | |
| Rows/Columns |  | There 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 date | C_DAT_ACT | Interval | Yes | Choose interval of last step date (applied on all query). |
| Creation Date | 0CALDAY | Interval | No | Choose date interval. |
| Posting Month/Year | 0CALMONTH | Selection Option | No | Choose posting month date. |
| Global Business Unit | C_SUBACT2__CPFCTR1_2 | Selection Option | No | Choose GBU. |
| Zone (PUR) | C_COMPCDE__C_PZONE | Selection Option | No | Choose zone. |
| Company code | C_COMPCDE | Selection Option | No | Choose company code. |
| Site | C_PLANT__C_PSITE | Selection Option | No | Choose site. |
| Plant | C_PLANT | Selection Option | No | Choose spant. |
| Supplier Domain | C_CREDID__C_DOMAIN | Single Value | No | Choose supplier domain. |
| Supplier Segment | C_SEGT | Selection Option | No | Choose segment. |
| Supplier Class | C_VENCLS | Several Single Values | No | Choose supplier class. |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
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 |
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
| Ratio | is composed by KF or CKF or RKF | With 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)
| Ratio | is composed by KF or CKF or RKF | With 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
| Ratio | is composed by KF or CKF or RKF | With 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
| Ratio | is composed by KF or CKF or RKF | With 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
| Ratio | is composed by KF or CKF or RKF | With 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
| Ratio | is composed by KF or CKF or RKF | With 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
| Ratio | is composed by KF or CKF or RKF | With Restriction |
|---|---|---|
| A | K_WBCD Web Cycle in Days | C_DATEWC (Web cycle date) <> #
|
| B |  |
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Free | C_DOCTYP | Account Document Type | |
| Free | 0AC_DOC_NO | Accounting Document Nb | |
| Free | 0ALLOC_NMBR | Allocation Nb | |
| Free | 0BLINE_DATE | Baseline Date | |
| Free | 0CALDAY | Posting Date | |
| Free | 0CALYEAR | Posting Year | |
| Free | 0CALMONTH | Posting Month/Year | |
| Free | 0CALWEEK | Posting Week/Year | |
| Free | 0CLEAR_DATE | Clearing Date | |
| Free | C_COMPCDE | Company | |
| Free | C_COMPCDE__0COUNTRY | Country of the Company | |
| Free | 0DOC_DATE | Document Date | |
| Free | 0FISCYEAR | Fiscal year | |
| Free | 0FISCPER | Fiscal year / period | |
| Free | C_FAEINV | Flag Automatic and Electronic Invoices | |
| Free | C_FLGOVD | Flag Overdue | |
| Free | C_SUBACT2__CPFCTR1_2 | Global Business Unit | |
| Free | 0REF_DOC_NO | Invoice Nb | |
| Free | 0NETDUEDATE | Net Due Date | |
| Free | C_PMNTTRM | Payment Terms | |
| Free | C_PLANT | Plant | |
| Free | C_PUR_ORG | Purchase Organisation | |
| Free | C_PUR_GRP | Purchasing Group | |
| Free | C_DTSCAN | Scanning Date | |
| Free | C_PLANT__C_PSITE | Site | |
| Free | 0LOGSYS | Source System | |
| Free | C_STATUS | Status | |
| Free | C_CREDID | Supplier | |
| Free | C_VENDCOM | Supplier (Company view) | |
| Free | C_CREDID__0COUNTRY | Supplier Country | |
| Free | C_CREDID__C_DOMAIN | Supplier Domain | |
| Free | C_VENDCOM__0PMNTTRMS | Supplier Payment Terms (Co) | |
| Free | C_CREDID__C_SEGT | Supplier Segment | |
| Free | C_COMPCDE__C_PZONE | Zone (PUR) | |
| Free | C_DOCNO | Cockpit Doc. Nb | |
| Free | C_DATEWC | Web Cycle Date | |
| Free | C_FGRSWC | Flag Web Cycle (Y/N) | |
| Free | 0AEDAT | Modification Date | |
| Free | C_FIMMFLG | Flag FI or MM Doc. | |
| Free | vC_CREDID__C_VENCLS | Supplier Class | |
| Free | C_CREDID__C_ENTRP | Supplier Internal Flag | |
| Free | 0CREATEDON | Creation Date | |
| Free | C_SAPDOCN | Cockpit SAP Doc Num | |
| Free | C_DAT_REJ | Date of rejection | |
| Free | C_DAT_ACT | Last step date | |
| Free | ZREJCODE | Rejection Code | |
| Free | C_WC_USER | WEB CYCLE user | |
| Free | C_WC_ID | Workflow ID | |
| Free | C_WCSTATU | Workflow status | |
| Free | C_CPDOCTP | IC doc type |
Conditions
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
| Counter <> 0 | Yes | Counter | Not equal | 0 | All characteristics in the drilldown Independcy |