P_REIntegObjectOccpcyCalc3

DDL: P_REINTEGOBJECTOCCPCYCALC3 SQL: PREINTOBJOCCCAL3 Type: view COMPOSITE

P_REIntegObjectOccpcyCalc3 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 PREINTOBJOCCCAL3 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
REMaxOccupancyFromDate
REIntegObjectValidityEndDate I_REIntegrationObject ValidityEndDate
IsVacant 
@AbapCatalog.sqlViewName: 'PREINTOBJOCCCAL3'
@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_REIntegObjectOccpcyCalc3
  as select from I_REIntegrationObject     as _REIntegrationObject
    inner join   P_REIntegObjectOccpcyCalc9 as _REIntegObjectOccpcyCalc on  _REIntegObjectOccpcyCalc.REIntegObjectStatusObject = _REIntegrationObject.REStatusObject
                                                                       and _REIntegrationObject.ValidityStartDate             < _REIntegObjectOccpcyCalc.REMinOccupancyFromDate

{
  _REIntegrationObject.InternalRealEstateNumber          as REIntegObjectInternalNumber,
  _REIntegrationObject.REStatusObject                    as REIntegObjectStatusObject,
  _REIntegrationObject.ValidityStartDate                 as REIntegObjectValidityStartDate,
  dats_add_days( REMinOccupancyFromDate,-1,'UNCHANGED' ) as REMinOccupancyFromDate,
  '        '                                             as REMaxOccupancyFromDate,
  _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