I_CmplRqVersEnhanced

@AbapCatalog.sqlViewName: 'ICRVERSIONENH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

// Authorization not required, CRV is customizing-like data and  shall be generally available without restriction

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Compliance Requirement Version View'

@VDM.viewType: #BASIC

@ObjectModel:
{
    transactionalProcessingEnabled: true,
    usageType:
    {
      -- see https://wiki.wdf.sap.corp/wiki/x/R5Bbbg

      dataClass: #MASTER,
      sizeCategory: #S,
      serviceQuality: #C
    },
    representativeKey: 'CmplRqVersUUID'
}
@ClientHandling.algorithm: #SESSION_VARIABLE

@Analytics:{
    dataCategory: #DIMENSION
}
/*----------------------------------------------------------------------------------------------------------------------
    Returns all Compliance Requirement Versions with CRV name with default logic
------------------------------------------------------------------------------------------------------------------------*/
define view I_CmplRqVersEnhanced
  as select from I_CmplRqVers as CmplRqVers
  association [0..*] to I_CmplRqVersText           as _CmplRqVersText              on  $projection.CmplRqVersUUID = _CmplRqVersText.CmplRqVersUUID
  //  association [0..1] to I_CmplRqVersName    as _CmplRqVersNames   on  $projection.CmplRqVersUUID = _CmplRqVersNames.CmplRqVersUUID

  association [0..1] to I_CmplRqVersText           as _CmplRqVersTextInCurrentLang on  $projection.CmplRqVersUUID            = _CmplRqVersTextInCurrentLang.CmplRqVersUUID
                                                                                       and _CmplRqVersTextInCurrentLang.Language = $session.system_language
  association [0..1] to P_CmplRqVersEnglishText    as _CmplRqVersTextEnglish       on  $projection.CmplRqVersUUID = _CmplRqVersTextEnglish.CmplRqVersUUID
  association [0..1] to I_EHSCmplRqIssgOrgFallback as _CmplRqIssgOrgText           on  $projection.CmplRqVersUUID = _CmplRqIssgOrgText.CmplRqVersUUID
  association [0..1] to I_CmplncRqmtStatus         as _CmplncRqmtStatus            on  $projection.CmplRqVersMaintStatus = _CmplncRqmtStatus.CmplRqStatus
  association [0..1] to I_CmplncRqmtType           as _CmplncRqmtType              on  $projection.CmplRqType = _CmplncRqmtType.CmplRqType
  association [0..1] to I_CmplRqDomain             as _CmplRqDomain                on  $projection.CmplRqDomain = _CmplRqDomain.CmplRqDomain

  association [0..*] to I_CmplRqVersStructure      as _CmplRqVersStructure         on  $projection.CmplRqVersUUID = _CmplRqVersStructure.CmplRqVersUUID
{
      @ObjectModel.text.element: [ 'CmplRqVersName' ]
  key CmplRqVersUUID,
      CmplRqVers,
      CmplRqUUID,
      ComplianceRequirement,
      @ObjectModel.foreignKey.association: '_CmplncRqmtStatus'
      --@ObjectModel.text.association: '_CmplncRqmtStatus'
      CmplRqVersMaintStatus,
      @ObjectModel.foreignKey.association: '_CmplncRqmtType'
      --@ObjectModel.text.association: '_CmplncRqmtType'
      CmplRqType,
      CmplRqMigrationSource,
      CmplRqPattern,
      //IssuingOrganization, Using Issuing Organization from text node as the one from root node is obsolete

      _CmplRqIssgOrgText.IssuingOrganization                                       as IssuingOrganization,
      _CmplRqIssgOrgText.IssgOrganizationFreeSearchName,
      ContentProvider,
      CmplRqVersBuildDate,
      EffectiveDate,
      CmplRqVersValidToDate,
      CmplRqApplicationComponent,
      CmplRqSourceURL,
      TransitionPeriodEndDate,
      CmplRqIsInitiallyPrvddBySAP,
      CmplRqExternalUUID,
      CountryName,
      CmplRqVersDocumentationObject,
      CmplRqVersPermitNumber,
      @ObjectModel.foreignKey.association: '_CmplRqDomain'
      --@ObjectModel.text.association: '_CmplRqDomain'
      cast( CmplRqDomain as abap.char(21))                                         as CmplRqDomain,
      cast( CmplRqPermitType as abap.char(10))                                     as CmplRqPermitType,
      CmplRqVers.LastChangedByUser,
      CmplRqVers.LastChangeDateTime,

      // name with fallback language

      cast(
        case
          when _CmplRqVersTextInCurrentLang.CmplRqVersName is not null
           and _CmplRqVersTextInCurrentLang.CmplRqVersName is not initial
            then _CmplRqVersTextInCurrentLang.CmplRqVersName
          when _CmplRqVersTextEnglish.CmplRqVersName is not null
           and _CmplRqVersTextEnglish.CmplRqVersName is not initial
            then _CmplRqVersTextEnglish.CmplRqVersName
          when ( _CmplRqVersTextInCurrentLang.CmplRqVersName is null or
                 _CmplRqVersTextInCurrentLang.CmplRqVersName is initial )
           and ( _CmplRqVersTextEnglish.CmplRqVersName is null or
                 _CmplRqVersTextEnglish.CmplRqVersName is initial )
            then ComplianceRequirement
        end
      as ehfnd_crr_crv_name preserving type )                                      as CmplRqVersName,

      _CmplRqVersTextEnglish.CmplRqVersName                                        as CmplRqVersEnglishName,
      _CmplRqVersTextInCurrentLang.CmplRqVersName                                  as CmplRqVersNameInCurLang,
      //      _CmplRqVersNames.CmplRqVersName,

      //      _CmplRqVersNames.CmplRqVersEnglishName,

      //      _CmplRqVersNames.CmplRqVersNameInCurLang,

      cast( CmplRqVersEHSLocationUUID as ehfnd_location_uuid_ref preserving type ) as CmplRqVersEHSLocationUUID,

      dats_days_between( CurrentDate, CmplRqVersValidToDate )                      as CmplRqVersExpiryDaysValue,
      SDSSubsqntShptOriglRule,
      CmplRqVersTopic,

//      // Official name with fallback language

//      cast(

//        case

//         when CmplRqRegulationOfficialName is not null

//           and CmplRqRegulationOfficialName is not initial

//            then CmplRqRegulationOfficialName

//          when CmplRqRglnEnglishOfclName is not null

//           and CmplRqRglnEnglishOfclName is not initial

//            then CmplRqRglnEnglishOfclName

//        end

//      as ehfnd_crv_regulation_off_name preserving type )                           as CmplRqRegulationOfficialName,

//

//      // Version name with fallback language

//      cast(

//        case

//         when CmplRqRegulationVersionName is not null

//           and CmplRqRegulationVersionName is not initial

//            then CmplRqRegulationVersionName

//         when CmplRqRglnEnglishVersName is not null

//           and CmplRqRglnEnglishVersName is not initial

//            then CmplRqRglnEnglishVersName

//        end

//      as ehfnd_crv_regulation_vers_name preserving type )                          as CmplRqRegulationVersionName,

//

//      // CR Pattern name with fallback language

//      cast(

//        case

//         when _CompReqPattern.CmplRqPatternName is not null

//           and _CompReqPattern.CmplRqPatternName is not initial

//            then _CompReqPattern.CmplRqPatternName

//         when _CompReqPattern.CmplRqPatternEnglishName is not null

//           and _CompReqPattern.CmplRqPatternEnglishName is not initial

//            then _CompReqPattern.CmplRqPatternEnglishName

//        end

//      as ehfnd_req_pattern_name_short preserving type )                           as CmplRqPatternName,


      /* Associations */
      _CmplRqApplCompText,
      _CmplRqVersAppltyArea,
      _CmplRqVersCrTypeText,
      _CmplRqVersText,
      _CmplRqVersTextInCurrentLang,
      _CmplRqVersStructure,
      _CompReqDesc,
      _CompReqHelpUrl,
      _CompReqPattern,
      _CompReqRegON,
      _CompReqRegVN,
      _CmplRqIssgOrgText,
      _CmplncRqmtStatus,
      _CmplncRqmtType,
      _CmplRqDomain
}