ESH_N_MEASURING_POINT

DDL: ESH_N_MEASURING_POINT SQL: ESH_L_MEASPOINT Type: view Package: BSESH_PM
28 Fields 1 Data Sources

Anchor view -MEASURING_POINT

ESH_N_MEASURING_POINT is a CDS View that provides data about "Anchor view -MEASURING_POINT" in SAP S/4HANA. It reads from 1 data source (P_MeasuringPointSearch) and exposes 28 fields with key field MeasuringPoint. Part of development package BSESH_PM.

Data Sources (1)

SourceAliasJoin Type
P_MeasuringPointSearch P_MeasuringPointSearch from

Parameters (2)

NameTypeDefault
P_Language abap.lang
P_KEYDATE sydate

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_MEASPOINT view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY MeasuringPoint MeasuringPoint
Characteristic
CharcValueUnit
CharcDescription
CharcValue
PlainLongText
AuthorizationGroup AuthorizationGroup AuthorizGroup
Equipment _Equipment Equipment Equipment check
MeasurementTransferIsSupported MeasurementTransferIsSupported
InspSpecAdditionalCatalogText
InspSpecAddlCodeGroupText
MeasuringPointPositionNumber MeasuringPointPositionNumber
MeasuringPointCategory MeasuringPointCategory
MeasuringPointIsInactive MeasuringPointIsInactive
Assembly Assembly Pegged Reqmt
MsrgPtIsCountingBackwards MsrgPtIsCountingBackwards
MeasuringPointAnnualEstimate MeasuringPointAnnualEstimate
MeasuringPointCatalogType MeasuringPointCatalogType
MeasuringPointCodeGroup MeasuringPointCodeGroup
ValuationCodeIsSufficient ValuationCodeIsSufficient
MeasuringPointDescription MeasuringPointDescription
MeasuringPointIsReference MeasuringPointIsReference
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
MeasuringPointIsCounter MeasuringPointIsCounter
MeasuringPointCategoryDesc
FunctionalLocation _FunctionalLocation FunctionalLocation Object ID
FuncnlLocPrimaryLabelName

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 ESH_N_MEASURING_POINT.
-- 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: ESH_L_MEASPOINT
-- Parameters: P_Language : abap.lang, P_KEYDATE : sydate

CREATE VIEW ESH_N_MEASURING_POINT AS
SELECT
  MeasuringPoint,
  _Characteristic(P_KeyDate : $parameters.P_KEYDATE).Characteristic AS Characteristic,
  _Characteristic(P_KEYDATE : $parameters.P_KEYDATE).CharcValueUnit AS CharcValueUnit,
  _Characteristic(P_KEYDATE : $parameters.P_KEYDATE)._CharacteristicDesc(P_KeyDate : $parameters.P_KEYDATE)[1: Language = $parameters.P_Language ].CharcDescription AS CharcDescription,
  _Characteristic(P_KEYDATE : $parameters.P_KEYDATE)._CharacteristicValue(P_KeyDate : $parameters.P_KEYDATE).CharcValue AS CharcValue,
  _LongText[1: Language = $parameters.P_Language ].PlainLongText AS PlainLongText,
  AuthorizationGroup,
  _Equipment.Equipment AS Equipment,
  MeasurementTransferIsSupported,
  _MsmtRdngSourceMeasuringPoint._MeasuringPointCatalogType._InspectionCatalogText[1: Language = $parameters.P_Language ].InspSpecAdditionalCatalogText AS InspSpecAdditionalCatalogText,
  _MsmtRdngSourceMeasuringPoint._MeasuringPointCodeGroup._Text[1: Language = $parameters.P_Language ].InspSpecAddlCodeGroupText AS InspSpecAddlCodeGroupText,
  MeasuringPointPositionNumber,
  MeasuringPointCategory,
  MeasuringPointIsInactive,
  Assembly,
  MsrgPtIsCountingBackwards,
  MeasuringPointAnnualEstimate,
  MeasuringPointCatalogType,
  MeasuringPointCodeGroup,
  ValuationCodeIsSufficient,
  MeasuringPointDescription,
  MeasuringPointIsReference,
  CreatedByUser,
  LastChangedByUser,
  MeasuringPointIsCounter,
  _MeasuringPointCategory._MeasuringPointCategoryText[1: Language = $parameters.P_Language ].MeasuringPointCategoryDesc AS MeasuringPointCategoryDesc,
  _FunctionalLocation.FunctionalLocation AS FunctionalLocation,
  _FunctionalLocation._FunctionalLocationLabel.FuncnlLocPrimaryLabelName AS FuncnlLocPrimaryLabelName
FROM P_MeasuringPointSearch
;

Learn More