Hierarchy
SAP_APPL (Software Component) Logistics and Accounting⤷
LO-MAP (Application Component) Merchandise and Assortment Planning⤷
WIS_PLAN (Package) Retail: Planning
Basic Data
| Data Element | WISP_NORMA |
| Short Description | Key Figure for 'Norm' and 'Weighted Average' Aggregation |
Data Type
| Category of Dictionary Type | Direct Type Entry | |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | ||
| Data Type | CHAR | Character String |
| Length | 30 | |
| Decimal Places | 0 | |
| Output Length | 30 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Key Figure |
| Medium | 18 | Key Figure |
| Long | 24 | Reference Key Figure |
| Heading | 20 | Reference Key Figure |
Documentation
Definition
If a planning key figure has the time-based aggregation behavior "Norming" or "Weighted Average", you need to specify a reference key figure. This reference key figure determines the norming characteristics of the planning key figure or contains the weights to be used for the time-based averaging.
Note that the reference key figure must always be used at the same time as the planning key figure in a planning layout. If the reference key figure is missing in a planning layout, the time-based aggregation behavior of the planning key figure is set to "Summation" for time that this layout is used.
Use
Dependencies
If a planning key figure has the time-based aggregation behavior "Norming", then the reference key figure should be assigned the aggregation behavior "Maximum" (see example).
Example
Time-based aggregation "Norming":
The key figure "Package Price" has the time-based aggregation behavior "Norming". It has been assigned the reference key figure "Pieces per Package", which has the time-based aggregation behavior "Maximum". Here is the period screen and overview screen (time-based aggregated values) of a planning layout.
Period screen:
Period Package Price Pieces per Package
1 1.50 1
2 8.00 6
3 8.00 6
4 14.00 12
Overview screen (periods 1-4 aggregated):
Period Package Price Pieces per Package
1-4 16 12
The average package price for a package containing 12 pieces is calculated. In this example it is calculated as
AVERAGE VALUE( 1.5*12/1; 8*12/6; 8*12/6; 14*12/12).
Time-based aggregation "Weighted Average":
The key figure "Price per Piece" has the time-based aggregation behavior "Weighted Average" and the key figure "Number of pieces sold" has the aggregation behavior "Summation". The second key figure is assigned to the first as a reference key figure.
Period screen:
Period Price Number Sold
1 1.50 1237
2 1.60 1090
3 1.70 1297
4 1.55 2077
Overview screen (periods 1-4 aggregated):
Period Price Number Sold
1-4 1.58 5701
In the overview screen, the average price is displayed and the number of sales is quoted in terms of weight:
Average price = (1.5*1237 + 1.6*1090 + 1.7*1297 + 1.55*2077) / 5701.
History
| Last changed by/on | SAP | 20020107 |
| SAP Release Created in | 470 |
