P_MeasurementDocSearch

DDL: P_MEASUREMENTDOCSEARCH Type: view_entity BASIC Package: BSESH_PM
48 Fields 1 Data Sources 1 Associations

Measuring Document Anchor View for CDS Search Model

P_MeasurementDocSearch is a Basic CDS View that provides data about "Measuring Document Anchor View for CDS Search Model" in SAP S/4HANA. It reads from 1 data source (I_MeasurementDocument) and exposes 48 fields with key field MeasurementDocument. It has 1 association to related views. Part of development package BSESH_PM.

Data Sources (1)

SourceAliasJoin Type
I_MeasurementDocument I_MeasurementDocument from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_TextObjectPlainLongText _LongText $projection.MeasurementDocument = _LongText.TextObjectKey and _LongText.TextObjectCategory = 'IMRG' and _LongText.TextObjectType = 'LTXT'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.representativeKey MeasurementDocument view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (48)

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

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 P_MeasurementDocSearch.
-- 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 P_MeasurementDocSearch AS
SELECT
  MeasurementDocument,
  MeasuringPoint,
  MsmtRdngDate,
  MsmtRdngTime,
  MeasurementDocumentText,
  Language,
  MeasurementDocumentHasLongText,
  MsmtRdngByUser,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  SingleLevelDeletionLogicFlag,
  MeasurementDocumentOrigin,
  InspectionLot,
  InspectionCharacteristic,
  MsmtRdngSourceMeasurementDoc,
  ProdnRsceToolTypeCode,
  ProdnRsceToolInternalID,
  MsmtIsDoneAfterTaskCompltn,
  MeasurementReading,
  MeasurementReadingInEntryUoM,
  MeasurementReadingEntryUoM,
  MeasurementCounterReading,
  MsmtCounterReadingDifference,
  MsmtCntrReadingDiffIsEntered,
  MsmtCounterReadingIsReplaced,
  MeasurementDocumentCatalogType,
  MeasurementDocumentCodeGroup,
  MsmtValuationCode,
  MsmtValuationCodeVersNmbr,
  MsmtRdngStatus,
  MsmtRdngIsReversed,
  InspectionValuationResult,
  MsmtRdngIsIntervalDoc,
  MsmtRdngIntervalStartDate,
  MsmtRdngIntervalStartTime,
  MaintOrderOperationInternalID
FROM I_MeasurementDocument
LEFT OUTER JOIN I_TextObjectPlainLongText AS _LongText ON MeasurementDocument = _LongText.TextObjectKey AND _LongText.TextObjectCategory = 'IMRG' AND _LongText.TextObjectType = 'LTXT'  -- association [0..*]
;

Learn More