Hierarchy
SAP_FIN (Software Component) SAP_FIN⤷
CO (Application Component) Controlling⤷
RS_IMG_CO (Package) OLTP-IMG CO (Controlling)
IMG Activity
| ID | BWCOPA_REPL | Procedure for Setting Up Replication Model |
| Transaction Code | S_AX6_42000008 | IMG Activity: BWCOPA_REPL |
| Created on | 19990930 | |
| Customizing Attributes | BWCOPA_REPL | Procedure for Setting Up Replication Model |
| Customizing Activity |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | BWCOPA_REPL |
This activity describes the process you should use to create the connection between your Profitability Analysis (CO-PA) and SAP BW, this connection being required for the replication model. Since it is impossible to deliver a DataSource that is tailored precisely to all the specific requirements that customers have for analyzing profitability data, the procedure applied here differs from that applied in other applications.
Most of the activities necessary for creating the connection between CO-PA and SAP BW are not performed in the source system (only the creation of DataSources in performed there). The rest of the activities are performed in SAP BW (such as the creation of InfoCubes). The activities described below are intended to provide a rough outline of the process and contain notes on particular aspects of Profitability Analysis that you need to be aware of. You can find more detailed information in the documentation for each IMG activity or in the SAP BW documentation.
Note
The steps described below relate to connecting a BW system from Release 2.0. If you also want to set up a connection to the BW system Release 1.2 with this extractor, see the section Procedure for Setting Up the Replication Model for BW Release 1.2.
Example
Requirements
Standard settings
Recommendation
Activities
- Creating DataSource
Create a DataSource for the operating concern and transfer the default settings for it. Be sure to see the notes in the section Create Transaction Data DataSource.
- Activating Business Content
Activate at least one part of the Business Content for Profitability Analysis, in particular the InfoObjects for the InfoCubes CO-PA: Published Key Figures and CO-PA: Quickstart (S_GO). In this way, you can then use InfoObjects that are usually frequently used in Profitability Analysis. You should activate the other delivered InfoCubes if you want to use the corresponding operating concern templates that are available from R/3 Release 4.6.
- Metadata Upload
The metadata upload function is used to replicate in the BW system the DataSources from a source system.
Switch to the source system tree and choose the desired source system. If the Profitability Analysis node exists for the selected source system, select it with the cursor and use the right mouse button to choose Update metadata. If the Profitability Analysis component does not exist, use the right mouse button to choose the function for the source system.
A dialog box then appears. You should always set the upload to occur in the background. Make sure that the time of execution is at least a few minutes ahead of the current time.
- Creating InfoSource
Switch to the InfoSource tree and use the right mouse button to create for the application component Profitability Analysis an InfoSource for transaction data. The InfoSource can collect data from different systems.
- Mapping DataSource and InfoSource Fields
Switch to the source system tree. Select the DataSource and use the right mouse button to choose Map DataSource to a BW InfoSource. Assign the created InfoSource.
The system then generates a corresponding object in the background for each CO-PA-specific field with a five-character name. The name of the generated InfoObject consists of the five-character field name and the prefix "0G_x" (where x=C for characteristic, x=A for amount, x=Q for quantity, and x=U for unit of measure). For example, for the characteristic WWXYZ, the system generates an InfoObject with the name 0G_CWWXYZ.
In the next screen, the generated InfoObjects as well as the info objects for the activated Business Content are already assigned to the corresponding fields of the DataSource. Enter any missing assignments between field and InfoObject manually. This may require you to create InfoObjects.
When you choose Suggest transfer rules, the system copies the field assignments to the transfer rules, the transfer structure, and the communication structure.
Finally, activate the mapping settings.
- Creating InfoCube
Switch to the InfoCube tree (by choosing Data targets) and use the right mouse button to create an InfoCube using the InfoSource as a template. Create dimensions for the InfoCube and assign the characteristics to these dimensions.
As a rule, it is useful to use the following dimensions in Profitability Analysis:
- Customer
- Product
- Organization structure
- Other
You should make the assignments of characteristics to the dimensions according to the settings for characteristic derivation. This means that you should assign to the dimension Customer, for example, all characteristics that were derived from the customer.
- Creating Update Rules
The InfoCube is linked to the InfoSource via the update rules.
Use the right mouse button to create the update rules for the InfoCube, using the InfoSource as the source of data. Copy the suggestion and activate the rules.
- Initializing the Delta Procedure
Switch to the InfoSource tree and navigate to the source system. Use the right mouse button to create an InfoPackage for the initialization of the delta procedure and schedule it to occur once.
- Regular Extraction of Transaction Data
Create one extra InfoPackage and schedule it to occur regularly for a delta update. It is not practical to create several InfoPackages for delta updates.
Business Attributes
| ASAP Roadmap ID | 207 | Establish Reporting |
| Mandatory / Optional | 1 | Mandatory activity |
| Critical / Non-Critical | 1 | Critical |
| Country-Dependency | A | Valid for all countries |
Assigned Application Components
| Documentation Object Class | Documentation Object Name | Current line number | Application Component | Application Component Name |
|---|---|---|---|---|
| SIMG | BWCOPA_REPL | 0 | HLA0009438 | Information System |
Maintenance Objects
| Maintenance object type |
History
| Last changed by/on | SAP | 19990930 |
| SAP Release Created in |
