SAP table IMRG (Measurement Document)

SAP table IMRG has 2 primary key fields being MANDT,MDOCM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MDOCM Measurement Document CHAR 20 0 IMRC_MDOCM
POINT Measuring Point CHAR 12 0 IMPTT IMRC_POINT
IDATE Date of the Measurement DATS 8 0 IMRC_IDATE
ITIME Time of Measurement TIMS 6 0 IMRC_ITIME
INVTS Inverted Time Stamp: 99.999.999.999 - Seconds AD NUMC 11 0 IMRC_INVTS
CNTRG Indicator: Counter Reading Document CHAR 1 0 IMRC_CNTRG
MDTXT Measurement Document Text CHAR 40 0 IMRC_MDTXT
MLANG Language Key LANG 1 0 T002 SPRAS
KZLTX Long Text Exists CHAR 1 0 ILOM_KZLTX
READR Person who Took the Measurement Reading CHAR 12 0 IMRC_READR
ERDAT Date on which the object was created DATS 8 0 ICRDT
ERUHR Time at which the object was created TIMS 6 0 ICRTM
ERNAM Name of User Who Created the Object CHAR 12 0 ICRNA
AEDAT Date on which the object was last changed DATS 8 0 IUPDT
AENAM Name of the user who last changed the object CHAR 12 0 IUPNA
LVORM Deletion Flag for 1-Level Deletion Logic CHAR 1 0 IMRC_DEL1
No deletion flag
1 Object can be deleted
GENER Origin Indicator CHAR 1 0 IMRC_GENER
1 Customer variant 1
2 Customer variant 2
3 Customer variant 3
A Transfer from API, without dialog
C Entry of vehicle usage
D Normal online entry
I Batch input entry
L Default from measurement reading entry list
M R/2 -> R/3 migration
Q Automatically created by the QM application
R Manual transfer from the QM application
T Created automatically by measurement reading transfer
PRUEFLOS Inspection Lot Number NUMC 12 0 QALS QPLOS
VORGLFNR Current Node Number from Order Counter NUMC 8 0 QLFNKN
MERKNR Inspection Characteristic Number NUMC 4 0 QMERKNRP
DETAILERG Development reserve: Format NUMC, length 8 NUMC 8 0 RESERVE_NUMC_008
ROOTD Source Document for Measurement Reading Transfer CHAR 20 0 IMRG IMRC_ROOTD
TOLTY CIM Resource Object Type for Production Resources/Tools CHAR 2 0 IMRC_TOLTY
TOLID Production Resource/Tool Object ID NUMC 8 0 CRID IMRC_TOLID
WOOBJ Object Number of Order CHAR 22 0 ONR00 IMRC_WOOBJ
DOCAF Indicator: MeasDoc. Created After Associated Task CHAR 1 0 IMRC_DOCAF
READG Measurement Reading/Total Counter Reading in SI Unit FLTP 16 16 IMRC_READG
READGI Indicator: Associated Number Field Contains a Value CHAR 1 0 IVALU
RECDV Measurement Reading in Unit of Entry FLTP 16 16 IMRC_RECDV
RECDVI Indicator: Associated Number Field Contains a Value CHAR 1 0 IVALU
RECDU Unit of Measurement for Document Entry UNIT 3 0 T006 IMRC_RECDU
CNTRR Counter Reading in SI Unit FLTP 16 16 IMRC_CNTRR
CNTRRI Indicator: Associated Number Field Contains a Value CHAR 1 0 IVALU
CDIFF Counter Reading Difference in SI Unit FLTP 16 16 IMRC_CDIFF
CDIFFI Indicator: Associated Number Field Contains a Value CHAR 1 0 IVALU
IDIFF Indicator: Counter Reading Entered as Difference CHAR 1 0 IMRC_IDIFF
EXCHG Indicator: Counter Replaced CHAR 1 0 IMRC_EXCHG
TOTEX Indicator: Total Counter Reading Set Externally CHAR 1 0 IMRC_TOTEX
CODCT Catalog Type - Measurement Reading Valuation Code CHAR 1 0 TQ15 IMRC_CODCT
CODGR Code Group - Measurement Reading Valuation Code CHAR 8 0 QPGR IMRC_CODGR
VLCOD Valuation Code CHAR 4 0 QPCD IMRC_VLCOD
CVERS Version Number CHAR 6 0 QVERSNR
PREST Processing Status CHAR 1 0 IMRC_PREST
1 MeasReading processed: activities need to be carried out
2 MeasReading processed: activities covered by planned task
7 MeasReading processed: no activities need to be carried out
CANCL Reversal Indicator CHAR 1 0 IMRC_CANCL
WOOB1 Object Number of Order Operation/Confirmation Counter etc. CHAR 22 0 ONR00 IMRC_WOOB1
PROBENR Number of Partial Sample NUMC 6 0 QASV QSTIPRONR
MBEWERTG Inspection Result Valuation CHAR 1 0 QMBEWERTG
INTVL Indicator that Document Refers to Time Interval CHAR 1 0 IMRC_INTVL
No interval document
1 Interval document, generated by counter reading transfer
IDAT1 Date of Interval Start DATS 8 0 IMRC_IDAT1
ITIM1 Time of Interval Start TIMS 6 0 IMRC_ITIM1
TMSTP_BW Time Stamp for BW Delta Extraction DEC 16 0 TSTMP_BW_EXTRACT
LOGSYSTEM Logical System CHAR 10 0 * LOGSYSTEM

IMRG foreign key relationships

Table Field Check Table Check Field
0 IMRG CODCT TQ15 Inspection catalog type index KATALOGART
1 IMRG CODGR QPGR Inspection catalog code groups MANDT
1 IMRG CODGR QPGR Inspection catalog code groups KATALOGART
0 IMRG MANDT T000 Clients MANDT
1 IMRG MLANG T002 Language Keys (Component BC-I18) SPRAS
0 IMRG POINT IMPTT Measuring Point (Table) POINT
1 IMRG PROBENR QASV Sample specifications for inspection processing MANDANT
1 IMRG PROBENR QASV Sample specifications for inspection processing PRUEFLOS
1 IMRG PROBENR QASV Sample specifications for inspection processing VORGLFNR
1 IMRG PROBENR QASV Sample specifications for inspection processing MERKNR
1 IMRG PROBENR QASV Sample specifications for inspection processing PROBENR
0 IMRG PRUEFLOS QALS Inspection lot record MANDANT
1 IMRG RECDU T006 Units of Measurement MANDT
1 IMRG RECDU T006 Units of Measurement MSEHI
0 IMRG ROOTD IMRG Measurement Document MDOCM
1 IMRG TOLID CRID CIM Resource - Entities MANDT
1 IMRG TOLID CRID CIM Resource - Entities OBJID
0 IMRG VLCOD QPCD Inspection catalog codes MANDT
0 IMRG VLCOD QPCD Inspection catalog codes KATALOGART
0 IMRG VLCOD QPCD Inspection catalog codes CODEGRUPPE
0 IMRG VLCOD QPCD Inspection catalog codes CODE
0 IMRG VLCOD QPCD Inspection catalog codes VERSION
1 IMRG WOOB1 ONR00 General Object Number MANDT
1 IMRG WOOB1 ONR00 General Object Number OBJNR
0 IMRG WOOBJ ONR00 General Object Number MANDT
0 IMRG WOOBJ ONR00 General Object Number OBJNR