I_GhoMeasItem_Db

DDL: I_GHOMEASITEM_DB SQL: IGHOMEASITEMDB Type: view BASIC
9 Fields 1 Data Sources 1 Associations

Measurement Item

I_GhoMeasItem_Db is a Basic CDS View (Dimension) that provides data about "Measurement Item" in SAP S/4HANA. It reads from 1 data source (gho_imrg_item) and exposes 9 fields with key fields UpstreamMsmtDoc, UpstreamMsmtDocItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
gho_imrg_item gho_imrg_item from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_GhoMeasDocExtn_Db _MeasurementDoc $projection.UpstreamMsmtDoc = _MeasurementDoc.UpstreamMsmtDoc

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IGHOMEASITEMDB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Measurement Item view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ObjectModel.representativeKey UpstreamMsmtDocItem view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY UpstreamMsmtDoc mdocm Measurement Doc. No.
KEY UpstreamMsmtDocItem item Task ID
UpstreamCharName atnam Characteristic
UpstreamMsmtParameter param Sourcing Project PLM Collaboration Configuration Parameter
UpstreamMsmtMode measmnt_mode Measurment Mode
endasUpstreamMsmtReading
UpstreamMsmtUnit recdu DocMeasUnit
UpstreamMsmt measmnt Measurement
_MeasurementDoc _MeasurementDoc

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_GhoMeasItem_Db.
-- 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: IGHOMEASITEMDB

CREATE VIEW I_GhoMeasItem_Db AS
SELECT
  mdocm AS UpstreamMsmtDoc,
  item AS UpstreamMsmtDocItem,
  atnam AS UpstreamCharName,
  param AS UpstreamMsmtParameter,
  measmnt_mode AS UpstreamMsmtMode,
  case when recdv = '' then '0' else replace(gho_imrg_item.recdv,',','.') end as UpstreamMsmtReading AS endasUpstreamMsmtReading,
  recdu AS UpstreamMsmtUnit,
  measmnt AS UpstreamMsmt
FROM gho_imrg_item
LEFT OUTER JOIN I_GhoMeasDocExtn_Db AS _MeasurementDoc ON UpstreamMsmtDoc = _MeasurementDoc.UpstreamMsmtDoc  -- association [1..1]
;

Learn More