IMPTT
Measuring Point (Table)
IMPTT is an SAP database table in S/4HANA. Measuring Point (Table). It contains 58 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /merp/pm_Measuring_Point | view | from | CDS View: Measuring Point | |
| /merp/pm_Measuring_Point | view | union | CDS View: Measuring Point | |
| I_MeasuringPoint | view | from | BASIC | Measuring Point |
| I_MsrgPointPRTByInternalKey | view | inner | BASIC | Measuring Point PRT by internal key |
Fields (58)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | point | IMRC_POINT | Measuring point | |||
| mpobj | IMRC_MPOBJ | OBjNo.MeasPObj. | ||||
| psort | IMRC_PSORT | MeasPosition | ||||
| psortr | IMRCRPSORT | RefMeasPos. | ||||
| pttxt | IMRC_PTTXT | Description | ||||
| mlang | SPRAS | Language | ||||
| kzltx | ILOM_KZLTX | Long text | ||||
| mptyp | IMRC_MPTYP | MeasPtCategory | ||||
| irfmp | IMRC_IRFMP | RefMeasPoint | ||||
| erdat | ICRDT | Created on | ||||
| ernam | ICRNA | Created by | ||||
| aedat | IUPDT | Changed on | ||||
| aenam | IUPNA | Changed by | ||||
| begru | IAUTG | AuthorizGroup | ||||
| inact | IMRC_INACT | MeasPt.inact. | ||||
| lvorm | IMRC_DEL2 | Deletion flag | ||||
| locas | IMRC_LOCAS | Assembly | ||||
| refmp | IMRC_REFMP | Ref. Meas. Pt | ||||
| atinn | ATINN | Internal char. | ||||
| atinnr | IMRCRATINN | RefCharact. | ||||
| expon | IMRC_EXPON | FloatPointExp. | ||||
| decim | IMRC_DECIM | Decimal places | ||||
| desir | IMRC_DESIR | Target value | ||||
| desiri | IVALU | Contains value | ||||
| desirr | IMRCRDESIR | RefTargetVal. | ||||
| dstxt | IMRC_DSTXT | Text | ||||
| dstxtr | IMRCRDSTXT | RefText | ||||
| mrmin | IMRC_MRMIN | LoMRLimit | ||||
| mrmini | IVALU | Contains value | ||||
| mrmax | IMRC_MRMAX | UpMRLimit | ||||
| mrmaxi | IVALU | Contains value | ||||
| mrngu | IMRC_MRNGU | MeasRangeUnit | ||||
| indct | IMRC_INDCT | Counter | ||||
| indrv | IMRC_INDRV | Backwards | ||||
| indtr | IMRC_INDTR | Supported | ||||
| trans | IMRC_TRANS | Readg trans.fr. | ||||
| cjump | IMRC_CJUMP | CtrOverReadg | ||||
| cjumpi | IVALU | Contains value | ||||
| pyear | IMRC_PYEAR | AnnualEstimate | ||||
| pyeari | IVALU | Contains value | ||||
| codct | IMRC_CODCT | Catalog type | ||||
| codgr | IMRC_CODGR | Code group | ||||
| codgrr | IMRCRCODGR | RefCodeGroup | ||||
| cdsuf | IMRC_CDSUF | ValCode suff. | ||||
| modtr | IMRC_MODTR | Transfer mode | ||||
| indtrr | IMRCRINDTR | RefTargetVal. | ||||
| threshold_ind | EAM_THRESHOLD_IND | Enable Conditions | ||||
| upr_tolerance | IMRC_MTMAX | Upper Msmt Tolerance | ||||
| lowr_tolerance | IMRC_MTMIN | Lower Msmt Tolerance | ||||
| upr_tolerancei | IVALU | Contains value | ||||
| lowr_tolerancei | IVALU | Contains value | ||||
| upr_dsp_tol | IMRC_MTMAC | Upper Msmt Tolerance | ||||
| lowr_dsp_tol | IMRC_MTMIC | Lower Msmt Tolerance | ||||
| upr_dsp_unit | IMRC_DSP_UNIT | Tolerance Unit | ||||
| lowr_dsp_unit | IMRC_DSP_UNIT | Tolerance Unit | ||||
| logsys | /ISDFPS/LOGSYS | Logical System | ||||
| logsys_chg | TZNTSTMPS | Time Stamp |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Measuring Point (Table)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IMPTT (
MANDT, -- Client [MANDT]
POINT, -- Measuring point [IMRC_POINT]
MPOBJ, -- OBjNo.MeasPObj. [IMRC_MPOBJ]
PSORT, -- MeasPosition [IMRC_PSORT]
PSORTR, -- RefMeasPos. [IMRCRPSORT]
PTTXT, -- Description [IMRC_PTTXT]
MLANG, -- Language [SPRAS]
KZLTX, -- Long text [ILOM_KZLTX]
MPTYP, -- MeasPtCategory [IMRC_MPTYP]
IRFMP, -- RefMeasPoint [IMRC_IRFMP]
ERDAT, -- Created on [ICRDT]
ERNAM, -- Created by [ICRNA]
AEDAT, -- Changed on [IUPDT]
AENAM, -- Changed by [IUPNA]
BEGRU, -- AuthorizGroup [IAUTG]
INACT, -- MeasPt.inact. [IMRC_INACT]
LVORM, -- Deletion flag [IMRC_DEL2]
LOCAS, -- Assembly [IMRC_LOCAS]
REFMP, -- Ref. Meas. Pt [IMRC_REFMP]
ATINN, -- Internal char. [ATINN]
ATINNR, -- RefCharact. [IMRCRATINN]
EXPON, -- FloatPointExp. [IMRC_EXPON]
DECIM, -- Decimal places [IMRC_DECIM]
DESIR, -- Target value [IMRC_DESIR]
DESIRI, -- Contains value [IVALU]
DESIRR, -- RefTargetVal. [IMRCRDESIR]
DSTXT, -- Text [IMRC_DSTXT]
DSTXTR, -- RefText [IMRCRDSTXT]
MRMIN, -- LoMRLimit [IMRC_MRMIN]
MRMINI, -- Contains value [IVALU]
MRMAX, -- UpMRLimit [IMRC_MRMAX]
MRMAXI, -- Contains value [IVALU]
MRNGU, -- MeasRangeUnit [IMRC_MRNGU]
INDCT, -- Counter [IMRC_INDCT]
INDRV, -- Backwards [IMRC_INDRV]
INDTR, -- Supported [IMRC_INDTR]
TRANS, -- Readg trans.fr. [IMRC_TRANS]
CJUMP, -- CtrOverReadg [IMRC_CJUMP]
CJUMPI, -- Contains value [IVALU]
PYEAR, -- AnnualEstimate [IMRC_PYEAR]
PYEARI, -- Contains value [IVALU]
CODCT, -- Catalog type [IMRC_CODCT]
CODGR, -- Code group [IMRC_CODGR]
CODGRR, -- RefCodeGroup [IMRCRCODGR]
CDSUF, -- ValCode suff. [IMRC_CDSUF]
MODTR, -- Transfer mode [IMRC_MODTR]
INDTRR, -- RefTargetVal. [IMRCRINDTR]
THRESHOLD_IND, -- Enable Conditions [EAM_THRESHOLD_IND]
UPR_TOLERANCE, -- Upper Msmt Tolerance [IMRC_MTMAX]
LOWR_TOLERANCE, -- Lower Msmt Tolerance [IMRC_MTMIN]
UPR_TOLERANCEI, -- Contains value [IVALU]
LOWR_TOLERANCEI, -- Contains value [IVALU]
UPR_DSP_TOL, -- Upper Msmt Tolerance [IMRC_MTMAC]
LOWR_DSP_TOL, -- Lower Msmt Tolerance [IMRC_MTMIC]
UPR_DSP_UNIT, -- Tolerance Unit [IMRC_DSP_UNIT]
LOWR_DSP_UNIT, -- Tolerance Unit [IMRC_DSP_UNIT]
LOGSYS, -- Logical System [/ISDFPS/LOGSYS]
LOGSYS_CHG, -- Time Stamp [TZNTSTMPS]
PRIMARY KEY (MANDT, POINT)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA