Provide an overview of the app (e.g Domain, key processes, purpose of the app, etc)

Describe the key User profiles that exist for the application.

General role/Viewer role:

Approver role:

Target Users:

As examples: Controllers / Accountants

VERSION	DATE	MODIFIED BY	DESCRIPTION
0.01	dd.mm.yyyy	<Insert name>	Initial draft

Data Product Type

Dashboard
Report
Advanced analytics
AI
Others <specify which one>

Technologies

BW
Tableau
Qliksense
Talend
Dataiku
Others <specify which one>

Data Sources

Note: list of all applications and various environment

SAP PF1 (Production environment)
SAP WP1
SAP PI1
BW (versions)
iCare CRM
CORE CRM
Others <specify the name of the source>

2.0 Business Process

Capture the business process that the application supports . This can be describe through a process diagram or a business capability model

3.0 Application Feature Overview

Information about the existent Workbooks and the respective BW queries.

Reports	Description	Info Providers	Application	Prompts	Query Technical Name	Additional Information
SPRINT - PtP: Material Analysis	MasterData Material (C_MATNR2)DSOs Material Modification Follow-up			Infoprovider = C_MATNR2= DB_MMAT1= DB_MMAT2= DB_MMAT3Modification Date= #	BW_QRY_MV_MATAN1_0001
SPRINT - PtP: Readsoft Payables Ageing	Cubes Read Soft Header DataDSO Read Soft Header Data				BW_QRY_MV_RDSF01_0002
SPRINT - PtP: ReadSoft Analysis (Core Query)	Cubes Read Soft Header DataDSO Read Soft Header Data				BW_QRY_MV_RDSF01_0001
SPRINT - PtP: Suppliers Analysis (Core Query)	DSOs Vendor Modification Follow-up (+ PRS)MasterData PRS Vendor (C_VENDPRS)				BW_QRY_MV_SUPAN1_0001
SPRINT - PO Messages Follow-up (Core Query	Cubes PO - Messages Status	MV_PUMS1	SPRINT - PtP	InfoProvider= C_PUMS1= C_PUMS2= C_PUMS30Calday= #Vendor Class<> SVendor Account Group<> KRED<> PERS<> Z012<> Z013<> ZSET<> ZZCP<> ZZPEVendor<> [P000000000 - PZZZZZZZZZ]	BW_QRY_MV_PUMS1_0001
SPRINT - Provisioning Analysis (Core Query)	Cubes PO Schedule LineMasterData Item number of purchase requisition (C_PURRQI)				BW_QRY_MV_PROVG_0001	This query will be split into 5 core queries like it is done for QlikView. Currently the date filter is only applied at restricted keyfigure level so the whole cubes are read each time.
SPRINT - PtP: Payables Analysis (Core Query)	Cubes FIAP for SprintCubes Read Soft Header Data			InfoProvider= CR_PUAP1= CR_PUAP2= CR_PUAP3= CR_RDSF1= CR_RDSF2Creditor<> [P000000000 - PZZZZZZZZZ]Creditor Class<> SCreditor Account Group<> KRED<> PERS<> Z012<> Z013<> ZSET<> ZZCP<> ZZPEVendor Class <> S	BW_QRY_MV_APRS1_0003
SPRINT - PtP: Payables Analysis Posting Date (Core Query)	MV_APRS1				BW_QRY_MV_APRS1_0004
SPRINT - PtP: Payables Analysis Clearing Date (Core Query)	MV_APRS1		Account Payable		BW_QRY_MV_APRS1_0005
SPRINT - PtP: Payables Analysis (QV Query)	MV_APRS1		Account Payable		QVSBS_BW_QRY_MV_APRS1_0003
SPRINT - PtP: Payables Analysis - Invoices (QV Query)	MV_APRS1		AP		QVSBS_BW_QRY_MV_APRS1_0003B
SPRINT - PtP: SAP Contract Analysis (Core Query)	Dsos Agreement Modification Follow-upMasterData Item for Principal Agreement (C_AGRITM)	MV_PROVG			BW_QRY_MV_MATAN1_0002
SPRINT - PtP: Prov. Acknowlegment Analysis (Core Query)	SPRINT - PtP	MV_PROVG	SPRINT - PtP	InfoProvider = C_PURRQI= CR_PUSL1= CR_PUSL2= CR_PUSL3Vendor Class<> SVendor<> [P000000000 - P999999999]Vendor Account Group<> KRED<> PERS<> Z012<> Z013<> ZSET<> ZZCP<> ZZPE	BW_QRY_MV_PROVG_0001BW_QRY_MV_PROVG_0003

4.0 Functional Specification

4.1 General Data/Calculations

This section will approach the concepts/definitions that will be used in all the reports and required to understand the data from the reports.

Could be specific fields, closing activities, additional information to work and understand the reports.

SPRINT - PtP: Material Analysis

Variable Sequence

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-11 15:13:30.png

Key figures

SPRINT - PtP: Payables Analysis

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

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-5 17:24:46.png

Key figures

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-5 17:42:21.png

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-5 17:43:5.png

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-5 17:43:42.png

SPRINT - PtP: Payables Analysis Posting Date (Core Query)

Description

Key Figure	Type	Display/hide
BW_RBK_MV_APRS1_0001	Restricted Keyfigure	Display
BW_RBK_MV_APRS1_0056		Display
BW_RBK_MV_APRS1_0057		Display
BW_RBK_MV_APRS1_0038
BW_RBK_MV_APRS1_0039		Display
BW_RBK_MV_APRS1_0002		Display

SPRINT - PtP: Payables Analysis Clearing Date (Core Query)

Key Figure 1

Description

Key Figure	Type	Show/Hide
1 - In Advance (RHO)	Selection	Show
1 - In Advance (RCS)	Selection	Show
1 - In Advance (PF1)	Selection	Show

Characteristics

Location	Info-object Name	Info-object Text
Free	C_CREDID__0COUNTRY	Creditor Country

SPRINT - PtP: Payables Analysis - Invoices (QV Query)

Key Figure 1

Description

Key Figure	Type	Display/hide
BW_RBK_MV_APRS1_0001	Restricted Keyfigure	Display
BW_RBK_MV_APRS1_0056		Display
BW_RBK_MV_APRS1_0057		Display
BW_RBK_MV_APRS1_0038
BW_RBK_MV_APRS1_0039		Display
BW_RBK_MV_APRS1_0002		Display

Exceptions

Exception Name

Active

By default

Alert Level

Operator

Value

Other parameters

(if different from default)

Yes/No

SPRINT - PtP: PO Messages Follow-up (Core Query)

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
PO Creation Date	0DOC_DATE	Interval	YES	Choose interval on PO creation date
Vendor Zone (PUR)	C_VENDID__C_PZONE	Authorization / Selection Option	No
Source System	0LOGSYS	Customer exit / Several single values	No
Message date	0CALDAY	Interval	Yes
Global Business Unit	C_SUBACT2__CPFCTR1_2	Authorization / Selection Option	No
Zone (PUR)	C_COMPCDE__C_PZONE	Authorization / Selection Option	No
Company code	C_COMPCDE	Authorization / Selection Option	No
Company Country	C_COMPCDE__0COUNTRY	Selection Option	No
Site	C_PLANT__C_PSITE	Selection Option	No
Plant	C_PLANT	Authorization / Selection Option	No
Purchasing Group	C_PUR_GRP	Selection Option	No
Purchase Organisation	C_PUR_ORG	Selection Option	No
Purchase Doc Category	C_BSTYP	Selection Option	No
Purchase Doc Type	C_BSART	Selection Option	No
PO Number	C_EBELN	Selection Option	No
PO Created By	C_PO_ITM__0USERNAME	Selection Option	No

SPRINT - PtP: PO Messages Follow-up (Core Query)

Variable Sequence

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-7 15:48:38.png

Key figures

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-7 15:55:42.png

SPRINT - PtP: Prov. Acknowlegment Analysis (Core Query)

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
PO Schedule Line Delivery Date	0SCL_DELDAT	Interval	YES	Choose interval of PO Schedule Line Delivery Date
Vendor Zone (PUR)	C_VENDID__C_PZONE	Selection Option	No
Country Attribut Purch. Zone	C_ORIGCTY__C_PZONE	Selection Option	No
Source System	0LOGSYS	Several Single Values	No
Company code	C_COMPCDE	Selection Option	No
Site	C_PSITE	Selection Option	No
Plant	C_PLANT	Selection Option	No
Material	C_MATNR2	Selection Option	No
Material Group	C_MAT_GRP	Selection Option	No
Material Type	C_MATNR2__C_MAT_TYP	Selection Option	No
Purchasing Group	C_PUR_GRP	Selection Option	No
Purchase Organisation	C_PUR_ORG	Selection Option	No
Vendor PRS	C_VENDID__C_VENDPRS	Selection Option	No
Vendor	C_VENDID	Several Single Values	No
Vendor Country	0COUNTRY	Selection Option	No
Vendor Class	C_VENDID__C_VENCLS	Several Single Values	No
PO Number	0DOC_NUM	Selection Option	No
PO Item Category	C_PO_ITM__C_PSTYP	Selection Option	No
Purchase Doc Type	C_BSART	Selection Option	No
Capex flag	C_WBS_EL2__C_WBSE_TP	Single value	No
Purchase Request	C_PURRQT	Selection Option	No
SAP Contract	C_AGRNBR	Selection Option	No
Purch. Inforecord (PIR)	C_PURIFR	Selection Option	No
Domain	C_DOMAIN	Selection Option	No
Segment	C_SEGT	Selection Option	No
Order Acknowl. Reqrm	C_PO_ITM__C_KZABS	Single Value	No
PO Item Created by	C_PO_ITM__OCREATEDBY	Selection Option	No
PO Origin of Needs	C_PO_ITM__C_ORICDE	Selection Option	No
PO Created By	C_PO_ITM__0USERNAME	Selection Option	No
Global Business Unit	C_SUBACT2__CPFCTR1_2	Selection Option	No

Variable Sequence

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2016-6-24 10:38:3.png

Key figures

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2016-6-24 11:32:41.png

4.2 Process Detail

4.2.1. Report/Process Definition

Domain	Supply Chain
Application
Provider	<insert name>
Existing Documentation	<insert link>

This section represents the process with detail information for the application.

SPRINT - PtP: Material Analysis

Calculation rule detail

Ratio	is composed by KF or CKF or RKF	With Restriction
A	1ROWCOUNT Number of Records
B	RKF_MV_MATAN1_0002 (C) Number of modifications on Material	Aggragtion by counter for all detailed values on C_MATNR2.
C	1ROWCOUNT Number of Records
D	RKF_MV_MATAN1_0009 (I) Nb of Material Blocked	Aggregation by summation on C_MATNR2
E	RKF_MV_MATAN1_0010 (J) Nb of Material Unlocked	Aggregation by summation on C_MATNR2
F	RKF_MV_MATAN1_0011 (K) Nb of Material Deleted	Aggregation by summation on C_MATNR2
G	RKF_MV_MATAN1_0012 (L) Nb of Material Undeleted	Aggregation by summation on C_MATNR2
H	1ROWCOUNT Number of Records
I	1ROWCOUNT Number of Records
J	1ROWCOUNT Number of Records
K	1ROWCOUNT Number of Records
L	1ROWCOUNT Number of Records

Characteristics

Location	Info-object Name	Info-object Text
Free	0CREATEDBY	Material Created By
Free	C_MATNR2	Material Code
Free	0CREATEDON	Material Creation Date
Free	0DEL_FLAG	Material Deletion flag
Free	C_MAT_GRP	Material Group
Free	C_MMSTA	Material Status
Free	0DOC_DATE	Modification Date
Free	0LOGSYS	Source System
Free	C_MAT_TYP	Material Type
Free	C_MAT_GRP__C_DOMAIN	Material Group Domain
Free	C_MAT_GRP__C_SEGT	Material Group Segment

SPRINT - PtP: Payables Analysis

2.06 Nb Invoices Posted

Description

2.06 Nb Invoices Posted = Sum of posted doc FI

Calculation rule detail

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > 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
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

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-5 18:16:59.png

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

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-6 10:15:25.png

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

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-6 14:16:37.png

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.
J	BW_CKF_MV_APRS1_0006 (J1)) Nb of Accounting Document Aggregation → Summation on C_COMPCDE
J1

