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
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

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

2.10 % Payment on Time

Description

2.10% Payment on Time = Percentage of accounting document with status of payment "In advance" "At Due Date" "Month Postpone" and "Week Postpone" to the total number of documents with all status of payment.

Calculation rule detail

Ratio	is composed by KF or CKF or RKF	With Restriction
A	1 - In Advance (RCS) (A.1) + 1 - In Advance (PF1) (A.2) + 1 - In Advance (RHO) (A.3)
A1	BW_CKF_MV_APRS1_0007 (J)
A2	BW_CKF_MV_APRS1_0007 (J)
A3	BW_CKF_MV_APRS1_0007 (J) Nb of Accounting Doc by Company
B	2 - At Due Date (RCS) (B.1) + 1 - At Due Date (RCS) (B.2) + 1 - At Due Date (RCS) (B.3)
B.1 B.2 B.3	Same CKF of A1 A2 and A3 and same filters, just the status of payment (C_STPMNT) is different. Here it's equal to 2 "At Due date".
C	3 - Month Postpone (RCS) (C.1) + 3 - Month Postpone (PF1) (C.2) + 3 - Month Postpone (RHO) (C.3)
C.1 C.2 C.3	Same CKF of A1 A2 and A3 and same filters, just the status of payment (C_STPMNT) is different. Here it's equal to 3 "At Month Postpone".
D	4 - Week Postpone (RCS) (D.1) + 4 - Week Postpone (PF1) (D.2) + 4 - Week Postpone (RHO) (D.3)
D.1 D.2 D.3	Same CKF of A1 A2 and A3 and same filters, just the status of payment (C_STPMNT) is different. Here it's equal to 4 "Week Postpone".
E	5 - ]0-5] days (RCS) (E.1) + 5 - ]0-5] days (PF1) (E.2) + 5 - ]0-5] days (RHO) (E.3)
E.1 E.2 E.3	Same CKF of A1 A2 and A3 and same filters, just the status of payment (C_STPMNT) is different. Here it's equal to 5.
F	6 - ]5-10] days (RCS) (F.1) + 6 - ]5-10] days (PF1) (F.2) + 6 - ]5-10] days (RHO) (F.3)
F.1 F.2 F.3	Same CKF of A1 A2 and A3 and same filters, just the status of payment (C_STPMNT) is different. Here it's equal to 6.
G	7 - ]10-30] days (RCS) (G.1) + 7 - ]10-30] days (PF1) (G.2) + 7 - ]10-30] days (RHO) (G.3)
G.1 G.2 G.3	Same CKF of A1 A2 and A3 and same filters, just the status of payment (C_STPMNT) is different. Here it's equal to 7.
H	8 - ]30-60] days (RCS) (H.1) + 8 - ]30-60] days (PF1) (H.2) + 8 - ]30-60] days (RHO) (H.3)
H.1 H.2 H.3	Same CKF of A1 A2 and A3 and same filters, just the status of payment (C_STPMNT) is different. Here it's equal to 8.
I	9 - Rest (>60 days) (RCS) (I.1) + 9 - Rest (>60 days) (PF1) (I.2) + 9 - Rest (>60 days) (RHO) (I.3)
I.1 I.2 I.3	Same CKF of A1 A2 and A3 and same filters, just the status of payment (C_STPMNT) is different. Here it's equal to 9.

2.14 % Urgent Payments

Description

2.14 % Urgent Payments = Percentage of urgent payments to the total number of payments.

Calculation rule detail

Ratio	is composed by KF or CKF or RKF	With Restriction
A
A.1	BW_RKF_MV_APRS1_0006 (A.1.1) Nb of Urgent Payments (PF1)
A.1.1	BW_CKF_MV_APRS1_0008 (C) Counter of house bank = Factu by document
A.2	BW_RKF_MV_APRS1_0003 (A.2.1) Nb of Urgent Payments (RCS)
A.2.1	BW_CKF_MV_APRS1_0008 (C) Counter of house bank = Factu by document
B
B.1	BW_RBK_MV_APRS1_0026 (B.1.1) Posted Document (FI - RCS) payments
B.1.1	BW_CKF_MV_APRS1_0007 (D) Nb of Accounting Doc by Company
B.2	BW_RBK_MV_APRS1_0027 (B.2.1) Posted Document (FI - PF1) payments
B.2.1	BW_CKF_MV_APRS1_0007 (D) Nb of Accounting Doc by Company
C	Aggregation by summation on 0AC_DOC_NO
D	BW_CKF_MV_APRS1_0006 (D1)) Nb of Accounting Document Aggregation → Summation on C_COMPCDE
D1

2.11 % Invoices with PO

Description

2.11 % Invoices with PO = Number of MM invoices vs total number of invoices created on date

Calculation rule detail

Ratio	is composed by KF or CKF or RKF	With Restriction
A
A.1	BW_RBK_MV_APRS1_0025 (A.1.1) Invoices with PO (RHO)
A.1.1	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
A.2	BW_RBK_MV_APRS1_0024 (A.2.1) Invoices with PO (RCS)
A.2.1	BW_CKF_MV_APRS1_0007 (C) Nb of Accounting Doc by Company
A.3	BW_RBK_MV_APRS1_0004 (A.3.1) Invoices with PO (PF1)
A.3.1	BW_CKF_MV_APRS1_0007 (C) Nb of Accounting Doc by Company
B
B.1	BW_RBK_MV_APRS1_001 (B.1.1) Posted Document (FI - RHO)
B.1.1	BW_CKF_MV_APRS1_0007 (C) Nb of Accounting Doc by Company
B.2	BW_RBK_MV_APRS1_005 (B.2.1) Posted Document (FI - RCS)
B.2.1	BW_CKF_MV_APRS1_0007 (C) Nb of Accounting Doc by Company
B.3	BW_RBK_MV_APRS1_0011 (B.3.1) Posted Document (FI - PF1)
B.3.1	BW_CKF_MV_APRS1_0007 (C) Nb of Accounting Doc by Company