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

Tab	Screenshot	Comment
Display	$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 16:52:22.png$
Rows/Columns	$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 16:52:54.png$
Value Display	$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 16:53:9.png$
Planning	$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 16:53:27.png$
Extended	$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 16:54:15.png$

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

$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 17:24:46.png$

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

$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 17:42:21.png$

$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 17:43:5.png$

$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 17:43:42.png$

2.06 Nb Invoices Posted = Sum of posted doc FI

$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 17:49:24.png$

Ratio	is composed by KF or CKF or RKF	With Restriction
A	BW_RBK_MV_APRS1_0012 (A1) Posted Document FI - RHO	$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 17:51:51.png$
A1	BW_CKF_MV_APRS1_0007 (D) Nb of Accounting Doc. by Company	$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 17:54:17.png$ $TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 17:54:37.png$
B	BW_RBK_MV_APRS1_0005 (B1) Posted Document (FI - RCS)	$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 18:0:11.png$
B1	BW_CKF_MV_APRS1_0007 (D) Nb of Accounting Doc. by Company	$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 18:2:34.png$
C	BW_RBK_MV_APRS1_0011 (C1) Posted Document (FI - PF1)	$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 18:5:7.png$
C1	BW_CKF_MV_APRS1_0007 (D) Nb of Accounting Doc. by Company	$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 18:7:3.png$ $TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 18:7:51.png$
D	BW_CKF_MV_APRS1_0006 (D1) Nb of Accounting Document Aggregation → Summation on C_COMPCDE
D1	$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 17:58:21.png$

2.07 % Paperless Invoices = Reverse the percentage of documents scanned automatically to the total number of documents posted

$TECHNO - BI TEAM > SPRINT - PtP: Payables Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-5 18:16:59.png$

Location	Info-object Name	Info-object Text	Explanation (if needed)

Condition Name	Active By default	Key Figure (Structure)	Operator	Value	Characteristic Assignement