I_REIntegObjectSubObjValidity

DDL: I_REINTEGOBJECTSUBOBJVALIDITY SQL: IREINTOBJSUBOBJV Type: view COMPOSITE
16 Fields 1 Data Sources

Real Estate Integ Object Sub Validity

I_REIntegObjectSubObjValidity is a Composite CDS View that provides data about "Real Estate Integ Object Sub Validity" in SAP S/4HANA. It reads from 1 data source (I_REIntegrationObject) and exposes 16 fields with key fields InternalRealEstateNumberLvl0, InternalRealEstateNumberLvl1.

Data Sources (1)

SourceAliasJoin Type
I_REIntegrationObject _REIntegObjLvl0 from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IREINTOBJSUBOBJV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Integ Object Sub Validity view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumberLvl0 I_REIntegrationObject InternalRealEstateNumber RE Key
KEY InternalRealEstateNumberLvl1 _REIntegObjLvl1 InternalRealEstateNumber RE Key
RealEstateExternalIDLvl0 I_REIntegrationObject RealEstateExternalID
REIntegrationObjectNumberLvl0 I_REIntegrationObject REIntegrationObjectNumber
REIntegObjectSiteName I_REIntegrationObject REIntegrationObjectName
ValidityStartDateLvl0 I_REIntegrationObject ValidityStartDate Validity Start Date
ValidityEndDateLvl0 I_REIntegrationObject ValidityEndDate ValidTo
REAreaUnit I_REIntegrationObject REAreaUnit
RealEstateExternalIDLvl1 _REIntegObjLvl1 RealEstateExternalID
REIntegrationObjectNumberLvl1 _REIntegObjLvl1 REIntegrationObjectNumber
ValidityStartDateLvl1 _REIntegObjLvl1 ValidityStartDate Validity Start Date
ValidityEndDateLvl1 _REIntegObjLvl1 ValidityEndDate ValidTo
ValidityEndDateendasValidityEndDateLvl2
ValidityEndDateendasValidityEndDateLvl3
REIntegrationObjectType _REIntegObjLvl3 REIntegrationObjectType
_UnitOfMeasureArea I_REIntegrationObject _UnitOfMeasureArea

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_REIntegObjectSubObjValidity.
-- 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: IREINTOBJSUBOBJV

CREATE VIEW I_REIntegObjectSubObjValidity AS
SELECT
  _REIntegObjLvl0.InternalRealEstateNumber AS InternalRealEstateNumberLvl0,
  _REIntegObjLvl1.InternalRealEstateNumber AS InternalRealEstateNumberLvl1,
  _REIntegObjLvl0.RealEstateExternalID AS RealEstateExternalIDLvl0,
  _REIntegObjLvl0.REIntegrationObjectNumber AS REIntegrationObjectNumberLvl0,
  _REIntegObjLvl0.REIntegrationObjectName AS REIntegObjectSiteName,
  _REIntegObjLvl0.ValidityStartDate AS ValidityStartDateLvl0,
  _REIntegObjLvl0.ValidityEndDate AS ValidityEndDateLvl0,
  _REIntegObjLvl0.REAreaUnit AS REAreaUnit,
  _REIntegObjLvl1.RealEstateExternalID AS RealEstateExternalIDLvl1,
  _REIntegObjLvl1.REIntegrationObjectNumber AS REIntegrationObjectNumberLvl1,
  _REIntegObjLvl1.ValidityStartDate AS ValidityStartDateLvl1,
  _REIntegObjLvl1.ValidityEndDate AS ValidityEndDateLvl1,
  case _REIntegObjLvl2.REIntegrationObjectType when 'C4LA' then '99991231' else _REIntegObjLvl2.ValidityEndDate end as ValidityEndDateLvl2 AS ValidityEndDateendasValidityEndDateLvl2,
  case _REIntegObjLvl2.REIntegrationObjectType when 'C4LA' then _REIntegObjLvl2.ValidityEndDate else _REIntegObjLvl3.ValidityEndDate end as ValidityEndDateLvl3 AS ValidityEndDateendasValidityEndDateLvl3,
  _REIntegObjLvl3.REIntegrationObjectType AS REIntegrationObjectType,
  _REIntegObjLvl0._UnitOfMeasureArea AS _UnitOfMeasureArea
FROM I_REIntegrationObject AS _REIntegObjLvl0
;

Learn More