The integration of Products
in SAP
NetWeaver Business Intelligence (SAP NetWeaver BI) is divided
into two essentially different areas.
Set types can be created as either distribution-chain-dependent or distribution-chain-independent. Where set types are distribution-chain-dependent, the attribute values are only valid for a specific sales organization and a specific distribution channel.
Standard set types used in Products
are
transferred to SAP NetWeaver BI using SAP
CRM DataSources and mapped in SAP NetWeaver BI using
one of the following InfoObjects:
InfoObject 0CRM_PROD is used for distribution-chain-independent
set types of type Material
or Service
InfoObject 0CRM_PRFI is used for distribution-chain-independent
set types of type Financing
InfoObject 0CRM_PRODSL is used for distribution-chain-dependent
set types of type Material
or Service
InfoObject 0CRM_PRFISL is used for distribution-chain-dependent
set types of type Financing
There are several DataSources for the attributes of these InfoObjects, for which mapping rules are already available in the standard Business Content. This standard Business Content only needs to be activated.
The following DataSources are provided for the InfoObject 0CRM_PROD
(distribution-chain-independent, type Material
/Service
):
DataSource |
Use |
---|---|
0CRM_PRODUCT_ATTR |
Product: CRM Part |
0CRM_PR_PRMAT_ATTR |
Product Material Data |
0CRM_TR_CONTROL_ATTR |
Transaction Control Parameters |
0CRM_PR_REST_IN_ATTR |
Handling Indicator |
The following DataSources are provided for the InfoObject 0CRM_PRFI
(distribution-chain-independent, type Financing
):
DataSource |
Use |
---|---|
0CRM_PR_FIN01_ATTR |
Financing : Basic Data |
The following DataSources are provided for the InfoObject 0CRM_PRODSL
(distribution-chain-dependent, type Material
/Service
):
DataSource |
Use |
---|---|
0CRM_PR_SALESA_ATTR |
Product: Order Data |
0CRM_PR_SALESG_ATTR |
Product: Sales Pricing |
0CRM_PROD_STATUS_SALES_ATTR |
Product: Status (Sales View) |
0CRM_CR_CONTROL_ATTR |
Control Parameters Claims/Returns |
0CRM_EXCH_BUS_ATTR |
Entitlements |
0CRM_PR_RESIDVL_ATTR |
Financing-Dependent Attributes |
The following DataSources are provided for the InfoObject 0CRM_PRFISL
(distribution-chain-dependent, type Financing
):
DataSource |
Use |
---|---|
0CRM_PR_FIN02_ATTR |
Financing: Distribution-Chain-Dependent Data |
0CRM_PR_FIN03_ATTR |
Financing: Classification and Views |
The following text DataSources are provided for attributes belonging to the InfoObject 0CRM_PROD:
DataSource |
Use |
---|---|
0CRM_PROD_IDCMP_TEXT |
Texts for Compound Product ID |
0CRM_SRV_ESCAL_TEXT |
Response Profile |
0CRM_SRV_SERWI_TEXT |
Service Profile |
0CRM_ITEM_INSP_TEXT |
Item Inspection |
0CRM_PROD_HNDLCODE_TEXT |
Handling Code |
The following text DataSource is provided for attributes belonging to the InfoObject 0CRM_PRFI:
DataSource |
Use |
---|---|
0CRM_CLASSIFICATION_TEXT |
CRM Contract Class |
The following text DataSources are provided for attributes belonging to the InfoObject 0CRM_PRODSL:
DataSource |
Use |
---|---|
0CRM_REBATE_GROUP_TEXT |
Volume Rebate Group |
0CRM_RESID_VALUE_GRP_TEXT |
Residual Value Curve |
0CRM_RESID_VALUE_ST_TEXT |
Residual Value Strategy |
0CRM_ACCTGRPPROD_TEXT |
Account Assignment Group Product |
0CRM_COMM_GROUP_TEXT |
Commission Group |
0CRM_RETURNABL_TEXT |
Returnable |
0CRM_PROC_IND_TEXT |
Process Indicator |
0CRM_COREPART_IND_TEXT |
Used Part Indicator |
The following text DataSources are provided for attributes belonging to the InfoObject 0CRM_PRFISL:
DataSource |
Use |
---|---|
0CRM_REFERENCE_INT_D_TEXT |
Interest Reference ID |
0CRM_REFERENCE_INT_TEXT |
Reference Interest Rate |
0CRM_TIMEUNIT_TEXT |
Time Unit |
0CRM_INTERIM_PERIOD_TEXT |
Interim Period |
0CRM_LOOKUP_FOR_INT_TEXT |
Interest Determination |
0CRM_PAYMNT_FORM_TEXT |
Payment Form |
0CRM_PAYMNT_FREQ_TEXT |
Type of Installment Payment |
0CRM_LEAS_CLASS_TEXT |
Tax Pricing Strategy |
0CRM_PRIC_FIMA_TEXT |
Process Indicator Financial Mathematics |
A separate DataSource is generated in the application system for each customer-defined set type if at least one attribute has been flagged as BW-relevant. The SAP CRM DataSources generated for customer-defined set types allow all attributes in the set type designated as relevant to BW to be transferred to SAP NetWeaver BI. If a field is also designated as relevant for selection, the data selection can be restricted later from SAP NetWeaver BI using this field. If the set type contains attributes which require a text DataSource, these are also generated. However, the system does not generate any objects in SAP NetWeaver BI, these must be made available by the application.
Before the DataSources generated in the application system can be transferred to SAP NetWeaver BI , and the missing meta data (InfoObjects and transfer rules) created, the modeling must be specified within SAP NetWeaver BI. For SAP CRM distribution-chain-independent attributes for products, there are basically two options:
Option 1: Include new attributes in existing InfoObjects
The attributes of type Material
or Service
that
need to be transferred to SAP NetWeaver BI can
be transferred as attributes of the InfoObject 0CRM_PROD (Product), the attributes
of type Financing
can be transferred as attributes
of the InfoObject 0CRM_PRFI (SAP CRM Financing
Product). As a result, the total number of attributes for these InfoObjects
will increase considerably and may reach the technical limit of 249 attributes.
Option 2: Create new InfoObjects
If quite a large number of new attributes is anticipated or if the attributes are of a new type, you are advised to create a new InfoObject ZMY_PROD (or similar) and append the attributes to it. This InfoObject must have the same data type and length as the InfoObject 0CRM_PROD or 0CRM_PRFI.
If the number of attributes is very high, you may want to create several of these InfoObjects and group the attributes thematically. The individual InfoObjects will therefore remain compact and the number of attributes required later in a query can be better restricted.
The procedure is similar for SAP CRM distribution-chain-dependent attributes for products. There are basically two options:
Option 1: Include new distribution-chain-dependent attributes in existing InfoObjects
The distribution-chain-dependent
attributes of type Material
or Service
that
need to be transferred to SAP NetWeaver BI can
be transferred as attributes of the InfoObject 0CRM_PRODSL (Product Sales
View), the distribution-chain-dependent attributes of type Financing
can
be transferred as attributes of the InfoObject 0CRM_PRFISL (SAP
CRM Financing Product Sales View). As a result, the total number
of attributes for these InfoObjects will increase considerably and may reach
the technical limit of 249 attributes.
Option 2: Create new InfoObjects
If quite a large number of new attributes is anticipated or if the distribution-chain-dependent attributes are of a new type, you are advised to create a new InfoObject ZMY_PRODSL (or similar), compounded with the InfoObjects 0CRM_SALORG and 0DISTR_CHAN, and append the attributes to it. This InfoObject must have the same data type and length as the InfoObject 0CRM_PRODSL or 0CRM_PRFISL.
If the number of attributes is very high, you may want to create several of these InfoObjects and group the attributes thematically. The individual InfoObjects will therefore remain compact and the number of attributes required later in a query can be better restricted.
The modeling of master data is very important for transaction data and queries.
When the transaction data is transferred, the product GUID (key in SAP NetWeaver BI) contained in the transfer structure must be copied to the relevant fields (communication structure, update rules). This is possible because all InfoObjects for the product have the same data type and length.
When distribution-chain-dependent transaction data is transferred, the product GUID, the SAP CRM sales organization and distribution channel (compound key in SAP NetWeaver BI) contained in the transfer structure must be copied to the relevant fields (communication structure, transfer rules)
You should first replicate the generated master data and text DataSources from the application system to SAP NetWeaver BI from the administrator workbench.