P_REINTEGOBJECTOCCPCYCALC9

CDS View

P_REINTEGOBJECTOCCPCYCALC9 is a CDS View in S/4HANA. 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
P_REIntegObjectOccpcyCalc4 view inner COMPOSITE 
@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_REINTEGOBJECTOCCPCYCALC1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More