P_REINTEGOBJECTOCCPCYCALC2

CDS View

P_REINTEGOBJECTOCCPCYCALC2 is a CDS View in S/4HANA. It contains 18 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 18 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_REIntegObjectOccupancy view from COMPOSITE Real Estate Integ Object Occupancy
P_REIntegObjectOccpcyCalc6 view from COMPOSITE
P_REIntegObjectOccpcyCalc6 view inner COMPOSITE

Fields (18)

KeyField CDS FieldsUsed in Views
CompanyCode CompanyCode 1
ContractEndDate ContractEndDate 1
ContractStartDate ContractStartDate 1
RealEstateContract RealEstateContract 1
REContractInternalNumber REContractInternalNumber 1
REContractStatusObject REContractStatusObject,REContractStatusObject2 1
REIntegObjectInternalNumber REIntegObjectInternalNumber 1
REIntegObjectStatusObject REIntegObjectStatusObject,REIntegObjectStatusObject2 1
REIntegObjectValidityEndDate REIntegObjectValidityEndDate 1
REIntegObjectValidityStartDate REIntegObjectValidityStartDate 1
RENextOccupancyToDate RENextOccupancyToDate,RENextOccupancyToDate2 1
REObjAssgmtValidityEndDate REObjAssgmtValidityEndDate 1
REObjAssgmtValidityStartDate REObjAssgmtValidityStartDate 1
REObjectPossessionEndDate REObjectPossessionEndDate 1
REObjectPossessionStartDate REObjectPossessionStartDate 1
REOccupancyFromDate REOccupancyFromDate,REOccupancyFromDate2 1
REOccupancyToDate REOccupancyToDate,REOccupancyToDate2 1
REPrevOccupancyFromDate REPrevOccupancyFromDate,REPrevOccupancyFromDate2 1 
@AbapCatalog.sqlViewName: 'PREINTOBJOCCCAL2'
@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_REIntegObjectOccpcyCalc2

  as select from P_REIntegObjectOccpcyCalc1
{
  REIntegObjectStatusObject,
  REContractStatusObject,
  REIntegObjectInternalNumber,
  REContractInternalNumber,
  CompanyCode,
  RealEstateContract,
  REOccupancyFromDate,
  REOccupancyToDate,
  dats_add_days( REOccupancyFromDate,-1,'UNCHANGED' )        as REPrevOccupancyFromDate,
  dats_add_days( REOccupancyToDate,1,'UNCHANGED' )           as RENextOccupancyToDate,
  REIntegObjectValidityStartDate,
  REIntegObjectValidityEndDate,
  ContractStartDate,
  ContractEndDate,
  REObjAssgmtValidityStartDate,
  REObjAssgmtValidityEndDate,
  REObjectPossessionStartDate,
  REObjectPossessionEndDate,
  cast( ' ' as abap_boolean preserving type )                as IsVacant,
  cast( REContractIsActive as abap_boolean preserving type ) as REContractIsActive


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_REINTEGOBJECTOCCPCYCALC1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More