2.14 % Urgent Payments

Description

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

Calculation rule detail

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-6 17:51:50.png

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

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-7 9:38:6.png

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

Characteristics

Location	Info-object Name	Info-object Text
Free	C_CREDID__C_GRPPUR	Creditor Group (PUR) Code
Free	C_VENDID__C_GRPPUR	Vendor Group (PUR) Code
Free	0LOGSYS	Source System
Free	C_COMPCDE	Company code
Free	C_COMPCDE__0COUNTRY	Country of the Company
Free	C_DOMAIN	Domain
Free	C_COSTCTR__C_FUNCT_2	Function
Free	C_SUBACT2__CPFCTR1_2	Global Business Unit
Free	C_SEGT	Segment
Free	0PROFIT_CTR	Profit Center
Free	C_PUR_GRP	Purchasing Group
Free	C_PUR_ORG	Purchase Organisation
Free	C_PLANT__C_PSITE	Site
Free	C_COMPCDE__C_PZONE	Zone (PUR) of the Company
Free	C_CREDID__0COUNTRY	Country of the Creditor
Free	C_VENDCOM__C_PMNTTRM	Creditor Payment Terms (Co)
Free	C_CREDID	Creditor
Free	0CALQUARTER	Calendar Year/Quarter
Free	0CALMONTH2	Calendar Month
Free	0CALYEAR	Posting Year
Free	0CALWEEK	Posting Week/Year
Free	0HALFYEAR1	Calendar Halfyear
Free	0CALQUART1	Calendar Quarter
Free	C_CREDID__C_FLGINT	Flag Intercompany
Free	0AC_DOC_NO	Accounting Doc. Nb
Free	C_DOCTYP	Account Doc. Type
Free	0ALLOC_NMBR	Allocation Doc. Nb
Free	0BLINE_DATE	Baseline Date
Free	C_XINVE	Capex Flag (old)
Free	0CLR_DOC_NO	Clearing Doc. Nb
Free	0CLEAR_DATE	Clearing Date
Free	0CO_AREA	Controlling area
Free	0CREATEDON	Created on
Free	C_BKTXT	Document header text
Free	0CALMONTH	Posting Year/Month
Free	0GL_ACCOUNT	G/L Account
Free	C_VENDCOM__C_ZWELS	List of the payments to take into account
Free	C_PM_BLCK	Payment Block
Free	C_PM_METH	Payment Method
Free	C_PMNTTRM	Invoice Payment Terms
Free	0REF_DOC_NO	Reference Doc. Nb
Free	0CALDAY	Posting Date
Free	0DOC_DATE	Document Date
Free	C_PLANT	plant
Free	C_STPMNT	Status of Payment
Free	C_CREDID__C_PZONE	Zone (PUR) of the Creditor
Free	0NETDUEDATE	Net Due Date
Free	C_ORNETDT	Original Net Due Date
Free	C_STATUS	ReadSoft Status
Free	C_DOCNO	Cockpit Doc. Nb
Free	C_FIMMFLG	Flag FI or MM Doc.
Free	C_CREDID__C_VENCLS	Creditor Class
Free	C_CREDID__C_VENDVIP	VIP Vendor
Free	C_FAEINV	Flag Scanned
Free	0USERNAME	User Name
Free	0DOC_NUM	PO Number
Free	C_PO_ITM	PO Item
Free	C_TCODE	Transaction code

SPRINT - PtP: PO Messages Follow-up (Core Query)

Message Status

Description

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-7 15:58:17.png

% of PO with Electronic Msg

Description

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-7 16:1:34.png

Ratio

is composed by KF or CKF or RKF

With Restriction

A

BW_RKF_MV_PUMS1_0001 (C)

Nb of Electronic 1rst Msg

C

BW_CKF_MV_PUMS1_0001 (B)

Nb of PO

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-7 16:8:59.png

B

1 aggragtion by summation with reference Purch Order number - C_EBELN

% of PO with Fax Msg

Description

Ratio

is composed by KF or CKF or RKF

With Restriction

A

BW_CKF_MV_PUMS1_0001 (B)

Nb of PO

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2017-4-7 16:23:27.png

B

1 aggragtion by summation with reference Purch Order number - C_EBELN

% of PO with Fax Msg

Description

Ratio	is composed by KF or CKF or RKF	With Restriction
A	BW_CKF_MV_PUMS1_0001 (B) - (BW_RKF_MV_PUMS1_0001 (C) + BW_RKF_MV_PUMS1_0002 (D)) Nb of PO - ( Nb of electronic 1rst Msg + Nb of Fax 1rst Msg )
B	1 aggragtion by summation with reference Purch Order number - C_EBELN
C	BW_CKF_MV_PUMS1_0001 (B) Nb of PO
C	BW_CKF_MV_PUMS1_0001 (B) Nb of PO

