Purchasing Group Analysis 

Technical name: 0MMPUR_C04_Q01

Based on InfoCube: 0PUR_C04

Use

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: