P_REINTEGOBJECTVALIDITYCALC3

CDS View

P_REINTEGOBJECTVALIDITYCALC3 is a CDS View in S/4HANA. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_REIntegObjectValidityCalc4 view from COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
KEY InternalRealEstateNumber InternalRealEstateNumber 1 
@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