BW Export File
Technical name: BIC0CDBEXPnnn.ASCII, where nnn stands for a numeric counter (D&B Marketing Universe for SAP BW solution), DBFILE.ASCII or a user-defined name (D&B Vendor/Customer Analytics for SAP BW solution)
If you are using the D&B Marketing Universe for SAP BW solution, the BW Export file contains address and sales revenue information on all of your customers and business partners (if a SAP CRM system is involved). The BW Export file is generated using a standard BW query.
If you are using the D&B Vendor/Customer for SAP BW solution, the BW Export file contains address information and the purchase amount of each vendor, such as sales for each customer. The BW Export file is generated using a standard BW export program that is based on a standard BW query.
The file is then sent to D&B used to carry out the matching process.
File Structure
|
Field |
Description |
Type |
Length |
|
DBSOURSYST |
BW source system ID |
CHAR |
2 |
|
DBDATAID |
Customer ID or Vendor ID |
CHAR |
10 |
|
BPARTNER |
Business partner ID |
CHAR |
10 |
|
DB_FILLER |
Customer defined filler |
CHAR |
50 |
|
NAME |
Name/Text of DBDATAID |
CHAR |
40 |
|
NAME2 |
Business Name 2 |
CHAR |
40 |
|
NAME3 |
Business Name 3 |
CHAR |
40 |
|
STREET |
Street Name and Number |
CHAR |
70 |
|
CITY |
City/Province |
CHAR |
40 |
|
REGION |
Region Code |
CHAR |
3 |
|
COUNTRY |
Country Code |
CHAR |
3 |
|
PHONE |
Telephone Number |
CHAR |
30 |
|
DBDUNS_NUM |
D-U-N-S Number |
CHAR |
9 |
|
P.O. BOX |
P.O. Box |
CHAR |
10 |
|
POSTCD_GIS |
Postal Code / Zip Code (Address) |
CHAR |
10 |
|
POSTCD_BOX |
Postal Code / Zip Code (P.O. box) |
CHAR |
10 |
|
TAX_NUMB |
Tax Number |
CHAR |
16 |
|
INV_RC_VAL |
Invoice Amount (1) |
DEC |
20 |
|
INV_RC_VALCURR |
Local Currency (Invoice Amount) |
CHAR |
5 |
|
ORDER_VAL |
Effective purchase order value, only filled within the D&B Vendor/Customer Analytics for SAP BW scenario |
DEC |
20 |
|
ORDER_VALCURR |
Currency (effective purchase order value) |
CHAR |
5 |
|
DB_ACTION |
Action Flag (2) |
CHAR |
1 |
(1) Invoice amount as at posting date. Derived from Purchasing InfoCube 0PUR_C01 (D&B Vendor/Customer Analytics for SAP BW) or from Sales InfoCube 0SD_C03 (D&B Marketing Universe for SAP BW). Converted into one currency, no decimal places transferred.
(2) Only used within the D&B Vendor/Customer Analytics for SAP BW scenario. The action flag influences processing on D&B’s side. It is set during the export process according to your choices:
M = Match. Usually set for new or changed records
R = Refresh. Set with no identification of change
N = No match required. Set if another refresh is not required, either if a match has previously failed or if the last refresh has been relatively recent