cancel
Showing results for 
Search instead for 
Did you mean: 

PM measurement data source extraction

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

I know about the links between the tables IMRG,T006 and T006D. I want to know that is it mandatory to maintain DIMID against any unit so that it's data will not be filtered out when extraction takes place in 0PM_MEASUREMENT.

Former Member
0 Kudos

Hello,

Did you get this issue resolved? Please let me know the solution if you did.

thanks,

Siddu

Answers (0)