Start of Content Area

Query Invoice Values per Category Locate the document in its SAP Library structure

Technical Name: 0SR_FIC01_Q0006

Use

The Query shows the invoice values of the five UNSPSC categories that have been ordered with the greatest frequency in the current 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_CAT_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 Group-ID Product is called Product (consolidated) in the Query.

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

Rows

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Structure link0CALQUARTER

Calendar year/quarter

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0GN_CAT_PUR_0UNSPSC_AC

Current UNSPSC number

0SR_FIIVNLC

Effective Net Invoice Volume in Local Currency

The key figure Effective Net Invoice Volume in Local Currency is called Purchase Order Volume in the Query.

The values displayed are restricted to the top five invoice values by the condition Top 5.

 

End of Content Area