The new wiki link for this data flow is here:
Technical Documentation - Procurement - SPRINT report
Please update the new doc there and no longer here.
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 |