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 Payables Ageing (Core Query) |
|---|---|
| Technical Name | BW_QRY_MV_RDSF01_0002 |
Application | SPRINT - PtP |
Info-provider | MV_RDSF01 |
Usage type | Direct execution in analyser |
Expected users |
Workbook/Query General Description
Query Payables Ageing is used to analyse the amount of readsoft data and the number of cockpit document with intervals between current date and net due date.
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 Values | No | Choose source system. |
| Target Currency | C_CRCYTGT | Single Value | Yes | Is used by conversion with conversion type CTK_CAR3CD, target currency = ORDCUR01 (ZXRSRU01 -> when ORDCUR01, we take CRCYTG01). |
| Created On | 0CREATEDON | Interval | No | Choose interval of creation date. |
| Plant | C_PLANT | Selection Option | No | Choose plant. |
| Site (of the plant) | C_PLANT__C_SITE | Several Single Values | No | Choose site (of the plant). |
| Company | C_COMPCDE | Selection Option | No | Choose company |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
Key figures
Key Figure 1
Description
Calculation rule detail
Text Replacement Variable
Currency Conversion
Exchange Rate Type :
Currency :
Time Reference :
Unit Conversion
Unit :
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
Cells
Conditions
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
Exceptions
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Yes/No | |||||