D&B Invoiced Amount per Vendor with Family Tree
D&B Invoiced Amount per Vendor with Family Tree
Technical name: 0PUR_C01_DB_Q01
Based on InfoCube: 0PUR_C01
Use
This query provides an overview of the invoiced amount per vendor. Displaying the D&B family free gives you an overview of how the invoiced amount may be summed up looking at inter-company relationships.
Filter
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0VALUETYPE |
Only Actual Values (Valuetype = 10) |
Free Characteristics
|
InfoObject |
Description |
|
0CALMONTH |
Calender Month (var) |
|
0VENDOR |
Vendor (var) |
|
0VENDOR__0DB87SIC1 |
SIC Code of Vendor (var) |
|
0VENDOR__0COUNTRY |
Country of Vendor |
Rows
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0VENDOR__0DBDUNS_NUM |
D-U-N-S Number |
Add your name of the D-U-N-S family tree to this query and save it again. Since the name of this family tree varies, it may not be delivered in a pre-configured way.
Columns
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0IV_REC_QTY |
Invoiced Quantity |
|
0INVCD_AMNT |
Invoiced Amount |