Defining Grouping Break-downs
Use
If planning data is only available on an aggregated planning level, you require data on a lower level so that a suitably-defined grouping break-down can be assigned to the interface that is to be used for generating the break-down.
Example
: The planning data exists at site group level. Before you can create an allocation table, you must enter data on the site level. The grouping break-down describes how sites are identified for the site group. Use the SAP Classification System or the break-down tables to break-down site groups.Break-downs are maintained in Customizing for planning interfaces in Merchandise and Assortment Planning. Break-downs are assigned to specific planning interfaces.
Break-downs using the SAP Classification System
To use groupings that were generated using the SAP Classification System, the Break-down using the Classification System method must be assigned to the break-down in question.
A grouping characteristic and a classification type must also be entered.
Example
: In our example, the grouping characteristic is site group and the classification type is 30 (only one SAP classification type per site grouping). The sites to be used are defined using the grouping that has been defined in the SAP Classification System. Quantities are assigned to sites equally.The application uses the grouping characteristic to ascertain the exact content of the group. Alternatively, you can assign an RFC destination that defines the target system in which the necessary classifications were made.
Break-downs using the SAP Classification System
Break-down 1MCO_TO_ARTICLE is available for running merchandise category break-downs using the SAP Classification System. Retail classification type 26 is used to break-down the merchandise category. The grouping characteristic is MATKL (base merchandise category).
Using break-down tables to run break-downs
Objects can be assigned to groups directly from database tables especially created for break-downs. To use break-down tables, you must select Break-down table as your break-down method and then assign a suitable database table to the break-down in question.
You must also enter a grouping characteristics and a base characteristic.
Example
: The grouping characteristic is the site group characteristic and the base characteristic is site.The base characteristic represents the target of the grouping break-down. The name of the base characteristic must be match the key field for a break-down table.
As well as base characteristics and grouping characteristics, you can also use context characteristics as key fields. In doing so, you can assign base characteristics to grouping characteristics, depending on the context characteristics used.
Example
: The assignment of a site to a site group depends on the previous year's sales for the site, for the merchandise category in question. This should allow you to differentiate between 'strong'-performing and 'weak'-performing sites for the merchandise category in question. The context characteristic used here is the merchandise category. The break-down defines how sites are to be assigned.The break-down table can also contain the field RELF (relative factor). The field can contain information about the proportional factor that a certain value for a base characteristic for a grouping contains. The information is then used by different applications to disaggregate key figures.
Example
: Quantities should not be distributed equally to sites that are assigned to a 'strong' site group (defined using sales data). One site should be assigned the double quantity as the site is expected to achieve higher sales in the future. The following table can thus be created:Base characteristic Site |
Context characteristic Merchandise category |
Grouping characteristic Site group |
Relative factor |
Site 1 |
Merchandise category A |
Site group - 'strong' |
1 |
Site 2 |
Merchandise category A |
Site group - 'strong' |
2 |
Site 3 |
Merchandise category A |
Site group - 'strong' |
1 |
Site 4 |
Merchandise category A |
Site group - 'strong' |
1 |
You are planning a sales quantity of 1000 PC of article XYZ for your 'strong' sites. This article belongs to merchandise category A. When creating an allocation table in planning, the following allocation table quantities are considered:
Article XYZ |
Site 1 |
200 PC |
Article XYZ |
Site 2 |
400 PC |
Article XYZ |
Site 3 |
200 PC |
Article XYZ |
Site 4 |
200 PC |
Break-down table structure
Field name |
Key field |
Field category |
<Base characteristic> |
Yes |
Undefined |
<ContextChar1> |
Yes |
Undefined |
... |
... |
... |
<ContextCharN> |
Yes |
Undefined |
<GroupChar> |
No |
Undefined |
RELF |
No |
WISP_RELF |
Break-down tables delivered with MAP
The following are provided for running break-downs for a merchandise category-dependent site grouping:
You can use the database table to define the assignments of sites to site groups. This can be done using a customer-specific analysis program (Report) that uses sales data from the previous year, for example. Characteristics WGRU1 (merchandise category, hierarchy level 1), WGRU2 (merchandise category, hierarchy level 2) and MATKL (base merchandise category) are included. This enables you to analyze sales data for each merchandise category so that 'strong' and 'weak' sites can be defined for each merchandise category.
The database table also contains field RELF (relative factor).
The database table is also used in transaction WXP51 and transaction WXP54 for MAP. It used to create
Use break-down 1SITEGROUP, method Break-down table is used to find the sites for a particular site group. 1SITEGROUP contains the following attributes: