D&B Duplicate Vendors per one D-U-N-S Number
D&B Duplicate Vendors per one D-U-N-S Number
Technical name: 0PUR_C01_DB_Q02
Based on InfoCube: 0PUR_C01
Use
This query shows for all D-U-N-S numbers which vendor numbers are related to them. It therefore facilitates identification of duplicate vendor numbers.
This query reads a lot of transaction data. The response time may therefore be quite high. However in order to capture all duplicates, an unfiltered view of the data is required. When dealing with great volumes of vendor records, add a variable for the D-U-N-S number to receive reports with a "usable" amount of records.
Free Characteristics
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0VENDOR__0COUNTRY |
Country of Vendor |
Rows
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0VENDOR__0DBDUNS_NUM |
D-U-N-S Number |
|
0VENDOR |
Vendor |
Columns
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0INVCD_AMNT |
Invoiced Amount |