ploading Repeatedly Delivered D&B Files

Purpose

In addition to the D&B files delivered only once (see Uploading Initially Delivered D&B Files) you also get the following files:

D&B file	Technical Name
D&B Marketing Universe Matched Client File	0DB_IMPORTFILE_MU.csv
D-U-N-S Text File	0DBDUNS_NUM_TEXT_MU.csv
D&B Universe of Abstract Data	0DBDUNS_NUM_ABSTRACT_MU.csv

These files are also delivered each time you request new data from D&B, for example on a six-monthly or quarterly basis depending on your contract with D&B.

Each time D&B provides new data both the master data for the InfoObjects D-U-N-S number and vendor number (0VENDOR) require updating. If a SAP CRM system is involved, the business partner number requires updating, too. The data also has to be loaded into the InfoCube D&B Marketing Cube.

The process of uploading D&B data is simplified significantly by using process chains. The process chains delivered by SAP enable the automatic upload of D&B master and transactional data.

Prerequisites

You have successfully performed the previous steps of the upload process.

Process

The upload process for these files can be described as a ten-step procedure. The following chart gives an overview of the individual steps.

For a description of the individual steps, see:

· Uploading the D-U-N-S Text File

· Uploading D&B's Universe of Abstract Data

· Enhancing the D-U-N-S Number with Status Information

· Applying Attribute Changes to InfoObject D-U-N-S Number

· Updating InfoObject Customer Number

· Applying Attribute Changes to InfoObject Customer Number

· Updating InfoObject Business Partner

· Applying Attribute Changes to InfoObject Business Partner

· Enhancing Business Partner in SAP CRM with D-U-N-S Number

· Uploading Transactional Data into the Marketing Cube

Uploading Initially Delivered D&B Files

Use

The following D&B files are required for initial upload only:

D&B file	Technical Name
Legal Status Text File	0DBLGLSTAT_TEXT.CSV
D&B Rating Net Worth - Text	0DBRATENW_TEXT_MU.CSV
D&B Rating Condition – Text	0DBRATECON_TEXT_ MU.CSV
D&B Score - Text	0DBSCORE_TEXT_MU.CSV
D&B Sector Code - Text	0DBSECTCOD_TEXT_MU.CSV
Country Code Text File	0DBCTRYCOD_TEXT.CSV
D&B Region Code - Text	0DBREGCOD_TEXT_MU.CSV
D&B Area Code - Text	0DBAREACOD_TEXT_MU.CSV
D&B District Code - Text	0DBDISTRCOD_TEXT_MU.CSV
SIC Text File	0DB87SIC1_TEXT.CSV
SIC Hierarchy File	0DB87SIC1_HIER.CSV

Prerequisites

You have successfully performed the previous steps of the upload process.

Procedure

The process of uploading D&B data is simplified significantly by using process chains. The D&B Marketing Initial Data Load process chains enable the automatic uploading of initially delivered D&B data (master data).

You can upload these files in any order. To start the upload for a file:

...

1. Select transaction rsa1.

2. If Modeling is not already selected in the left navigation window, choose Modeling and then InfoSources.

3. Expand the tree Non-SAP Sources ® Data Provider ® External Market Data ® Dun & Bradstreet ® Dun & Bradstreet Master Data.

4. Expand the tree for the element where you want to start the upload, for example, the InfoObject Legal Status 0DBLGLSTAT.

5. Expand the branch SAP Demo PC Files.

6. Right-click on the required InfoPackage and select Schedule from the context menu.

7. Start the data load.

8. Use the BW Monitor to check whether the D&B files have been uploaded successfully.

Rationalizing Customer and Business Partner Master Data

Use

To get your data D-U-N-S numbered you send all your customer and business partner data to D&B for rationalization. Rationalization means that D&B will match all customers and business partner to the unique D-U-N-S number.

The rationalization process requires a flat file listing all your customers and business partners. The flat file also contains necessary address and sales revenue information:

• The address data is needed by D&B to match the customer to the unique D-U-N-S number. For the identification, the customer name and address is required.
• The sales revenue of a customer is used as a measure of the importance of the customer to your company. This measure influences the effort D&B takes to match the customer. The sales revenue is derived from the standard Sales InfoCube 0SD_C03, which is filled from R/3 or from another 3^rd party transaction system.

Prerequisites

You have successfully performed the previous steps of the upload process.

Procedure

To create the flat file:

1. Select transaction rsmonitor_db.
2. Click on Rationalization.
3. Choose the query I_0SD_C03/0SD_C03_QDB001 for selection of customer and business partner data. Use of this query for rationalization is compulsory.
4. Click on the Execute icon.

A dialog box for country selection appears.

5. In the dialog box, choose the required option:

• If the rationalization process is supposed to be tested, you can choose a country for which you would like to extract all customers.
• If the customers extracted are for dispatch to D&B, it is absolutely essential that you do not choose a country.

6. Click on the Execute icon to generate the flat file.

You find the resulting flat file on the application server using transaction al11 in the default directory, for example your home directory DIR_HOME. The file name is BIC0CDBEXPnnn.ASCII, where nnn stands for a numeric counter. For a detailed description of the structure of the export file for the customer data, see BW Export File.

7. Send the flat file to D&B.

D&B processes the file and matches your customer and business partner data to the D-U-N-S number.

Procedure documentation Uploading Data from OLTP Systems

Procedure

First you have to upload the relevant master and transactional data. This step involves:

• Extraction of master data for the InfoObject Customer number (0CUSTOMER) from SAP R/3 (table KNA1) or other 3rd party source systems into BW
• Extraction of master data for the InfoObject Business Partner (0BPARTNER) from SAP CRM or another 3rd party CRM system into BW
• Extraction of the transactional data into the InfoCube 0SD_C03. The D&B Marketing Universe for SAP BW solution uses the billing information for the InfoCube. Therefore you should use at least InfoSource 2LIS_13_VDHDR and 2LIS_13_VDITM for filling the InfoCube.

The uploads are a prerequisite for any subsequent steps.

Uploading D&B Data for Marketing Universe

Purpose

The upload process for D&B data is typically repeated on a six-monthly or quarterly basis. This ensures that your company makes decisions on the most up to date market data.

Prerequisites

You have completed the preparatory steps, see Implementing D&B Marketing Universe for SAP BW.

Process

The process of uploading D&B data is simplified significantly by using process chains. The process chains delivered by SAP enable the automatic upload of D&B master and transactional data.

The following chart gives an overview of your tasks during the whole process.

For a description of the individual steps, see:

· Uploading Data from OLTP Systems

· Rationalizing Customer and Business Partner Master Data

· Storing D&B Data on an Application Server

· Uploading Initially Delivered D&B Files

· Uploading Repeatedly Delivered D&B Files