P_REINTEGOBJECTOCCPCYCALC8

CDS View

P_REINTEGOBJECTOCCPCYCALC8 is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_REIntegObjectOccupancy view union COMPOSITE Real Estate Integ Object Occupancy 
@AbapCatalog.sqlViewName: 'PREINTOBJOCCCAL8'
@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_REIntegObjectOccpcyCalc8


  as select from P_REIntegObjectOccpcyCalc3 as _REIntegObjectOccpcyBefore
{
  //roocc_before

  REIntegObjectInternalNumber,
  REIntegObjectStatusObject,
  REIntegObjectValidityStartDate,
  REIntegObjectValidityEndDate,
  REIntegObjectValidityStartDate   as REOccupancyFromDate,
  REMinOccupancyFromDate           as REOccupancyToDate,
  cast( IsVacant as abap_boolean ) as IsVacant
}
union select from P_REIntegObjectOccpcyCalc4 as _REIntegObjectOccpcyAfter
{
  //roocc_after

  REIntegObjectInternalNumber,
  REIntegObjectStatusObject,
  REIntegObjectValidityStartDate,
  REIntegObjectValidityEndDate,
  //  min_occ_from,

  REMaxOccupancyToDate             as REOccupancyFromDate,
  REIntegObjectValidityEndDate     as REOccupancyToDate,
  cast( IsVacant as abap_boolean ) as IsVacant
}
union select from P_REIntegObjectOccpcyCalc5 as _REIntegObjectOccpcyWithout
{
  //roocc_without

  REIntegObjectInternalNumber,
  REIntegObjectStatusObject,
  REIntegObjectValidityStartDate,
  REIntegObjectValidityEndDate,
  REIntegObjectValidityStartDate   as REOccupancyFromDate,
  //min_occ_from,

  //max_occ_to,

  REIntegObjectValidityEndDate     as REOccupancyToDate,
  cast( IsVacant as abap_boolean ) as IsVacant
}
union select from P_REIntegObjectOccpcyCalc7 as _REIntegObjectOccpcyInside
{
  //roocc_inside

  REIntegObjectInternalNumber,
  REIntegObjectStatusObject,
  REIntegObjectValidityStartDate,
  REIntegObjectValidityEndDate,
  REOccupancyFromDate,
  REOccupancyToDate,
  cast( IsVacant as abap_boolean ) as IsVacant
}

Learn More