I_DataCollectionRoot

DDL: I_DATACOLLECTIONROOT SQL: IMDEFROOT Type: view COMPOSITE
23 Fields 1 Data Sources 4 Associations

Data Collection Root

I_DataCollectionRoot is a Composite CDS View that provides data about "Data Collection Root" in SAP S/4HANA. It reads from 1 data source (I_DataCollectionRootBasic) and exposes 23 fields with key field DataCollectionUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DataCollectionRootBasic I_DataCollectionRootBasic from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _UnitText $projection.UnitOfMeasure = _UnitText.UnitOfMeasure
[0..1] I_UnitOfMeasure _UnitTextAlt $projection.EHSAltvUnitOfMeasurement = _UnitTextAlt.UnitOfMeasure
[1..1] I_EHSLocationRevision _EHSLocation $projection.EHSLocationUUID = _EHSLocation.EHSLocationUUID and( _EHSLocation.RevisionStartDate <= $session.system_date and _EHSLocation.RevisionEndDate >= $session.system_date )
[0..1] I_EHSDataPeriod _EHSDataPeriod $projection.DataUsagePeriodicity = _EHSDataPeriod.EHSDataPeriod

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDEFROOT view
EndUserText.label Data Collection Root view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY DataCollectionUUID DataCollectionUUID UUID
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
DataCollectionID DataCollectionID WorklistID
DataCollectionName DataCollectionName Zone name
DataCollectionInputMethod DataCollectionInputMethod Input Method
EHSAmountExternalSource EHSAmountExternalSource External Source
DataUsagePeriodicity DataUsagePeriodicity
UnitOfMeasure UnitOfMeasure Unit Protected Qty
UnitOfMeasureName
EHSAltvUnitOfMeasurement EHSAltvUnitOfMeasurement
EHSAltvUnitOfMeasurementName
_UnitText _UnitText
_UnitTextAlt _UnitTextAlt
EHSSubjectType EHSSubjectType Subject Type
EHSSubjectUUID EHSSubjectUUID Subject Ref Key
DataCollectionTitle DataCollectionTitle View Title
EHSLocationUUID EHSLocationUUID NodeID
EHSLocRespTechnicianID
_EHSLocation _EHSLocation
_EHSDataPeriod _EHSDataPeriod

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_DataCollectionRoot.
-- 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: IMDEFROOT

CREATE VIEW I_DataCollectionRoot AS
SELECT
  DataCollectionUUID,
  CreationDateTime,
  LastChangeDateTime,
  CreatedByUser,
  LastChangedByUser,
  DataCollectionID,
  DataCollectionName,
  DataCollectionInputMethod,
  EHSAmountExternalSource,
  DataUsagePeriodicity,
  UnitOfMeasure,
  _UnitText._Text[1: Language = $session.system_language ].UnitOfMeasureName AS UnitOfMeasureName,
  EHSAltvUnitOfMeasurement,
  _UnitTextAlt._Text[1: Language = $session.system_language ].UnitOfMeasureName AS EHSAltvUnitOfMeasurementName,
  EHSSubjectType,
  EHSSubjectUUID,
  DataCollectionTitle,
  EHSLocationUUID,
  _EHSLocation._EHSLocRespTechnician.EHSLocRespTechnicianID AS EHSLocRespTechnicianID
FROM I_DataCollectionRootBasic
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitText ON UnitOfMeasure = _UnitText.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitTextAlt ON EHSAltvUnitOfMeasurement = _UnitTextAlt.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_EHSLocationRevision AS _EHSLocation ON EHSLocationUUID = _EHSLocation.EHSLocationUUID AND( _EHSLocation.RevisionStartDate <= $session.system_date AND _EHSLocation.RevisionEndDate >= $session.system_date )  -- association [1..1]
LEFT OUTER JOIN I_EHSDataPeriod AS _EHSDataPeriod ON DataUsagePeriodicity = _EHSDataPeriod.EHSDataPeriod  -- association [0..1]
;

Learn More