I have equiremenet like this inPM
Measuremnt point calday Measurement doc
Meter1 12/2/06 20 units
13/2/06 30 units
so on
up to
30/2/06 40 units
Meter2 1/3/06 20 units
2/3/06 30 units
so on
up to
30/3/06 40 units
Now in R/3 They are able to see the total now of units for particular month for example Meter1 total units from 12/2/06 to 30/2/06 is 203040=90 units Now in BW they want
Per unit the price will be different for diff locations
Ex:- 1 unit = RS 4/- for Gurgaon
1 unit = RS 5/- for Pune
etc
so this price data is not stored in R/3 i.e., 1 unit = RS 4/- for Gurgaon
1 unit = RS 5/- for Pune
IN Bw report they want the report like this
Measurement doc
20 units
30 units
so I shouls build a formula for this I fthe price is same for all the locations then its not complex to build a formula but the price is differnrt for different locations so how is it possible to do through some ABAP coding if so need the guidance
IN Bw report they want the report like this(if eg:- price for 1 unit = 4
)
Location Measurement doc Total amount
Gurgaon
20 units 20*4=80
30 units 30*4=120
and in the same report there is one more reuirement like this
Measuremnt point Measurement doc
Meter1 20 units
Meter2 30 units
Meter1 contains data from where ever it is taking the current
Ex:- take Maruti as an example our client will take current from maruti for making of Indicators ligths, head lights etc & our client will have they own generators for making so Measurement point stores the data how many units how been taken from particular manufacturer (in our case the manfacturer is Maruti)so whenever the manfacturer changes the multiplying factor will change (eg:- if the manfacturer is Maruti multiplying factor will be 10 , if s using its own generators then multiplying factor will be 20),this multiplying factor should be multiplied with Measurement doc so that it will give the correct reading
Measuremnt point Measurement doc Total Reading units
Meter1 (if Maurti) 20 units 20*10=200 units
Meter2 ( if generator) 30 units 30 *20=600 units
How can this be done
Thanks
Priya