Start of Content Area

Query Ending Inventory: Time Series – Actual Prices  Locate the document in its SAP Library structure

Technical name: 0COPC_C02_Q0005

Based on InfoCube Actual Costing / Material Ledger – Costs 0COPC_C02

Use

This time series report displays the actual prices of the periodic ending inventories for different materials in a plant. This enables materials to be compared and also shows the change in the actual price of a given material over a selected range of periods.

Note

This query is contained in the following workbook:

Ending Inventory: Time Series – Actual Prices

For background information on the concept of queries, see Queries in Controlling.

Filters

Technical Name

Description (Restriction)

0PLANT

Plant (variable 0P_PLANT; single value entry, required)

0MATERIAL__0MATL_TYPE

Material type (variable 0S_MATTP; selection options, optional)

0MATERIAL__0MATL_GROUP

Material group (variable 0S_MATG; selection options, optional)

0VALUATION

Valuation view (fixed value 0, legal valuation)

0CURTYPE

Currency type (fixed value 10, currency of company code)

Rows

InfoObject

Description (Restriction)

0MATERIAL

Material (variable 0S_MAT; selection options, optional)

Columns

InfoObject

Description (Restriction)

0FISCPER

Fiscal year/period (variable 0I_FPER; interval entry, required)

0COPC_C02_RK046

Ending inventory: actual price