P_MeasuringPointSearch

DDL: P_MEASURINGPOINTSEARCH SQL: PMEASURINGPTSRCH Type: view BASIC
46 Fields 1 Data Sources 1 Associations

P_MeasuringPointSearch is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_MeasuringPoint) and exposes 46 fields with key field MeasuringPoint. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MeasuringPoint I_MeasuringPoint from

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PMEASURINGPTSRCH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.representativeKey MeasuringPoint view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY MeasuringPoint MeasuringPoint Measuring point
MeasuringPointObjectIdentifier MeasuringPointObjectIdentifier OBjNo.MeasPObj.
MeasuringPointPositionNumber MeasuringPointPositionNumber MeasPosition
MeasuringPointCategory MeasuringPointCategory MPlan cat.
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
AuthorizationGroup AuthorizationGroup AuthorizGroup
MeasuringPointIsInactive MeasuringPointIsInactive TRUE
MeasuringPointIsCounter MeasuringPointIsCounter Counter
MultiLevelDeletionLogicStatus MultiLevelDeletionLogicStatus Stock del. flag
Assembly Assembly Pegged Reqmt
ReferenceMeasuringPoint ReferenceMeasuringPoint Ref. Meas. Pt
MsrgPtInternalCharacteristic MsrgPtInternalCharacteristic Internal char.
MeasuringPointExponent MeasuringPointExponent FloatPointExp.
MeasuringPointDecimalPlaces MeasuringPointDecimalPlaces Decimal places
MeasuringPointMinimumThreshold MeasuringPointMinimumThreshold LoMRLimit
MeasuringPointMaximumThreshold MeasuringPointMaximumThreshold UpMRLimit
MeasurementRangeUnit MeasurementRangeUnit MeasRangeUnit
MsrgPtIsCountingBackwards MsrgPtIsCountingBackwards Backwards
MsmtRdngSourceMeasuringPoint MsmtRdngSourceMeasuringPoint Univ. Journ. Integr.
CounterOverflowRdngThreshold CounterOverflowRdngThreshold CtrOverReadg
MeasuringPointAnnualEstimate MeasuringPointAnnualEstimate AnnualEstimate
MeasuringPointCatalogType MeasuringPointCatalogType Catalog type
MeasuringPointCodeGroup MeasuringPointCodeGroup Code group
ValuationCodeIsSufficient ValuationCodeIsSufficient ValCode suff.
Language Language Report Text Language
MeasuringPointDescription MeasuringPointDescription Description
MeasuringPointShortText MeasuringPointShortText Text
MeasuringPointIsReference MeasuringPointIsReference RefMeasPoint
MeasurementTransferIsSupported MeasurementTransferIsSupported Supported
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
MeasuringPointHasLongText MeasuringPointHasLongText More text
_Characteristic _Characteristic
_ControllingObject _ControllingObject
_Equipment _Equipment
_FunctionalLocation _FunctionalLocation
_Language _Language
_MeasuringPointCatalogType _MeasuringPointCatalogType
_MeasuringPointCategory _MeasuringPointCategory
_MeasuringPointCodeGroup _MeasuringPointCodeGroup
_MsmtRdngSourceMeasuringPoint _MsmtRdngSourceMeasuringPoint
_Product _Product
_ReferenceMeasuringPoint _ReferenceMeasuringPoint
_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_MeasuringPointSearch.
-- 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: PMEASURINGPTSRCH

CREATE VIEW P_MeasuringPointSearch AS
SELECT
  MeasuringPoint,
  MeasuringPointObjectIdentifier,
  MeasuringPointPositionNumber,
  MeasuringPointCategory,
  CreationDate,
  LastChangeDate,
  AuthorizationGroup,
  MeasuringPointIsInactive,
  MeasuringPointIsCounter,
  MultiLevelDeletionLogicStatus,
  Assembly,
  ReferenceMeasuringPoint,
  MsrgPtInternalCharacteristic,
  MeasuringPointExponent,
  MeasuringPointDecimalPlaces,
  MeasuringPointMinimumThreshold,
  MeasuringPointMaximumThreshold,
  MeasurementRangeUnit,
  MsrgPtIsCountingBackwards,
  MsmtRdngSourceMeasuringPoint,
  CounterOverflowRdngThreshold,
  MeasuringPointAnnualEstimate,
  MeasuringPointCatalogType,
  MeasuringPointCodeGroup,
  ValuationCodeIsSufficient,
  Language,
  MeasuringPointDescription,
  MeasuringPointShortText,
  MeasuringPointIsReference,
  MeasurementTransferIsSupported,
  CreatedByUser,
  LastChangedByUser,
  MeasuringPointHasLongText
FROM I_MeasuringPoint
LEFT OUTER JOIN I_TextObjectPlainLongText AS _LongText ON MeasuringPoint = _LongText.TextObjectKey AND _LongText.TextObjectCategory = 'IMPTT' AND _LongText.TextObjectType = 'LTXT'  -- association [0..*]
;

Learn More