Invoice Values with Purchase Order Ref. and Contract (cons.) 

Technical Name: 0SR_FIC01_Q0009

Use

The Query shows in the standard view an overview of the total of the invoice values for each of the current and four previous quarters. You can expand the totals columns and also display the invoice values without purchase order reference. You can compare the quarters with each other.

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
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
0GN_CAT_PUR_0UNSPSC_AC	Current UNSPSC number
0COSTCENTER	Cost center
0CO_AREA	Controlling area

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

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

Variables Used

Variable	Description
0CALQUARTER	Calendar year/quarter

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0CALQUARTER	Calendar year/quarter
0CALMONTH	Calendar month
0CKSUM	Total
0SR_CKPOR	Values with purchase order reference
0SR_CKWIC	With purchase order reference and contract
0SR_CKPOOC	With purchase order reference and without contract
0SR_CKWOI	Values without purchase order reference

0CKSUM: Calculated from 0SR_CKPOR (values with purchase order reference) and 0SR_CKWOI (values without purchase order reference).

0SR_CKPOR: Lists the total of values that have been purchased with purchase order reference. These are broken down by values with and without contract reference.

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.

Columns

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0GN_CAT_PUR_0UNSPSC_AC	Current UNSPSC number
0SR_FIIVNLC	Purchase order volume