P_REIntegObjectOccpcyCalc4

DDL: P_REINTEGOBJECTOCCPCYCALC4 SQL: PREINTOBJOCCCAL4 Type: view COMPOSITE

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

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
P_REIntegObjectOccpcyCalc9 _REIntegObjectOccpcyCalc inner
I_REIntegrationObject _REIntegrationObject from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PREINTOBJOCCCAL4 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 (7)

KeyFieldSource TableSource FieldDescription
REIntegObjectInternalNumber I_REIntegrationObject InternalRealEstateNumber
REIntegObjectStatusObject I_REIntegrationObject REStatusObject
REIntegObjectValidityStartDate I_REIntegrationObject ValidityStartDate
REMinOccupancyFromDate
REMaxOccupancyToDate
REIntegObjectValidityEndDate I_REIntegrationObject ValidityEndDate
IsVacant 
@AbapCatalog.sqlViewName: 'PREINTOBJOCCCAL4'
@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_REIntegObjectOccpcyCalc4
  as select from I_REIntegrationObject     as _REIntegrationObject
    inner join   P_REIntegObjectOccpcyCalc9 as _REIntegObjectOccpcyCalc on  _REIntegObjectOccpcyCalc.REIntegObjectStatusObject = _REIntegrationObject.REStatusObject
                                                                       and _REIntegrationObject.ValidityEndDate               > _REIntegObjectOccpcyCalc.REMaxOccupancyToDate

{
  _REIntegrationObject.InternalRealEstateNumber        as REIntegObjectInternalNumber,
  _REIntegrationObject.REStatusObject                  as REIntegObjectStatusObject,
  _REIntegrationObject.ValidityStartDate               as REIntegObjectValidityStartDate,
  '        '                                           as REMinOccupancyFromDate,
  dats_add_days( REMaxOccupancyToDate,1,'UNCHANGED' )  as REMaxOccupancyToDate,
  _REIntegrationObject.ValidityEndDate                 as REIntegObjectValidityEndDate,
  'X'                                                  as IsVacant
}
//where REIntegObjectReference = '2'

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

Learn More