CRM Product Master Data 
CRM Product Master Data
Technical Name: 0CRM_PROD
Use
The InfoSource 0CRM_PROD is defined with master data, text data, and hierarchy data, and can be used to create an InfoCube containing product data from CRM.
Characteristics
The fields in the transfer structures of the DataSources 0CRM_PROD_ATTR and 0CRM_PR_MAT_ATTR are mapped to the InfoObjects in the Business Information Warehouse. These InfoObjects are then assigned to the attributes of the InfoSource 0CRM_PROD according to the following tables.
0CRM_PROD_ATTR
|
InfoObject |
Description |
Data Element |
Field in Transfer Structure |
Source |
|
0CRM_PROD |
CRM Product GUID |
COMT_PRODUCT_GUID |
PRODUCT_GUID |
0CRM_PROD |
|
0CRM_SYS_PR |
Source System |
COMT_LOGSYS |
LOGSYS |
0CRM_SYS_PR |
|
0PROD_TYPE |
Product Type |
COMT_PRODUCT_TYPE |
PRODUCT_TYPE |
0PROD_TYPE |
|
0PROD_ID |
Product ID |
COMT_PRODUCT_ID |
PRODUCT_ID |
0PROD_ID |
|
0PROD_OBJFA |
Object Family |
COMT_PRODUCT_OBJECT_FAMILY |
OBJECT_FAMILY |
0PROD_OBJFA |
|
0CRM_PRCONF |
Configuration Product GUID |
COMT_PRODUCT_GUID |
CONF_PROD_GUID |
0CRM_PRCONF |
|
0DIVISION |
Division |
CRMT_DIVISION |
DIVISION |
0DIVISION |
|
0DUR_UNIT |
Unit of Duration of Work |
CRMT_PR_DURATION_UOM |
DURATION_UOM |
0DUR_UNIT |
|
0DURATION |
Duration of Work |
CRMT_PR_DURATION |
DURATION |
0DURATION |
|
0BASE_UOM |
Base UOM |
COMT_MAT_BASE_UOM |
BASE_UOM |
0BASE_UOM |
|
0CRM_PRIDCP |
Compound Product ID |
COMT_PRODUCT_ID |
PRODUCT_ID |
0CRM_PRIDCP |
|
0CRM_SRVESC |
Response Profile |
SRV_ESCAL |
SRV_ESCAL |
0CRM_SRVESC |
|
0CRM_SRVSWI |
Service Profile |
SRV_SERWI |
SRV_SERWI |
0CRM_SRVSWI |
0CRM_PR_MAT_ATTR
|
InfoObject |
Description |
Data Element |
Field in Transfer Structure |
Source |
|
0CRM_PROD |
CRM Product GUID |
COMT_PRODUCT_GUID |
PRODUCT_GUID |
0CRM_PROD |
|
0CRM_SYS_PR |
Source System |
COMT_LOGSYS |
LOGSYS |
0CRM_SYS_PR |
|
0PROD_TYPE |
Product Type |
COMT_PRODUCT_TYPE |
PRODUCT_TYPE |
0PROD_TYPE |
|
0PROD_ID |
Product ID |
COMT_PRODUCT_ID |
PRODUCT_ID |
0PROD_ID |
|
0MATERIAL |
R/3 Material Number |
MATNR |
MATNR |
0MATERIAL |
|
0SERVICE |
R/3 Service Number |
LSTNR |
LSTNR |
0SERVICE |
The fields in the transfer structure of the DataSource 0CRM_PROD_TEXT are mapped to the InfoObjects in the Business Information Warehouse. These InfoObjects are then assigned to the attributes of the InfoSource 0CRM_PROD according to the following table:
0CRM_PROD_TEXT
|
InfoObject |
Description |
Data Element |
Field in Transfer Structure |
Source |
|
0LANGU |
Language |
SPRAS |
LANGU |
0LANGU |
|
0CRM_PROD |
CRM Product GUID |
COMT_PRODUCT_GUID |
PRODUCT_GUID |
0CRM_PROD |
|
0TXTSH |
Description Short |
COMT_PRSHTEXTX |
SHORT_TEXT |
0TXTSH |
|
0TXTMD |
Description Medium |
COMT_PRSHTEXTX |
SHORT_TEXT |
0TXTMD |
|
0TXTLG |
Description Long |
COMT_PRSHTEXTX |
SHORT_TEXT |
0TXTLG |
The hierarchy data is provided by the DataSource 0CRM_PROD_HIER. The intermediate nodes of a product hierarchy are InfoObjects of the type 0PROD_CATEG and the end nodes are InfoObjects of the type 0CRM_PROD. The hierarchy data is neither time-dependent nor version-dependent.
Additional Information
Product Categories Product Master Data (EBP) CRM Financing Product Master Data CRM Product (Sales) Master Data CRM Financing Product (Sales) Master Data