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 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 | Ex: GBU zone and WW controllers |
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. |
| Company zone | C_COMPCODE__C_PZONE | Selection Option | No | Choose company zone. |
| Global Business Unit | C_SUBACT2__CPFCTR1_2 | Selection Option | No | Choose global business unit. |
| Creditor | C_CREDID | Several Single Values | No | Choose Creditor. |
| Creditor Class | C_CREDID__C_VENCLS | Several Single Values | No | Choose creditor class. |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
InfoProvider 0INFOPROV | = CR_RDSF1 = CR_RDSF2 | Ex : Exclude intercompanies |
Clearing Doc.Number 0CLR_DOC_NO | = # | In this query we take into account only document not clearing |
Clearing Date 0CLEAR_DATE | = # | In this query we take into account only document not clearing |
Vendor Account Group C_CREDID__0ACCNT_GRPV | <> KRED <> PERS <> Z012 <> Z013 <> ZSET <> ZZCP <> ZZPE | |
Creditor Class C_CREDID__C_VENCLS | <> S | |
Creditor C_CREDID | <> [P000000000 - PZZZZZZZZZ] | |
Status C_STATUS | <> 13 | In this query we don't take into account rejected documents. |
IC doc type C_CPDOCTP | <> AP <> LA |
Key figures
Gross Amount
Description
Key figure isued is Amount (0AMOUNT).
On columns, there is a sharing of the amount by intervals on net due date from current date:
< -60
[-60; -30[
[-30; -10[ For example, here it's the total of amount between 30 days and 11 days before the current date.
[-10; -5[
[-10; -0[
Payment run (0)
]0; 5]
]5; 10]
]10; 30]
]30; 60]
> 60
Calculation rule detail
Amount
Currency Conversion
Exchange Rate Type : CTK_CAR3CD
Currency : ORDCUR01
Nb Cockpit Doc
Description
Columns Nb Cockpit Doc corresponding to calculated key figure BW_CKF_MV_RDSF01_0003.
There is the same sharing in intervals as Gross Amount.
Calculation rule detail
- Nb Cockpit Doc. BW_CKF_MV_RDSF01_0002:
This Calculated key figure used key figure Counter (K_COUNTER). There is aggragation by summation with Cockpit Doc. Nb (C_DOCNO).
Key figure Counter is used instead of Cockpit Doc. Nb because we need to count only the last version of Cockpit Doc. Nb and not all versions (with the reversals in cube, row with counter equal 1 is the last version). - Nb Cockpit Doc.aggr. Source. Syst. BW_CKF_MV_RDSF01_0003
This calculated key figure = BW_CKF_MV_RDSF01_0002 with aggregation by summation on source system (0LOGSYS).
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Column | 0CURRENCY | Currency | It's useful for the conversion of gross amount. |
| Free | C_COMPCDE__0COUNTRY | Country key | |
| Free | C_PLANT | Plant | |
| Free | 0REF_DOC_NO | Reference | |
| Free | 0LOGSYS | Source System | |
| Free | C_DOCNO | Cockpit Doc. Nb | |
| Free | C_CREDID | Creditor | |
| Free | C_COMPCDE | Company Code | |
| Free | C_PLANT__C_SITE | Site | |
| Free | C_FIMMFLG | Flag for FI or MM do | |
| Free | C_DOCTYP | Accnt. document type | |
| Free | C_CPDOCTP | IC doc type | |
| Free | C_STATUS | Status | |
| Free | 0PMNT_BLOCK | Payment block | |
| Free | C_WC_ID | Workflow ID | |
| Free | C_WCSTATU | Workflow status | |
| Free | C_WC_USER | WEB CYCLE user | |
| Free | 0ALLOC_NMBR | Assignment | |
| Free | ZREJCODE | Rejection Code | |
| Free | C_PMNTTRM | Terms of Payment Key | |
| Free | C_EBELN | Purch. order number | |
| Free | C_SAPDOCN | Cockpit SAP Doc Num | |
| Free | C_PAYMET | Payment method | |
| Free | 0DOC_DATE | Document Date | |
| Free | C_NETDT | Due Date 1 | |
| Free | C_DTSCAN | Date Scanning | |
| Free | 0CALDAY | Posting Date | |
| Free | 0CREATEDON | Creation Date | |
| Free | C_DAT_REJ | Date of rejection | |
| Free | C_DAT_ACT | Last step date | |
| Free | 0NETDUEDATE | Net Due Date | |
| Free | C_STPMNT2 | Status of Payment re | |
| Free | C_INV_IND | Invoice flag | |
| Free | C_CREDID__C_VENCLS | Creditor Class | |
| Free | C_COMPCDE__C_PZONE | Purchasing Zone |