D&B Invoiced Amount per Vendor with
Family Tree
Technical name: 0SD_C03_DB_Q0001
Basierend auf dem InfoCube 0SD_C03
Use
This query returns an overview of the invoiced amount per customer. Displaying the D&B family tree gives you an overview of how the invoiced amount can be aggregated within the organization.
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 (variable) |
|
0CALMONTH |
Month/calendar year (variable) |
|
0SOLD_TO |
Sold to party (variable) |
|
0SOLD_TO__0DB87SIC1 |
Sold-to party US 1987 SIC Code (variable) |
|
0MATERIAL__0MATL_GROUP |
Material group (variable) |
Rows
|
InfoObject |
Description of the InfoObject (or Restriction or Calculation Formula) |
|
0SOLD_TO__0DBDUNS_NUM |
DUNS number (hierarchy) |
Columns
|
Info Object |
Description of the InfoObject (or Restriction or Calculation Formula) |
|
0INV_VALUE |
Billing value |
|
0INV_QTYQ |
Invoiced quantity |