Sales Manager Product Group Overview
Sales Manager Product Group Overview
Technical name: 0SEM_C09_Q02
Based on InfoCube:
0SEM_C09Use
The query is part of the SEM-BPS planning application Profit planning. It shows the planned values of the contribution margin scheme broken down by product groups. It is based on the view of the sales manager.
Filter
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
0VTYPE |
= 20 (Plan) |
|
0VERSION |
= SP2 (Version Level Sales Manager) |
|
0COMP-CODE |
= 0S_COCD |
|
0FISCYEAR |
= 0P_FYEAR |
Free Characteristics
InfoObject |
Description |
| 0CO_AREA |
Controlling area |
|
0DISTR_CHAN |
Distribution channel |
|
0SALESORG |
Sales organization |
Rows
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0COPASLQTY |
Sales quantity |
|
0COPAREVEN |
Revenue |
|
0COPADISCT |
Total sales deductions |
|
0COPANETSL |
Net sales |
|
0COPADIRSL |
Total direct costs of sales |
|
0COPANETRV |
Net revenue |
|
0COPACOGSV |
Total COGM variable |
0COPAMARGN1 |
Contribution margin I |
|
0COPACOGSF |
Total COGM fixed |
|
0COPACOGS |
Cost of sales |
0COPAMARGN2 |
Contribution margin II |
|
0COPASPROM |
Promotion |
Columns
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0MATL_GROUP |
= SAP2 (non-alcoholic beverages) |
|
0MATL_GROUP |
= SAP1 (alcoholic beverages) |
|
0MATL_GROUP |
= SAP3 (glasses) |
Total |
= 'non-alcoholic beverages' + 'alcoholic beverages' + 'glasses' |