Description	SPRINT - PtP: Material Analysis (Core Query)
Technical Name	BW_QRY_MV_MATAN1_0001
Application	SPRINT - PtP
Info-provider	MV_MATAN1
Usage type	Direct execution in analyser
Expected users

Workbook/Query General Description

General parameters

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

Variable Name	Info-object	Selection Type	Required
Source System	0LOGSYS	Customer Exit / Several Single Values	No
Time (From... to... )	0DATE	Interval	Yes
Material Group Domain	C_MAT_GRP__C_DOMAIN	Several single values	No
Material Group Segment	C_MAT_GRP__C_SEGT	Several single values	No
Material Group	C_MAT_GRP	Selection Option	No
Material Type	C_MAT_TYP	Selection Option	No
Material	C_MATNR2	Selection Option	No
Plant	C_PLANT	Authorization / Selection Option	No

$TECHNO - BI TEAM > SPRINT - PtP: Material Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-11 15:13:30.png$

Object

Filter Value

Explanation

Infoprovider

= C_MATNR2

= DB_MMAT1

= DB_MMAT2

= DB_MMAT3

Modifcation Date

= #

Add screenshot if relevant

$TECHNO - BI TEAM > SPRINT - PtP: Material Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-11 15:19:49.png$

Ratio	is composed by KF or CKF or RKF	With Restriction
A	1ROWCOUNT Number of Records	$TECHNO - BI TEAM > SPRINT - PtP: Material Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-11 15:27:28.png$
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	$TECHNO - BI TEAM > SPRINT - PtP: Material Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-11 15:30:44.png$
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	$TECHNO - BI TEAM > SPRINT - PtP: Material Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-11 15:40:24.png$
I	1ROWCOUNT Number of Records	$TECHNO - BI TEAM > SPRINT - PtP: Material Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-11 15:33:48.png$
J	1ROWCOUNT Number of Records	$TECHNO - BI TEAM > SPRINT - PtP: Material Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-11 15:36:0.png$
K	1ROWCOUNT Number of Records	$TECHNO - BI TEAM > SPRINT - PtP: Material Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-11 15:37:59.png$
L	1ROWCOUNT Number of Records	$TECHNO - BI TEAM > SPRINT - PtP: Material Analysis (Core Query) /!\ Obsolete /!\ > image2017-4-11 15:39:38.png$

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

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