C_MeasuringPointDEX

DDL: C_MEASURINGPOINTDEX Type: view_entity CONSUMPTION
39 Fields 1 Data Sources

Measuring Point

C_MeasuringPointDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Measuring Point · Asset Management

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

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-EQM-SF-MPC
CapabilitiesData Source for Data Extraction, Analytical Dimension, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageAsset Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MeasuringPoint I_MeasuringPoint from

Annotations (15)

NameValueLevelField
EndUserText.label Measuring Point view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey MeasuringPoint view
ObjectModel.sapObjectNodeType.name MeasuringPoint view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Analytics.internalName #LOCAL view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY MeasuringPoint MeasuringPoint Measuring point
Language Language Report Text Language
MeasuringPointDescription MeasuringPointDescription Description of Measuring Point
MeasuringPointShortText MeasuringPointShortText Aditional Short Text for Measuring Point
MeasuringPointObjectIdentifier MeasuringPointObjectIdentifier Object Number for the Measuring Point Object
MeasuringPointPositionNumber MeasuringPointPositionNumber Position Number of the Object Measuring Point (Sort Field)
MeasuringPointCategory MeasuringPointCategory Measuring Point Category
CreationDate CreationDate Date on which the object was created
LastChangeDate LastChangeDate Date on which the object was last changed
AuthorizationGroup AuthorizationGroup Technical Object Authorization Group
MeasuringPointIsInactive MeasuringPointIsInactive Indicator: Measuring Point Inactive
MeasuringPointIsCounter MeasuringPointIsCounter Indicator to Show that Measuring Point Is a Counter
MultiLevelDeletionLogicStatus MultiLevelDeletionLogicStatus Deletion Flag for 2-Level Deletion Logic
Assembly Assembly Assembly for Localization of Measuring Point
ReferenceMeasuringPoint ReferenceMeasuringPoint Reference Meas.Pt
MsrgPtInternalCharacteristic Internal Characteristic ID New
MeasuringPointExponent MeasuringPointExponent Power of Ten Exponent for Floating Point Display
MeasuringPointDecimalPlaces MeasuringPointDecimalPlaces Number of Decimal Places for Number Display
MeasuringPointMinimumThreshold MeasuringPointMinimumThreshold Lower Measurement Range Limit/Minimum Total Counter Reading
MeasuringPointMaximumThreshold MeasuringPointMaximumThreshold Upper Measurement Range Limit/Maximum Total Counter Reading
MeasurementRangeUnit MeasurementRangeUnit Measurement Range Unit
MeasuringPointSIUnitOfMeasure MeasuringPointSIUnitOfMeasure SI Unit
MsrgPtIsCountingBackwards MsrgPtIsCountingBackwards Indicator: Counter Runs Backwards
MsmtRdngSourceMeasuringPoint MsmtRdngSourceMeasuringPoint Measuring Point from Which Meas. Reading Was Transferred
CounterOverflowRdngThreshold CounterOverflowRdngThreshold Counter Overflow Reading in SI Unit
MeasuringPointAnnualEstimate MeasuringPointAnnualEstimate Annual Estimate in SI Unit
MeasuringPointCatalogType MeasuringPointCatalogType Catalog Type - Measurement Reading Valuation Code
MeasuringPointCodeGroup MeasuringPointCodeGroup Code Group - Measurement Reading Valuation Code
ValuationCodeIsSufficient ValuationCodeIsSufficient Indicator: Valuation Code Sufficient for Measurmnt. Document
MeasuringPointHasLongText MeasuringPointHasLongText Long Text Exists
_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 C_MeasuringPointDEX.
-- 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.

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

Learn More