P_REIntegObjectValidityCalc3

DDL: P_REINTEGOBJECTVALIDITYCALC3 SQL: PREINTOBJVALC3 Type: view COMPOSITE

P_REIntegObjectValidityCalc3 is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (P_REIntegObjectValidityCalc2, I_REIntegrationObjectBasicData, I_REIntegrationObjectRelation) and exposes 5 fields with key field REIntegObjectRelationUUID.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
P_REIntegObjectValidityCalc2 _REIntegObjectValidityCalc2 inner
I_REIntegrationObjectBasicData _REIntegrationObject inner
I_REIntegrationObjectRelation _REIntegrationObjectRelation from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PREINTOBJVALC3 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY REIntegObjectRelationUUID I_REIntegrationObjectRelation REIntegObjectRelationUUID
InternalRealEstateNumber I_REIntegrationObjectRelation InternalRealEstateNumber
InternalRealEstateNumberRltn I_REIntegrationObjectRelation InternalRealEstateNumberRltn
ValidityStartDateendasValidityStartDate
ValidityEndDateendasValidityEndDate 
@AbapCatalog.sqlViewName: 'PREINTOBJVALC3'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Real Estate Integ Validity Calc3'

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.private: true

@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
define view P_REIntegObjectValidityCalc3
  as select from I_REIntegrationObjectRelation  as _REIntegrationObjectRelation
  //    inner join P_REIntegObjectValidityCalc2 as _REIntegObjectValidityCalc2 on _REIntegrationObjectRelation.RERelatedIntegObjectExternalID = _REIntegObjectValidityCalc2.RealEstateExternalID

    inner join   P_REIntegObjectValidityCalc2   as _REIntegObjectValidityCalc2 on _REIntegrationObjectRelation.InternalRealEstateNumberRltn = _REIntegObjectValidityCalc2.InternalRealEstateNumber
    inner join   I_REIntegrationObjectBasicData as _REIntegrationObject        on _REIntegrationObjectRelation.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber
{
  key _REIntegrationObjectRelation.REIntegObjectRelationUUID,
      _REIntegrationObjectRelation.InternalRealEstateNumber,
      //      _REIntegrationObjectRelation.RERelatedIntegObjectExternalID,

      _REIntegrationObjectRelation.InternalRealEstateNumberRltn,
      case when _REIntegrationObjectRelation.ValidityStartDate > _REIntegObjectValidityCalc2.ValidityStartDate then _REIntegrationObjectRelation.ValidityStartDate
           else _REIntegObjectValidityCalc2.ValidityStartDate
           end as ValidityStartDate,
      case when _REIntegrationObjectRelation.ValidityEndDate < _REIntegObjectValidityCalc2.ValidityEndDate then _REIntegrationObjectRelation.ValidityEndDate
           else _REIntegObjectValidityCalc2.ValidityEndDate
           end as ValidityEndDate
      //      _REIntegrationObject

}
where
  _REIntegrationObject.REIntegrationObjectType = 'C4SG'

Learn More