I_REOBJECTARCHIVED

CDS View

Archived Real Estate Object

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

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_REIntegObjectOccpcyCalc1 view inner COMPOSITE

Fields (2)

KeyField CDS FieldsUsed in Views
InternalRealEstateNumber REContractInternalNumber 1
REStatusObject REContractStatusObject 1 
@AbapCatalog.sqlViewName: 'IREOBJARCH'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Archived Real Estate Object'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #BASIC
@ObjectModel.semanticKey: [ 'REStatusObject' ]
@ObjectModel.representativeKey: 'REArchiveObjectUUID'


define view I_REObjectArchived
  as select from vicaarobj as _REObjectArchived
//  association [0..1] to I_REKeyAssgmt as _REKeyAssgmt     on $projection.InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber

  association [0..1] to I_User        as _CreatedByUser   on $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User        as _ResponsibleUser on $projection.Responsible = _ResponsibleUser.UserID
{
  key arobjguid                                   as REArchiveObjectUUID,
      arobjtype                                   as REArchiveObjectType,
      arobjkey                                    as RealEstateArchiveObjectKey,
      ardeleted                                   as REObjectIsDeleted,
      rerf                                        as CreatedByUser,
      derf                                        as CreationDate,
      terf                                        as CreationTime,
      reher                                       as RESourceOfCreation,
      arfileid                                    as REArchiveFileID,
      intreno                                     as InternalRealEstateNumber,
      objnr                                       as REStatusObject,
      cast(imkey as recaimkeyfi preserving type ) as REInternalFinNumber,
      guid                                        as REObjectUUID,
      identkey                                    as REIdentificationKey,
      responsible                                 as Responsible,
      ardestroyed                                 as REObjectIsDestroyed,
//      _REKeyAssgmt,

      _CreatedByUser,
      _ResponsibleUser
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VICAAROBJ"
],
"ASSOCIATED":
[
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More