Description | SPRINT - PtP: Payables Analysis (Core Query) |
|---|---|
| Technical Name | BW_QRY_MV_APRS1_0003 |
Application | SPRINT - PtP |
Info-provider | MV_APRS1 |
Usage type | Direct execution in analyser |
Expected users |
Workbook/Query General Description
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| Display |
| |
| Rows/Columns |
| |
| Value Display |
| |
| Planning |
| |
| Extended |
|
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
| Vendor Zone (PUR) | C_VENDID__C_PZONE | Authorization / Selection Option | No | |
| Zone (PUR) | C_COMPCDE__C_PZONE | Authorization / Selection Option | No | |
| Creditor Attribut Purch. Zone | C_CREDID__C_PZONE | Authorization / Selection Option | No | |
| Source System | 0LOGSYS | Several Single Values | No | |
| Global Business Unit | C_SUBACT2__CPFCTR1_2 | Authorization / Selection | No | |
| Company code | C_COMPCDE | Authorization / Selection | No | |
| Site | C_PLANT__C_PPSITE | Selection Option | No | |
| Plant | C_PLANT | Authorization / Selection Option | No | |
| Domain | C_DOMAIN | Selection Option | No | |
| Segment | C_SEGT | Selection Option | No | |
| Purchase Organisation | C_PUR_ORG | Selection Option | No | |
| Purchasing Group | C_PUR_GRP | Selection Option | No | |
| Invoice Payment Terms | C_PMNTTRM | Selection Option | No | |
| Creditor Class | C_VENCLS | Several Single Values | No | |
| Vendor Class | C_VENDID__C_VENCLS | Several Single Values | No | |
| Posting Date | 0CALDAY | Interval | No | |
| Clearing Date | 0CLEAR_DATE | Interval | No | |
| Account Document Number | 0AC_DOC_NO | Selection Option | No |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| InfoProvider | = CR_PUAP1 = CR_PUAP2 = CR_PUAP3 = CR_RDSF1 = CR_RDSF2 | |
| Creditor | <> [P000000000 - PZZZZZZZZZ] | |
| Creditor Class | <> S | |
| Creditor Account Group | <> KRED <> PERS <> Z012 <> Z013 <> ZSET <> ZZCP <> ZZPE | |
| Vendor Class | <> S |
Add screenshot if relevant
Key figures
2.06 Nb Invoices Posted
Description
2.06 Nb Invoices Posted = Sum of posted doc FI
Calculation rule detail
Ratio | is composed by KF or CKF or RKF | With Restriction |
|---|---|---|
| A | BW_RBK_MV_APRS1_0012 (A1) Posted Document FI - RHO |
|
| A1 | BW_CKF_MV_APRS1_0007 (D) Nb of Accounting Doc. by Company |
|
| B | BW_RBK_MV_APRS1_0005 (B1) Posted Document (FI - RCS) |
|
| B1 | BW_CKF_MV_APRS1_0007 (D) Nb of Accounting Doc. by Company |
|
| C | BW_RBK_MV_APRS1_0011 (C1) Posted Document (FI - PF1) |
|
| C1 | BW_CKF_MV_APRS1_0007 (D) Nb of Accounting Doc. by Company |
|
| D | BW_CKF_MV_APRS1_0006 (D1) Nb of Accounting Document Aggregation → Summation on C_COMPCDE | |
| D1 |
|
2.07 % Paperless Invoices
Description
2.07 % Paperless Invoices = Reverse the percentage of documents scanned automatically to the total number of documents posted
Calculation rule detail
Ratio | is composed by KF or CKF or RKF | With Restriction |
|---|---|---|
| A | Posted Doc. (FI - RCS) Posting Date (A1) + Posted Doc. (FI - PF1) Posting Date (A2) | |
| A1 | BW_RBK_MV_APRS1_0005 (A1.1) Posted Document (FI - RCS) |  |
| A1.1 | BW_CKF_MV_APRS1_0007 (C) Nb of Accounting Doc. by Company |  |
| A2 | BW_RBK_MV_APRS1_0011 (A2.1) Posted Document (FI - PF1) | |
| A2.1 | BW_CKF_MV_APRS1_0007 (C) Nb of Accounting Doc. by Company |
|
| B | Posted Doc. (FI - RCS) Posting Date (A1) + Posted Doc. (FI - PF1) Posting Date (A2) - ( Scanned Invoice (ReadSoft PF1) (B1) + Scanned Invoice 5readsoft RCS (B2) ) | |
| B1 | BW_RBK_MV_APRS1_0009 (B1.1) Scanned Invoice (ReadSoft PF1) | |
| B1.1 | BW_CKF_MV_APRS1_0007 (C) Nb of Accounting Doc. by Company |  |
| B2 | BW_RBK_MV_APRS1_0008 (B2.2) Scanned Invoice (ReadSoft RCS) | |
| B2.2 | BW_CKF_MV_APRS1_0007 (C) Nb of Accounting Doc. by Company |  |
| C | BW_CKF_MV_APRS1_0006 (C1) Nb of Accounting Document Aggregation → Summation on C_COMPCDE | |
| C1 |  |
2.09 % Automatic Posting
Description
2.09% Automatic Posting = Percentage automatic posted doc to the total number of documents posted.
Calculation rule detail
Ratio | is composed by KF or CKF or RKF | With Restriction |
|---|---|---|
| A | Posted Doc. by system Job/Batch (RHO) (A1) + Posted Doc. by system Job/Batch (RCS) (A2) + Posted Doc. by system Job/Batch (PF1) (A3) | |
| A1 | BW_RBK_MV_APRS1_0007 (A1.1) Posted Document by system Job/Batch (RHO) | |
| A1.1 | BW_CKF_MV_APRS1_0007 (C) Nb of Accounting Doc. by Company |  |
| A2 | BW_RBK_MV_APRS1_0001 (A2.1) Posted Document by system Job/Batch (RCS) | |
| A2.1 | BW_CKF_MV_APRS1_0007 (C) Nb of Accounting Doc. by Company |
|
| B |
See KPI: 2.06 Nb Invoices Posted | |
| C | BW_CKF_MV_APRS1_0006 (C1) Nb of Accounting Document Aggregation → Summation on C_COMPCDE | |
| C1 | |
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
Conditions
Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|