InfoPackages for Repeated Upload 
Both vendor analysis and customer analysis scenarios will be described here. If you are implementing only one scenario then descriptions for the other scenario have no relevance.
Each time D&B provides new data, the master data for the InfoObjects DUNS Number (0DBDUNS_NUM), Vendor (0VENDOR), and Customer number (0CUSTOMER) require updating. For this purpose the following files are sent from D&B:
· Vendor/Customer Analytics Import File (0DB_IMPORTFILE_VC.csv)
· D-U-N-S Text File (0DBDUNS_NUM_TEXT_VC.csv)
· D-U-N-S Family Tree File (0DBDUNS_NUM_HIER_VC.csv)
· Optionally the D-U-N-S Contact Details File (0DBDUNS_CONT_VC.csv)
The first time you receive data from D&B, D&B provides these files in addition to the files required for initial upload.
For the InfoObjects 0DBDUNS_NUM, 0VENDOR, and 0CUSTOMER new InfoPackages are required.
· For the InfoObject 0DBDUNS_NUM you create three InfoPackages for the different data sources:
¡ One for the text description (data source 0DBDUNS_NUM_TEXT)
¡ Two for the master data upload (one for each data source 0DBDUNS_NUM3_ATTR and 0DBDUNS_NUM_HIER).
· For the InfoObjects 0VENDOR and 0CUSTOMER you create one new InfoPackage.
InfoPackage parameters are described in the following tables. Use this information to create InfoPackages.
InfoPackages 0DBDUNS_NUM_TEXT, 0DBDUNS_NUM3_ATTR and 0DBDUNS_NUM_HIER
|
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_TEXT_VC. D:\usr\sap\QB5\D19\work/0DBDUNS_NUM_HIER_VC. 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 |
InfoPackage 0VENDOR
|
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 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 |
|
|
Error Handling |
Valid records update, reporting possible (request green) |
|
|
Error Handling – Termination by no. errors |
9999999999 |
InfoPackage 0CUSTOMER – only relevant for customer analysis scenario
|
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 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 data targets |
|
|
Data targets |
Select data target 0CUSTOMER |
|
Update parameters |
|
|
|
|
Update mode |
Full update |
|
|
Error Handling |
Valid records update, reporting possible (request green) |
|
|
Error Handling – Termination by no. errors |
9999999999 |