Technical name: 0MMPUR_C04_Q01
Based on InfoCube:
0PUR_C04Use
This Query enables you to analyze the distribution of purchasing activities per purchasing group. It helps you to find answers to questions such as the following: "What is the total value of the orders placed by a certain purchasing group?" "How many POs were placed with a certain vendor, and what was the total value of these orders?"
Filter
InfoObject |
Description of InfoObject (or Restriction or Calculation Formula) |
| 0VTYPE |
Value type (=ACTUAL) |
Free Characteristics
InfoObject |
Description |
| 0PURCH_ORG |
Purchasing organization |
| 0VENDOR |
Vendor |
| 0CALMONTH |
Calendar year/month |
Rows
InfoObject |
Description of InfoObject (or Restriction or Calculation Formula) |
| 0PUR_GROUP |
Purchasing group |
Columns
InfoObject |
Description of InfoObject (or Restriction or Calculation Formula) |
| 0NO_REQ_QUT |
Number of RFQs |
| 0RFQ_ITEMS |
Number of RFQ items |
| 0QUOT_ITEMS |
Number of quotation items |
| 0PO_ITEMLNS |
Number of purchase order schedule lines |
| 0PO_ITEMS |
Number of purchase order items |
| 0NO_PUR_ORD |
Number of purchase orders |
| 0CONTRACTS |
Number of contracts |
| 0CONTR_ITEM |
Number of contract items |
| 0SCHED_AGR |
Number of scheduling agreements |
| 0DEL_SCHEDS |
Number of scheduling agreement schedule lines |
| 0SCH_AGR_IT |
Number of scheduling agreement items |
| 0DELIVERIES |
Number of deliveries |
| 0ORDER_VAL |
Effective order value |
| 0INVCD_AMNT |
Invoiced amount |
The following additional queries are available for the analysis of purchasing groups: