I_REOBJECTASSGMTARCHIVED

CDS View

Real Estate Archived Object Assignments

I_REOBJECTASSGMTARCHIVED is a CDS View in S/4HANA. Real Estate Archived Object Assignments. It contains 6 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 6 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_REIntegObjectOccpcyCalc1 view inner COMPOSITE Real Estate Integ Occpy Calc 1

Fields (6)

KeyField CDS FieldsUsed in Views
ContractEndDate ContractEndDate 1
ContractStartDate ContractStartDate 1
REObjectPossessionEndDate REPossessionEndDate 1
REObjectPossessionStartDate REPossessionStartDate 1
ValidityEndDate REOccupancyToDate 1
ValidityStartDate REOccupancyFromDate 1 
@AbapCatalog.sqlViewName: 'IREOBJECTASSARCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Archived Object Assignments'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

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

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

@ObjectModel.representativeKey: 'REStatusObjectTarget'
@ObjectModel.semanticKey: ['REStatusObjectTarget', 'REObjectAssignmentType', 'REStatusObjectSource', 'ValidityStartDate' ]


define view I_REObjectAssgmtArchived
  as select from vibdobjassarch as REObjectAssgmtArchived

  association [0..1] to I_REObjectTypeDetails as _REObjectTypeDetails on $projection.REStatusObjectTarget = _REObjectTypeDetails.REStatusObject
  association [1..1] to I_REObjectAssignmentType as _REObjectAssignmentType  on $projection.REObjectAssignmentType = _REObjectAssignmentType.REObjectAssignmentType
  association [1..1] to I_REContractType      as _REContractType      on $projection.REContractType = _REContractType.REContractType

{
  key objnrtrg                                              as REStatusObjectTarget,
      @ObjectModel.foreignKey.association: '_REObjectAssignmentType'
  key objasstype                                            as REObjectAssignmentType,
  key objnrsrc                                              as REStatusObjectSource,
      @Semantics.businessDate.from: true
  key cast( validfrom as rebdvdmvalidfrom )                 as ValidityStartDate,
      @Semantics.businessDate.to: true
      cast( validto as rebdvdmvalidto )                     as ValidityEndDate,
      @ObjectModel.foreignKey.association: '_REContractType'
      recntype                                              as REContractType,
      cast( recnbeg as recnvdmcnbeg preserving type )       as ContractStartDate,
      cast( recnendabs as recnvdmcnendabs preserving type ) as ContractEndDate,
      possdatefrom                                          as REObjectPossessionStartDate,
      possdateto                                            as REObjectPossessionEndDate,
      _REObjectTypeDetails,
      _REObjectAssignmentType,
      _REContractType

}

Learn More