I_REIntegrationObjectSubObj

DDL: I_REINTEGRATIONOBJECTSUBOBJ SQL: IREINTOBJSUBOBJ Type: view COMPOSITE
11 Fields 1 Data Sources

Real Estate Integ Object Subobject

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

Data Sources (1)

SourceAliasJoin Type
I_REIntegrationObjectBasicData _REIntegObjLvl0 from

Annotations (10)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumberLvl0 I_REIntegrationObjectBasicData InternalRealEstateNumber RE Key
KEY InternalRealEstateNumberLvl1 _REIntegObjLvl1 InternalRealEstateNumber RE Key
RealEstateExternalIDLvl0 I_REIntegrationObjectBasicData RealEstateExternalID External Key
REIntegrationObjectNumberLvl0 I_REIntegrationObjectBasicData REIntegrationObjectNumber Real Estate Object
REIntegObjectSiteName I_REIntegrationObjectBasicData REIntegrationObjectName Object Name (Short)
REIntegrationObjectTypeLvl0 I_REIntegrationObjectBasicData REIntegrationObjectType Object Type
REAreaUnit I_REIntegrationObjectBasicData REAreaUnit Area Unit
RealEstateExternalIDLvl1 _REIntegObjLvl1 RealEstateExternalID External Key
REIntegrationObjectNumberLvl1 _REIntegObjLvl1 REIntegrationObjectNumber Real Estate Object
REIntegrationObjectTypeLvl1 _REIntegObjLvl1 REIntegrationObjectType Object Type
_UnitOfMeasureArea I_REIntegrationObjectBasicData _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_REIntegrationObjectSubObj.
-- 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: IREINTOBJSUBOBJ

CREATE VIEW I_REIntegrationObjectSubObj AS
SELECT
  _REIntegObjLvl0.InternalRealEstateNumber AS InternalRealEstateNumberLvl0,
  _REIntegObjLvl1.InternalRealEstateNumber AS InternalRealEstateNumberLvl1,
  _REIntegObjLvl0.RealEstateExternalID AS RealEstateExternalIDLvl0,
  _REIntegObjLvl0.REIntegrationObjectNumber AS REIntegrationObjectNumberLvl0,
  _REIntegObjLvl0.REIntegrationObjectName AS REIntegObjectSiteName,
  _REIntegObjLvl0.REIntegrationObjectType AS REIntegrationObjectTypeLvl0,
  _REIntegObjLvl0.REAreaUnit AS REAreaUnit,
  _REIntegObjLvl1.RealEstateExternalID AS RealEstateExternalIDLvl1,
  _REIntegObjLvl1.REIntegrationObjectNumber AS REIntegrationObjectNumberLvl1,
  _REIntegObjLvl1.REIntegrationObjectType AS REIntegrationObjectTypeLvl1,
  _REIntegObjLvl0._UnitOfMeasureArea AS _UnitOfMeasureArea
FROM I_REIntegrationObjectBasicData AS _REIntegObjLvl0
;

Learn More