Skip to Content
0
Former Member
Dec 05, 2006 at 11:17 AM

Requirement of PM in BW

39 Views

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