on 05-25-2011 5:02 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.