IMPTT
Measuring Point (Table)
IMPTT is an SAP database table in S/4HANA. Measuring Point (Table). It contains 47 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| 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 | |
| E_MeasuringPoint | view_entity | from | EXTENSION | Measuring Points - Extension |
| I_MeasuringPoint | view | from | BASIC | Measuring Point |
| I_MsrgPointPRTByInternalKey | view | inner | BASIC | Measuring Point PRT by internal key |
Fields (47)
| 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. |
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]
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