Table to find number of measurement doc for a particular measuring point

[Former Member]

Dear experts,

I have a requirement for finding out the average effieciency of a fork lift based on the operating hours and number of cylinders used. Due to some project technical constraints, i cannot use the standard fleet management functionality to capture this report.

I am using a counter to capture the operated hours which will be divided directly by 19.6 kg (capacityof cylinder). This is simple to develop.

One more report to calculate average effciency of the forklift from a given date range has to be developed. I am not sure which table i can get the data from. In the selection screen, when i pass the date range the program should pick up the number of measurement documents updated for the given measuring point. How can i do this? Is there any table from where i can run the select query?

Thanks in advace,

Boby

[Former Member · Accepted solution]

Hi ,

IMPTT : Measuring Point Table

IMRG : Measurement document table against a measuring point ..

plz check the above ..

Regards

pushpa

[Former Member · Accepted solution]

Thanks Pushpa,

How can i find the last measuring docuement entered for a measuring point from table IMRG. From the last measuring document, i will pick up the total counter reading and divide it by the consumtion value of the gas taken from table MSEG. Please give a logic if you have.

Thanks,

Boby

[Former Member · Accepted solution]

Hi ,

You can find that from IMRG Table by entering the measuring point and excute , check the fields Date, Time ,Measuring Reading ,MeasReading in Entry Unit , respectively counter also ..