Stock Development Report 
Query: 0FRE_MC03_Q0001 / 0FRE_MC23_Q0001
This query is used to analyze the development of the stock value for a product/location combination or hierarchical level, for a given period of time.
Variables are provided so you can enter a selection range of periods, products, and locations (calendar week is a mandatory variable).
Note
Data for the F&R Weekly Figures InfoProvider (0FRE_C05) is collected on a weekly basis and contains the following time characteristics: 0CALWEEK, 0CALMONTH, 0CALYEAR, 0FISCPER, 0FISCVARNT and 0FISCYEAR. In this query, BI summarizes the key figure data from this InfoProvider, based on the first day of the calendar week.
For example, assume you have the following weekly records:
The total for June is 360. Consumption for calendar week 22, which includes five days in June, is not included in the June summary line. This is because only the first day of the week is used to determine the month to which the weekly information belongs.
This limitation applies to all reports based on the F&R Weekly Figures InfoProvider (0FRE_C05).
The following key performance indicators (KPIs) are calculated in this query:
Weekly consumption cost
The following KPIs and key figures are displayed in this query:
Weekly average stock (in BUoM)
Weekly average stock cost
Weekly consumption (in BUoM)
Weekly consumption value
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| N/A |
- |
Object Type | Name | Technical Name |
|---|---|---|
| Description |
InfoObject |
| Location Type |
0PLANT__0PLANTCAT |
| Merchandise Category |
0MATERIAL__0MATL_GROUP |
| Material Group Hierarchy 1 |
0MATERIAL__ORPA_WGH1 |
| Material Group Hierarchy 2 |
0MATERIAL__ORPA_WGH2 |
| Material Group Hierarchy 3 |
0MATERIAL__ORPA_QGH3 |
| Material Group Hierarchy 4 |
0MATERIAL__ORPA_QGH4 |
| Replenishment Type |
0FRE_REPLST |
| Replenishment Planner |
0MAT_PLANT_0FRE_PLNPUR |
| Listing Status |
0FRE_LISTST |
| ABC Indicator |
0MAT_PLANT_0ABCKEY |
| Selling Class |
0MAT_PLANT_0FRE_SELCLS |
| Production Substitution Type |
0FRE_REPLTY |
Object Type | Name | Technical Name |
|---|---|---|
| Description |
Variable |
| Calendar year/week |
0I_CWEEK |
| Product |
0S_PROD |
| Location |
0S_LOC |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Calendar year/week |
0CALWEEK |
- |
| Product |
0MATERIAL |
- |
| Location |
0PLANT |
- |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Weekly Average Stock (in BUoM) |
0FRE_WKAVST |
- |
| Weekly Average Stock Cost |
0FRE_AVSTCS |
- |
| Weekly Consumption (in BuoM) |
0FRE_CONSWK |
- |
| Weekly Consumption Value |
0FRE_CONVWK |
- |
| Weekly Consumption Cost – (Calculated Key Figure) |
0FRE_MC03_CK001 |
Time of Calculation = After Aggregation |