Data exchange with flat files is implemented in both SAP solutions that process data supplied by D&B, namely:

• D&B Vendor/Customer Analytics For SAP BW
• D&B Marketing Universe For SAP BW

While these two solutions are fulfilled, at least initially, from different sources, there are a number of similar or identical file requirements common to both solutions.

Where possible, these requirements have been harmonized. In those cases where the file formats are identical, a common name is used, even where the actual use to which the data is put differs slightly.

In order to distinguish between files that are common to both solutions and those that are peculiar to one or the other, technical names are used as well as the common descriptions.

The text files have a suffix depending on the solution: MU for Marketing Universe or VC or Vendor/Customer. For those files used in both solutions, the following conventions apply:

• Files that are uploaded initially and are used by both solutions have no suffix.
• For files that are uploaded repeatedly and are used in both solutions, the MU or VC suffix be added.
• Some of the files are delivered with Business Content. Those files have no suffix.

In the following, the file structures are described. For each file you find the definition of the fields contained in that file, that is field name, description, data type and field length. All files for import into BW are in csv format with a comma as separator.

During data upload, the fields of the data source are mapped to the corresponding InfoObjects. The name of a corresponding InfoObject has an 0 prefix and is otherwise identical to the field name, for example the CUSTOMER field is mapped to the 0CUSTOMER InfoObject.