I_REObjectByStatusObject

DDL: I_REOBJECTBYSTATUSOBJECT SQL: IREOBJBYSTOBJ Type: view COMPOSITE

Real Estate Object by Status Object

I_REObjectByStatusObject is a Composite CDS View that provides data about "Real Estate Object by Status Object" in SAP S/4HANA. It reads from 2 data sources (I_RECostCollector, I_REKeyAssgmt) and exposes 29 fields with key field REStatusObject. It has 2 associations to related views.

2 data source(s) 29 fields

Data Sources (2)

SourceAliasJoin Type
I_RECostCollector _RECostCollector union
I_REKeyAssgmt _REKeyAssgmt from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_REObjectTypeText _REObjectTypeText _REObjectTypeText.RealEstateObjectType = $projection.RealEstateObjectType and _REObjectTypeText.Language = $session.system_language
[1..1] I_REKeyAssgmt _REKeyAssgmt $projection.InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IREOBJBYSTOBJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Object by Status Object 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
ObjectModel.representativeKey REStatusObject view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY REStatusObject REStatusObject
InternalRealEstateNumber InternalRealEstateNumber
RealEstateObjectType RealEstateObjectType
REIdentificationKey REIdentificationKey
REInternalFinNumber REInternalFinNumber
CompanyCode CompanyCode
RealEstateContract RealEstateContract
REBusinessEntity REBusinessEntity
RERentalObject RERentalObject
RealEstateBuilding RealEstateBuilding
RealEstateProperty RealEstateProperty
ArchitecturalObject ArchitecturalObject
REServiceChargeKey REServiceChargeKey
RESettlementUnitID RESettlementUnitID
system_languagekeyREStatusObject
InternalRealEstateNumber InternalRealEstateNumber
RealEstateObjectType I_REKeyAssgmt RealEstateObjectType
REIdentificationKey I_REKeyAssgmt REIdentificationKey
REInternalFinNumber I_REKeyAssgmt REInternalFinNumber
CompanyCode I_REKeyAssgmt CompanyCode
RealEstateContract I_REKeyAssgmt RealEstateContract
REBusinessEntity I_REKeyAssgmt REBusinessEntity
RERentalObject I_REKeyAssgmt RERentalObject
RealEstateBuilding I_REKeyAssgmt RealEstateBuilding
RealEstateProperty I_REKeyAssgmt RealEstateProperty
ArchitecturalObject I_REKeyAssgmt ArchitecturalObject
REServiceChargeKey I_REKeyAssgmt REServiceChargeKey
RESettlementUnitID I_REKeyAssgmt RESettlementUnitID
REStatusObjectParent I_REKeyAssgmt REStatusObject 
@AbapCatalog.sqlViewName: 'IREOBJBYSTOBJ'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Object by Status Object'

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'REStatusObject'
@ObjectModel.semanticKey: [ 'InternalRealEstateNumber' ]

define view I_REObjectByStatusObject
  as select from I_REKeyAssgmt as _REKeyAssgmt
  association [0..1] to I_REObjectTypeText as _REObjectTypeText on  _REObjectTypeText.RealEstateObjectType = $projection.RealEstateObjectType
                                                                and _REObjectTypeText.Language             = $session.system_language
{
  key       REStatusObject,
            InternalRealEstateNumber,
            RealEstateObjectType,
            REIdentificationKey,
            cast(
            concat_with_space(_REObjectTypeText.REObjectTypePrefix,
            REIdentificationKey,1 ) as recaident) as REIdentification,
            cast(
            concat_with_space(_REObjectTypeText.RealEstateObjectTypeName,
            REIdentificationKey,1 ) as recaident) as REAccountingObjectName,
            REInternalFinNumber,
            CompanyCode,
            RealEstateContract,
            REBusinessEntity,
            RERentalObject,
            RealEstateBuilding,
            RealEstateProperty,
            ArchitecturalObject,
            //PGID

            REServiceChargeKey,
            RESettlementUnitID,
            '                      '              as REStatusObjectParent
            //COMPGRP

}
where
  RealEstateObjectType <> 'I1'

union select from I_RECostCollector as _RECostCollector
association [1..1] to I_REKeyAssgmt      as _REKeyAssgmt      on  $projection.InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber
association [0..1] to I_REObjectTypeText as _REObjectTypeText on  _REObjectTypeText.RealEstateObjectType = 'I1'
                                                              and _REObjectTypeText.Language             = $session.system_language
{
  key       REStatusObject,
            InternalRealEstateNumber,
            _REKeyAssgmt.RealEstateObjectType,
            _REKeyAssgmt.REIdentificationKey,
            cast(
            concat_with_space(_REObjectTypeText.REObjectTypePrefix,
            _REKeyAssgmt.REIdentificationKey,1 ) as recaident) as REIdentification,
            cast(
            concat_with_space(_REObjectTypeText.RealEstateObjectTypeName,
            _REKeyAssgmt.REIdentificationKey,1 ) as recaident) as REAccountingObjectName,
            _REKeyAssgmt.REInternalFinNumber,
            _REKeyAssgmt.CompanyCode,
            _REKeyAssgmt.RealEstateContract,
            _REKeyAssgmt.REBusinessEntity,
            _REKeyAssgmt.RERentalObject,
            _REKeyAssgmt.RealEstateBuilding,
            _REKeyAssgmt.RealEstateProperty,
            _REKeyAssgmt.ArchitecturalObject,
            //PGID

            _REKeyAssgmt.REServiceChargeKey,
            _REKeyAssgmt.RESettlementUnitID,
            _REKeyAssgmt.REStatusObject                        as REStatusObjectParent //COMPGRP



}

Learn More