Start of Content Area

Background documentation Files for Both D&B Solutions for SAP BW (Uploaded Repeatedly)  Locate the document in its SAP Library structure

Common Description

Technical Name

Price/Status D&B Vendor/ Cust. Analytics

Price/Status D&B Marketing Universe

Comments

BW Export File

See BW Export File

Standard

Standard

For both solutions, the same export file format is generated using a standard BW query. The file is then used to carry out the matching process at D&B.

D-U-N-S Family Tree File

0DBDUNS_NUM_HIER_MU.csv

0DBDUNS_NUM_HIER_VC.csv

Standard

Not part of standard solution, requested as option

File in format that is loadable into BW hierarchy format.

Process, developed by Doug Jolly, generates file from Worldbase.

D-U-N-S Text File

0DBDUNS_NUM_TEXT_MU.csv

0DBDUNS_NUM_TEXT_VC.csv

Optional (additional cost)

Standard

Comprises D-U-N-S number with textual description. Includes Global Ultimate D-U-N-S for all records in delivered Abstract Data or in delivered 1784 File

D-U-N-S Contact Details File

0DBDUNS_NUM_CONT_MU.csv

0DBDUNS_NUM_CONT_VC.csv

Optional (additional cost)

Supplied only for those records for which it is requested

Contains names, addresses, phone numbers and so on to be used in contacting the organization.

End of Content Area