P_REINTEGOBJECTOCCPCYCALC9

CDS View

Real Estate Integ Occpy Calc

P_REINTEGOBJECTOCCPCYCALC9 is a CDS View in S/4HANA. Real Estate Integ Occpy Calc. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_REIntegObjectOccpcyCalc3 view inner COMPOSITE Real Estate Integ Occpy Calc 3
P_REIntegObjectOccpcyCalc4 view inner COMPOSITE Real Estate Integ Occpy Calc 4 
@AbapCatalog.sqlViewName: 'PREINTOBJOCCCAL9'
@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_REIntegObjectOccpcyCalc9
  as select from P_REIntegObjectOccpcyCalc1
{
  REIntegObjectInternalNumber,
  REIntegObjectStatusObject,
  REIntegObjectValidityStartDate,
  REIntegObjectValidityEndDate,
  min(REOccupancyFromDate) as REMinOccupancyFromDate,
  max(REOccupancyToDate)   as REMaxOccupancyToDate
}
group by
  REIntegObjectInternalNumber,
  REIntegObjectStatusObject,
  REIntegObjectValidityStartDate,
  REIntegObjectValidityEndDate

Learn More