R_ChgRecdRefRateRtgTskListTP

@EndUserText.label: 'Chg Reсd Ref Rate Route Task List - TP'
@AccessControl.authorizationCheck: #MANDATORY

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #L}

define root view entity R_ChgRecdRefRateRtgTskListTP
  as select from           I_ChgRecdRefRateRtgTskListBsc as RefRateRtgTaskListReference
    left outer to one join I_BillOfOperations            as RefRateRtgTaskList on  RefRateRtgTaskListReference.ChgRecRefInternalKey1 = RefRateRtgTaskList.BillOfOperationsType
                                                                               and RefRateRtgTaskListReference.ChgRecRefInternalKey2 = RefRateRtgTaskList.BillOfOperationsGroup
                                                                               and RefRateRtgTaskListReference.ChgRecRefInternalKey3 = RefRateRtgTaskList.BillOfOperationsVariant

  association [0..1] to E_ChgRecdRefRateRtgTskListBsc as _RefRateRtgTaskListExtension on  $projection.ChangeRecordReferenceUUID = _RefRateRtgTaskListExtension.ChangeRecordReferenceUUID

  association [0..1] to C_ChangeRecdDigSignStatusVH   as _DigSignStatusText           on  $projection.ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus
                                                                                      and _DigSignStatusText.Language  = $session.system_language

  association [0..1] to I_ChangeRecordRefObjIcons     as _ChangeRecordRefObjIcons     on  $projection.ChangeRecordUUID          = _ChangeRecordRefObjIcons.ChangeRecordUUID
                                                                                      and $projection.ChangeRecordReferenceType = _ChangeRecordRefObjIcons.ChangeRecordReferenceType

  association [1..1] to R_ChangeRecordHeader       as _ChangeRecord                on  $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID

{
  key   RefRateRtgTaskListReference.ChangeRecordReferenceUUID,
        case
           when RefRateRtgTaskList.BillOfOperationsType is null then cast(substring( RefRateRtgTaskListReference.ChangeRecordReference, 1, 1) as plnty)
           else cast(RefRateRtgTaskList.BillOfOperationsType as plnty)
           end as BillOfOperationsType,

        case
        when RefRateRtgTaskList.BillOfOperationsGroup is null then  cast(substring( RefRateRtgTaskListReference.ChangeRecordReference, 2, 9) as plnnr)
        else cast(RefRateRtgTaskList.BillOfOperationsGroup as plnnr)
        end    as BillOfOperationsGroup,

        case
         when RefRateRtgTaskList.BillOfOperationsVariant is null then cast (substring( RefRateRtgTaskListReference.ChangeRecordReference, 10, 2) as plnal)
         else cast(RefRateRtgTaskList.BillOfOperationsVariant as plnal)
         end   as BillOfOperationsVariant,

        RefRateRtgTaskListReference.ChangeRecordUUID,
        RefRateRtgTaskListReference.ChangeRecordReferenceType,
        RefRateRtgTaskListReference.ChangeRecordReferenceSubtype,
        RefRateRtgTaskListReference.ChangeRecordRefObjectUUID,
        RefRateRtgTaskListReference.ChangeRecordReference,
        RefRateRtgTaskListReference.ParentChangeRecordRefUUID,
        RefRateRtgTaskListReference.IsMainReference,
        RefRateRtgTaskListReference.ChgRecdReasonForChange,
        RefRateRtgTaskListReference.ExpdCompltnDte,
        RefRateRtgTaskListReference.ChgRecdAuthznGrpText,
        RefRateRtgTaskListReference.ChgRecdNmbrChgSts,

        @Semantics.user.createdBy: true
        RefRateRtgTaskListReference.CreatedByUser,
        RefRateRtgTaskListReference.CreationDateTime,
        @Semantics.user.lastChangedBy: true
        RefRateRtgTaskListReference.LastChangedByUser,
        RefRateRtgTaskListReference.LastChangeDateTime,
        RefRateRtgTaskListReference.ChangeRecordItemRelevance,
        RefRateRtgTaskListReference.ChangeRecordVirtualRefInd,
        RefRateRtgTaskListReference.ChangeRecordItemProcgStatus,
        RefRateRtgTaskListReference.ChgRecdCurrentItemProcgStatus,
        RefRateRtgTaskListReference.ChangeNumber,
        RefRateRtgTaskListReference.ChgRecdItmTgtSts,
        RefRateRtgTaskListReference.ChgRecdItmDSgntr,
        //_DigSignStatusText.ChgRecdDigSignStatusTxt,

        @Semantics.imageUrl: true
        _ChangeRecordRefObjIcons[ChangeRecordType = ChangeRecordType].ChangeRecordRefObjIcon as ChangeRecordRefObjIcon,

        _ChangeRecord,

        _ChangeRecordRefObjIcons
}
where
     RefRateRtgTaskList.BillOfOperationsType = 'M'
  or RefRateRtgTaskList.BillOfOperationsType is null