I_REServiceGroup

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_REServiceGroup.
-- 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: IRESERVICEGRP

CREATE VIEW I_REServiceGroup AS
SELECT
  objectuuid AS REServiceGroupUUID,
  intreno AS InternalRealEstateNumber,
  objnr AS REStatusObject,
  oid AS REServiceGroupOID,
  sgnr AS RealEstateServiceGroupNumber,
  alternativeid AS REServiceGroupAlternativeID,
  name AS REServiceGroupName,
  bukrs AS CompanyCode,
  parentobjectuuid AS REServiceGroupParentUUID,
  sgtype AS REServiceGroupType,
  sgcategory AS REServiceGroupCategory,
  authgrp AS REAuthorizationGroup,
  validfrom AS ValidityStartDate,
  validto AS ValidityEndDate,
  CreationDateTime,
  LastChangeDateTime,
  LocalLastChangeDateTime
FROM vicssg
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REAuthorizationGroup AS _REAuthorizationGroup ON REAuthorizationGroup = _REAuthorizationGroup.REAuthorizationGroup AND _REAuthorizationGroup.RealEstateObjectType = 'J6'  -- association [0..1]
LEFT OUTER JOIN I_REServiceGroupType AS _REServiceGroupType ON REServiceGroupType = _REServiceGroupType.REServiceGroupType  -- association [1..1]
LEFT OUTER JOIN I_REServiceGroupCategory AS _REServiceGroupCategory ON REServiceGroupCategory = _REServiceGroupCategory.REServiceGroupCategory  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON REStatusObject = _StatusObject.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatus AS _StatusObjectStatus ON REStatusObject = _StatusObjectStatus.StatusObject  -- association [1..*]
LEFT OUTER JOIN I_RESrvcGrpToContractAssgmt AS _RESrvcGrpToContractAssgmt ON REStatusObject = _RESrvcGrpToContractAssgmt.REStatusObjectSource  -- association [1..*]
LEFT OUTER JOIN I_REArchitectureObject AS _REArchitectureObject ON REServiceGroupParentUUID = _REArchitectureObject.REArchitectureObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_RESrvcGrpArchtrObjPartcipn AS _RESrvcGrpArchtrObjPartcipn ON REServiceGroupUUID = _RESrvcGrpArchtrObjPartcipn.REServiceGroupUUID  -- association [0..*]
LEFT OUTER JOIN I_RESrvcGrpSettlementRule AS _RESrvcGrpSettlementRule ON REServiceGroupUUID = _RESrvcGrpSettlementRule.REServiceGroupUUID  -- association [0..*]
LEFT OUTER JOIN I_RESrvcGrpSettlmtRule2CostCat AS _RESrvcGrpSettlmtRule2CostCat ON REServiceGroupUUID = _RESrvcGrpSettlmtRule2CostCat.REServiceGroupUUID  -- association [0..*]
LEFT OUTER JOIN I_REApportionmentRule AS _REApportionmentRule ON REServiceGroupUUID = _REApportionmentRule.REServiceGroupUUID  -- association [0..*]
LEFT OUTER JOIN I_RESrvcGrpDenominatorRule AS _REDenominatorRule ON REServiceGroupUUID = _REDenominatorRule.REServiceGroupUUID  -- association [0..*]
LEFT OUTER JOIN I_REServiceGroupAcctObjAssgmt AS _REServiceGroupAcctObjAssgmt ON REServiceGroupUUID = _REServiceGroupAcctObjAssgmt.REServiceGroupUUID  -- association [0..*]
LEFT OUTER JOIN E_REServiceGroup AS _Extension ON REServiceGroupUUID = _Extension.REServiceGroupUUID  -- association [1..1]
;