Number of Vendors per Category (SAP Library - Supplier Relationship Management)

Number of Vendors per Category

Technical Name: 0SR_FIC01_Q0003

Use

This Query lists the number of vendors per current UNSPSC category for each of the current and four previous quarters.

Filter

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0CALQUARTER	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 Standard cat. reporting is called Standard Category in the Query.

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0GN_CAT_PUR_0UNSPSC_AC	Current UNSPSC

Columns

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0SR_CKGPNUM	Number of vendors

The number of vendors is determined using a replacement path (0SR_CKGP). In the replacement path, a 1 is added as a constant for each read record. This way the number of vendors can be determined.