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.13 WF Cycle Time
Description
2.13 WF Cycle Time: Sum of Cycle time WF replied (A) and Cycle Time WF pending reply (B) divided by the Nb Cockpit Doc (C).
Calculation rule detail
| Ratio | is composed by KF or CKF or RKF | With Restriction |
|---|---|---|
| A | K_WBCD Web Cycle in Days (Key figure from multiprovider) | Status (C_STATUS) = 1 or 2 or 3 or 6 or 7 or 8 or 13 Workflow status (C_WCSTATU) = 4 or 5 or 6 or 12 |
| B | K_WBCD Web Cycle in Days (Key figure from multiprovider) | Status (C_STATUS) = 1 or 2 or 3 or 6 or 7 or 8 or 13 Workflow status (C_WCSTATU) <> 4 or 5 or 6 or 7 or 9 or 12 |
BW_CKF_MV_RDSF01_0002 (C) = K_COUNTER with aggrgation by summation on C_DOCNO.
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 |