A_REIntegrationObject

DDL: A_REINTEGRATIONOBJECT Type: view_entity CONSUMPTION

Real Estate Integration Object

A_REIntegrationObject is a Consumption CDS View that provides data about "Real Estate Integration Object" in SAP S/4HANA. It reads from 1 data source (R_REIntegrationObjectTP) and exposes 34 fields with key field InternalRealEstateNumber.

Data Sources (1)

SourceAliasJoin Type
R_REIntegrationObjectTP R_REIntegrationObjectTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey InternalRealEstateNumber view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Real Estate Integration Object view
OData.entityType.name REIntegrationObject_Type view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
RealEstateExternalID RealEstateExternalID
REStatusObject REStatusObject Val. Obj. No.
REIntegrationObjectNumber REIntegrationObjectNumber
REIntegrationObjectType REIntegrationObjectType
REIntegObjectCtrlgObjectType REIntegObjectCtrlgObjectType
REIntegrationObjectName REIntegrationObjectName
REIntegObjectLongName REIntegObjectLongName
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
REIntegObjSpaceGroupType REIntegObjSpaceGroupType
RESpaceGroupUsageType RESpaceGroupUsageType
RESpaceGrpEnableUseType RESpaceGrpEnableUseType
REParentIntegObjectType REParentIntegObjectType
REParentIntegObjectExternalID REParentIntegObjectExternalID
REInternalNumberForUseEnable REInternalNumberForUseEnable
REIdentificationKey _REKeyAssgmt REIdentificationKey Object ID
CompanyCode CompanyCode Receiver Company Code
CompanyCodeEnableUse CompanyCodeEnableUse
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreationDateTime CreationDateTime Timestamp
RESourceOfCreation RESourceOfCreation Source.In.Entry
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangeDateTime LastChangeDateTime Timestamp
RESourceOfChange RESourceOfChange Editing Source
Responsible Responsible User Name
REAuthorizationGroup REAuthorizationGroup Authoriz. Group
REAreaUnit REAreaUnit
RealEstateObjectType RealEstateObjectType Object Type
RESpaceGroupDirection _REIntegObjSpaceGroupType RESpaceGroupDirection

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 A_REIntegrationObject.
-- 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 A_REIntegrationObject AS
SELECT
  InternalRealEstateNumber,
  RealEstateExternalID,
  REStatusObject,
  REIntegrationObjectNumber,
  REIntegrationObjectType,
  REIntegObjectCtrlgObjectType,
  REIntegrationObjectName,
  REIntegObjectLongName,
  ValidityStartDate,
  ValidityEndDate,
  REIntegObjSpaceGroupType,
  RESpaceGroupUsageType,
  RESpaceGrpEnableUseType,
  REParentIntegObjectType,
  REParentIntegObjectExternalID,
  REInternalNumberForUseEnable,
  _REKeyAssgmt.REIdentificationKey AS REIdentificationKey,
  CompanyCode,
  CompanyCodeEnableUse,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationDateTime,
  RESourceOfCreation,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  RESourceOfChange,
  Responsible,
  REAuthorizationGroup,
  REAreaUnit,
  RealEstateObjectType,
  _REIntegObjSpaceGroupType.RESpaceGroupDirection AS RESpaceGroupDirection
FROM R_REIntegrationObjectTP
;