Wednesday, April 16, 2008

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.

Leaving content frame

No comments:

Blog Archive