InfoPackages for Initial Upload

Together with the first D&B data files you also receive some D&B files containing customer-independent information. These files need to be uploaded only once. To prepare the upload process you create the required InfoPackages.

The following table shows the files you get from D&B for the initial upload. For each file you create one InfoPackage. In the right column you see the InfoObjects to which the new InfoPackages belong.

D&B File	Technical name	InfoObject for which you create the InfoPackage
Legal Status Text File	0DBLGLSTAT_TEXT.CSV	0DBLGLSTAT
D&B Rating Net Worth - Text	0DBRATENW_TEXT_MU.CSV	0DBRATENW
D&B Rating Condition – Text	0DBRATECON_TEXT_MU.CSV	0DBRATECON
D&B Score - Text	0DBSCORE_TEXT_MU.CSV	0DBSCORE
D&B Sector Code - Text	0DBSECTCOD_TEXT_MU.CSV	0DBSECTCOD
Country Code Text File	0DBCTRYCOD_TEXT.CSV	0DBCTRYCOD
D&B Region Code - Text	0DBREGCOD_TEXT_MU.CSV	0DBREGCOD
D&B Area Code - Text	0DBAREACOD_TEXT_MU.CSV	0DBAREACOD
D&B District Code - Text	0DBDISTRCOD_TEXT_MU.CSV	0DBDISTRCOD
SIC Text File	0DB87SIC1_TEXT.CSV	0DB87SIC1
SIC Hierarchy File	0DB87SIC1_HIER.CSV	0DB87SIC1

All the InfoPackages have got the same pattern as described in following table. Create the InfoPackages with this information.

Tab	Field	Value
Select data
		No entries required
External data
	Load external data from	Application server
	File name	A combination of the path of the working directory on the application server and the file name For example D:\usr\sap\QB5\D19\work/0DBLGLSTAT_TEXT.CSV for InfoPackage 0DBLGLSTAT_TEXT Ask your system administrator which directories the files will be stored in (see also Storing D&B Data on an Application Server)
	Control file	No
	File type	CSV file
	Data separator	,
	Escape sign	"
External data parameters
	Thousand separator	,
	Character for decimal point	.
	Number of headers that should be ignored when loading	1
Processing
	Update data	PSA and then in the InfoObject
Update parameters
	Update mode	Full update

InfoPackages for Repeated Upload

Each time D&B provides new data, the master data for the InfoObjects DUNS Number (0DBDUNS_NUM) and Customer number (0CUSTOMER) require updating. If you are using a SAP CRM system, the InfoObject Business Partner (0BPARTNER) also requires updating. The data has also to be loaded into the MarketingCube. For this purpose the following files are sent from D&B:

• 
  
D&B Marketing Universe Matched Client File (0DB_IMPORTFILE_MU.csv)
• 
  
D-U-N-S Text File (0DBDUNS_NUM_TEXT_MU.csv)
• 
  
D&B Universe of Abstract Data (0DBDUNS_NUM_ABSTRACT_MU.csv)

The first time you get data from D&B, D&B provides these files in addition to the files required for initial upload.

For the InfoObjects 0CUSTOMER, 0BPARTNER and 0DBDUNS_NUM new InfoPackages are required. The D&B Marketing Cube (InfoSource 0DB_MKT_1) needs one new InfoPackage as well.

• For the InfoObject 0DBDUNS_NUM you create four InfoPackages for the different data sources:

• One for the text description (data source 0DBDUNS_NUM_TEXT)
• Three for the master data upload (for each data source 0DBDUNS_NUM_ATTR, 0DBDUNS_NUM2_ATTR, 0DBDUNS_NUM3_ATTR).

• For each of the InfoObjects 0CUSTOMER and 0BPARTNER and for the D&B Marketing Cube (InfoSource 0DB_MKT_1) you create one new InfoPackage.

The parameters of the InfoPackages are described in the following tables. Create the InfoPackages with this information.

InfoPackages 0DBDUNS_NUM_TEXT, 0DBDUNS_NUM_ATTR and 0DBDUNS_NUM3_ATTR

Tab	Field	Value
Select data
		No entries required
External data
	Load external data from	Application server
	File name	A combination of the path of the working directory on the application server and the file name. For example D:\usr\sap\QB5\D19\work/0DBDUNS_NUM_ABSTRACT_MU.CSV for InfoPackage 0DBDUNS_NUM_ATTR D:\usr\sap\QB5\D19\work/0DBDUNS_NUM_CONT_MU.csv for InfoPackage 0DBDUNS_NUM3_ATTR D:\usr\sap\QB5\D19\work/0DBDUNS_NUM_TEXT_MU.csv for InfoPackage 0DBDUNS_NUM_TEXT Ask your system administrator which directories the files will be stored in (see also Storing D&B Data on an Application Server)
	Control file	No
	File type	CSV file
	Data separator	,
	Escape sign	"
External data parameters
	Thousand separator	,
	Character for decimal point	.
	Number of headers that should be ignored when loading	1
Processing
	Update data	Only PSA and then in the InfoObject
Update parameters
	Update mode	Full update

InfoPackage 0DBDUNS_NUM2_ATTR, 0CUSTOMER and 0BPARTNER

Tab	Field	Value
Select data
		No entries required
External data
	Load external data from	Application server
	File name	A combination of the path of the working directory on the application server and the file name. For example D:\usr\sap\QB5\D19\work/0DB_IMPORTFILE_MU.csv Ask your system administrator which directories the files will be stored in (see also Storing D&B Data on an Application Server)
	Control file	No
	File type	CSV file
	Data separator	,
	Escape sign	"
External data parameters
	Thousand separator	,
	Character for decimal point	.
	Number of headers that should be ignored when loading	1
Processing
	Update data	Only PSA Update Subsequently in Data Targets Ignore Double Data Records
Update parameters
	Update mode	Full update

InfoPackage for InfoSource 0DB_MKT_1

Tab	Field	Value
Select data
		No entries required
External data
	Load external data from	Application server
	File name	A combination of the path of the working directory on the application server and the file name. For example D:\usr\sap\QB5\D19\work/0DB_IMPORTFILE_MU.csv Ask your system administrator which directories the files will be stored in (see also Storing D&B Data on an Application Server)
	Control file	No
	File type	CSV file
	Data separator	,
	Escape sign	"
External data parameters
	Thousand separator	,
	Character for decimal point	.
	Number of headers that should be ignored when loading	1
Processing
	Update data	PSA and then in the InfoObject
Data targets
		Select data targets Under the column Updating the data target, mark the field that refers to the D&B Marketing Cube
Update parameters
	Update mode	Full update
	Error Handling	Valid records update, reporting possible (request green)
	Error Handling – Termination by no. errors	9999999999