Query
SBO: Purchase Activities
Technical Name: 0SBO_C11_Q002
Use
This query enables you to display purchasing activities in relation to materials and vendors from the SAP Business One system. You can compare the following key figures:
· Number of PO Items
· PO Value
· PO Quantity
· Number of Delivery Items
· GR Value
· GR Quantity
· Invoiced Value
· Invoiced Quantity
Filter
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0VTYPE |
Value type (Single value ‘10’ (Actual)) |
Free Characteristics
|
InfoObject |
Description |
|
0VENDOR |
Vendor |
|
0PURCH_ORG |
Purchasing org. |
|
0CALMONTH |
Cal. Year/Month |
|
0CALWEEK |
Calendar Year/Week |
|
0CALDAY |
Calendar Day |
Variables Used
|
Variable |
Description |
|
0S_VEND |
Vendor number |
|
0S_PUROR |
Purchasing organization |
|
0I_DAYIN |
Day Interval |
|
0S_MAT |
Material (Selection Options, Optional) |
Rows
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0MATERIAL |
Material |
Columns
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0PO_ITEMS |
No of PO items |
|
0ORDER_VAL |
PO Value |
|
0PO_QTY |
PO Quantity |
|
0DELIVERIES |
No of Delivery items |
|
0GR_VAL |
GR Value |
|
0GR_QTY |
GR Quantity |
|
0INVCD_AMNT |
Invoiced Value |
|
0IV_REC_QTY |
Invoiced Quantity |