Start of Content Area

Query D&B Duplicate Vendors per one D-U-N-S Number  Locate the document in its SAP Library structure

Technical name: 0SD_C03_DB_Q0002

Based on InfoCube 0SD_C03

Use

This query shows the customer numbers that are assigned to all D-U-N-S numbers. In this way, you are able to detect duplicate customer numbers very easily.

Filters

InfoObject

Description of the InfoObject (or Restriction or Calculation Formula)

0VTYPE

Only Actual Values (Value type = 10)

Free Characteristics

InfoObject

Description

0SOLD_TO__0COUNTRY

Sold to country

Rows

InfoObject

Description of the InfoObject (or Restriction or Calculation Formula)

0SOLD_TO__0DBDUNS_NUM

DUNS number

0SOLD_TO

Sold-To Party

Columns

Info Object

Description of the InfoObject (or Restriction or Calculation Formula)

0INV_VALUE

Billing value

 

 

End of Content Area