C_MeasurementDocumentDP

DDL: C_MEASUREMENTDOCUMENTDP Type: view_entity CONSUMPTION Package: VDM_EAM_MEASUREMENTDOCUMENT
56 Fields 1 Data Sources 1 OData Services

Data Provider for Measurement Document

C_MeasurementDocumentDP is a Consumption CDS View that provides data about "Data Provider for Measurement Document" in SAP S/4HANA. It reads from 1 data source (C_MeasurementDocumentDEX) and exposes 56 fields with key field MeasurementDocument. It is exposed through 1 OData service (DP_MEASUREMENTDOCUMENT). Part of development package VDM_EAM_MEASUREMENTDOCUMENT.

Data Sources (1)

SourceAliasJoin Type
C_MeasurementDocumentDEX C_MeasurementDocumentDEX from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Data Provider for Measurement Document view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name MeasurementDocument view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
DataIntegration.deltaReplication.intended true view

OData Services (1)

ServiceBindingVersionContractRelease
DP_MEASUREMENTDOCUMENT DP_MEASUREMENTDOCUMENT C2 NOT_RELEASED

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY MeasurementDocument MeasurementDocument
MeasuringPoint MeasuringPoint
MsmtRdngDate MsmtRdngDate
MsmtRdngTime MsmtRdngTime
MsmtRdngIsForCounter MsmtRdngIsForCounter
MeasurementDocumentText MeasurementDocumentText
Language Language Report Text Language
MeasurementDocumentHasLongText MeasurementDocumentHasLongText
MsmtRdngByUser MsmtRdngByUser
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
SingleLevelDeletionLogicFlag SingleLevelDeletionLogicFlag
MeasurementDocumentOrigin MeasurementDocumentOrigin
InspectionLot InspectionLot Inspection Lot
InspectionCharacteristic InspectionCharacteristic
MsmtRdngSourceMeasurementDoc MsmtRdngSourceMeasurementDoc
ProdnRsceToolTypeCode ProdnRsceToolTypeCode
ProdnRsceToolInternalID ProdnRsceToolInternalID
MsmtDocumentReferredOrder MsmtDocumentReferredOrder
MsmtIsDoneAfterTaskCompltn MsmtIsDoneAfterTaskCompltn
MeasurementReading MeasurementReading
MsmtRdngIsEntered MsmtRdngIsEntered Is Msmt Reading Entered
MeasurementReadingInEntryUoM MeasurementReadingInEntryUoM
MsmtReadingInEntryUoMIsEntered MsmtReadingInEntryUoMIsEntered Is MSMT Reading In UoM Entered
MeasurementReadingEntryUoM MeasurementReadingEntryUoM
MeasurementCounterReading MeasurementCounterReading
MsmtCntrRdngIsEntered MsmtCntrRdngIsEntered Is Msmt Counter Reading Entered
MsmtCounterReadingDifference MsmtCounterReadingDifference
MsmtCntrReadingDiffIsEntered MsmtCntrReadingDiffIsEntered
MsmtCounterReadingIsReplaced MsmtCounterReadingIsReplaced
TotalMsmtRdngIsSetExternally TotalMsmtRdngIsSetExternally
MeasurementDocumentCatalogType MeasurementDocumentCatalogType
MeasurementDocumentCodeGroup MeasurementDocumentCodeGroup
MsmtValuationCode MsmtValuationCode
MsmtValuationCodeVersNmbr MsmtValuationCodeVersNmbr
MsmtRdngStatus MsmtRdngStatus
MsmtRdngIsReversed MsmtRdngIsReversed
InspectionValuationResult InspectionValuationResult
MsmtRdngIsIntervalDoc MsmtRdngIsIntervalDoc
MsmtRdngIntervalStartDate MsmtRdngIntervalStartDate Interval Start Date
MsmtRdngIntervalStartTime MsmtRdngIntervalStartTime
MaintOrderOperationInternalID MaintOrderOperationInternalID Object number
_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_MeasurementDocumentDP.
-- 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_MeasurementDocumentDP 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 C_MeasurementDocumentDEX
;

Learn More