Wednesday, April 16, 2008

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

Leaving content frame

No comments:

Blog Archive