Last Measurement document - Table

[Former Member]

We are developing a report. We want to fulfill the report by adding the latest Measurement document data for Measuring point of the Equipment.

Can you please suggest, from which table can we fetch.

Raja

[AjayV]

There is no need to add a custom report for last measurement document. SAP has provided a standard report with tcode IK17 and you can configure it with variant, as below to get the latest document (using No. of MeasDocs by MeasPoint as 1) and other parameters.

[Former Member]

Thanks a lot for detailing

[sebastian_lenartowicz]

Greetings Rajapandian,

EQUI - Equipments

IMPTT - Measuring points

IMRG - Measurement documents

You can also use table IMPT_LAST_DOC

Join on OBJNR & POINT

[Former Member]

i checked in Table IMPT_LAST_DOC.

I cannot get the Last Measurement document value, selectively.

Can you please elaborate.

Thanks and Regards,

Raja Pandian

[Former Member]

Give equipment number in EQUI in EQUNR field & get OBJNR value. Give OBJNR value in MPOBJ field in IMPTT table to get POINT value. Give POINT value in IMRG table to get RECDV value. If there are one line items, sort based on IDATE value.