Characteristics

Location	Info Object Name	Info Object Text
Free	C_NAUTO	Automatique Message
Free	C_COMPCDE	Company
Free	C_AENDE	Change message flag
Free	C_LOEKZ	Deletion indicator in PO
Free	C_VSZTP	Dispatch time
Free	C_FPOMSG	First PO Message
Free	C_SUBACT2__CPFCTR1_2	Global Business Unit
Free	C_MANUE	Manual Message
Free	0CALDAY	Message Date
Free	0BPARTNER	Message Partner
Free	0PART_FUNCT	Message Partner Function
Free	C_VSTAT	Message Status
Free	C_NACHA	Message Transmission Medium
Free	C_MTYPE	Message Type
Free	0CALMONTH	Message Year/Month
Free	C_PLANT	Plant
Free	0DOC_DATE	PO Creation Date
Free	C_EBELN	PO Number
Free	C_UHRVR	Processing Time
Free	C_BSTYP	Purchasing Doc Categ
Free	C_BSART	Purchasing Type
Free	C_COMPCDE__C_PZONE	Zone (PUR)
Free	C_PLANT__C_PSITE	Site
Free	C_VENDID	Vendor
Free	C_VENDID__C_VENCLS	Vendor Class
Free	C_VENDID__C_DOMAIN	Vendor Domain
Free	C_VENDID__C_VENDPRS	Vendor PRS
Free	C_VENDID__C_SEGT	Vendor Segment
Free	C_PUR_ORG	Purchase Organisation
Free	C_ORICDE	PO Origin of Needs
Free	0USERNAME	PO Created User
Free	C_PUR_GRP	Purchasing Group
Free	0LOGSYS	Source System
Free	C_COMPCDE__0COUNTRY	Country of the Company
Free	C_VENDID__0COUNTRY	Vendor Coutnry

