R_WorkAssignmentAltCost

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@EndUserText.label: 'Alternate Cost Objects for Work Assignment'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED

}
define view entity R_WorkAssignmentAltCost
  as select from I_WorkAssignmentAltCost as _AlternativeCostAssgmt
    inner join   R_WorkAssignmentBP      as _BuPaIdentification on _BuPaIdentification.WorkforceAssignment = _AlternativeCostAssgmt.WorkforceAssignment
  association [1..1] to I_BusinessPartner        as _WorkAssignmentBP   on  _WorkAssignmentBP.BusinessPartner = _BuPaIdentification.WorkAssignmentBusinessPartner
  association [1..1] to I_WorkAssignmentDetail_1 as _AssignmentDetails  on  _AlternativeCostAssgmt.IsDefaultValue          =  'X'
                                                                        and _AssignmentDetails.WorkforceAssignment         = $projection.WorkAssignment
                                                                        and (
                                                                           (
                                                                             _AssignmentDetails.WorkforceAssgmtStartDate   <= _AlternativeCostAssgmt.WorkforceAssgmtStartDate
                                                                             and _AssignmentDetails.WorkforceAssgmtEndDate >= _AlternativeCostAssgmt.WorkforceAssgmtEndDate
                                                                           )
                                                                           // if assignment details is a subset of alternate cost

                                                                           or(
                                                                             _AssignmentDetails.WorkforceAssgmtStartDate   >= _AlternativeCostAssgmt.WorkforceAssgmtStartDate
                                                                             and _AssignmentDetails.WorkforceAssgmtEndDate <= _AlternativeCostAssgmt.WorkforceAssgmtEndDate
                                                                           )
                                                                         )

  association [0..1] to I_CostCenter             as _CostCenterText     on  $projection.CostCenter            =  _CostCenterText.CostCenter
                                                                        and _CostCenterText.ControllingArea   =  _AlternativeCostAssgmt.ControllingArea
                                                                        and _CostCenterText.ValidityStartDate <= _AlternativeCostAssgmt.WorkforceAssgmtStartDate
                                                                        and _CostCenterText.ValidityEndDate   >= _AlternativeCostAssgmt.WorkforceAssgmtEndDate

  association [1..1] to I_FunctionalArea         as _FunctionalAreaText on  $projection.FunctionalArea = _FunctionalAreaText.FunctionalArea
  association [1..1] to I_Grant                  as _GrantText          on  $projection.GrantID = _GrantText.GrantID
  association [1..1] to I_Fund                   as _FundText           on  $projection.Fund                               = _FundText.Fund
                                                                        and _AlternativeCostAssgmt.FinancialManagementArea = _FundText.FinancialManagementArea
  association [1..1] to I_WBSElementBasicData    as _WBSText            on $projection.WBSElementExternalID = _WBSText.WBSElementExternalID
  association        to parent R_WorkAssignment  as _WorkAssignment     on  $projection.WorkAssignmentUUID = _WorkAssignment.WorkAssignmentUUID
                                                                        and $projection.WorkAssignment     = _WorkAssignment.WorkAssignment
  // pernr addition

{
  key   _WorkAssignmentBP.BusinessPartnerUUID           as WorkAssignmentUUID,
  
        //key   case

        //    when (_AlternativeCostAssgmt.IsDefaultValue is not initial and (  _AssignmentDetails.WorkforceAssgmtStartDate >= _AlternativeCostAssgmt.WorkforceAssgmtStartDate

        //                                                                              and _AssignmentDetails.WorkforceAssgmtEndDate   <= _AlternativeCostAssgmt.WorkforceAssgmtEndDate

        //                                                                             ) )

        //   then    _AssignmentDetails.WorkforceAssgmtStartDate

        //else _AlternativeCostAssgmt.WorkforceAssgmtStartDate end as WorkAssignmentStartDate,


  key   _AlternativeCostAssgmt.WorkforceAssgmtStartDate  as WorkAssignmentStartDate,
  key   _AlternativeCostAssgmt.SequenceNumber            as SequenceNumber,
        _AlternativeCostAssgmt.WorkforceAssignment       as WorkAssignment,
        //      case

        //      when (_AlternativeCostAssgmt.IsDefaultValue is not initial and (  _AssignmentDetails.WorkforceAssgmtStartDate >= _AlternativeCostAssgmt.WorkforceAssgmtStartDate

        //                                                                                 and _AssignmentDetails.WorkforceAssgmtEndDate   <= _AlternativeCostAssgmt.WorkforceAssgmtEndDate

        //                                                                                  ) )

        //          then    _AssignmentDetails.WorkforceAssgmtEndDate

        //      else _AlternativeCostAssgmt.WorkforceAssgmtEndDate end    as WorkAssignmentEndDate,


        _AlternativeCostAssgmt.WorkforceAssgmtEndDate   as WorkAssignmentEndDate,
        case when _AlternativeCostAssgmt.IsDefaultValue is not initial
             then _AssignmentDetails.CostCenter
             else _AlternativeCostAssgmt.CostCenter
             end                                        as CostCenter,
        _AlternativeCostAssgmt.IsDefaultValue,
        _AlternativeCostAssgmt.FunctionalArea,
        _AlternativeCostAssgmt.Fund,
        _AlternativeCostAssgmt.GrantID,
        _AlternativeCostAssgmt.WBSElementExternalID,
        _AlternativeCostAssgmt.AlternateCostPercent,
        _AlternativeCostAssgmt.IsDefaultValue           as OrganizationalAssignment,
        //        case when _AlternativeCostAssgmt.IsDefaultValue is not initial

        //             then 'Yes' //Primary

        //             else 'No' //Alternative

        //             end                                        as OrganizationalAssignment,

        _AlternativeCostAssgmt.ControllingArea,
        _AlternativeCostAssgmt.FinancialManagementArea,
        _AlternativeCostAssgmt.WorkforceAssgmtStartDate,
        _AlternativeCostAssgmt.WorkforceAssgmtEndDate,
        _AlternativeCostAssgmt.IsBlocked                as IsBlocked,
        cast('%' as qprozent)                           as CostAssignmentPercentageUnit,        
        _CostCenterText,
        _FunctionalAreaText,
        _GrantText,
        _FundText,
        _WBSText,
        _WorkAssignment // Make association public

}