I_REIntegObjectObjectAssgmt

DDL: I_REINTEGOBJECTOBJECTASSGMT SQL: IREINTOBJASGMT Type: view COMPOSITE Package: VDM_RE_IP

Real Estate Integration Object Assignment

I_REIntegObjectObjectAssgmt is a Composite CDS View that provides data about "Real Estate Integration Object Assignment" in SAP S/4HANA. It reads from 2 data sources (I_REIntegrationObjectBasicData, I_REObjectAssgmt) and exposes 20 fields with key fields REStatusObjectSource, REObjectAssignmentType, REStatusObjectTarget, ValidityStartDate, InternalRealEstateNumber. It has 2 associations to related views. Part of development package VDM_RE_IP.

2 data source(s) 20 fields

Data Sources (2)

SourceAliasJoin Type
I_REIntegrationObjectBasicData _REIntegrationObject inner
I_REObjectAssgmt _REObjectAssgmt from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_REObjectType _REObjectTypeTarget $projection.REObjectTypeTarget = _REObjectTypeTarget.RealEstateObjectType
[0..*] I_REObjectTypeText _REObjectTypeTargetText $projection.REObjectTypeTarget = _REObjectTypeTargetText.RealEstateObjectType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IREINTOBJASGMT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Integration Object Assignment 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
AbapCatalog.preserveKey true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY REStatusObjectSource I_REObjectAssgmt REStatusObjectSource
KEY REObjectAssignmentType I_REObjectAssgmt REObjectAssignmentType
KEY REStatusObjectTarget I_REObjectAssgmt REStatusObjectTarget
KEY ValidityStartDate I_REObjectAssgmt ValidityStartDate
KEY InternalRealEstateNumber I_REIntegrationObjectBasicData InternalRealEstateNumber
ValidityEndDate I_REObjectAssgmt ValidityEndDate
REOnlyInfoAssgmt I_REObjectAssgmt REOnlyInfoAssgmt
REStatusObjectSourceIsArchived I_REObjectAssgmt REStatusObjectSourceIsArchived
REGenerationType I_REObjectAssgmt REGenerationType
REIsMainAsset I_REObjectAssgmt REIsMainAsset
REAssignmentHasMultiple I_REObjectAssgmt REAssignmentHasMultiple
REObjectPossessionStartDate I_REObjectAssgmt REObjectPossessionStartDate
REObjectPossessionEndDate I_REObjectAssgmt REObjectPossessionEndDate
REObjectTypeTarget
InternalRealEstateNumberTarget
REIsLeadingObject I_REObjectAssgmt REIsLeadingObject
_REObjectTypeTarget _REObjectTypeTarget
_REObjectTypeTargetText _REObjectTypeTargetText
_REObjectAssignmentType _REObjectAssignmentType
_REGenerationType _REGenerationType 
@AbapCatalog.sqlViewName: 'IREINTOBJASGMT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integration Object Assignment'
@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_REIntegObjectObjectAssgmt
  as select from I_REObjectAssgmt        as _REObjectAssgmt
   
//  association [0..1] to I_REIntegrationObjectBasicData as _REIntegrationObject on  $projection.REStatusObjectSource = _REIntegrationObject.REStatusObject 

  inner join            I_REIntegrationObjectBasicData as _REIntegrationObject on _REObjectAssgmt.REStatusObjectSource = _REIntegrationObject.REStatusObject 
  association [1..1] to I_REObjectType                 as _REObjectTypeTarget  on $projection.REObjectTypeTarget       = _REObjectTypeTarget.RealEstateObjectType

  //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 _REIntegrationObject.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,
      cast( left(_REObjectAssgmt.REStatusObjectTarget,2) as reipvdmbusobjtypecn preserving type ) as REObjectTypeTarget,
      _REObjectAssgmt._REObjectTypeDetails.InternalRealEstateNumber                            as InternalRealEstateNumberTarget,
      _REObjectAssgmt.REIsLeadingObject                                                        as REIsLeadingObject,
      
      _REObjectTypeTarget,
      _REObjectTypeTargetText,
      _REObjectAssignmentType,
      _REGenerationType

  
}

Learn More