P_REIntegObjectOccpcyCalc6

DDL: P_REINTEGOBJECTOCCPCYCALC6 SQL: PREINTOBJOCCCAL6 Type: view COMPOSITE Package: VDM_RE_IP

Real Estate Integ Occpy Calc 6

P_REIntegObjectOccpcyCalc6 is a Composite CDS View that provides data about "Real Estate Integ Occpy Calc 6" in SAP S/4HANA. It reads from 2 data sources (P_REIntegObjectOccpcyCalc2, P_REIntegObjectOccpcyCalc2) and exposes 24 fields. Part of development package VDM_RE_IP.

2 data source(s) 24 fields

Data Sources (2)

SourceAliasJoin Type
P_REIntegObjectOccpcyCalc2 _REIntegObjectOccpcyCalc from
P_REIntegObjectOccpcyCalc2 _REIntegObjectOccpcyCalc2 inner

Annotations (10)

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

KeyFieldSource TableSource FieldDescription
REIntegObjectStatusObject P_REIntegObjectOccpcyCalc2 REIntegObjectStatusObject
REContractStatusObject P_REIntegObjectOccpcyCalc2 REContractStatusObject
REIntegObjectInternalNumber P_REIntegObjectOccpcyCalc2 REIntegObjectInternalNumber
REContractInternalNumber P_REIntegObjectOccpcyCalc2 REContractInternalNumber
CompanyCode P_REIntegObjectOccpcyCalc2 CompanyCode
RealEstateContract P_REIntegObjectOccpcyCalc2 RealEstateContract
REOccupancyFromDate P_REIntegObjectOccpcyCalc2 REOccupancyFromDate
REOccupancyToDate P_REIntegObjectOccpcyCalc2 REOccupancyToDate
REPrevOccupancyFromDate P_REIntegObjectOccpcyCalc2 REPrevOccupancyFromDate
RENextOccupancyToDate P_REIntegObjectOccpcyCalc2 RENextOccupancyToDate
REIntegObjectValidityStartDate P_REIntegObjectOccpcyCalc2 REIntegObjectValidityStartDate
REIntegObjectValidityEndDate P_REIntegObjectOccpcyCalc2 REIntegObjectValidityEndDate
ContractStartDate P_REIntegObjectOccpcyCalc2 ContractStartDate
ContractEndDate P_REIntegObjectOccpcyCalc2 ContractEndDate
REObjAssgmtValidityStartDate P_REIntegObjectOccpcyCalc2 REObjAssgmtValidityStartDate
REObjAssgmtValidityEndDate P_REIntegObjectOccpcyCalc2 REObjAssgmtValidityEndDate
REObjectPossessionStartDate P_REIntegObjectOccpcyCalc2 REObjectPossessionStartDate
REObjectPossessionEndDate P_REIntegObjectOccpcyCalc2 REObjectPossessionEndDate
REIntegObjectStatusObject2 P_REIntegObjectOccpcyCalc2 REIntegObjectStatusObject
REContractStatusObject2 P_REIntegObjectOccpcyCalc2 REContractStatusObject
REOccupancyFromDate2 P_REIntegObjectOccpcyCalc2 REOccupancyFromDate
REOccupancyToDate2 P_REIntegObjectOccpcyCalc2 REOccupancyToDate
REPrevOccupancyFromDate2 P_REIntegObjectOccpcyCalc2 REPrevOccupancyFromDate
RENextOccupancyToDate2 P_REIntegObjectOccpcyCalc2 RENextOccupancyToDate 
@AbapCatalog.sqlViewName: 'PREINTOBJOCCCAL6'
@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_REIntegObjectOccpcyCalc6
  as select from           P_REIntegObjectOccpcyCalc2 as _REIntegObjectOccpcyCalc
    inner join             P_REIntegObjectOccpcyCalc2 as _REIntegObjectOccpcyCalc2 on  _REIntegObjectOccpcyCalc.REIntegObjectStatusObject =  _REIntegObjectOccpcyCalc2.REIntegObjectStatusObject
                                                                                   and _REIntegObjectOccpcyCalc.RENextOccupancyToDate     <= _REIntegObjectOccpcyCalc2.REOccupancyFromDate
    left outer to one join P_REIntegObjectOccpcyCalc2 as _REIntegObjectOccpcyCalc3 on  _REIntegObjectOccpcyCalc.REIntegObjectStatusObject = _REIntegObjectOccpcyCalc3.REIntegObjectStatusObject
                                                                                   and _REIntegObjectOccpcyCalc.RENextOccupancyToDate     = _REIntegObjectOccpcyCalc3.REOccupancyFromDate
{
  _REIntegObjectOccpcyCalc.REIntegObjectStatusObject,
  _REIntegObjectOccpcyCalc.REContractStatusObject,
  _REIntegObjectOccpcyCalc.REIntegObjectInternalNumber,
  _REIntegObjectOccpcyCalc.REContractInternalNumber,
  _REIntegObjectOccpcyCalc.CompanyCode,
  _REIntegObjectOccpcyCalc.RealEstateContract,
  _REIntegObjectOccpcyCalc.REOccupancyFromDate,
  _REIntegObjectOccpcyCalc.REOccupancyToDate,
  _REIntegObjectOccpcyCalc.REPrevOccupancyFromDate,
  _REIntegObjectOccpcyCalc.RENextOccupancyToDate,
  _REIntegObjectOccpcyCalc.REIntegObjectValidityStartDate,
  _REIntegObjectOccpcyCalc.REIntegObjectValidityEndDate,
  _REIntegObjectOccpcyCalc.ContractStartDate,
  _REIntegObjectOccpcyCalc.ContractEndDate,
  _REIntegObjectOccpcyCalc.REObjAssgmtValidityStartDate,
  _REIntegObjectOccpcyCalc.REObjAssgmtValidityEndDate,
  _REIntegObjectOccpcyCalc.REObjectPossessionStartDate,
  _REIntegObjectOccpcyCalc.REObjectPossessionEndDate,
  _REIntegObjectOccpcyCalc2.REIntegObjectStatusObject as REIntegObjectStatusObject2,
  _REIntegObjectOccpcyCalc2.REContractStatusObject    as REContractStatusObject2,
  _REIntegObjectOccpcyCalc2.REOccupancyFromDate       as REOccupancyFromDate2,
  _REIntegObjectOccpcyCalc2.REOccupancyToDate         as REOccupancyToDate2,
  _REIntegObjectOccpcyCalc2.REPrevOccupancyFromDate   as REPrevOccupancyFromDate2,
  _REIntegObjectOccpcyCalc2.RENextOccupancyToDate     as RENextOccupancyToDate2
}
where
      _REIntegObjectOccpcyCalc3.REIntegObjectStatusObject is null
  and _REIntegObjectOccpcyCalc.REOccupancyToDate          <> '99991231'

Learn More