I_DFS_MeasureAttributes

DDL: I_DFS_MEASUREATTRIBUTES SQL: IORGMATTR Type: view BASIC
6 Fields 1 Data Sources 1 Associations

Measure specific attributes

I_DFS_MeasureAttributes is a Basic CDS View that provides data about "Measure specific attributes" in SAP S/4HANA. It reads from 1 data source (/isdfps/orgm) and exposes 6 fields with key field DfsOrglMeasureUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
/isdfps/orgm _Attributes from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_DFS_MeasureType _MeasureType $projection.DfsOrglMeasureType = _MeasureType.DfsOrglMeasureType

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IORGMATTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Measure specific attributes view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey DfsOrglMeasureUUID view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DfsOrglMeasureUUID case_guid UUID
DfsOrglMeasureHeaderType orgm_head_otype Object type
DfsOrglMeasureHeaderID orgm_head Header Element
DfsOrglMeasureType orgm_type Measure Type
DfsOrglMsrEffectivenessDate orgm_effect Effectiveness
_MeasureType _MeasureType

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_DFS_MeasureAttributes.
-- 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: IORGMATTR

CREATE VIEW I_DFS_MeasureAttributes AS
SELECT
  case_guid AS DfsOrglMeasureUUID,
  orgm_head_otype AS DfsOrglMeasureHeaderType,
  orgm_head AS DfsOrglMeasureHeaderID,
  orgm_type AS DfsOrglMeasureType,
  orgm_effect AS DfsOrglMsrEffectivenessDate
FROM /isdfps/orgm AS _Attributes
LEFT OUTER JOIN I_DFS_MeasureType AS _MeasureType ON DfsOrglMeasureType = _MeasureType.DfsOrglMeasureType  -- association [0..1]
;

Learn More