CO-PA: Consumer Products Industry (S_CP)
CO-PA: Consumer Products Industry (S_CP)
Technical name: 0COPA_C04
Use
This InfoCube allows you to perform a results analysis that is specific to the consumer goods industry. The InfoCube is compatible with the operating concern template Consumer Goods Industry S_CP, which is delivered in the R/3 System from Release 4.6A and which you can use for testing and demonstration purposes.
You access the environment for operating concern templates in the R/3 System by choosing Structures ® Define Operating Concern ® Operating Concern Templates ® Use SAP Operating Concern Template in Customizing for CO-PA. From this environment, you can access the functions available for the template and detailed information about these functions.
In the template environment, you can generate test data (planning and actual data) for the template and analyze this data using the queries for this InfoCube.
If your Profitability Analysis is a new installation, you can copy the operating concern template S_CP for use in the live system and extract your live data into this InfoCube. You can then use the queries delivered for this InfoCube to analyze your live data.
Since Profitability Analysis is an application that generates data, certain aspects differ from the usual BW Content concept. Not all of the usual elements can be delivered with the CO-PA Business Content.
You create DataSources manually in the IMG of the OLTP system (which can be reached using transaction SBIW) under Customer-Defined DataSources ® Profitability Analysis ® Create DataSource.
The product category is updated using the material and its attribute 'CRM product'. A hierarchy must be created with the CRM product. The hierarchy must be taken from a CRM system. This hierarchy is then used to define the superior node for the CRM product. This node must be a product category and it used to update the characteristics "Product Category" in the InfoCube.
InfoSources
0CO_PA_4: CO-PA: Consumer Good Industry (S_CP)Characteristics
|
InfoObject |
Description |
 0COMP_CODE |
