Start of Content Area

Query Top 15 Categories Locate the document in its SAP Library structure

Technical Name: 0SR_FIC01_Q0007

Use

The Query shows the 15 categories in which your company has effected the greatest purchase order volume (effective net invoice volume in local currency) in the current quarter and four previous quarters.

Filter

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Structure link0CALQUARTER

Calendar year/quarter

Free Characteristics

InfoObject

Description

0PRODUCT_0CI_GRP_PRO

Group-ID Product

0PRODUCT

Product

0GN_AT_PUR_0CI_SPURCAT

Standard cat. reporting

0GN_CAT_PUR

Purchasing category

GN_CAT_PUR_0ECLASS_AV

Current version eCl@ss

GN_CAT_PUR_0ECLASS_AC

Current eCl@ss

GN_CAT_PUR_0UNSPSC_AV

Current version UNSPSC

The characteristic Standard cat. reporting is called Standard Category in the Query.

The characteristic Group-ID Product is called Product (consolidated) in the Query.

Rows

<Here you enter general explanations for the characteristics and key figures in the rows.>

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0GN_CAT_PUR_0UNSPSC_AC

Current UNSPSC number

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0SR_FIIVNLC

Purchase order volume (corresponds to the key figure Effective Net Invoice Volume in Local Currency)

In the Query the InfoObject Purchase Order Volume is called Invoice Volume.

The values displayed are restricted to the 15 categories with the highest invoice values by the condition Top 15.

 

End of Content Area