I_BusSolnOrderItemSituation

@AbapCatalog.sqlViewName: 'ISOLOITEMSITU'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl:
       {
         authorizationCheck: #CHECK,
         personalData.blocking: #('TRANSACTIONAL_DATA')
       }


@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM: {
  viewType: #COMPOSITE
}

@ObjectModel:{
 representativeKey: 'BusinessSolutionOrder',
       usageType:
       {
          dataClass: #TRANSACTIONAL,
          serviceQuality: #C,
          sizeCategory: #XXL
       }
}

@ObjectModel.semanticKey: ['BusinessSolutionOrder', 'BusinessSolutionOrderItem']

@EndUserText.label:'Solution Order Item  Situation View'
define view I_BusSolnOrderItemSituation
  as select from           I_ServiceDocumentItemEnhcd     as SolutionOrderItem

    left outer to one join I_ServiceDocumentItemSuccssr_3 as ServiceDocumentFlow   on  SolutionOrderItem.ServiceObjectType           = 'BUS2000172'
                                                                                   and SolutionOrderItem.ServiceDocumentItemCharUUID = ServiceDocumentFlow.ServiceDocumentItemCharUUID

    left outer to one join I_ServiceDocumentItemEnhcd     as ServiceDocuments      on  ServiceDocumentFlow.ServiceDocumentItemSuccessor is not null
                                                                                   and ServiceDocuments.ServiceDocumentItemCharUUID     = ServiceDocumentFlow.ServiceDocumentItemSuccessor

    left outer to one join I_ServiceDocumentSuccessor     as SalesOrder            on ServiceDocumentFlow.ServiceDocumentItmRelationUUID = SalesOrder.ServiceDocumentRelationUUID

    left outer to one join I_BusSolnOrdItmFUPSubscription as SubscriptionItem      on  SubscriptionItem.BusSolnOrderItemCharUUID       = SolutionOrderItem.ServiceDocumentItemCharUUID
                                                                                   and SolutionOrderItem.ServiceDocumentItemObjectType = 'BUS2000189'

    left outer to one join I_BusSolnOrdFUPSubscription    as Subscription          on Subscription.ServiceDocumentRelationUUID = SubscriptionItem.ServiceDocumentItmRelationUUID

    left outer to one join I_BusSolnOrdItmFUPEntProject   as EnterpriseProjectItem on EnterpriseProjectItem.BusSolnOrderItemCharUUID = SolutionOrderItem.ServiceDocumentItemCharUUID

    left outer to one join I_EnterpriseProject            as EnterpriseProject     on EnterpriseProject.ProjectUUID = EnterpriseProjectItem.ProjectUUID

  association [0..1] to I_BusinessUserBasic as _ResponsibleEmployee on $projection.ResponsibleEmployee = _ResponsibleEmployee.BusinessPartner
{
      // Key fields

  key SolutionOrderItem.ServiceObjectType                                      as ServiceObjectType,
  key SolutionOrderItem.ServiceDocument                                        as BusinessSolutionOrder,
  key cast(ltrim(SolutionOrderItem.ServiceDocumentItem, '0') as abap.char(45)) as BusinessSolutionOrderItem,
  key case
      when SolutionOrderItem.ServiceDocumentItemObjectType = 'BUS2000131'
        then cast(ltrim(SalesOrder.ServiceDocSuccessor, '0') as abap.char(10))
      else
        cast(ltrim(ServiceDocuments.ServiceDocument, '0') as abap.char(10))
      end                                                                      as SuccessorReferenceDocument,

      // For authorization and navigation to object page

      @Semantics.uuid: true
      SolutionOrderItem.ServiceDocumentItemCharUUID                            as BusSolnOrderItemCharUUID,
      SolutionOrderItem.ServiceDocumentItemObjectType,
      SolutionOrderItem.ServiceDocItemCategory,
      @ObjectModel.foreignKey.association: '_RespEmployee'
      SolutionOrderItem.ResponsibleEmployee,
      _ResponsibleEmployee.UserID                                              as ResponsibleEmployeeUserID,

      ServiceDocuments.ServiceObjectType                                       as ServiceDocSuccessorBusObjType,
      Subscription.SubscrpnBillgSubscription,

      // Situation: Delivery date is reached, but no or only partial delivery has taken place | Template: SOLN_SOLO_SLSITM_NOT_DLVRD

      SolutionOrderItem.SrvcDocItmDeliveryStatus,
      SolutionOrderItem.LtstConfirmedDeliveryDateTime,

      // Situation: Requested service date of the Solution Order service item is close | Template: SOLN_SOLO_SRVCITM_NOT_SCHEDLD

      SolutionOrderItem.RequestedServiceStartDateTime,
      SolutionOrderItem.RequestedServiceStartDate,
      @ObjectModel.foreignKey.association: '_ServiceEmployee'
      ServiceDocuments.ServiceEmployee,

      // Situation: Planned execution date of the Solution Order service item reached | Template: SOLN_SOLO_SRVCITM_NOT_CMPLTD

      SolutionOrderItem.PlannedServiceEndDateTime,
      SolutionOrderItem.PlannedServiceEndDate,

      // Situation: Project Start date of customer project changed | Template: SOLN_SOLO_PROJITM_DATE_CHGD

      EnterpriseProject.Project                                                as SuccessorProject,
      EnterpriseProject.ProjectInternalID,
      EnterpriseProject.ProcessingStatus,

      @ObjectModel.foreignKey.association: '_SrvcDocItmLifecycleStatus'
      SolutionOrderItem.ServiceDocumentItemStatus,
      SolutionOrderItem.ServiceDocumentItemUUID,

      // Fields required for authorization

      @ObjectModel.foreignKey.association: '_SalesOrganization'
      SolutionOrderItem.SalesOrganization,

      @ObjectModel.foreignKey.association: '_DistributionChannel'
      SolutionOrderItem.DistributionChannel,

      @ObjectModel.foreignKey.association: '_Division'
      SolutionOrderItem.Division,

      @ObjectModel.foreignKey.association: '_SalesOffice'
      SolutionOrderItem.SalesOffice,

      @ObjectModel.foreignKey.association: '_SalesGroup'
      SolutionOrderItem.SalesGroup,

      @ObjectModel.foreignKey.association: '_SalesOfficeOrgUnit_2'
      SolutionOrderItem.SalesOfficeOrgUnitID,

      @ObjectModel.foreignKey.association: '_SalesOrganizationOrgUnit_2'
      SolutionOrderItem.SalesOrganizationOrgUnitID,

      @ObjectModel.foreignKey.association: '_SalesGroupOrgUnit_2'
      SolutionOrderItem.SalesGroupOrgUnitID,

      @ObjectModel.foreignKey.association: '_ServiceOrganizationOrgUnit_2'
      SolutionOrderItem.ServiceOrganization,

      @ObjectModel.foreignKey.association: '_ServiceDocumentType'
      SolutionOrderItem.ServiceDocumentType,


      //Associations

      _ResponsibleEmployee,

      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SalesOfficeOrgUnit_2'
      SolutionOrderItem._SalesOfficeOrgUnit,
      SolutionOrderItem._SalesOfficeOrgUnit_2,

      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SalesOrganizationOrgUnit_2'
      SolutionOrderItem._SalesOrganizationOrgUnit,
      SolutionOrderItem._SalesOrganizationOrgUnit_2,

      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SalesGroupOrgUnit_2'
      SolutionOrderItem._SalesGroupOrgUnit,
      SolutionOrderItem._SalesGroupOrgUnit_2,

      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_ServiceOrganizationOrgUnit_2'
      SolutionOrderItem._ServiceOrganizationOrgUnit,
      SolutionOrderItem._ServiceOrganizationOrgUnit_2,
      SolutionOrderItem._SalesOrganization,
      SolutionOrderItem._SalesOffice,
      SolutionOrderItem._SalesGroup,
      SolutionOrderItem._DistributionChannel,
      SolutionOrderItem._Division,
      SolutionOrderItem._RespEmployee,
      SolutionOrderItem._ServiceDocumentType,

      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SrvcDocItmLifecycleStatus'
      SolutionOrderItem._ServiceDocItemStatus,
      SolutionOrderItem._SrvcDocItmLifecycleStatus,

      ServiceDocuments._ServiceEmployee
}
where
  SolutionOrderItem.ServiceObjectType = 'BUS2000172'