SPRINT - PtP: Prov. Acknowlegment Analysis (Core Query)

1.06 % of PO Ack. Collected

Description

1.06% of PO Ack. Collected: percentage of Ack. Date < SLD <> 0 (A) on Nb PO Ack. Flag (B)

Calculation rule detail

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2016-6-24 10:59:3.png

Ratio	is composed by KF or CKF or RKF	With Restriction
A	BW_CKF_MV_PROVG_0013 (C) Acknowlegment Date less than Sched. Line Delivery date <> 0	Variables:
B	BW_RKF_MV_PROVG_0007 (D) Nb of PO lines without PREQ	Variables:
C	K_ADLSLD aggr by C_PO_ITM Acknowlegment Date less than Sched. Line Delivery date	<> 0
D	BW_CKF_MV_PROVG_0009 (E) Nb of PO Items	OINFOPROV = CR_PUSL1 OINFOPROV = CR_PUSL2 OINFOPROV = CR_PUSL3 C_PO_ITM__C_KZABS (Order Acknowl. Reqm) = X
E	Sum 1 aggr by C_PO_ITM

! Warning:

Key figure K_ADLSLD (with others) is not calculated in data flow, there isn't mapping between DSO schedule line and cube.

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2016-6-24 11:17:30.png

These keys figures are calculated in badi RSR_OLAP_BADI (Transaction SE18), implementation -> overview : ZVAR_IMPLT_MV_PROVG -> interface -> compute.

The calculation is done when some queries are executed.

Data, Analytics & AI Platform > Functional Documentation - Procurement - SPRINT - SBS PtP report > image2016-6-24 11:20:30.png

Characteristics

