IMPTT SAP (Measuring Point (Table)) Table details
Dictionary Type: Table
Description: Measuring Point (Table)
Description: Measuring Point (Table)
Table field list including key, data, relationships and ABAP select examples
IMPTT is a standard SAP Table which is used to store Measuring Point (Table) data and is available within R/3 SAP systems depending on the version and release level.
The IMPTT table consists of various fields, each holding specific information or linking keys about Measuring Point (Table) data available in SAP. These include POINT (Measuring Point), MPOBJ (Object Number for the Measuring Point Object), PSORT (Position Number of the Object Measuring Point (Sort Field)), PSORTR (Indicator: Position Number Comes From Reference MeasPoint).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP IMPTT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
POINT | Measuring Point | IMRC_POINT | CHAR | 12 | ALPHA | IMRC_POINT | IPT | IMPM | |
MPOBJ | Object Number for the Measuring Point Object | IMRC_MPOBJ | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
PSORT | Position Number of the Object Measuring Point (Sort Field) | IMRC_PSORT | CHAR | 20 | CHAR20 | ||||
PSORTR | Indicator: Position Number Comes From Reference MeasPoint | IMRCRPSORT | CHAR | 1 | X | ||||
PTTXT | Description of Measuring Point | IMRC_PTTXT | CHAR | 40 | TEXT40 | ||||
MLANG | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
KZLTX | Indicator: Long text exists | ILOM_KZLTX | CHAR | 1 | X | ||||
MPTYP | Measuring Point Category | IMRC_MPTYP | CHAR | 1 | T370P | IMRC_MPTYP | IP1 | ||
IRFMP | Indicator: MeasPoint Is a Reference Measuring Point | IMRC_IRFMP | CHAR | 1 | X | ||||
ERDAT | Date on which the object was created | ICRDT | DATS | 8 | DATUM | ||||
ERNAM | Name of User Who Created the Object | ICRNA | CHAR | 12 | USNAM | ||||
AEDAT | Date on which the object was last changed | IUPDT | DATS | 8 | DATUM | ||||
AENAM | Name of the user who last changed the object | IUPNA | CHAR | 12 | USNAM | ||||
BEGRU | Technical object authorization group | IAUTG | CHAR | 4 | T370B | IAUTG | |||
INACT | Indicator: Measuring Point Inactive | IMRC_INACT | CHAR | 1 | X | ||||
LVORM | Deletion Flag for 2-Level Deletion Logic | IMRC_DEL2 | CHAR | 1 | IMRC_DEL2 | ||||
LOCAS | Assembly for Localization of Measuring Point | IMRC_LOCAS | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
REFMP | Reference Meas.Pt | IMRC_REFMP | CHAR | 12 | IMPTT | ALPHA | IMRC_POINT | IMRC_REFMP | |
ATINN | Internal characteristic | ATINN | NUMC | 10 | CABN | ATINN | ATINN | ||
ATINNR | Indicator: Charac Comes From Reference Measuring Point | IMRCRATINN | CHAR | 1 | X | ||||
EXPON | Power of Ten Exponent for Floating Point Display | IMRC_EXPON | INT2 | 5 | IMRC_EXPON | ||||
DECIM | Number of Decimal Places for Number Display | IMRC_DECIM | INT2 | 5 | IMRC_DECIM | ||||
DESIR | Measuring Point Target Value | IMRC_DESIR | FLTP | 16(16) | IMRC_FLTPS | ||||
DESIRI | Indicator: Associated Number Field Contains a Value | IVALU | CHAR | 1 | X | ||||
DESIRR | Indicator: Target Value Comes From Reference Measuring Point | IMRCRDESIR | CHAR | 1 | X | ||||
DSTXT | Aditional Short Text for Measuring Point | IMRC_DSTXT | CHAR | 40 | TEXT40 | ||||
DSTXTR | Indicator: Additional Text Comes From Reference MeasPoint | IMRCRDSTXT | CHAR | 1 | X | ||||
MRMIN | Lower Measurement Range Limit/Minimum Total Counter Reading | IMRC_MRMIN | FLTP | 16(16) | IMRC_FLTPS | ||||
MRMINI | Indicator: Associated Number Field Contains a Value | IVALU | CHAR | 1 | X | ||||
MRMAX | Upper Measurement Range Limit/Maximum Total Counter Reading | IMRC_MRMAX | FLTP | 16(16) | IMRC_FLTPS | ||||
MRMAXI | Indicator: Associated Number Field Contains a Value | IVALU | CHAR | 1 | X | ||||
MRNGU | Measurement Range Unit | IMRC_MRNGU | UNIT | 3 | T006 | CUNIT | MEINS | ||
INDCT | Indicator to Show that Measuring Point Is a Counter | IMRC_INDCT | CHAR | 1 | X | ||||
INDRV | Indicator: Counter Runs Backwards | IMRC_INDRV | CHAR | 1 | X | ||||
INDTR | Indicator That Measurement Reading Transfer is Supported | IMRC_INDTR | CHAR | 1 | X | ||||
TRANS | Measuring Point from Which Meas. Reading Was Transferred | IMRC_TRANS | CHAR | 12 | IMPTT | ALPHA | IMRC_POINT | IMPM | |
CJUMP | Counter Overflow Reading in SI Unit | IMRC_CJUMP | FLTP | 16(16) | IMRC_FLTPS | ||||
CJUMPI | Indicator: Associated Number Field Contains a Value | IVALU | CHAR | 1 | X | ||||
PYEAR | Annual Estimate in SI Unit | IMRC_PYEAR | FLTP | 16(16) | IMRC_FLTPS | ||||
PYEARI | Indicator: Associated Number Field Contains a Value | IVALU | CHAR | 1 | X | ||||
CODCT | Catalog Type - Measurement Reading Valuation Code | IMRC_CODCT | CHAR | 1 | TQ15 | QKATART | |||
CODGR | Code Group - Measurement Reading Valuation Code | IMRC_CODGR | CHAR | 8 | QPGR | QCODEGRP | |||
CODGRR | Indicator: Code Group Comes From Reference Measuring Point | IMRCRCODGR | CHAR | 1 | X | ||||
CDSUF | Indicator: Valuation Code Sufficient for Measurmnt. Document | IMRC_CDSUF | CHAR | 1 | X | ||||
MODTR | Mode of Counter Reading Transfer | IMRC_MODTR | CHAR | 1 | IMRC_MODTR | ||||
INDTRR | Indicator: Measurement Transfer Comes from Ref. Meas. Point | IMRCRINDTR | CHAR | 1 | X | ||||
.INCLU--AP | 0 | ||||||||
LOGSYS | Logical System | /ISDFPS/LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | /ISDFPS/ALE_SYNC_SYSTEM | |
LOGSYS_CHG | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | TZNTSTMPS |
Key field | Non-key field |
How do I retrieve data from SAP table IMPTT using ABAP code
The following ABAP code Example will allow you to do a basic selection on IMPTT to SELECT all data from the tableDATA: WA_IMPTT TYPE IMPTT.
SELECT SINGLE *
FROM IMPTT
INTO CORRESPONDING FIELDS OF WA_IMPTT
WHERE...
How to access SAP table IMPTT
Within an ECC or HANA version of SAP you can also view further information about IMPTT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects