ESH_N_MEASUREMENT_DOCUMENT

DDL: ESH_N_MEASUREMENT_DOCUMENT SQL: ESH_L_MEASDOC Type: view
32 Fields 1 Data Sources

ESH_N_MEASUREMENT_DOCUMENT is a CDS View in SAP S/4HANA. It reads from 1 data source (P_MeasurementDocSearch) and exposes 32 fields with key field MeasurementDocument.

Data Sources (1)

SourceAliasJoin Type
P_MeasurementDocSearch P_MeasurementDocSearch 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 #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_MEASDOC view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY MeasurementDocument MeasurementDocument
Assembly
AssetManufacturerName
AuthorizationGroup
Characteristic
CharcValueUnit
CharcDescription
CharcValue
CreatedByUser CreatedByUser User Name
Equipment
EquipmentName
FunctionalLocation
FuncnlLocPrimaryLabelName
FunctionalLocationName
InspectionCodeText
InspSpecAddlCodeGroupText
LastChangedByUser LastChangedByUser User Name
MeasurementDocumentCatalogType MeasurementDocumentCatalogType
MeasurementDocumentCodeGroup MeasurementDocumentCodeGroup
MeasurementDocumentOrigin MeasurementDocumentOrigin
MeasurementDocumentText MeasurementDocumentText
MeasuringPoint MeasuringPoint
MeasuringPointCategory
MeasuringPointDescription
MeasuringPointIsCounter
MeasuringPointPositionNumber
MsmtRdngByUser MsmtRdngByUser
MsmtRdngDate MsmtRdngDate
MsmtRdngStatus MsmtRdngStatus
MsmtValuationCode MsmtValuationCode
PlainLongText
ReferenceMeasuringPoint

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_MEASUREMENT_DOCUMENT.
-- 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_MEASDOC
-- Parameters: P_Language : abap.lang, P_KeyDate : sydate

CREATE VIEW ESH_N_MEASUREMENT_DOCUMENT AS
SELECT
  MeasurementDocument,
  _MeasuringPoint[1: Language = $parameters. P_Language].Assembly AS Assembly,
  _MeasuringPoint._Equipment.AssetManufacturerName AS AssetManufacturerName,
  _MeasuringPoint[1: Language = $parameters. P_Language].AuthorizationGroup AS AuthorizationGroup,
  _MeasuringPoint._Characteristic( P_KeyDate: $parameters.P_KeyDate ).Characteristic AS Characteristic,
  _MeasuringPoint._Characteristic(P_KEYDATE : $parameters.P_KEYDATE).CharcValueUnit AS CharcValueUnit,
  _MeasuringPoint._Characteristic(P_KEYDATE : $parameters.P_KEYDATE)._CharacteristicDesc(P_KeyDate : $parameters.P_KeyDate)[1: Language = $parameters.P_Language ].CharcDescription AS CharcDescription,
  _MeasuringPoint._Characteristic(P_KEYDATE : $parameters.P_KEYDATE)._CharacteristicValue(P_KeyDate : $parameters.P_KeyDate).CharcValue AS CharcValue,
  CreatedByUser,
  _MeasuringPoint._Equipment.Equipment AS Equipment,
  _MeasuringPoint._Equipment._EquipmentText[1: Language = $parameters. P_Language].EquipmentName AS EquipmentName,
  _MeasuringPoint._FunctionalLocation.FunctionalLocation AS FunctionalLocation,
  _MeasuringPoint._FunctionalLocation._FunctionalLocationLabel.FuncnlLocPrimaryLabelName AS FuncnlLocPrimaryLabelName,
  _MeasuringPoint._FunctionalLocation._FunctionalLocationText[1: Language = $parameters. P_Language].FunctionalLocationName AS FunctionalLocationName,
  _MeasurementValuationCode._Text[1: Language = $parameters. P_Language].InspectionCodeText AS InspectionCodeText,
  _MeasurementDocumentCodeGroup._Text[1: Language = $parameters. P_Language].InspSpecAddlCodeGroupText AS InspSpecAddlCodeGroupText,
  LastChangedByUser,
  MeasurementDocumentCatalogType,
  MeasurementDocumentCodeGroup,
  MeasurementDocumentOrigin,
  MeasurementDocumentText,
  MeasuringPoint,
  _MeasuringPoint[1: Language = $parameters. P_Language].MeasuringPointCategory AS MeasuringPointCategory,
  _MeasuringPoint[1: Language = $parameters. P_Language].MeasuringPointDescription AS MeasuringPointDescription,
  _MeasuringPoint[1: Language = $parameters. P_Language].MeasuringPointIsCounter AS MeasuringPointIsCounter,
  _MeasuringPoint[1: Language = $parameters. P_Language].MeasuringPointPositionNumber AS MeasuringPointPositionNumber,
  MsmtRdngByUser,
  MsmtRdngDate,
  MsmtRdngStatus,
  MsmtValuationCode,
  _LongText[1: Language = $parameters. P_Language].PlainLongText AS PlainLongText,
  _MeasuringPoint[1: Language = $parameters. P_Language].ReferenceMeasuringPoint AS ReferenceMeasuringPoint
FROM P_MeasurementDocSearch
;

Learn More