Key Figure Type

[Former Member]

Hello,

I am looking for the official definition of Key Figure Type (0METYPE). Can anyone tell me where I can find this?

[former_member188975 · Accepted solution]

Hi,

You can look it up in RSD1...it is actually a char and you can take a look at the master data to see the different values like Target, Overhead Rate, Consumption Quantities, Statistical Key Figures etc.

Hope this helps...

[Former Member · Accepted solution]

What I need to figure out is how it is used and how to define it to a user.

[Former Member · Accepted solution]

Hi MG.

0METYPE is a key figure-specific info object usually used to define semantics of the individual business key figures in BW (for example, actual, commitment, plan, target values).

Its a bi specific field which is filled from extract structure field named MEASTYPE table COSR

Refer to OSS Note 523742 for how it is filled and the following link for additiona information.

http://help.sap.com/saphelp_nw70/helpdata/en/91/ddd52b9ef30645a338e28aae443807/frameset.htm

Assign points if its helpful

Regards, Uday

[Former Member · Accepted solution]

I do apologize I have not awarded points or stated if this is resolved. I do not have access to OSS and I'm waiting on someone to send me the information in that note. Thank you all for your help.

[Former Member · Accepted solution]

Note 523742 - BCT-CO: BW key figure model and R/3 tables for trans. data

This note provides information on the key figure model in the area of BW Content CO-OM. It also gives an overview of the DataSources for transaction data and the corresponding source tables and value fields in the R/3 System.

The key figure model for currency fields in the area of CO-OM contents affects the following info object of type key figure:

0AMOUNT Amount

The key figure itself does have any business semantics.

The semantics of the individual business key figures in BW (for example, actual, commitment, plan, target values) is determined using combinations of values for the following key figure-specific info objects (see also the account model in SEM-BPS, note 407563):

0METYPE Key figure type

0VTYPE Value type for reporting

--> 0VTDETL Details of the value type

--> 0VTSTAT Statistics indicator for the value type.

For example, using transaction SE16, the possible characteristics of the values of this InfoObject can be taken from the above-mentioned master data tables in R/3.

The business key figures on the InfoCubes of the standard BW content were defined as restricted key figures using this semantics of the key-figure-specific characteristics.

The conversion of the R/3 transaction data in the BW key figure model is carried out in the extractors using the ROMI_GET_VTYPE_AND_DETAIL function module. It primarily happens using the specified conversion tables.

The following dependencies exist for the source tables of the DataSources:

COSP_VTYPE for COSS, COSP, COVP,

COSB_VTYPE for COSB,

BPXX_VTYPE for BPGE, BPJA, BPEE

If an R/3 source record cannot be converted using these tables, it may not be extracted to BW.The application log of the R/3 DataSource transaction RSA3 contains entries for the unconverted values after the test run.(The log function for the CO-OM DataSources was considerably improved by the correction for note 523655).

The application log for the extraction runs from BW can be evaluated using transaction SLG1 (Object: RSAP, object information: RSAP_INFO)

Furthermore, the semantics of a key figure are still determined by the time characteristics and the following key-figure-specific info objects:

0CURTYPE Currency type (for more information, see note 517909),

0DB_CR_IND Debit/credit indicator (for more information, see note 065075),

0VERSION CO version