I_MeasuringPointData

DDL: I_MEASURINGPOINTDATA SQL: IMEASPOINTDATA Type: view COMPOSITE
39 Fields 1 Data Sources

Measuring Point Data

I_MeasuringPointData is a Composite CDS View (Dimension) that provides data about "Measuring Point Data" in SAP S/4HANA. It reads from 1 data source (I_MeasuringPoint) and exposes 39 fields with key field MeasuringPoint.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryDimension
StatusReleased
Data Extraction TypeFull (physical deletions are possible in source tables)
Corresponding DataSource0I_MEASUREMENTPOINTDATA
Purpose
This CDS view provides the prerequisites for answering the following business questions: What are the description and the short text of the measuring point? Is there a long text available for the measuring point? For which technical object was the measuring point created? You can also obtain details about the technical object, such as the creation date, the last change date or the authorization group. What is the measuring point category? Is the measuring point inactive or marked for deletion? Is the measuring point a counter? If yes, you can obtain counter data, such as the information if the counter runs backwards or if there is a counter overflow. What are the accepted decimal places for the measuring point?/What is the internal characteristic of the measuring point? What are the measurement limit details of the measuring point? From which measuring point did the system transfer counter readings or measurement readings to the measuring point? What are the details of the related measurement readings? Note This CDS view is modeled for usage as a DataSource in Business Warehouse. We strongly recommend that you only use it for this purpose.

Prerequisites
You have authorizations to display measuring points in transaction IK03 . This check is based on the following fields: Authorization Group ( I_BEGRP ) Transaction Code ( I_TCODE )

Structure
Business Objects This view is built on the following business objects: Technical object Measuring point Main CDS parameters and filters This CDS view does not have any input parameters. Measures and attributes Some important measures and attributes are: Measuring point description Short text Technical object Creation date Last change date Authorization group Measuring point category Inactivity flag Measuring point is a counter flag Backwards counter flag Counter overflow Measuring point deletion flag Decimal places Measurement limit data, for example Upper Measurement Range Limit and Measurement Range Unit Source measuring point Measurement reading data, for example Catalog Type and Code Group Long text availability

Business Warehouse (BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Application Help BI Content Product Lifecycle Management Asset Lifecycle Management Plant Maintenance .

Constraints
You can extract data only for those measuring points which belong to technical objects (pieces of equipment or functional locations).

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_MeasuringPoint I_MeasuringPoint from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IMEASPOINTDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Measuring Point Data view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey MeasuringPoint view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #EXTRACTION_DATA_SOURCE view
ObjectModel.sapObjectNodeType.name MeasuringPoint view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY MeasuringPoint MeasuringPoint Measuring point
Language Language Report Text Language
MeasuringPointDescription MeasuringPointDescription Description
MeasuringPointShortText MeasuringPointShortText Text
MeasuringPointObjectIdentifier MeasuringPointObjectIdentifier OBjNo.MeasPObj.
MeasuringPointPositionNumber MeasuringPointPositionNumber MeasPosition
MeasuringPointCategory MeasuringPointCategory MPlan cat.
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
AuthorizationGroup AuthorizationGroup AuthorizGroup
MeasuringPointIsInactive MeasuringPointIsInactive TRUE
MeasuringPointIsCounter MeasuringPointIsCounter Counter
MultiLevelDeletionLogicStatus MultiLevelDeletionLogicStatus Stock del. flag
Assembly Assembly Pegged Reqmt
ReferenceMeasuringPoint ReferenceMeasuringPoint Ref. Meas. Pt
MsrgPtInternalCharacteristic MsrgPtInternalCharacteristic Internal char.
MeasuringPointExponent MeasuringPointExponent FloatPointExp.
MeasuringPointDecimalPlaces MeasuringPointDecimalPlaces Decimal places
MeasuringPointMinimumThreshold MeasuringPointMinimumThreshold LoMRLimit
MeasuringPointMaximumThreshold MeasuringPointMaximumThreshold UpMRLimit
MeasurementRangeUnit MeasurementRangeUnit MeasRangeUnit
MeasuringPointSIUnitOfMeasure MeasuringPointSIUnitOfMeasure
MsrgPtIsCountingBackwards MsrgPtIsCountingBackwards Backwards
MsmtRdngSourceMeasuringPoint MsmtRdngSourceMeasuringPoint Univ. Journ. Integr.
CounterOverflowRdngThreshold CounterOverflowRdngThreshold CtrOverReadg
MeasuringPointAnnualEstimate MeasuringPointAnnualEstimate AnnualEstimate
MeasuringPointCatalogType MeasuringPointCatalogType Catalog type
MeasuringPointCodeGroup MeasuringPointCodeGroup Code group
ValuationCodeIsSufficient ValuationCodeIsSufficient ValCode suff.
MeasuringPointHasLongText MeasuringPointHasLongText More text
_Language _Language
_ControllingObject _ControllingObject
_MeasuringPointCategory _MeasuringPointCategory
_Product _Product
_ReferenceMeasuringPoint _ReferenceMeasuringPoint
_UnitOfMeasure _UnitOfMeasure
_MsmtRdngSourceMeasuringPoint _MsmtRdngSourceMeasuringPoint
_MeasuringPointCatalogType _MeasuringPointCatalogType
_MeasuringPointCodeGroup _MeasuringPointCodeGroup

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MeasuringPointData.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMEASPOINTDATA

CREATE VIEW I_MeasuringPointData AS
SELECT
  MeasuringPoint,
  Language,
  MeasuringPointDescription,
  MeasuringPointShortText,
  MeasuringPointObjectIdentifier,
  MeasuringPointPositionNumber,
  MeasuringPointCategory,
  CreationDate,
  LastChangeDate,
  AuthorizationGroup,
  MeasuringPointIsInactive,
  MeasuringPointIsCounter,
  MultiLevelDeletionLogicStatus,
  Assembly,
  ReferenceMeasuringPoint,
  MsrgPtInternalCharacteristic,
  MeasuringPointExponent,
  MeasuringPointDecimalPlaces,
  MeasuringPointMinimumThreshold,
  MeasuringPointMaximumThreshold,
  MeasurementRangeUnit,
  MeasuringPointSIUnitOfMeasure,
  MsrgPtIsCountingBackwards,
  MsmtRdngSourceMeasuringPoint,
  CounterOverflowRdngThreshold,
  MeasuringPointAnnualEstimate,
  MeasuringPointCatalogType,
  MeasuringPointCodeGroup,
  ValuationCodeIsSufficient,
  MeasuringPointHasLongText
FROM I_MeasuringPoint
;

Learn More