Start of Content Area

Background documentation D-U-N-S Text File  Locate the document in its SAP Library structure

Technical name: 0DBDUNS_NUM_TEXT_MU.csv (D&B Marketing Universe for SAP BW solution), 0DBDUNS_NUM_TEXT_VC.csv (D&B Vendor/Customer Analytics for SAP BW solution)

Loaded with data source: 0DBDUNS_NUM_TEXT

In addition to the BW import files (0DB_IMPORTFILE_MU.csv and 0DB_IMPORTFILE_VC.csv) and the D-U-N-S Family Tree file, there is a corresponding D-U-N-S Text file containing the D-U-N-S numbers used in the BW import and D-U-N-S Family Tree files along with the company names. BW requires this information to display a D-U-N-S number description in queries and hierarchy displays.

All D-U-N-S numbers included in the BW import and D-U-N-S Family Tree file should be listed in the D-U-N-S Text file.

File Structure

Field

Description

Type

Length

DBDUNS_NUM

D-U-N-S number

NUMC

9

TXTLG

Company name

CHAR

60

End of Content Area