Start of Content Area

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

Technical Name: 0SR_FIC01_Q0004

Use

The Query shows the 15 vendors with 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

Product

0GN_CAT_PUR_0CI_SPURCAT

Standard category

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

Rows

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0GN_VENDOR_0CI_GRP_PAR

Group ID for Partners

The InfoObject Group-ID Partner is called Vendor in the Query.

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0GN_CAT_PUR_0UNSPSC_AC

Current UNSPSC number

0SR_FIIVNLC

Purchase order volume (corresponds to the key figure 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 15 vendors with the highest invoice values by the condition Top 15.

 

End of Content Area