I_REIntegrationObjectRelation

DDL: I_REINTEGRATIONOBJECTRELATION SQL: IREINTOBJECTREL Type: view BASIC

Real Estate Integ Object Relation

I_REIntegrationObjectRelation is a Basic CDS View that provides data about "Real Estate Integ Object Relation" in SAP S/4HANA. It reads from 1 data source (viipobjrel) and exposes 15 fields with key field REIntegObjectRelationUUID. It has 5 associations to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
viipobjrel _REIntegObjectRelation from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_REIntegrationObjectBasicData _REIntegrationObject $projection.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber
[1..1] I_REIntegrationObjectBasicData _RERelatedIntegrationObject $projection.InternalRealEstateNumberRltn = _RERelatedIntegrationObject.InternalRealEstateNumber
[1..1] I_REIntegrationObjectBasicData _REUseEnableIntegrationObject $projection.REInternalNumberForUseEnable = _REUseEnableIntegrationObject.InternalRealEstateNumber
[1..1] I_REMeasurementType _REMeasurementType $projection.REMeasurementType = _REMeasurementType.REMeasurementType
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.REMeasurementUnit = _UnitOfMeasure.UnitOfMeasure

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IREINTOBJECTREL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Integ Object Relation view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey REIntegObjectRelationUUID view
ObjectModel.semanticKey InternalRealEstateNumber view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY REIntegObjectRelationUUID objrelguid
InternalRealEstateNumber intreno
InternalRealEstateNumberRltn intrenorel
ValidityStartDate
ValidityEndDate
REIsObjectRelationPartial isobjectrelpart
REMeasurementType meas
REMeasurementPartialQuantity measpart
REMeasurementUnit
REInternalNumberForUseEnable _REIntegrationObject REInternalNumberForUseEnable
_REIntegrationObject _REIntegrationObject
_RERelatedIntegrationObject _RERelatedIntegrationObject
_REUseEnableIntegrationObject _REUseEnableIntegrationObject
_REMeasurementType _REMeasurementType
_UnitOfMeasure _UnitOfMeasure 
@AbapCatalog.sqlViewName: 'IREINTOBJECTREL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integ Object Relation'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.representativeKey: 'REIntegObjectRelationUUID'
@ObjectModel.semanticKey: 'InternalRealEstateNumber'
@VDM.viewType: #BASIC
//@Search.searchable: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true

define view I_REIntegrationObjectRelation
  as select from viipobjrel as _REIntegObjectRelation
  association [1..1] to I_REIntegrationObjectBasicData as _REIntegrationObject          on $projection.InternalRealEstateNumber     = _REIntegrationObject.InternalRealEstateNumber
  association [1..1] to I_REIntegrationObjectBasicData as _RERelatedIntegrationObject   on $projection.InternalRealEstateNumberRltn = _RERelatedIntegrationObject.InternalRealEstateNumber
  association [1..1] to I_REIntegrationObjectBasicData as _REUseEnableIntegrationObject on $projection.REInternalNumberForUseEnable = _REUseEnableIntegrationObject.InternalRealEstateNumber

  association [1..1] to I_REMeasurementType   as _REMeasurementType          on $projection.REMeasurementType = _REMeasurementType.REMeasurementType
  association [0..1] to I_UnitOfMeasure       as _UnitOfMeasure              on $projection.REMeasurementUnit = _UnitOfMeasure.UnitOfMeasure
{
  key objrelguid                                                  as REIntegObjectRelationUUID,
      intreno                                                     as InternalRealEstateNumber,
      intrenorel                                                  as InternalRealEstateNumberRltn,
      @Semantics.businessDate.from: true
      cast( validfrom as rebdvdmvalidfrom preserving type )       as ValidityStartDate,
      @Semantics.businessDate.to: true
      cast( validto as rebdvdmvalidto preserving type )           as ValidityEndDate,
      isobjectrelpart                                             as REIsObjectRelationPartial,
      meas                                                        as REMeasurementType,
      @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
      measpart                                                    as REMeasurementPartialQuantity,
//      @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'

//      measfull                                                    as REMeasurementTotalQuantity,

      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      @Semantics.unitOfMeasure
      cast (measunit as msehiunit preserving type)                as REMeasurementUnit,
      _REIntegrationObject.REInternalNumberForUseEnable           as REInternalNumberForUseEnable,

      _REIntegrationObject,
      _RERelatedIntegrationObject,
      _REUseEnableIntegrationObject,
      _REMeasurementType,
      _UnitOfMeasure

} where $projection.internalrealestatenumber like 'J5%'

Learn More