Location	Info-object Name	Info-object Text
Free	C_COMPCDE	Company code
Free	C_ORIGCTY	Country of the Company
Free	C_SUBACT2__CPFCTR1_2	Global Business Unit
Free	C_DATE_EM	Good Receipt Date
Free	C_MATNR2	Material
Free	C_MAT_GRP	Material Group
Free	C_MATNR2__C_MAT_TYP	Material Type
Free	C_PO_ITM__C_LABNR	Order acknowledgment
Free	C_PO_ITM__C_KZABS	Order Acknowl. Reqrm
Free	C_PLANT	Plant
Free	C_PO_ITM__0USERNAME	PO Created By
Free	C_PO_ITM	PO Item
Free	0CALDAY	PO Line Creation Date
Free	0HALFYEAR1	PO Line Creation Halfyear
Free	0CALMONTH2	PO Line Creation Month
Free	0CALQUART1	PO Line Creation Quarter
Free	0CALYEAR	PO Line Creation Year
Free	0CALQUARTER	PO Line Creation Year/Quarter
Free	0CALMONTH	PO Line Creation Year/Month
Free	0CALWEEK	PO Line Creation Year/Week
Free	C_PO_ITM__C_ORICDE	PO Need Origin
Free	0STAT_DATE	PO Statistics Date
Free	C_PURRQT	Purchase Request (PREQ)
Free	C_PURRQI	PREQ Item
Free	0DOC_NUM	Purchase Order (PO)
Free	C_PUR_GRP	Purchasing Group
Free	C_PUR_ORG	Purchase Organisation
Free	C_PLANT__C_PSITE	Site
Free	C_VENDID	Vendor
Free	C_VENDID__C_SEGT	Segment
Free	C_COMPCDE__C_PZONE	Zone (PUR)
Free	C_PURRQI__C_NFPREQ	PREQ Non-Conform
Free	C_PO_ITM__C_PSTYP	PO Item Category
Free	C_PO_ITM__C_LOEKZI	PO Item Deletion Flag
Free	C_PO_ITM__C_LOEKZ	PO Deletion Flag
Free	C_PO_ITM__0ERDAT	PO Created Date
Free	C_AGRNBR	SAP Contract number
Free	C_AGRITM	SAP Contract Item
Free	0SCL_DELDAT	PO Schedule Line Delivery Date
Free	0ORDER_CURR	PO Order Currency
Free	0PO_UNIT	Order unit
Free	C_BSART	Purchasing Doc. Type
Free	0INFO_TYPE	Infotype
Free	C_TYPCDE	PO Line Type
Free	0LOC_CURRCY	PO Local Currency
Free	0LOGSYS	Source System
Free	C_PURRQI__C_DA_DATE	PREQ Creation Date
Free	C_PURRQI__C_VALDAT	PREQ Release Date
Free	C_PO_ITM__0CREATEDBY	PO Item Created By
Free	C_PO_ITM__0CREATEDON	PO Item Creation Date
Free	C_PO_ITM__C_DTPOACK	Date of PO Acknowledgment
Free	C_PO_ITM__0PO_STATUS	PO Status
Free	C_PO_ITM__C_TCODE	PO Created Transaction
Free	C_WBS_EL2__C_WBSE_TP	Capex Flag
Free	C_PO_ITM__C_KNTTP2	Account Assignment Category
Free	C_PURIFR	Purchase Info Record (PIR)
Free	C_PURRQI__C_PUR_GRP	PREQ Purch. Group
Free	C_DOMAIN	Domain
Free	C_PLANT__0COUNTRY	Country of the Plant
Free	C_PO_ITM__C_PRIOREQ	PO: Requirement Priority
Free	C_PO_ITM__C_PRIOURG	PO: Requirement Urgency
Free	Vendor Class	C_VENDID__C_VENCLS
Free	Vendor Group (PUR) Code	C_VENDID__C_GRPPUR

Conditions

Condition Name

Active

By default

Key Figure

(Structure)

Operator

Value

Characteristic Assignement

Counter <> 0

Yes

Counter

Not equal

0

All characteristics in the drilldown Independcy

5.0 Non-functional Descriptions

Please populate the relevant section and delete those that are not applicable.

5.1 Usability

Usability is about the ease with which a User can learn to start using the solution and the ease with which they can use the system. In addition to ease of learning and ease of use, usability also includes areas such as ease of recall, error avoidance and handling, accessibility among others e.g., 99% of metadata entry Users who have use the Maintenance Dashboard should be able to change filters, extract etc., when required. Maintenance data will be centrally stored in the Google Cloud platform, which will be available to other applications e.g., and Dashboards if needed.

5.2 Regulatory Compliance

Software systems must comply with legal and regulatory e.g., GDPR requirements, this can change depending on country, organisation industry and / or region. The software systems must be secure from unauthorized access. The Maintenance Dashboard will comply with Solvay’s regulations and compliance e.g., access only granted to authorized Users.

5.3 Security

Security refers to essential aspects that assure a solution and its components will be protected against unauthorized access or malware attacks. Important considerations related to security aspects of a system are User authentication, User authorization or User access privileges, data theft, malware attacks, data encryption, and maintaining audit trails, e.g., only Users with administrator access shall be able to create new accounts and assign data access privileges to the new accounts e.g.,

