Uploading Repeatedly Delivered D&B Files

Use

In addition to the D&B files delivered only once, you also get the following files:

D&B file	Technical Name
D-U-N-S Text File	0DBDUNS_NUM_TEXT_VC.csv
D-U-N-S Family Tree File	0DBDUNS_NUM_HIER_VC.csv
D-U-N-S Contact Details File (optional)	0DBDUNS_CONT_VC.csv
Vendor/Customer Analytics Import File	0DB_IMPORTFILE_VC.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 D-U-N-S number and the vendor number (0VENDOR) and/or customer number require updating. The upload process for these files can be described as a five step procedure.

Prerequisites

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

Procedure

Uploading D-U-N-S Text Files

Data source: 0DBDUNS_NUM_TEXT

Upload the D-U-N-S Text File (0DBDUNS_NUM_TEXT_VC.csv) into the D-U-N-S number (InfoObject 0DBDUNS_NUM).

For step-by-step instructions, see Uploading Initially Delivered D&B Files .

Uploading D-U-N-S Family Tree Files

Data source: 0DBDUNS_NUM_HIER

Upload the D-U-N-S Family Tree File (0DBDUNS_NUM_HIER_VC.csv) into the D-U-N-S number (InfoObject 0DBDUNS_NUM).

For step-by-step instructions, see Uploading Initially Delivered D&B Files .

Uploading D-U-N-S Contact Information Files

Data source: 0DBDUNS_NUM3_ATTR

If you also requested detailed address information for your vendors, D&B returns the D-U-N-S Contact Details File (0DBDUNS_CONT_VC.csv). Upload this file into the D-U-N-S number (InfoObject 0DBDUNS_NUM).

For step-by-step instructions, see Uploading Initially Delivered D&B Files .

Uploading Vendor/Customer Analytics Import File

Note Note

You can change the transfer rules to handle particular situations, for example, the same D-U-N-S number has been matched to more than one vendor or customer number, a D-U-N-S number is listed as having been changed or deleted and so on. Changes to a transfer rule have to be done before you upload Vendor/ Customer Analytics Import Files.

End of the note.

Data source: 0DBDUNS_IMPORT_ATTR

Upload the Vendor/Customer Analytics Import File (0DB_IMPORTFILE_VC.csv) into the customer number (InfoObject 0CUSTOMER / 0VENDOR). Data target 0CUSTOMER / 0VENDOR is provided with flexible updating from InfoSource 0DBDUNS_IMPORT_ATTR.

The InfoObject 0VENDOR / 0CUSTOMER is enhanced with the D-U-N-S Number and current data provided by D&B.During the upload, the match recommended flag in the vendor master data should be cleared – that is set to the constant space – for each vendor (see also Customizing the Match Recommended Flag )

For step-by-step instructions, see Uploading Initially Delivered D&B Files .

Applying Attribute Changes

After the D-U-N-S number, vendor master data, and customer master data has been reloaded, you have to apply attribute changes to the InfoObjects 0DBDUNS_NUM, 0VENDOR, and/or 0CUSTOMER.

To apply attribute changes to an InfoObject, proceed as follows:

From the Administrator Workbench menu, select Tools and then Apply Hierarchy/Attribute change .

Click on the InfoObject list button.

Select the InfoObject to be activated and deselect any other InfoObjects.

Click on the Save InfoObject list icon.

Click on the Execute button.