Query MultiCube: Price Trends over the Last
Three Months 
Technical Name: 0SBO_MC11_Q004
Use
This query allows you to examine the average price (per unit of measure) for materials both from the SAP Business One system as well as from the R/3 system. You always see the average prices for the last three months (including the current month). This enables you to assess short-term price changes.
Filter
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0VTYPE |
Value type (Single value ‘10’ (Actual)) |
Free Characteristics
|
InfoObject |
Description |
|
0PURCH_ORG |
Purchasing organization |
|
0VENDOR |
Vendor |
Variables Used
|
Variable |
Description |
|
0S_PUROR |
Purchasing organization |
|
0S_MAT |
Material (Selection Options, Optional) |
|
0S_VEND |
Vendor number |
|
0CML3CM |
Last 3 Months Including Current Month |
Rows
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0MATERIAL |
Material |
Columns
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0CALMONTH |
Cal. Year/Month |
|
0SBO_C11_CK005 |
Price (NDIV0 ( 'Invoiced amount' / NODIM ( 'Invoiced quantity' ) ) |