All data will be encrypted in the dashboard
Only authorised Users / Administrative Users will be able to access data.
Maintenance data will be split between either SCO or ECO, and Users will only have authority to one Entity data.

5.4 Performance

Performance defines how fast a software system or a particular section of it responds to certain User actions under a certain workload. In most cases, this metric explains how long a User must wait before the target operation happens e.g., the page renders, a transaction is processed, etc., given the overall number of Users now. Performance requirements may describe background processes invisible to Users, e.g., backup and speed of data transfers.

5.5 Reliability

Reliability is the ability of a solution or its component to perform its required functions without failure under predefined conditions for a specified time / period. Reliability can possibly be specified in terms of average time system runs before failure occurs, percentage of operations completed successfully within a time / period, maximum acceptable failure probability, or number of failures within a period. Reliability aspects are in reference to (but not limited to) evaluation of the system to be considered as reliable, classification of reliability defining failures vs. regular failures, and the impact of failure on business operations. The Maintenance Dashboard will display data from the previous refresh of data.

5.6 Scalability

Scalability refers to the degree to which a solution can evolve to handle increased amounts of work. The increased amount of work could be in terms of the user base, transactions, data, network traffic, or other factors e.g., the system should be able to handle an additional load of a maximum of 5,000 Users every month for the next 6 months without any noticeable performance impacts.

5.7 Compatibility

Interoperability is the degree to which the solution is compatible with other components. It is a measure of how effectively the system interoperates with other software systems and how easily it integrates with external hardware devices.

Interoperability aspects to be discussed during elicitation are in reference to (but not limited to) software systems to be interfaced with along with data / messages to be exchanged and any standard data formats, hardware components to be integrated with, and any standard communication protocols to be followed e.g., Order Management system will push the order file into a secured file transfer protocol server from where it will be loaded into the system through a daily job. To guarantee between Google Cloud platform and SAP BW Queries e.g., BW_QRY_MVPMOR01_0002, Solvay has introduced a new tool called Xtract (Xtract).

5.8 Availability

Availability is the degree to which the solution is operable and accessible when required. It is a measure of time during which the system is fully operational e.g., available for use and sometimes included as a Service Level Agreement (SLA) considering its criticality to the business, e.g., the system shall be at least 99% available on weekdays between 09:00 to 18:30 Central European Time (CET).

5.9 Refresh of the Data

Frequency, data, and time of the data refresh in the data product.

1.0 Overview

2.0 Business Process

3.0 Application Feature Overview

4.0 Functional Specification

4.1 General Data/Calculations

SPRINT - PtP: Material Analysis

Variable Sequence

Key figures

SPRINT - PtP: Payables Analysis

General parameters

Global properties

Variables

Variable Sequence

Key figures

SPRINT - PtP: Payables Analysis Posting Date (Core Query)

SPRINT - PtP: Payables Analysis Clearing Date (Core Query)

Key Figure 1

Description

Characteristics

Description

SPRINT - PtP: PO Messages Follow-up (Core Query)

General parameters

Global properties

Variables

Definitions

Variable Sequence

SPRINT - PtP: Prov. Acknowlegment Analysis (Core Query)

General parameters

Global properties

Variables

Definitions

Variable Sequence

Key figures

4.2 Process Detail

4.2.1. Report/Process Definition

SPRINT - PtP: Payables Analysis

2.06 Nb Invoices Posted

Description

Calculation rule detail

2.07 % Paperless Invoices

Description

Calculation rule detail

2.09 % Automatic Posting

Description

Calculation rule detail

2.10 % Payment on Time

Description

Calculation rule detail

2.14 % Urgent Payments

Description

Calculation rule detail

2.11 % Invoices with PO

Description

Calculation rule detail

Characteristics

SPRINT - PtP: PO Messages Follow-up (Core Query)

Message Status

Description

% of PO with Electronic Msg

Description

% of PO with Fax Msg

Description

% of PO with Fax Msg

Description

Characteristics

1.06 % of PO Ack. Collected

Description

Calculation rule detail

! Warning:

Characteristics

Conditions

5.0 Non-functional Descriptions

5.1 Usability

5.2 Regulatory Compliance

5.3 Security

5.4 Performance

5.5 Reliability

5.6 Scalability

5.7 Compatibility

5.8 Availability