C_MeasurementDocumentDEX

DDL: C_MEASUREMENTDOCUMENTDEX Type: view_entity CONSUMPTION
56 Fields 1 Data Sources

Data Extraction for Measurement Document

C_MeasurementDocumentDEX (Consumption)

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

Measurement Document · Asset Management

C_MeasurementDocumentDEX is a Consumption CDS View that provides data about "Data Extraction for Measurement Document" in SAP S/4HANA. It reads from 1 data source (I_MeasurementDocument) and exposes 56 fields with key field MeasurementDocument.

SAP API Hub

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

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MeasurementDocument I_MeasurementDocument from

Annotations (16)

NameValueLevelField
VDM.viewType #CONSUMPTION view
EndUserText.label Data Extraction for Measurement Document view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view
Analytics.technicalName CMSMTDOCDEX view
Analytics.dataExtraction.enabled true view
Consumption.ranked true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
ObjectModel.sapObjectNodeType.name MeasurementDocument view
ObjectModel.representativeKey MeasurementDocument view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY MeasurementDocument MeasurementDocument Measurement Doc. No.
MeasuringPoint MeasuringPoint Measuring point
MsmtRdngDate MsmtRdngDate Date of the Measurement
MsmtRdngTime MsmtRdngTime Single-Character Flag
MsmtRdngIsForCounter MsmtRdngIsForCounter Indicator: Counter Reading Document
MeasurementDocumentText MeasurementDocumentText Measurement Document Text
Language Language Report Text Language
MeasurementDocumentHasLongText MeasurementDocumentHasLongText Long Text Exists
MsmtRdngByUser MsmtRdngByUser Person who Took the Measurement Reading
CreationDate CreationDate Date on which the object was created
CreationTime CreationTime Time at which the object was created
CreatedByUser CreatedByUser Name of User Who Created the Object
LastChangeDate LastChangeDate Date on which the object was last changed
LastChangedByUser LastChangedByUser Name of the user who last changed the object
SingleLevelDeletionLogicFlag SingleLevelDeletionLogicFlag Deletion Flag for 1-Level Deletion Logic
MeasurementDocumentOrigin MeasurementDocumentOrigin Origin Indicator
InspectionLot InspectionLot Inspection Lot Number
InspectionCharacteristic InspectionCharacteristic Inspection Characteristic Number
MsmtRdngSourceMeasurementDoc MsmtRdngSourceMeasurementDoc Source Document for Measurement Reading Transfer
ProdnRsceToolTypeCode ProdnRsceToolTypeCode CIM Resource Object Type for Production Resources/Tools
ProdnRsceToolInternalID ProdnRsceToolInternalID Production Resource/Tool Object ID
MsmtDocumentReferredOrder MsmtDocumentReferredOrder Object Number of Order
MsmtIsDoneAfterTaskCompltn MsmtIsDoneAfterTaskCompltn Indicator: MeasDoc. Created After Associated Task
MeasurementReading MeasurementReading Measurement Reading/Total Counter Reading in SI Unit
MsmtRdngIsEntered MsmtRdngIsEntered Indicator: Associated Number Field Contains a Value
MeasurementReadingInEntryUoM MeasurementReadingInEntryUoM Measurement Reading in Unit of Entry
MsmtReadingInEntryUoMIsEntered MsmtReadingInEntryUoMIsEntered Indicator: Associated Number Field Contains a Value
MeasurementReadingEntryUoM MeasurementReadingEntryUoM Unit of Measurement for Document Entry
MeasurementCounterReading MeasurementCounterReading Counter Reading in SI Unit
MsmtCntrRdngIsEntered MsmtCntrRdngIsEntered Indicator: Associated Number Field Contains a Value
MsmtCounterReadingDifference MsmtCounterReadingDifference Counter Reading Difference in SI Unit
MsmtCntrReadingDiffIsEntered MsmtCntrReadingDiffIsEntered Indicator: Counter Reading Entered as Difference
MsmtCounterReadingIsReplaced MsmtCounterReadingIsReplaced Indicator: Counter Replaced
TotalMsmtRdngIsSetExternally TotalMsmtRdngIsSetExternally Indicator: Total Counter Reading Set Externally
MeasurementDocumentCatalogType MeasurementDocumentCatalogType Catalog Type - Measurement Reading Valuation Code
MeasurementDocumentCodeGroup MeasurementDocumentCodeGroup Code Group - Measurement Reading Valuation Code
MsmtValuationCode MsmtValuationCode Valuation code
MsmtValuationCodeVersNmbr MsmtValuationCodeVersNmbr Version Number
MsmtRdngStatus MsmtRdngStatus Processing Status
MsmtRdngIsReversed MsmtRdngIsReversed Reversal Indicator
InspectionValuationResult InspectionValuationResult Inspection Result Valuation
MsmtRdngIsIntervalDoc MsmtRdngIsIntervalDoc Indicator that Document Refers to Time Interval
MsmtRdngIntervalStartDate MsmtRdngIntervalStartDate Date of Interval Start
MsmtRdngIntervalStartTime MsmtRdngIntervalStartTime Time of Interval Start
MaintOrderOperationInternalID MaintOrderOperationInternalID Object Number of Order Operation/Confirmation Counter etc.
_ControllingObject _ControllingObject
_InspectionLot _InspectionLot
_Language _Language
_MaintenanceNotification _MaintenanceNotification
_MaintenanceOrder _MaintenanceOrder
_MeasurementDocumentCodeGroup _MeasurementDocumentCodeGroup
_MeasurementValuationCode _MeasurementValuationCode
_MeasuringPoint _MeasuringPoint
_MsmtDocumentCatalogType _MsmtDocumentCatalogType
_MsmtRdngSourceMeasurementDoc _MsmtRdngSourceMeasurementDoc
_UnitOfMeasure _UnitOfMeasure

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_MeasurementDocumentDEX.
-- 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_MeasurementDocumentDEX AS
SELECT
  MeasurementDocument,
  MeasuringPoint,
  MsmtRdngDate,
  MsmtRdngTime,
  MsmtRdngIsForCounter,
  MeasurementDocumentText,
  Language,
  MeasurementDocumentHasLongText,
  MsmtRdngByUser,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  SingleLevelDeletionLogicFlag,
  MeasurementDocumentOrigin,
  InspectionLot,
  InspectionCharacteristic,
  MsmtRdngSourceMeasurementDoc,
  ProdnRsceToolTypeCode,
  ProdnRsceToolInternalID,
  MsmtDocumentReferredOrder,
  MsmtIsDoneAfterTaskCompltn,
  MeasurementReading,
  MsmtRdngIsEntered,
  MeasurementReadingInEntryUoM,
  MsmtReadingInEntryUoMIsEntered,
  MeasurementReadingEntryUoM,
  MeasurementCounterReading,
  MsmtCntrRdngIsEntered,
  MsmtCounterReadingDifference,
  MsmtCntrReadingDiffIsEntered,
  MsmtCounterReadingIsReplaced,
  TotalMsmtRdngIsSetExternally,
  MeasurementDocumentCatalogType,
  MeasurementDocumentCodeGroup,
  MsmtValuationCode,
  MsmtValuationCodeVersNmbr,
  MsmtRdngStatus,
  MsmtRdngIsReversed,
  InspectionValuationResult,
  MsmtRdngIsIntervalDoc,
  MsmtRdngIntervalStartDate,
  MsmtRdngIntervalStartTime,
  MaintOrderOperationInternalID
FROM I_MeasurementDocument
;

Learn More