I_RESrvcGrpObjectRelation

DDL: I_RESRVCGRPOBJECTRELATION SQL: IRESRVCGRPREL Type: view BASIC

Real Estate Service Group Relation

I_RESrvcGrpObjectRelation is a Basic CDS View that provides data about "Real Estate Service Group 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 _REServiceGroupObjRelation from

Associations (4)

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

Annotations (11)

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

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY REIntegObjectRelationUUID objrelguid
InternalRealEstateNumber intreno
InternalRealEstateNumberRltn intrenorel
ValidityStartDate
ValidityEndDate
REIsObjectRelationPartial isobjectrelpart
REMeasurementType meas
REMeasurementPartialQuantity measpart
REMeasurementUnit
_REServiceGroup _REServiceGroup
_RERelatedIntegrationObject _RERelatedIntegrationObject
_REMeasurementType _REMeasurementType
_UnitOfMeasure _UnitOfMeasure 
@AbapCatalog.sqlViewName: 'IRESRVCGRPREL'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Service Group Relation'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.representativeKey: 'REIntegObjectRelationUUID'
@ObjectModel.semanticKey: ['InternalRealEstateNumber']
@VDM.viewType: #BASIC

define view I_RESrvcGrpObjectRelation
  as select from viipobjrel as _REServiceGroupObjRelation
  association [1..1] to I_REServiceGroupBasicData as _REServiceGroup          on $projection.InternalRealEstateNumber     = _REServiceGroup.InternalRealEstateNumber
  association [1..1] to I_REIntegrationObjectBasicData 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,
      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,

      _REServiceGroup,
      _RERelatedIntegrationObject,
      _REMeasurementType,
      _UnitOfMeasure

}where _REServiceGroup.InternalRealEstateNumber like 'J6%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RESERVICEGROUPBASICDATA",
"VIIPOBJREL"
],
"ASSOCIATED":
[
"I_REINTEGRATIONOBJECTBASICDATA",
"I_REMEASUREMENTTYPE",
"I_RESERVICEGROUPBASICDATA",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More