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 |