I_MeasurementDocumentTP_2

DDL: I_MEASUREMENTDOCUMENTTP_2 Type: view_entity TRANSACTIONAL

Measurement Document - TP

I_MeasurementDocumentTP_2 is a Transactional CDS View that provides data about "Measurement Document - TP" in SAP S/4HANA. It reads from 1 data source (R_MeasurementDocumentTP) and exposes 28 fields with key field MeasurementDocument.

Data Sources (1)

SourceAliasJoin Type
R_MeasurementDocumentTP R_MeasurementDocumentTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Measurement Document - TP view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name MeasurementDocument view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY MeasurementDocument MeasurementDocument
MeasuringPoint MeasuringPoint
MeasuringPointPositionNumber MeasuringPointPositionNumber
MsmtRdngDate MsmtRdngDate
MsmtRdngTime MsmtRdngTime
Characteristic Characteristic Field Name
MsmtDocumentReferredOrder MsmtDocumentReferredOrder
RefdMaintOrderOpStatusObject RefdMaintOrderOpStatusObject Object number
MaintenanceOrderOperation MaintenanceOrderOperation Suboperation
MaintenanceOrderSubOperation MaintenanceOrderSubOperation Suboperation
MsmtIsDoneAfterTaskCompltn MsmtIsDoneAfterTaskCompltn
CharcValueUnit CharcValueUnit Internal UoM
MeasurementReading MeasurementReading
MeasurementReadingInEntryUoM MeasurementReadingInEntryUoM
MeasurementReadingEntryUoM MeasurementReadingEntryUoM
MeasurementCounterReading MeasurementCounterReading
MsmtCounterReadingDifference MsmtCounterReadingDifference
TotalMsmtRdngIsSetExternally TotalMsmtRdngIsSetExternally
MeasuringPointTargetValue MeasuringPointTargetValue
MsmtValuationCode MsmtValuationCode
MeasurementDocumentText MeasurementDocumentText
MeasurementDocumentHasLongText MeasurementDocumentHasLongText
MsmtRdngByUser MsmtRdngByUser
MsmtRdngStatus MsmtRdngStatus
MsmtCntrReadingDiffIsEntered MsmtCntrReadingDiffIsEntered
MsmtRdngIsReversed MsmtRdngIsReversed
AuthorizationGroup AuthorizationGroup AuthorizGroup
MsmtCounterReadingIsReplaced MsmtCounterReadingIsReplaced

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_MeasurementDocumentTP_2.
-- 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 I_MeasurementDocumentTP_2 AS
SELECT
  MeasurementDocument,
  MeasuringPoint,
  MeasuringPointPositionNumber,
  MsmtRdngDate,
  MsmtRdngTime,
  Characteristic,
  MsmtDocumentReferredOrder,
  RefdMaintOrderOpStatusObject,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  MsmtIsDoneAfterTaskCompltn,
  CharcValueUnit,
  MeasurementReading,
  MeasurementReadingInEntryUoM,
  MeasurementReadingEntryUoM,
  MeasurementCounterReading,
  MsmtCounterReadingDifference,
  TotalMsmtRdngIsSetExternally,
  MeasuringPointTargetValue,
  MsmtValuationCode,
  MeasurementDocumentText,
  MeasurementDocumentHasLongText,
  MsmtRdngByUser,
  MsmtRdngStatus,
  MsmtCntrReadingDiffIsEntered,
  MsmtRdngIsReversed,
  AuthorizationGroup,
  MsmtCounterReadingIsReplaced
FROM R_MeasurementDocumentTP
;