I_MeasurementDocumentData

DDL: I_MEASUREMENTDOCUMENTDATA SQL: IMEASDOCDATA Type: view COMPOSITE
53 Fields 2 Data Sources

Measurement Document Data

I_MeasurementDocumentData is a Composite CDS View (Fact) that provides data about "Measurement Document Data" in SAP S/4HANA. It reads from 2 data sources (I_MeasurementDocument, I_MeasuringPointData) and exposes 53 fields with key field MeasurementDocument.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryFact
StatusReleased
Data Extraction TypeFull (physical deletions are possible in source tables)
Corresponding DataSource0I_MEASUREMENTDOCDATA
Purpose
This CDS view provides the prerequisites for answering the following business questions: What is the description of the measurement document and is there a long text available? Who created or last changed the measurement document and at what time? Who entered the measuring readings at what date and time? Is the measurement document marked for deletion? To which maintenance order or order operation is the measurement document related? What are the details of the counter: has the counter been replaced? Is the counter reading a difference counter reading? What are the details of the related measurement readings? What are the measurement reading values and the measurement reading differences? 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 measurement documents in transactions IK13 and IK17 . 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: Measurement document 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: Measurement document description Measurement date and time Long text availability Person who entered the measurement readings Measurement document creation date and time Creator Changer Deletion flag Origin indicator Source document Maintenance order Measurement reading in SI unit Measurement reading difference in SI unit Difference counter reading flag Replaced counter flag Measurement reading data, for example Catalog Type and Code Group Maintenance order operation Key Performance Indicators (KPIs) Name Value MsmtReadingIsUnderThreshold 0 or 1. It is 0 if the measurement reading is above the low threshold limit of the measuring point. It is 1 if the measurement reading is under the low threshold limit of the measuring point. MsmtReadingIsOverThreshold 0 or 1. It is 0 if the measurement reading is under the top threshold limit of the measuring point. It is 1 if the measurement reading is above the top threshold limit of the measuring point.

