P_REIntegObjectOccpcyCalc7

DDL: P_REINTEGOBJECTOCCPCYCALC7 SQL: PREINTOBJOCCCAL7 Type: view COMPOSITE

P_REIntegObjectOccpcyCalc7 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_REIntegObjectOccpcyCalc6, I_REIntegrationObject) and exposes 9 fields.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
P_REIntegObjectOccpcyCalc6 _REIntegObjectOccpcyCalc inner
I_REIntegrationObject _REIntegrationObject from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PREINTOBJOCCCAL7 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true 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 (9)

KeyFieldSource TableSource FieldDescription
REIntegObjectStatusObject I_REIntegrationObject REStatusObject
REIntegObjectInternalNumber I_REIntegrationObject InternalRealEstateNumber
REIntegObjectValidityStartDate I_REIntegrationObject ValidityStartDate
REIntegObjectValidityEndDate I_REIntegrationObject ValidityEndDate
REOccupancyValidFromDate REOccupancyFromDate
REOccupancyValidToDate REOccupancyToDate
REOccupancyFromDate
REOccupancyToDate
IsVacant 
@AbapCatalog.sqlViewName: 'PREINTOBJOCCCAL7'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true

define view P_REIntegObjectOccpcyCalc7
  as select from I_REIntegrationObject      as _REIntegrationObject
    inner join   P_REIntegObjectOccpcyCalc6 as _REIntegObjectOccpcyCalc on _REIntegrationObject.REStatusObject = _REIntegObjectOccpcyCalc.REIntegObjectStatusObject
{
  _REIntegrationObject.REStatusObject           as REIntegObjectStatusObject,
  _REIntegrationObject.InternalRealEstateNumber as REIntegObjectInternalNumber,
  _REIntegrationObject.ValidityStartDate        as REIntegObjectValidityStartDate,
  _REIntegrationObject.ValidityEndDate          as REIntegObjectValidityEndDate,
  REOccupancyFromDate                           as REOccupancyValidFromDate,
  REOccupancyToDate                             as REOccupancyValidToDate,
  max(RENextOccupancyToDate)                    as REOccupancyFromDate,
  min(REPrevOccupancyFromDate2)                 as REOccupancyToDate,
  'X'                                           as IsVacant
}
group by
  InternalRealEstateNumber,
  REStatusObject,
  ValidityStartDate,
  ValidityEndDate,
  REOccupancyFromDate,
  REOccupancyToDate

Learn More