Splitting the Total Purchase Value over Time 

Technical Name: 0SR_FIC01_Q0005

Use

This Query displays for all categories the purchase order values for the current quarter and the four previous quarters broken down by:

●      Purchase order values with purchase order reference

○       With contract

○       Without contract

●      Purchase order values without purchase order reference

The categories, for example UNSPSC, are available as free characteristics so that the Query can be restricted to certain categories.

Filter

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0SR_TAX_ITM	Indicator: Tax Line
0CALQUARTER	Calendar year/quarter

With the characteristic indicator: Tax Line, you can filter the data according to the criterion – is the current account a tax account or not. The Query is restricted to those values where the content of the 0SR_TAX_ITM field is not the value # (not assigned).

 

Free Characteristics

InfoObject	Description
0PRODCUCT_0CI_GRP_PRO	Group-ID Product
0PRODUCT	Product

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0CALQUARTER	Calendar year/quarter

Columns

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0SR_CKWOI	Without purchase order reference
0SR_CKWPOOC	With purchase order reference and contract
0SR_CKWIC	With purchase order reference and contract

0SR_CKWIC: All values for which the conditions with purchase order reference and with contract are fulfilled.

0SR_CKPOOC: All values for which the conditions with purchase order reference and without contract are fulfilled.

0SR_CKWOI: All values where the purchase has been made without purchase order reference.