Show TOC

Background documentationIntegration in SAP NetWeaver Business Intelligence

 

The integration of Products in SAP NetWeaver Business Intelligence (SAP NetWeaver BI) is divided into two essentially different areas.

SAP CRM Set Types (Standard)

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
Customer-Defined Set Types

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.