I_REIntegrationObjectTimeline

DDL: I_REINTEGRATIONOBJECTTIMELINE SQL: IREINTOBJECTTIME Type: view BASIC Package: VDM_RE_IP

Real Estate Integration Object Timeline

I_REIntegrationObjectTimeline is a Basic CDS View that provides data about "Real Estate Integration Object Timeline" in SAP S/4HANA. It reads from 1 data source (viipiotimeline) and exposes 12 fields with key field REIntegObjectTimelineUUID. It has 4 associations to related views. Part of development package VDM_RE_IP.

Data Sources (1)

SourceAliasJoin Type
viipiotimeline _REIntegObjectTimeline from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_REIntegrationObject _REIntegrationObject $projection.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber
[1..1] I_REIntegObjectUsageType _REIntegObjectUsageType $projection.REIntegObjectUsageType = _REIntegObjectUsageType.REIntegObjectUsageType
[1..1] I_REIntegObjectUsageClfn _REIntegObjectUsageClfn $projection.REIntegObjectUsageClfn = _REIntegObjectUsageClfn.REIntegObjectUsageClfn
[1..1] I_REIntegObjectStatus _REIntegObjectStatus $projection.REIntegObjectStatus = _REIntegObjectStatus.REIntegObjectStatus

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IREINTOBJECTTIME view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Integration Object Timeline view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey REIntegObjectTimelineUUID view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY REIntegObjectTimelineUUID timelineguid
InternalRealEstateNumber intreno
ValidityStartDate
ValidityEndDate
REIntegrationObjectIsActive isactive
REIntegObjectUsageType usagetype
REIntegObjectUsageClfn usageclassification
REIntegObjectStatus objectstatus
_REIntegrationObject _REIntegrationObject
_REIntegObjectUsageType _REIntegObjectUsageType
_REIntegObjectUsageClfn _REIntegObjectUsageClfn
_REIntegObjectStatus _REIntegObjectStatus
@AbapCatalog.sqlViewName: 'IREINTOBJECTTIME'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integration Object Timeline'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.representativeKey: 'REIntegObjectTimelineUUID'
@ObjectModel.semanticKey: ['InternalRealEstateNumber', 'ValidityStartDate']
@VDM.viewType: #BASIC
//@Search.searchable: true

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

define view I_REIntegrationObjectTimeline
  as select from viipiotimeline as _REIntegObjectTimeline
  association [1..1] to I_REIntegrationObject    as _REIntegrationObject    on $projection.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber
  association [1..1] to I_REIntegObjectUsageType as _REIntegObjectUsageType on $projection.REIntegObjectUsageType = _REIntegObjectUsageType.REIntegObjectUsageType
  association [1..1] to I_REIntegObjectUsageClfn as _REIntegObjectUsageClfn on $projection.REIntegObjectUsageClfn = _REIntegObjectUsageClfn.REIntegObjectUsageClfn
  association [1..1] to I_REIntegObjectStatus    as _REIntegObjectStatus    on $projection.REIntegObjectStatus = _REIntegObjectStatus.REIntegObjectStatus
{
  key timelineguid                                          as REIntegObjectTimelineUUID,
      intreno                                               as InternalRealEstateNumber,
      @Semantics.businessDate.from: true
      cast( validfrom as rebdvdmvalidfrom preserving type ) as ValidityStartDate,
      @Semantics.businessDate.to: true
      cast( validto as rebdvdmvalidto preserving type )     as ValidityEndDate,
      isactive                                              as REIntegrationObjectIsActive,
      usagetype                                             as REIntegObjectUsageType,
      usageclassification                                   as REIntegObjectUsageClfn,
      objectstatus                                          as REIntegObjectStatus,
      _REIntegrationObject,
      _REIntegObjectUsageType,
      _REIntegObjectUsageClfn,
      _REIntegObjectStatus
}