Select language:

Procurement Value Analysis

Query Query: /IMO/PUR_M01_Q0001

 

This query displays the trend of procurement values per vendor. You can start further analyses, according to material group, material, purchasing group, or purchasing organization, or according to time per contract, for example. The query is intended for rough analysis of procurement behavior.

This query is based on the MM-PUR: Purchase Overview (/IMO/PUR_M01) MultiProvider.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Info Provider

0INFOPROV

Restricted by value /IMO/PUR/D12

Characteristic Characteristic

Purchasing Organization

0PURCH_ORG

Variable 0S_PUROR

Selection option

Optional

Characteristic Characteristic

Purchasing Group

0PUR_GROUP

Variable 0S_PURGR

Selection option

Optional

Characteristic Characteristic

Vendor

0VENDOR

Variable 0S_VEND

Selection option

Optional

Characteristic Characteristic

Material Group

0MATL_GROUP

Variable 0S_MATGR

Selection option

Optional

Characteristic Characteristic

Material

0MATERIAL

Variable 0S_MATERIAL

Selection option

Optional

Characteristic Characteristic

Calendar Year/Month

0CALMONTH

Variable 0CML3CM

Optional

Interval

Last 3 months as default

Characteristic Characteristic

Purchase Document Category

0DOC_CAT

Restricted in default values by

F = Purchase Order

and

L = Scheduling agreement

Characteristic Characteristic

Item Deleted

0ITEM_DEL

Restricted in default values by

# Not assigned

(only include not deleted purchase documents)

Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

Purchasing Organization

0PURCH_ORG

Characteristic Characteristic

Purchasing Group

0PUR_GROUP

Characteristic Characteristic

Plant

0PLANT

Characteristic Characteristic

Item Deleted

0ITEM_DEL

Characteristic Characteristic

Material

0MATERIAL

Characteristic Characteristic

Material Group

0MATL_GROUP

Characteristic Characteristic

Flag for Contracts

0CT_FLAG

Characteristic Characteristic

Final Delivery

0COMPL_DEL

Characteristic Characteristic

Returns Item

0RET_ITEM

Characteristic Characteristic

Purchasing Document Category

0DOC_CAT

Characteristic Characteristic

Purchasing Document Type

0DOCTYPE

Characteristic Characteristic

Item Category

0ITM_CAT

Characteristic Characteristic

Purchasing Document

0OI_EBELN

Characteristic Characteristic

Item

0OI_EBELP

Characteristic Characteristic

Schedule Line

0SCHED_LINE

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Vendor

0VENDOR

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Calendar Year / Month

0CALMONTH

Key Figure Key Figure

Net Order Value in Local Currency

0SR_POVLC

Returns Item (0RET_ITM) = #

Key Figure Key Figure

Net Return Value in Local Currency

0SR_POVLC

Returns Item (0RET_ITM) = X