Wednesday, April 16, 2008

Rationalizing Customer and Business Partner Master Data


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 3rd party transaction system.


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


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:
    • 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.
  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.

Leaving content frame

No comments:

Blog Archive