Start of Content Area

Background documentation D&B Universe of Abstract Data  Locate the document in its SAP Library structure

Technical name: 0DBDUNS_NUM_ABSTRACT_MU.csv

Loaded with data source: 0DBDUNS_NUM_ATTR

0DBDUNS_NUM_ABSTRACT_MU.csv contains the D&B Universe of Abstract Data. The file contains relevant companies (identified by the D-U-N-S number) for an area previously specified by your company in a contract with D&B. A D&B Marketing Universe comprises for example all companies in Germany.

File Structure

Field

Description

Type

Length

DBDUNS_NUM

D-U-N-S number

NUMC

9

 

Company name

CHAR

90

DBCTYNAM

Town / city

CHAR

30

DBSECTCOD

Sector code

NUMC

13

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

LATITUDE

Latitude

Number

(KYF)

 

LONGITUDE

Longitude

Number

(KYF)

 

DBRATENW

Rating – net worth

CHAR

3

DBRATECON

Rating - condition

CHAR

1

DBSCORE

Score

CHAR

3

End of Content Area