R_ChgRecdRefCutPlngPrflTP

@EndUserText.label: 'Change Recd Ref Cut Plan Profile - 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_ChgRecdRefCutPlngPrflTP
  as select from           I_ChgRecdRefCutPlngPrflBsc as CutPlngPrflTaskListReference
    left outer to one join I_BillOfOperations         as CutPlngPrflTaskList on  CutPlngPrflTaskListReference.ChgRecRefInternalKey1 = CutPlngPrflTaskList.BillOfOperationsType
                                                                             and CutPlngPrflTaskListReference.ChgRecRefInternalKey2 = CutPlngPrflTaskList.BillOfOperationsGroup
                                                                             and CutPlngPrflTaskListReference.ChgRecRefInternalKey3 = CutPlngPrflTaskList.BillOfOperationsVariant

  association [0..1] to E_ChgRecdRefCutPlngPrflBsc  as _CutPlngPrflTaskListExtension on  $projection.ChangeRecordReferenceUUID = _CutPlngPrflTaskListExtension.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   CutPlngPrflTaskListReference.ChangeRecordReferenceUUID,
        case
           when CutPlngPrflTaskList.BillOfOperationsType is null then cast(substring( CutPlngPrflTaskListReference.ChangeRecordReference, 1, 1) as plnty)
           else cast(CutPlngPrflTaskList.BillOfOperationsType as plnty)
           end                                                                               as BillOfOperationsType,

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

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

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

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

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

        _ChangeRecord,

        _ChangeRecordRefObjIcons
}
where
     CutPlngPrflTaskList.BillOfOperationsType = '3'
  or CutPlngPrflTaskList.BillOfOperationsType is null