CO-OM-OPA: Statistical Key Figures

Use

This InfoCube contains all the statistical key figures posted to internal orders, that were transferred from the linked source system(s).

Note Note

The category of the statistical key figure determines whether the system updates quantities or inventory quantities to the statistical key figure. The system fills the 0QUANT_AVRG InfoObject for non-cumulative values, such as "Number of Employees". However, for cumulative values such as "Telephone units", the system fills the 0QUANTITY InfoObject.

You can also use this InfoCube to access your own fields. For more information, see Customer-Defined Fields .

End of the note.

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

Higher-Level Objects

Roles

This InfoCube provides information on the following subject:

0OPA_RO_ROLE_CO_INTERNAL_ORDER: Internal Orders

Queries

The following queries can access this InfoCube:

0OPA_C02_Q0001: Internal Orders (Group): Statistical Key Figures Plan/Actual

0OPA_C02_Q0002: Internal Orders (List): Statistical Key Figures - Plan/Actual

InfoSources

0CO_OM_CCA_4: Statistical Key Figures

Loading Behavior

To keep the data to a minimum that is loaded into the BW, you should use the following characteristics to restrict the selection:

0CURTYPE Currency type

0VTYPE Value type for reporting

Each time you upload data, the system adds it to the existing values. You should therefore delete any existing values before repeating an upload.

Recommendation

SAP recommends that you load an InfoPackage (using certain characteristics, for example, FISCPER; selected dataset) for each posting period, once periodic tasks are complete. This has the advantage that you do not need to delete as much data when you reload. InfoPackages that are already complete can be retained.

End of the recommendation.

Characteristics

InfoObject	Description
0COORDER	Order number
0CO_AREA	Controlling area
0STKEYFIG	Statistical key figure
0VERSION	Version
0VTYPE	Value type for reporting

Navigation Attributes

The following navigation attributes have been activated: This is a sample selection. You are free to activate additional attributes, or deactivate attributes to improve performance.

InfoObject	Description
0COORDER__0CO_AREA	Controlling Area
0COORDER__0PROFIT_CTR	Profit center

Time Characteristics

InfoObject	Description
0FISCPER	Fiscal year/period
0FISCVARNT	Fiscal year variant
0FISCPER3	Posting period
0FISCYEAR	Fiscal year

The fiscal year ( 0FISCYEAR ) and posting period ( 0FISCPER3 ) characteristics are filled by the fiscal year period field ( 0FISCPER ) in the InfoSource.

Key Figures

InfoObject	Description
0QUANTITY	Quantity
0QUANT_AVRG	Inventory quantity

Restricted Key Figures

Note Note

The basic key figures cannot be used without restricting some of the characteristics. For this reason you should use only the supplied restricted key figures in Queries you have defined yourself, or analyze the supplied restricted key figures and modify them to suit your requirements.

End of the note.

InfoObject	Restriction
Data for all restricted key figures	Version = 0 (current variant)
0OPA_C02_RK_002 Actual quantity	Key figure = 0QUANTITY (quantity) Value type = 10 (actual)
0OPA_C02_RK004 Actual quantity (non-cumulative value)	Key figure = 0QUANT_AVRG (non-cumulative value) Value type = 10 (actual)
0OPA_C02_RK001 Planned quantity	Key figure = 0QUANTITY (quantity) Value type = 20 (plan)
0OPA_C02_RK003 Planned quantity (non-cumulative value)	Key figure = 0QUANT_AVRG (non-cumulative value) Value type = 20 (plan)

Units

InfoObject	Description
0UNIT	Unit of measure