Skip to Content
avatar image
Former Member

PM measurement data source extraction

Dear Experts

I want to extract data using 0PM_MEASUREMENT extractor but when i extract data using this extractor it filters out data which have units whose DIMID isn't maintained (i.e. DIMID field is either blank or has value AAADL).

Can anyone please explain why is it so? Also is it compulsory to maintain DIMID against each unit so as to enable data to be extracted usin 0PM_MEASUREMENT?

Regards,

NJ

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 25, 2011 at 05:28 AM

    Hi Namrata,

    The 0pm_measurement extractor pulls data based on the standard view : BW_0PM_MEASM . You can find this information in RSA2 .

    This view is made over four tables :

    IMPTT (Measuring Point (Table)

    IMRG (Measurement Document)

    T006D (Dimensions)

    T006 (Units of Measurement)

    If you check the selection conditions of this view , you will find a condition as :

    IMRG	GENER	NE	'T'	AND
    T006D	DIMID	NE	'AAAADL'	AND
    T006D	DIMID	NE	'POINTS'
    

    Basically the field CNTRR in table IMRG has values in SI units . If you are not maintaining them the extractor will send them without any SI units to BI Side .

    See the link is like this :

    In T006 table, you will find Unit of measurements i.e field MSEHI . In this table you will also find another field DIMID.

    This DIMID is the primary key of the table T006D table where against a DIMID , SI unit is maintained .

    So what SAP does here is corresponding to your Unit of measurement in measurement documents, it records the value of the CNTRR field in SI units. To get the SI unit, the above link it tries to follow i.e from your UOM to DIMID in table T006 and the DIMID to SI Unit in table T006D table .

    Also kindly check the below link related to 0pm_measurement datasource :

    http://help.sap.com/erp2005_ehp_04/helpdata/EN/64/dbf1e3f31848029464b75775d34783/frameset.htm

    Hope the above reply was helpful.

    Kind Regards,

    Ashutosh Singh

    Add comment
    10|10000 characters needed characters exceeded