InfoPackages for Initial Upload (Optional)
InfoPackages for Initial Upload (Optional)
Together with the first D&B data files you also receive some D&B files containing customer-independent information. If you want to use the information delivered with these files, these files need to be uploaded 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 |
| Country Code Text File |
0DBCTRYCOD_TEXT.CSV |
0DBCTRYCOD |
| SIC Text File |
0DB87SIC1_TEXT.CSV |
0DB87SIC1 |
| SIC Hierarchy File |
0DB87SIC1_HIER.CSV |
0DB87SIC1 |
All the InfoPackages have 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 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 |
|
|
|
Processing |
||
|
Update data |
PSA and then in the InfoObject |
|
|
Update parameters |
||
|
Update mode |
Full update |