I_REObjectToObjectGroup

DDL: I_REOBJECTTOOBJECTGROUP SQL: IREOBJOBJGRPASMT Type: view BASIC
9 Fields 1 Data Sources 3 Associations

Object to Object Group Assignments

I_REObjectToObjectGroup is a Basic CDS View that provides data about "Object to Object Group Assignments" in SAP S/4HANA. It reads from 1 data source (vibdobjass) and exposes 9 fields with key fields REStatusObjectSource, REObjectAssignmentType, REStatusObjectTarget, ValidityStartDate. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
vibdobjass vibdobjass from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_REObjectGroup _REObjectGroup $projection.REStatusObjectSource = _REObjectGroup.InternalRealEstateNumber or $projection.REStatusObjectTarget = _REObjectGroup.InternalRealEstateNumber
[1..1] I_REObjectAssgmt _REObjectAssgmt $projection.REStatusObjectSource = _REObjectAssgmt.REStatusObjectTarget and _REObjectAssgmt.REObjectAssignmentType = '10'
[1..1] I_REObjectAssignmentType _REObjectAssignmentType $projection.REObjectAssignmentType = _REObjectAssignmentType.REObjectAssignmentType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IREOBJOBJGRPASMT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Object to Object Group Assignments view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY REStatusObjectSource objnrsrc Object Number
KEY REObjectAssignmentType objasstype Assignment Type
KEY REStatusObjectTarget objnrtrg Object Number
KEY ValidityStartDate ValidityStartDate
REStatusObjectParent _REObjectAssgmt REStatusObjectSource Object Number
REGroupNumber _REObjectGroup REGroupNumber Group Number
REObjectGroupName _REObjectGroup REObjectGroupName Object Group
_REObjectGroup _REObjectGroup
_REObjectAssignmentType _REObjectAssignmentType

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_REObjectToObjectGroup.
-- 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: IREOBJOBJGRPASMT

CREATE VIEW I_REObjectToObjectGroup AS
SELECT
  objnrsrc AS REStatusObjectSource,
  objasstype AS REObjectAssignmentType,
  objnrtrg AS REStatusObjectTarget,
  cast( validfrom as dats ) AS ValidityStartDate,
  _REObjectAssgmt.REStatusObjectSource AS REStatusObjectParent,
  _REObjectGroup.REGroupNumber AS REGroupNumber,
  _REObjectGroup.REObjectGroupName AS REObjectGroupName
FROM vibdobjass
LEFT OUTER JOIN I_REObjectGroup AS _REObjectGroup ON REStatusObjectSource = _REObjectGroup.InternalRealEstateNumber OR REStatusObjectTarget = _REObjectGroup.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REObjectAssgmt AS _REObjectAssgmt ON REStatusObjectSource = _REObjectAssgmt.REStatusObjectTarget AND _REObjectAssgmt.REObjectAssignmentType = '10'  -- association [1..1]
LEFT OUTER JOIN I_REObjectAssignmentType AS _REObjectAssignmentType ON REObjectAssignmentType = _REObjectAssignmentType.REObjectAssignmentType  -- association [1..1]
;

Learn More