Purchasing: Time Series – Cumulated Actual Costs in Current Year
Purchasing: Time Series – Cumulated Actual Costs in Current Year
Technical name: 0COPC_C02_Q0012
Based on InfoCube
CO-PC: Actual Costing/Material Ledger – Costs 0COPC_C02Use
This query provides an annual overview of the material purchases for an entire company code. It compares the target costs and actual costs of purchases for all periods in the current fiscal year.
You can limit the cost comparison by selecting particular plants or material groups, for example. By changing the drilldown, you can perform the comparison for criteria such as all material groups. You can drill down to the level of individual materials.
This query is contained in the following workbook:
For background information on the concept of queries, see
Queries in Controlling.
Filters
InfoObject |
Description of the InfoObject (Restriction) |
0COMP_CODE |
Company code (variable 0P_COCD; single value entry, required) |
0FISCVARNT |
Fiscal year variant (
SAP exit variable 0P_FVAEX, derived from the company code) |
0FISCYEAR |
Fiscal year (SAP exit variable 0FYEAR, current fiscal year) |
0CURTYPE |
Currency type (fixed value 10, currency of company code) |
0VALUATION |
Valuation view (fixed value 0, legal valuation) |
User-Defined Characteristics
Technical Name |
Description (Restriction) |
0PLANT |
Plant (variable 0S_PLANT; selection options, optional) |
0MATERIAL__0MATL_TYPE |
Material type (variable 0S_MATTP; selection options, optional) |
0MATERIAL__0MATL_GROUP |
Material group (variable 0S_MATG; selection options, optional) |
0MATERIAL |
Material (variable 0S_MAT; selection options, optional) |
Rows
Technical Name |
Description |
0COPC_C02_RK047 |
Purchasing: target costs (subperiodic valuation) |
0COPC_C02_RK013 |
Purchasing: actual costs (purchase order valuated at actual cost) |
Columns
Technical Name |
Description |
0COPC_C02_S003 |
Periods (cumulative) (periods 1 to 12, cumulative) |