I_REOBJECTASSGMTHIER

CDS View

Real Estate Object Assignment Hierarchy

I_REOBJECTASSGMTHIER is a CDS View in S/4HANA. Real Estate Object Assignment Hierarchy. It contains 5 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 5 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_REObjectAssgmtAddl view from COMPOSITE RE Object Assignment additional
I_REObjectAssgmtHierAddl view from COMPOSITE IO Object Assgmt Hierarchy Additional
I_REObjectAssgmtIdnAddl view from COMPOSITE RE Obj Assgmt Identification Addl
R_REContrObjAssgmtTP view_entity from TRANSACTIONAL Real Estate Object Assignment TP
R_REIntegObjectObjAssgmtTP view_entity from TRANSACTIONAL IntegrationObject Object Assignment TP
R_REOccpcyMngCostObjAssgmtTP view_entity from TRANSACTIONAL IntegrationObject Occpcy CO Assign TP
R_RESrvcGrpAddlCostObjAssgmtTP view_entity from TRANSACTIONAL Real Estate ServGrp AddlCostObjAssgmt TP
R_RESrvcGrpLdngCostObjAssgmtTP view_entity from TRANSACTIONAL Real Estate ServGrp LdngCostObjAssgmt TP

Fields (5)

KeyField CDS FieldsUsed in Views
KEY InternalRealEstateNumber InternalRealEstateNumberTarget 1
KEY REObjectAssignmentType REObjectAssignmentType 1
KEY REStatusObjectSource REStatusObjectTarget 1
KEY REStatusObjectTarget REStatusObjectSource 1
InternalRealEstateNumberTarget InternalRealEstateNumber 1 
@AbapCatalog.sqlViewName: 'IREOBJASGMTH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Object Assignment Hierarchy'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@VDM.viewType: #COMPOSITE
//@Search.searchable: true

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

define view I_REObjectAssgmtHier
  as select distinct from I_REObjectAssgmt        as _REObjectAssgmt
    left outer join       I_REObjectToObjectGroup as _REObjectToObjectGroup on ( _REObjectAssgmt.REStatusObjectTarget = _REObjectToObjectGroup.REStatusObjectTarget
                                                                              or _REObjectAssgmt.REStatusObjectTarget = _REObjectToObjectGroup.REStatusObjectSource ) and
                                                                              _REObjectAssgmt.REStatusObjectSource = _REObjectToObjectGroup.REStatusObjectParent

  //  association [0..1] to I_REObjectTypeDetails as _REObjectTypeDetailsTarget on _REObjectTypeDetailsTarget.REStatusObject = $projection.REStatusObjectTarget

  association [0..1] to I_REObjectTypeDetails as _REObjectTypeDetailsSource on _REObjectTypeDetailsSource.REStatusObject = $projection.REStatusObjectSource
  association [1..1] to I_REObjectType        as _REObjectTypeTarget        on $projection.REObjectTypeTarget = _REObjectTypeTarget.RealEstateObjectType
  association [1..1] to I_REKeyAssgmt         as _REKeyAssgmt               on  $projection.InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber
  
  //Text

  association [0..*] to I_REObjectTypeText    as _REObjectTypeTargetText    on $projection.REObjectTypeTarget = _REObjectTypeTargetText.RealEstateObjectType
{

  key _REObjectAssgmt.REStatusObjectSource                                                     as REStatusObjectSource,
      @ObjectModel.foreignKey.association: '_REObjectAssignmentType'
  key _REObjectAssgmt.REObjectAssignmentType                                                   as REObjectAssignmentType,
  key _REObjectAssgmt.REStatusObjectTarget                                                     as REStatusObjectTarget,
  key _REObjectAssgmt.ValidityStartDate                                                        as ValidityStartDate,
      // new for TP composition purpose

  key _REObjectTypeDetailsSource.InternalRealEstateNumber                                      as InternalRealEstateNumber,
      _REObjectAssgmt.ValidityEndDate                                                          as ValidityEndDate,
      _REObjectAssgmt.REOnlyInfoAssgmt                                                         as REOnlyInfoAssgmt,
      _REObjectAssgmt.REStatusObjectSourceIsArchived                                           as REStatusObjectSourceIsArchived,
      @ObjectModel.foreignKey.association: '_REGenerationType'
      _REObjectAssgmt.REGenerationType                                                         as REGenerationType,
      _REObjectAssgmt.REIsMainAsset                                                            as REIsMainAsset,
      _REObjectAssgmt.REAssignmentHasMultiple                                                  as REAssignmentHasMultiple,
      _REObjectAssgmt.REObjectPossessionStartDate                                              as REObjectPossessionStartDate,
      _REObjectAssgmt.REObjectPossessionEndDate                                                as REObjectPossessionEndDate,

      _REObjectToObjectGroup.REGroupNumber                                                     as REGroupNumber,
      _REObjectToObjectGroup.REObjectGroupName                                                 as REObjectGroupName,
      cast( left(_REObjectAssgmt.REStatusObjectTarget,2) as rebdvdmbusobjtypecn preserving type ) as REObjectTypeTarget,
      //_REObjectAssgmt.REStatusObjectTarget                                                     as REStatusObjectTargetForEdit,

      _REObjectAssgmt._REObjectTypeDetails.InternalRealEstateNumber                            as InternalRealEstateNumberTarget,
      _REObjectAssgmt.REIsLeadingObject                                                        as REIsLeadingObject,
      _REObjectAssgmt._REContractSubject,
      _REObjectAssgmt._REObjectGroup,
      _REObjectAssgmt._REObjectTypeDetails,
      _REObjectAssgmt._CostCenter,
      _REObjectAssgmt._WBSElement,
      _REObjectAssgmt._InternalOrder,
      _REObjectAssgmt._FixedAsset,
      _REObjectAssgmt._TechnicalObject,
      _REObjectAssgmt._REObjectAssignmentType,
      _REObjectTypeTarget,
      _REObjectAssgmt._REGenerationType,
      _REKeyAssgmt,
      
      _REObjectTypeTargetText 
  
}
//where

//     _REObjectAssgmt.REObjectAssignmentType = '10'

//  or _REObjectAssgmt.REObjectAssignmentType = '11'

//  or _REObjectAssgmt.REObjectAssignmentType = '60'

//  or _REObjectAssgmt.REObjectAssignmentType = '61'

//  or _REObjectAssgmt.REObjectAssignmentType = '62'

//  or _REObjectAssgmt.REObjectAssignmentType = '63'

//  or _REObjectAssgmt.REObjectAssignmentType = '64'

//  or _REObjectAssgmt.REObjectAssignmentType = '65'

//  or _REObjectAssgmt.REObjectAssignmentType = '66'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_REOBJECTASSGMT",
"I_REOBJECTTOOBJECTGROUP",
"I_REOBJECTTYPEDETAILS"
],
"ASSOCIATED":
[
"I_COSTCENTER",
"I_INTERNALORDER",
"I_RECONTRACTSUBJECT",
"I_REFIXEDASSETRELATION",
"I_REGENERATIONTYPE",
"I_REKEYASSGMT",
"I_REOBJECTASSIGNMENTTYPE",
"I_REOBJECTGROUP",
"I_REOBJECTTYPE",
"I_REOBJECTTYPEDETAILS",
"I_REOBJECTTYPETEXT",
"I_TECHNICALOBJECT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_REOBJECTASSGMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More