I_REServiceGroupCtrlgObjAssgmt

DDL: I_RESERVICEGROUPCTRLGOBJASSGMT SQL: IRESGOBJCOBASS Type: view_entity COMPOSITE
21 Fields 1 Data Sources 5 Associations

Real Estate SG Controlling Object Assgmt

I_REServiceGroupCtrlgObjAssgmt is a Composite CDS View that provides data about "Real Estate SG Controlling Object Assgmt" in SAP S/4HANA. It reads from 1 data source (I_REObjectAssgmt) and exposes 21 fields with key fields InternalRealEstateNumber, REAccountingObject, ValidityStartDate. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_REObjectAssgmt _REObjectAssignment from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_REServiceGroupBasicData _REServiceGroup _REObjectAssignment.REStatusObjectSource = _REServiceGroup.REStatusObject
[1..1] I_REIntegrationObjectBasicData _REParentIntegrationObject $projection.REParentIntegObjectExternalID = _REParentIntegrationObject.RealEstateExternalID
[0..1] I_CostCenter _CostCenter $projection.REAccountingObject = _CostCenter.ObjectInternalID and( $projection.ValidityStartDate <= _CostCenter.ValidityEndDate or $projection.ValidityEndDate >= _CostCenter.ValidityStartDate )
[0..1] I_WBSElementBasicData _WBSElement $projection.REAccountingObject = _WBSElement.WBSElementObject
[0..1] I_InternalOrder _InternalOrder $projection.REAccountingObject = _InternalOrder.ControllingObject

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Analytics.technicalName IRESGOBJCOBASS view
EndUserText.label Real Estate SG Controlling Object Assgmt view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber
KEY REAccountingObject I_REObjectAssgmt REStatusObjectTarget Object Number
KEY ValidityStartDate I_REObjectAssgmt ValidityStartDate Validity Start Date
ValidityEndDate I_REObjectAssgmt ValidityEndDate ValidTo
CompanyCode _REServiceGroup CompanyCode Receiver Company Code
REOnlyInfoAssgmt I_REObjectAssgmt REOnlyInfoAssgmt Informational
REIsLeadingObject I_REObjectAssgmt REIsLeadingObject Leading object?
REIntegrationObjectNumberBldng
REIntegObjectBuildingName
REIntegrationObjectNumberSite
REIntegObjectSiteName
REParentIntegObjectExternalID
ControllingArea _CostCenter ControllingArea Controlling Area
CostCenter _CostCenter CostCenter Cost Center
WBSElementExternalID _WBSElement WBSElementExternalID WBS Element External ID
InternalOrder _InternalOrder InternalOrder Order
_REObjectTypeDetails _REObjectTypeDetails
_REParentIntegrationObject _REParentIntegrationObject
_CostCenter _CostCenter
_WBSElement _WBSElement
_InternalOrder _InternalOrder

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_REServiceGroupCtrlgObjAssgmt.
-- 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: IRESGOBJCOBASS

CREATE VIEW I_REServiceGroupCtrlgObjAssgmt AS
SELECT
  _REServiceGroup._REParentIntegrationObject.InternalRealEstateNumber AS InternalRealEstateNumber,
  _REObjectAssignment.REStatusObjectTarget AS REAccountingObject,
  _REObjectAssignment.ValidityStartDate AS ValidityStartDate,
  _REObjectAssignment.ValidityEndDate AS ValidityEndDate,
  _REServiceGroup.CompanyCode AS CompanyCode,
  _REObjectAssignment.REOnlyInfoAssgmt AS REOnlyInfoAssgmt,
  _REObjectAssignment.REIsLeadingObject AS REIsLeadingObject,
  _REServiceGroup._REParentIntegrationObject.REIntegrationObjectNumber AS REIntegrationObjectNumberBldng,
  _REServiceGroup._REParentIntegrationObject.REIntegrationObjectName AS REIntegObjectBuildingName,
  _REServiceGroup._REParentIntegrationObject._REParentIntegrationObject.REIntegrationObjectNumber AS REIntegrationObjectNumberSite,
  _REServiceGroup._REParentIntegrationObject._REParentIntegrationObject.REIntegrationObjectName AS REIntegObjectSiteName,
  _REServiceGroup._REParentIntegrationObject.RealEstateExternalID AS REParentIntegObjectExternalID,
  _CostCenter.ControllingArea AS ControllingArea,
  _CostCenter.CostCenter AS CostCenter,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _InternalOrder.InternalOrder AS InternalOrder
FROM I_REObjectAssgmt AS _REObjectAssignment
LEFT OUTER JOIN I_REServiceGroupBasicData AS _REServiceGroup ON _REObjectAssignment.REStatusObjectSource = _REServiceGroup.REStatusObject  -- association [1..1]
LEFT OUTER JOIN I_REIntegrationObjectBasicData AS _REParentIntegrationObject ON REParentIntegObjectExternalID = _REParentIntegrationObject.RealEstateExternalID  -- association [1..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON REAccountingObject = _CostCenter.ObjectInternalID AND( ValidityStartDate <= _CostCenter.ValidityEndDate OR ValidityEndDate >= _CostCenter.ValidityStartDate )  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON REAccountingObject = _WBSElement.WBSElementObject  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON REAccountingObject = _InternalOrder.ControllingObject  -- association [0..1]
;

Learn More