I_REServiceGroupBasicData

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_REServiceGroupBasicData.
-- 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: IRESERVICEGRPBSC

CREATE VIEW I_REServiceGroupBasicData AS
SELECT
  intreno AS InternalRealEstateNumber,
  objnr AS REStatusObject,
  sgnr AS RealEstateServiceGroupNumber,
  sgtype AS REServiceGroupType,
  sgcategory AS REServiceGroupCategory,
  sgxstext AS REServiceGroupName,
  sgxltext AS REServiceGroupLongName,
  parentintreno AS REParentIntRealEstateNumber,
  bukrs AS CompanyCode,
  rerf AS CreatedByUser,
  derf AS CreationDate,
  terf AS CreationTime,
  reher AS RESourceOfCreation,
  rbear AS LastChangedByUser,
  dbear AS LastChangeDate,
  tbear AS LastChangeTime,
  rbher AS RESourceOfChange,
  Responsible,
  authgrp AS REAuthorizationGroup
FROM vicssg
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON LastChangedByUser = _ChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ResponsibleUser ON Responsible = _ResponsibleUser.UserID  -- association [0..1]
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_REIntegrationObject AS _REParentIntegrationObject ON REParentIntRealEstateNumber = _REParentIntegrationObject.InternalRealEstateNumber  -- association [0..1]
LEFT OUTER JOIN I_RESrvcGrpObjectRelation AS _RESrvcGrpObjectRelation ON InternalRealEstateNumber = _RESrvcGrpObjectRelation.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_RESrvcGrpSettlementRule AS _RESrvcGrpSettlementRule ON InternalRealEstateNumber = _RESrvcGrpSettlementRule.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_RESrvcGrpSettlmtRule2CostCat AS _RESrvcGrpSettlmtRule2CostCat ON InternalRealEstateNumber = _RESrvcGrpSettlmtRule2CostCat.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_REApportionmentRule AS _REApportionmentRule ON InternalRealEstateNumber = _REApportionmentRule.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_REDenominatorRule AS _REDenominatorRule ON InternalRealEstateNumber = _REDenominatorRule.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_REPartnerAssgmt AS _REPartnerAssgmt ON InternalRealEstateNumber = _REPartnerAssgmt.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_REObjectAssgmt AS _REObjectAssgmt ON REStatusObject = _REObjectAssgmt.REStatusObjectSource  -- association [0..*]
LEFT OUTER JOIN I_REReminderObjRule AS _REReminderRule ON InternalRealEstateNumber = _REReminderRule.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN I_REServiceGroupAcctObjAssgmt AS _REServiceGroupAcctObjAssgmt ON InternalRealEstateNumber = _REServiceGroupAcctObjAssgmt.InternalRealEstateNumber  -- association [0..*]
LEFT OUTER JOIN E_REServiceGroup AS _Extension ON InternalRealEstateNumber = _Extension.InternalRealEstateNumber  -- association [1..1]
;