InfoPackages for Initial Upload (SAP Library

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