I_REIntegObjectRelationPartial

DDL: I_REINTEGOBJECTRELATIONPARTIAL SQL: IREINTOBJRELPART Type: view BASIC

Real Estate Integ Obj Partial Relation

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

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
viipobjrel _REIntegObjectRelationPartial from

Associations (4)

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IREINTOBJRELPART view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Integ Obj Partial 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 (13)

KeyFieldSource TableSource FieldDescription
KEY REIntegObjectRelationUUID objrelguid
InternalRealEstateNumber intreno
InternalRealEstateNumberRltn intrenorel
ValidityEndDate
ValidityStartDate
REIsObjectRelationPartial isobjectrelpart
REMeasurementType meas
REMeasurementPartialQuantity measpart
REMeasurementUnit
_REIntegrationObject _REIntegrationObject
_RERelatedIntegrationObject _RERelatedIntegrationObject
_REMeasurementType _REMeasurementType
_UnitOfMeasure _UnitOfMeasure 
@AbapCatalog.sqlViewName: 'IREINTOBJRELPART'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integ Obj Partial 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_REIntegObjectRelationPartial
  as select from viipobjrel as _REIntegObjectRelationPartial

  association [1..1] to I_REIntegrationObject as _REIntegrationObject on $projection.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber
  association [1..1] to I_REIntegrationObject as _RERelatedIntegrationObject on $projection.InternalRealEstateNumberRltn = _RERelatedIntegrationObject.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,
//      iorelextid                                            as RERelatedIntegObjectExternalID,

      intrenorel                                            as InternalRealEstateNumberRltn,
      @Semantics.businessDate.to: true
      cast( validto as rebdvdmvalidto preserving type )     as ValidityEndDate,
      @Semantics.businessDate.from: true
      cast( validfrom as rebdvdmvalidfrom preserving type ) as ValidityStartDate,
      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,
      _RERelatedIntegrationObject,
      _REMeasurementType,
      _UnitOfMeasure

}where isobjectrelpart = 'X'

Learn More