I_REGenericRentalObject

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_REGenericRentalObject.
-- 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.

CREATE VIEW I_REGenericRentalObject AS
SELECT
  objectuuid AS REGenericRentalObjectUUID,
  objtype AS REGenericRentalObjectType,
  intreno AS InternalRealEstateNumber,
  objnr AS REStatusObject,
  oid AS REGenericRentalObjectOID,
  gonr AS REGenericRentalObjectNumber,
  alternativeid AS REGnrcRntlObjectAlternativeID,
  description AS REGenericRentalObjectName,
  _REKeyAssgmt.REIdentificationKey AS REIdentificationKey,
  CompanyCode,
  validfrom AS ValidityStartDate,
  validto AS ValidityEndDate,
  authgrp AS REAuthorizationGroup,
  usagecategory AS REGnrcRentalObjUsageCategory,
  usagetype AS REGenericRentalObjectUsageType,
  parentobjectuuid AS REGenericRentalObjParentUUID,
  portfolioid AS REGnrcRentalObjPortfolioID,
  ownershipid AS REGnrcRentalObjOwnershipID,
  rentablecategory AS RERentableObjectCategory,
  CreationDateTime,
  LastChangeDateTime,
  LocalLastChangeDateTime
FROM vigobd
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_REAuthorizationGroup AS _REAuthorizationGroup ON REAuthorizationGroup = _REAuthorizationGroup.REAuthorizationGroup AND _REAuthorizationGroup.RealEstateObjectType = 'J7'  -- association [0..1]
LEFT OUTER JOIN I_REGenericRentalObjectType AS _REGenericRentalObjectType ON REGenericRentalObjectType = _REGenericRentalObjectType.REGenericRentalObjectType  -- association [1..1]
LEFT OUTER JOIN I_REGnrcRentalObjUsageCategory AS _REGnrcRentalObjUsageCategory ON REGnrcRentalObjUsageCategory = _REGnrcRentalObjUsageCategory.REGnrcRentalObjUsageCategory  -- association [1..1]
LEFT OUTER JOIN I_REGnrcRentalObjUsageType AS _REGnrcRentalObjUsageType ON REGenericRentalObjectUsageType = _REGnrcRentalObjUsageType.REGenericRentalObjectUsageType  -- association [1..1]
LEFT OUTER JOIN I_REGnrcRentalObjPortfolio AS _REGnrcRentalObjPortfolio ON REGnrcRentalObjPortfolioID = _REGnrcRentalObjPortfolio.REGnrcRentalObjPortfolioID  -- association [0..1]
LEFT OUTER JOIN I_REGnrcRentalObjOwnership AS _REGnrcRentalObjOwnership ON REGnrcRentalObjOwnershipID = _REGnrcRentalObjOwnership.REGnrcRentalObjOwnershipID  -- association [0..1]
LEFT OUTER JOIN I_RERentableObjectCategory AS _RERentableObjectCategory ON RERentableObjectCategory = _RERentableObjectCategory.RERentableObjectCategory  -- association [0..1]
LEFT OUTER JOIN I_REArchitectureObject AS _REArchitectureObject ON REGenericRentalObjParentUUID = _REArchitectureObject.REArchitectureObjectUUID  -- 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..*]
;