D-U-N-S Family Tree File
D-U-N-S Family Tree File
Technical name: 0DBDUNS_NUM_HIER_MU.csv (D&B Marketing Universe for SAP BW solution), 0DBDUNS_NUM_HIER_VC.csv (D&B Vendor/Customer Analytics for SAP BW solution)
Loaded with data source: 0DBDUNS_NUM_HIER
This file is optional for the D&B Marketing Universe for SAP BW solution.
For a description of the file contents, see
Family Trees.
File Structure
|
Field |
Description |
Type |
Length |
|
NODEID |
Internal ID of the hierarchy node (enumeration 00000001, 00000002 and so on) |
NUMC |
8 |
|
INFOOBJECT |
Name of the InfoObject (0DBDUNS_NUM or for dummy nodes ‘0HIER_NODE’) |
CHAR |
30 |
|
NODENAME |
For master data, the key of the master table (for dummy nodes enter an arbitrary name) |
CHAR |
32 |
|
LINK |
Leave blank |
CHAR |
1 |
|
PARENTID |
ID of the father node using leading zeros (enter 00000000 if there is none) |
NUMC |
8 |
|
CHILDID |
ID of the first child node using leading zeros (enter 00000000 if there is none) |
NUMC |
8 |
|
NEXTID |
ID of the first next node on the same hierarchy level using leading zeros (enter 00000000 if there is none) |
NUMC |
8 |
|
LANGU |
Language key (required only for dummy nodes), E for English |
CHAR |
1 |
|
TXTSH |
Text short (required for dummy nodes) |
CHAR |
20 |
|
TXTMD |
Text medium (required for dummy nodes) |
CHAR |
40 |
|
TXTLG |
Text long (required for dummy nodes) |
CHAR |
60 |
Child ID, Next ID: These fields are optional. They only must be supplied if the sequence of the nodes is supposed to be specified by the hierarchy file. The sequence is important for a family tree.
Language key, Description short, Description medium, Description long: These fields should be spaced since the D-U-N-S number description (name) is delivered with the D-U-N-S file. It is used for the root node only, that is the title dummy node.