SAP Business Warehouse (SAP 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 SAP Library BI Content Product Lifecycle Management Asset Lifecycle Management Plant Maintenance .

View on SAP Help Portal →

Data Sources (2)

SourceAliasJoin Type
I_MeasurementDocument I_MeasurementDocument from
I_MeasuringPointData I_MeasuringPointData inner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IMEASDOCDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Measurement Document Data view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.sapObjectNodeType.name MeasurementDocument view
ObjectModel.representativeKey MeasurementDocument view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.modelingPattern #EXTRACTION_DATA_SOURCE view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY MeasurementDocument I_MeasurementDocument MeasurementDocument Measurement Doc. No.
MeasuringPoint I_MeasurementDocument MeasuringPoint Measuring point
Language I_MeasurementDocument Language Report Text Language
MeasurementDocumentText I_MeasurementDocument MeasurementDocumentText Text
MsmtRdngDate I_MeasurementDocument MsmtRdngDate Single-Character Flag
MsmtRdngTime I_MeasurementDocument MsmtRdngTime Single-Character Flag
MeasurementReadingDateTime I_MeasurementDocument MeasurementReadingDateTime
MeasurementDocumentHasLongText I_MeasurementDocument MeasurementDocumentHasLongText More text
MsmtRdngByUser I_MeasurementDocument MsmtRdngByUser Read by
CreationDate I_MeasurementDocument CreationDate Time Stamp
CreationTime I_MeasurementDocument CreationTime Time of Change
MsmtDocumentCreationDateTime I_MeasurementDocument MsmtDocumentCreationDateTime
CreatedByUser I_MeasurementDocument CreatedByUser User Name
LastChangeDate I_MeasurementDocument LastChangeDate Time Stamp
LastChangedByUser I_MeasurementDocument LastChangedByUser User Name
SingleLevelDeletionLogicFlag I_MeasurementDocument SingleLevelDeletionLogicFlag Stock del. flag
MeasurementDocumentOrigin I_MeasurementDocument MeasurementDocumentOrigin Origin indic.
InspectionLot I_MeasurementDocument InspectionLot Inspection Lot
InspectionCharacteristic I_MeasurementDocument InspectionCharacteristic Characteristic
MsmtRdngSourceMeasurementDoc I_MeasurementDocument MsmtRdngSourceMeasurementDoc Source document
ProdnRsceToolTypeCode I_MeasurementDocument ProdnRsceToolTypeCode Object category
ProdnRsceToolInternalID I_MeasurementDocument ProdnRsceToolInternalID ProdResTool
MsmtDocumentReferredOrder I_MeasurementDocument MsmtDocumentReferredOrder OrderObjectNo.
MsmtIsDoneAfterTaskCompltn I_MeasurementDocument MsmtIsDoneAfterTaskCompltn AfterMaintTask
MeasurementReading I_MeasurementDocument MeasurementReading MeasRdg
MeasurementReadingInEntryUoM I_MeasurementDocument MeasurementReadingInEntryUoM MeasReading
MeasurementReadingEntryUoM I_MeasurementDocument MeasurementReadingEntryUoM DocMeasUnit
MsmtDocumentSIUnitOfMeasure I_MeasurementDocument MsmtDocumentSIUnitOfMeasure
MeasurementCounterReading I_MeasurementDocument MeasurementCounterReading CntrReadg
MsmtCounterReadingDifference I_MeasurementDocument MsmtCounterReadingDifference Difference
MsmtCntrReadingDiffIsEntered I_MeasurementDocument MsmtCntrReadingDiffIsEntered DiffEntered
MsmtCounterReadingIsReplaced I_MeasurementDocument MsmtCounterReadingIsReplaced CountrReplaced
MeasurementDocumentCatalogType I_MeasurementDocument MeasurementDocumentCatalogType Catalog type
MeasurementDocumentCodeGroup I_MeasurementDocument MeasurementDocumentCodeGroup Code group
MsmtValuationCode I_MeasurementDocument MsmtValuationCode Valuation code
MsmtValuationCodeVersNmbr I_MeasurementDocument MsmtValuationCodeVersNmbr Version
MsmtRdngStatus I_MeasurementDocument MsmtRdngStatus ProcessStatus
MsmtRdngIsReversed I_MeasurementDocument MsmtRdngIsReversed Reversal ind.
InspectionValuationResult I_MeasurementDocument InspectionValuationResult Valuation
MsmtRdngIsIntervalDoc I_MeasurementDocument MsmtRdngIsIntervalDoc Interval doc.
MsmtRdngIntervalStartDate I_MeasurementDocument MsmtRdngIntervalStartDate Time from
MsmtRdngIntervalStartTime I_MeasurementDocument MsmtRdngIntervalStartTime Time from
MaintOrderOperationInternalID I_MeasurementDocument MaintOrderOperationInternalID Object number
AuthorizationGroup
_Language I_MeasurementDocument _Language
_MeasuringPoint I_MeasurementDocument _MeasuringPoint
_InspectionLot I_MeasurementDocument _InspectionLot
_MsmtRdngSourceMeasurementDoc I_MeasurementDocument _MsmtRdngSourceMeasurementDoc
_ControllingObject I_MeasurementDocument _ControllingObject
_UnitOfMeasure I_MeasurementDocument _UnitOfMeasure
_MsmtDocumentCatalogType I_MeasurementDocument _MsmtDocumentCatalogType
_MeasurementDocumentCodeGroup I_MeasurementDocument _MeasurementDocumentCodeGroup
_MeasurementValuationCode I_MeasurementDocument _MeasurementValuationCode

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_MeasurementDocumentData.
-- 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: IMEASDOCDATA

CREATE VIEW I_MeasurementDocumentData AS
SELECT
  I_MeasurementDocument.MeasurementDocument AS MeasurementDocument,
  I_MeasurementDocument.MeasuringPoint AS MeasuringPoint,
  I_MeasurementDocument.Language AS Language,
  I_MeasurementDocument.MeasurementDocumentText AS MeasurementDocumentText,
  I_MeasurementDocument.MsmtRdngDate AS MsmtRdngDate,
  I_MeasurementDocument.MsmtRdngTime AS MsmtRdngTime,
  I_MeasurementDocument.MeasurementReadingDateTime AS MeasurementReadingDateTime,
  I_MeasurementDocument.MeasurementDocumentHasLongText AS MeasurementDocumentHasLongText,
  I_MeasurementDocument.MsmtRdngByUser AS MsmtRdngByUser,
  I_MeasurementDocument.CreationDate AS CreationDate,
  I_MeasurementDocument.CreationTime AS CreationTime,
  I_MeasurementDocument.MsmtDocumentCreationDateTime AS MsmtDocumentCreationDateTime,
  I_MeasurementDocument.CreatedByUser AS CreatedByUser,
  I_MeasurementDocument.LastChangeDate AS LastChangeDate,
  I_MeasurementDocument.LastChangedByUser AS LastChangedByUser,
  I_MeasurementDocument.SingleLevelDeletionLogicFlag AS SingleLevelDeletionLogicFlag,
  I_MeasurementDocument.MeasurementDocumentOrigin AS MeasurementDocumentOrigin,
  I_MeasurementDocument.InspectionLot AS InspectionLot,
  I_MeasurementDocument.InspectionCharacteristic AS InspectionCharacteristic,
  I_MeasurementDocument.MsmtRdngSourceMeasurementDoc AS MsmtRdngSourceMeasurementDoc,
  I_MeasurementDocument.ProdnRsceToolTypeCode AS ProdnRsceToolTypeCode,
  I_MeasurementDocument.ProdnRsceToolInternalID AS ProdnRsceToolInternalID,
  I_MeasurementDocument.MsmtDocumentReferredOrder AS MsmtDocumentReferredOrder,
  I_MeasurementDocument.MsmtIsDoneAfterTaskCompltn AS MsmtIsDoneAfterTaskCompltn,
  I_MeasurementDocument.MeasurementReading AS MeasurementReading,
  I_MeasurementDocument.MeasurementReadingInEntryUoM AS MeasurementReadingInEntryUoM,
  I_MeasurementDocument.MeasurementReadingEntryUoM AS MeasurementReadingEntryUoM,
  I_MeasurementDocument.MsmtDocumentSIUnitOfMeasure AS MsmtDocumentSIUnitOfMeasure,
  I_MeasurementDocument.MeasurementCounterReading AS MeasurementCounterReading,
  I_MeasurementDocument.MsmtCounterReadingDifference AS MsmtCounterReadingDifference,
  I_MeasurementDocument.MsmtCntrReadingDiffIsEntered AS MsmtCntrReadingDiffIsEntered,
  I_MeasurementDocument.MsmtCounterReadingIsReplaced AS MsmtCounterReadingIsReplaced,
  I_MeasurementDocument.MeasurementDocumentCatalogType AS MeasurementDocumentCatalogType,
  I_MeasurementDocument.MeasurementDocumentCodeGroup AS MeasurementDocumentCodeGroup,
  I_MeasurementDocument.MsmtValuationCode AS MsmtValuationCode,
  I_MeasurementDocument.MsmtValuationCodeVersNmbr AS MsmtValuationCodeVersNmbr,
  I_MeasurementDocument.MsmtRdngStatus AS MsmtRdngStatus,
  I_MeasurementDocument.MsmtRdngIsReversed AS MsmtRdngIsReversed,
  I_MeasurementDocument.InspectionValuationResult AS InspectionValuationResult,
  I_MeasurementDocument.MsmtRdngIsIntervalDoc AS MsmtRdngIsIntervalDoc,
  I_MeasurementDocument.MsmtRdngIntervalStartDate AS MsmtRdngIntervalStartDate,
  I_MeasurementDocument.MsmtRdngIntervalStartTime AS MsmtRdngIntervalStartTime,
  I_MeasurementDocument.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  I_MeasurementDocument._MeasuringPoint.AuthorizationGroup AS AuthorizationGroup,
  I_MeasurementDocument._Language AS _Language,
  I_MeasurementDocument._MeasuringPoint AS _MeasuringPoint,
  I_MeasurementDocument._InspectionLot AS _InspectionLot,
  I_MeasurementDocument._MsmtRdngSourceMeasurementDoc AS _MsmtRdngSourceMeasurementDoc,
  I_MeasurementDocument._ControllingObject AS _ControllingObject,
  I_MeasurementDocument._UnitOfMeasure AS _UnitOfMeasure,
  I_MeasurementDocument._MsmtDocumentCatalogType AS _MsmtDocumentCatalogType,
  I_MeasurementDocument._MeasurementDocumentCodeGroup AS _MeasurementDocumentCodeGroup,
  I_MeasurementDocument._MeasurementValuationCode AS _MeasurementValuationCode
FROM I_MeasurementDocument
INNER JOIN I_MeasuringPointData ON /* join condition not captured in parsed metadata */
;

Learn More