Start of Content Area

Procedure documentation Rationalizing Customer and Business Partner Master Data  Locate the document in its SAP Library structure

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:

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.
  5. A dialog box for country selection appears.

  6. In the dialog box, choose the required option:
  1. Click on the Execute icon to generate the flat file.
  2. 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.

  3. 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.

End of Content Area