Start of Content Area

Background documentation D&B Marketing Universe Matched Client File  Locate the document in its SAP Library structure

Technical name: 0DB_IMPORTFILE_MU.csv

Loaded with data source: 0CUSTOMER_ATTR, 0BPARTNER_ATTR and 0DBDUNS_NUM2_ATTR

The D&B Marketing Universe Matched Client File contains the following information:

It also contains additional information like employee number, turnover band, D-U-N-S number of the H/Q parent and the global ultimate companies.

File Structure

Field

Description

Type

Length

DBSOURSYST

Source system key

CHAR

2

CUSTOMER

Customer ID

CHAR

10

BPARTNER

Business partner ID

CHAR

10

DBDUNS_NUM

D-U-N-S number

CHAR

9

DB_MATCDS

Match code

CHAR

8

DB_MAKTCOD

Marketability code

CHAR

1

 

Company name

CHAR

60

DBCTYNAM

City name

CHAR

30

DBCTRYCOD

Country code

CHAR

3

DB87SIC1

Full US 1987 SIC code

CHAR

4

DBEMPTOT

Total employees for company

NUMC

7

DBANSALES

Annual turnover

NUMC

18

DBLGLSTAT

Legal status

CHAR

3

DBYRSTD

Year started

CHAR

4

DBHQDUNS

HQ/Parent D-U-N-S number

NUMC

9

DBGUDUNS

Global ultimate parent D-U-N-S number

NUMC

9

DBLOCACOD

Location code

CHAR

1

End of Content Area