Company code |
|
0CO_AREA |
Controlling area |
|
0PROFIT_CTR |
Profit center |
|
0PART_PRCTR |
Partner profit center |
|
0BUS_AREA |
Business area |
|
0CRM_MKTELE |
CRM Marketing Element (R/3 WBS Element) |
|
0CRM_MKTELM |
CRM Marketing Element (Campaign and Marketing Plan) |
|
0WBS_ELEMT |
WBS element |
|
0MATERIAL |
Material |
|
0CRM_PROD |
CRM Product |
|
0PROD_CATEG |
Product Category |
|
0MATL_GROUP |
Merchandise Category |
| 0BRAND |
Brand |
| 0BUSFIELD |
Business field |
| 0CUST_HIE01 |
Customer hierarchy level 1 |
| 0CUST_HIE02 |
Customer hierarchy level 2 |
| 0CUST_HIE03 |
Customer hierarchy level 3 |
|
0COUNTRY |
Country |
|
0NIELSEN_ID |
Nielsen ID |
| 0STRBUSUNIT |
Strategic business unit |
|
0DIVISION |
Division |
|
0PLANT |
Plant |
|
0CUSTOMER |
Customer |
|
0CUST_GROUP |
Customer group |
|
0SALES_OFF |
Sales office |
|
0SALESORG |
Sales organization |
|
0DISTR_CHAN |
Distribution channel |
|
0SALESEMPLY |
Sales employee |
|
0SALES_GRP |
Sales group |
|
0VTYPE |
Plan/actual indicator (value type for reporting) |
|
0VERSION |
Version |
| 0REC_TYPE |
Record type |
|
0CURRENCY |
Currency type |
|
0VALUATION |
Valuation view |
Time Characteristics
|
InfoObject |
Description |
|
0FISCPER |
Fiscal year/period |
|
0FISCVARNT |
Fiscal year variant |
|
0FISCYEAR |
Fiscal year |
Key Figures
|
InfoObject |
Description |
| 0COPASLQTY |
Sales quantity |
|
0BILL_QTY |
Billing Quantity in Base Unit of Measure |
| 0COPAREVEN |
Revenue |
| 0CUST_DSCNT |
Customer discount |
| 0PROD_DSCNT |
Material discount |
| 0QTY_DSCNT |
Quantity discount |
| 0OFFR_DSCNT |
Special offer discount |
| 0CASH_DSCNT |
Cash discount |
| 0VOL_REBATE |
Rebate |
|
0COPANETSL |
Net Sales |
| 0SALES_CMSN |
Sales commission |
| 0SPCDSLS_CS |
Special direct sales costs |
| 0ACCRDFR_CS |
Accrued freight costs |
| 0DIRMAT_CS |
Direct material costs |
| 0VARPROD_CS |
Variable production costs |
| 0MATOVHD |
Material overhead |
| 0FIXPROD_CS |
Fixed production costs |
| 0QUANT_VRNC |
Quantity variances |
| 0PRICE_VRNC |
Price variances |
| 0TRANS_VRNC |
Freight/transportation variances |
| 0LOTSZ_VRNC |
Lot size variances |
| 0PRDCS_VRNC |
Production cost variances |
| 0STRCT_VRNC |
Structure variances |
| 0OTHER_VRNC |
Miscellaneous variances |
| 0LOGISTICS |
Logistics |
| 0SALESFORCE |
Sales force |
| 0SALESOFFIC |
Sales office |
| 0ADVERTISNG |
Advertising |
| 0PROMOTIONS |
Promotions |
| 0MARKETING |
Marketing |
| 0ADMNSTRTN |
Administration |
| 0RSRCH_DEV |
Research and Development |
Calculated Key Figures
|
InfoObject |
Description |
Formula/Restriction |
|
0COPA_C04_CK001 |
Total sales deductions |
Customer discount + material discount + quantity discount + cash discount + rebate |
|
0COPA_C04_CK002 |
Net sales |
Revenue - total sales deductions |
|
0COPA_C04_CK003 |
Total direct sales costs |
Sales commission + special direct sales costs + accrued freight costs |
|
0COPA_C04_CK004 |
Net revenue |
Net sales - total direct sales costs |
|
0COPA_C04_CK005 |
Total variable costs of goods manufactured |
Direct material costs + variable production costs |
|
0COPA_C04_CK006 |
Contribution margin 1 |
Net revenue - total variable costs of goods manufactured |
|
0COPA_C04_CK007 |
Total fixed costs of goods manufactured |
Material overhead + fixed production costs |
|
0COPA_C04_CK008 |
Contribution margin 2 |
Contribution margin 1 - total fixed costs of goods manufactured |
|
0COPA_C04_CK009 |
Total variances |
Quantity variances + price variances + miscellaneous variances |
|
0COPA_C04_CK010 |
Contribution margin 3 |
Contribution margin 2 - total variances |
|
0COPA_C04_CK011 |
Total overhead |
Sales costs + administration + marketing + Research and Development + miscellaneous overhead |
|
0COPA_C04_CK012 |
Operating profit |
Contribution margin 3 - total overhead |
Restricted Key Figures
|
InfoObject |
Description |
Formula/Restriction |
|
0COPA_C04_RK001 |
Net Sales without Promotions |
0COPANETSL restricted to 0CRM_MKTELM "not assigned" |
Units
|
InfoObject |
Description |
| 0COPASLQTU |
Sales unit of measure |
|
0BASE_UOM |
Base unit of measure |
|
0CURRENCY |
Currency |
Structures
The queries for this InfoCube can be displayed by combining just a few row and column structures. The structures with a technical name ending with a number are found in the rows whereas those with a technical name ending with a letter appear in the columns.
|
InfoObject |
Description |
| 0COPA_C04_QT002 |
Net sales |
| 0COPA_C04_QT006 |
Contribution margin 1 |
| 0COPA_C04_QT012 |
Operating profit |
|
0COPA_C04_QT00A (same format as 0COPA_C03_QT00A) |
Plan/actual comparison |
|
0COPA_C04_QT00B (same format as 0COPA_C03_QT00A) |
Comparison with previous year |