Select language:
Entering content frame!--a11y-->

Background documentation Master Data in SAP BW 

Use

In the SAP Trade Promotion Management Business Scenario, you use the following master data.

Procedure

...

  1.  In SAP BW, activate the InfoSources given in the table below.

For general information on the procedure, see the SAP Library under SAP NetWeaver ® SAP Business Information Warehouse ® Administrator Workbench ® Business Content (Versions) ® Installing Business Content.

  2.  In the source system, activate the DataSources given in the table below and replicate the DataSources in SAP BW.

To replicate the metadata of a DataSource in SAP BW, choose Source System Tree ® Your Source System ® Your Application Components ® Your DataSource ® Context Menu (right mouse button) ® Replicate DataSources. For more information on data extraction see the SAP Library under Business Information Warehouse ® Administrator Workbench ® Modeling ® Source System ® Data Extraction from SAP Source Systems.

  3.  Assign the DataSources to the InfoSources as shown in the table and activate the related transfer rules.

For general information on the procedure, see the SAP Library under SAP NetWeaver ® SAP Business Information Warehouse ® Administrator Workbench ® Modeling ® Source System ® Data Extraction from SAP Source Systems ® DataSource ® Assigning DataSources to InfoSources and Fields to InfoObjects.

  4.  Schedule an InfoPackage and start it.

For more information on Info Packages, see the SAP Library under Business Information Warehouse ® Administrator Workbench ® Administration ® Scheduler.

Load the master data in the following order:

  a.  Standard attributes and texts for the following InfoObjects:

  i.  0BARTNER

  ii.  0CRM_PROD

  iii.  0PROD_CATEG

  iv.  0BP_GRP

  v.  0CUSTOMER

  vi.  0MATERIAL

  b.  Additional attributes from SAP CRM for:

  i.  0CUSTOMER

  ii.  0MATERIAL

  c.  Hierarchies for

  i.  0CRM_PROD

  ii.  0BPARTNER (optional)

  d.  Attributes for

  i.  0CRM_MKGUID

  ii.  0CRM_MKTELM (optional)

  e.  Attributes and texts for WBS_ELEMT

Master Data Overview

Business Partner

InfoObject

InfoSource

DataSource

System

Notes

0BPARTNER

0BPARTNER_ATTR

0BPARTNER_ATTR

CRM

Attributes

 

0BPARTNER_TEXT

0BPARTNER_TEXT

CRM

Texts

 

0BPARTNER

0CRM_BPART_BPGH_NAME_HIER

CRM

Hierarchy (Name time-dependent)

 

 

0CRM_BPART_BPGH_STRUCT_HIER

CRM

Hierarchy (structure time-dependent)

 

BP: Business Partner Group (from Hierarchy)

InfoObject

InfoSource

DataSource

System

Notes

0BP_GRP

0BP_GRP

0CRM_BP_GRP_ATTR

CRM

Hierarchy nodes for 0BPARTNER

 

 

0CRM_BP_GRP_TEXT

CRM

Hierarchy nodes for 0BPARTNER

 

Product

InfoObject

InfoSource

DataSource

System

Notes

0CRM_PROD

0CRM_PROD_ATTR

0CRM_PRODUCT_ATTR

CRM

Attributes (CRM)

 

 

0COM_PRODUCT_ATTR

CRM

Attributes

 

 

0CRM_PR_MAT_ATTR

CRM

Fills attributes OMATERIAL in 0CRM_PROD

 

0CRM_PROD_TEXT

0COM_PRODUCT_TEXT

CRM

Texts

 

0CRM_PROD

0COM_PRODUCT_HIER

CRM

Hierarchy

 

Product category

InfoObject

InfoSource

DataSource

System

Notes

0PROD_CATEG

0PROD_CATEG

0PROD_CATEG_ATTR

CRM

Hierarchy nodes for 0CRM_PROD

 

 

0PROD_CATEG_TEXT

CRM

Hierarchy nodes for 0CRM_PROD

 

Sales Organization CRM

InfoObject

InfoSource

DataSource

System

Notes

0CRM_SALORG

0ORGUNIT

0CRM_ORGUNIT_SALES_ATTR

CRM

Attributes

 

 

0CRM_ORGUNIT_TEXT

CRM

Texts

 

Product group 1

InfoObject

InfoSource

DataSource

System

Notes

0CRM_PRGRP1

0CRM_PRGRP1

0CRM_PRGRP1_TEXT

CRM

Texts

 

CRM Marketing Element (Campaign and Marketing Plan)

InfoObject

InfoSource

DataSource

System

Notes

0CRM_MKTELM

0CRM_MKTELM

0CRM_MKTELM5_ATTR

CRM

Attributes

 

Marketing GUID for Projects and Transactions

InfoObject

InfoSource

DataSource

System

Notes

0CRM_MKGUID

0CRM_MKGUID

0CRM_MKGUID_ATTR

CRM

GUID and Marketing ID

 

Work Breakdown Structure Element (WBS Element)

InfoObject

InfoSource

DataSource

System

Notes

0WBS_ELEMT

0WBS_ELEMT_ATTR

0WBS_ELEMT_ATTR

R/3

Attributes

 

0WBS_ELEMT

0WBS_ELEMT_TEXT

R/3

Texts

 

Customer number

InfoObject

InfoSource

DataSource

System

Notes

0CUSTOMER

0CUSTOMER

0CUSTOMER_ATTR

R/3

Attributes

 

 

0CUSTOMER_TEXT

R/3

Texts

 

 

0CRM_CUST_ATTR

CRM

Fills attribute 0BPARTNER in 0CUSTOMER

 

Material

InfoObject

InfoSource

DataSource

System

Notes

0MATERIAL

0MATERIAL_ATTR

0MATERIAL_ATTR

R/3

Attributes

 

0MATERIAL

0MATERIAL_TEXT

R/3

Texts

 

 

0CRM_PROD_2_ATTR

CRM

Fills attribute 0CRM_PROD in OMATERIAL

 

Sales organization

InfoObject

InfoSource

DataSource

System

Notes

0SALESORG

0SALESORG

0SALESORG_ATTR

R/3

Attributes

 

 

0SALESORG_TEXT

R/3

Texts

 

Distribution channel

InfoObject

InfoSource

DataSource

System

Notes

0DISTR_CHAN

 

0DISTR_CHAN_TEXT

R/3

Texts

 

Division

InfoObject

InfoSource

DataSource

System

Notes

0DIVISION

 

0DIVISION_TEXT

R/3

Texts

 

 

Leaving content frame