I_REIntegObjectAcctObjAssgmt

@AbapCatalog.sqlViewName: 'IREINTOBJACCASS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED 
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
//@ObjectModel.representativeKey: 'InternalRealEstateNumber'

@ObjectModel.semanticKey: ['InternalRealEstateNumber']
@VDM.viewType: #COMPOSITE

@ObjectModel.supportedCapabilities:  [  #CDS_MODELING_ASSOCIATION_TARGET,
                                        #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE,
                                        #EXTRACTION_DATA_SOURCE]
                                        
@Metadata.ignorePropagatedAnnotations: true                                        

@Analytics:{
    dataExtraction: {
        enabled: true
    }
}

//@Search.searchable: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Real Estate IO Accounting Object Assgmt'

define view I_REIntegObjectAcctObjAssgmt
//  as select from I_REIntegrationObject as _REIntegrationObject

//    inner join   I_REObjectAssgmt      as _REObjectAssignment on(

//      _REObjectAssignment.REStatusObjectSource       = _REIntegrationObject.REStatusObject

//      and _REObjectAssignment.REObjectAssignmentType = 'IO'

//    )

//    inner join   I_REControllingObject  as _REAccountingObject on _REAccountingObject.REAccountingObject = _REObjectAssignment.REStatusObjectTarget


as select from I_REObjectAssgmt      as _REObjectAssignment
//  association [0..*] to I_REObjectAssgmt      as _REObjectAssignment  on $projection.REStatusObject = _REObjectAssignment.REStatusObjectSource    

  association [1..1] to I_REIntegrationObjectBasicData  as _REIntegrationObject on _REObjectAssignment.REStatusObjectSource = _REIntegrationObject.REStatusObject
  association [1..1] to I_REControllingObject           as _REAccountingObject  on _REObjectAssignment.REStatusObjectTarget = _REAccountingObject.REAccountingObject 
  association [1..1] to I_CompanyCode                   as _CompanyCode         on _REAccountingObject.CompanyCode = _CompanyCode.CompanyCode
  association [1..1] to I_REObjectTypeDetails           as _REObjectTypeDetails on _REObjectAssignment.REStatusObjectTarget = _REObjectTypeDetails.REStatusObject
//  association [1..1] to I_REAccountingObject  as _REAccountingObject on _REAccountingObject.REAccountingObject = _REObjectAssignment.REStatusObjectTarget

{
  key  _REIntegrationObject.InternalRealEstateNumber,
  key  _REObjectAssignment.REStatusObjectTarget as REAccountingObject,
  key  _REObjectAssignment.ValidityStartDate    as ValidityStartDate,
       _REObjectAssignment.ValidityEndDate      as ValidityEndDate,
       _REObjectAssignment.REStatusObjectSource,
       @ObjectModel.foreignKey.association: '_CompanyCode'
       _REAccountingObject.CompanyCode,
       _REAccountingObject.REAccountingObjectType,
//       CompanyCode,

       _REObjectAssignment.REOnlyInfoAssgmt,
       _REObjectAssignment.REIsLeadingObject,
       _REIntegrationObject.REIntegObjSpaceGroupType,
       _REIntegrationObject.REParentIntegObjectType,
       _REIntegrationObject.REParentIntegObjectExternalID,       
//       _CostCenter.ControllingArea,

       _REAccountingObject.CostCenter,
       _REAccountingObject.InternalOrder,
       _REAccountingObject.OrderType,
       _REAccountingObject.ControllingArea,
       _REAccountingObject.ProfitCenter,
//       _REObjectAssignment._CostCenter.CostCenter,

//       _REObjectAssignment._InternalOrder.InternalOrder,

//       _REObjectAssignment._InternalOrder.OrderType,

//       coalesce (_REObjectAssignment._WBSElement.ControllingArea, _REObjectAssignment._CostCenter.ControllingArea) as ControllingArea,

//       _REObjectAssignment._WBSElement.ProfitCenter,

       
       _CompanyCode,
       _CostCenter,
       _InternalOrder,
       _WBSElement,
       _REAccountingObject,

       _REObjectTypeDetails

}
where REObjectAssignmentType = 'IO'
and _REIntegrationObject.InternalRealEstateNumber like 'J5%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECONTROLLINGOBJECT",
"I_REINTEGRATIONOBJECTBASICDATA",
"I_REOBJECTASSGMT"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_COSTCENTER",
"I_INTERNALORDER",
"I_RECONTROLLINGOBJECT",
"I_REINTEGRATIONOBJECTBASICDATA",
"I_REOBJECTTYPEDETAILS",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_REOBJECTASSGMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/