A_ServiceOrderItem

@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Service Order Items'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ASRVORDITM',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
  //,

  // _StatusSCDetn association is changed to PRIVILEGED_ONLY

  //privilegedAssociations: ['_StatusSCDetn']

}
@ObjectModel: {
   createEnabled: true,
   updateEnabled: true,
   deleteEnabled: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XXL
   }
}
@Metadata.ignorePropagatedAnnotations: true

define view A_ServiceOrderItem
  as select from I_ServiceDocumentItemEnhcd as ServiceOrderItem

  association [0..*] to A_ServiceOrderItemRefObject    as _ReferenceObject              on  $projection.ServiceOrder     = _ReferenceObject.ServiceOrder
                                                                                        and $projection.ServiceOrderItem = _ReferenceObject.ServiceOrderItem

  association [0..*] to A_SrvcOrdItmProdRefObject      as _ProductReferenceObject       on  $projection.ServiceOrder     = _ProductReferenceObject.ServiceOrder
                                                                                        and $projection.ServiceOrderItem = _ProductReferenceObject.ServiceOrderItem

  association [0..*] to A_ServiceOrderItemText         as _Text                         on  $projection.ServiceOrder     = _Text.ServiceOrder
                                                                                        and $projection.ServiceOrderItem = _Text.ServiceOrderItem

  association [0..*] to A_ServiceOrderItemConfirmation as _Confirmation                 on  $projection.ServiceOrder     = _Confirmation.ServiceOrder
                                                                                        and $projection.ServiceOrderItem = _Confirmation.ServiceOrderItem

  association [0..1] to A_ServiceOrdItmRefSrvcContr    as _RefServiceContract           on  $projection.ServiceOrderItemUUID = _RefServiceContract.ServiceOrderItemUUID

  association [0..1] to A_SrvcOrdItmRefSrvcOrdTmpl     as _RefServiceTemplate           on  $projection.ServiceOrderItemUUID = _RefServiceTemplate.ServiceOrderItemUUID

  association [0..1] to A_ServiceOrdItmRefSrvcReq      as _RefServiceRequest            on  $projection.ServiceOrderItemUUID = _RefServiceRequest.ServiceOrderItemUUID

  association [0..*] to A_ServiceOrderItemPriceElement as _PricingElement               on  $projection.ServiceOrder     = _PricingElement.ServiceOrder
                                                                                        and $projection.ServiceOrderItem = _PricingElement.ServiceOrderItem


  association [0..1] to I_RespyMgmtTeamHeaderDetail    as _ServiceTeamHeader            on  $projection.RespyMgmtServiceTeam = _ServiceTeamHeader.RespyMgmtTeamID


  //  association [0..1] to I_StatusObjectUUIDStatus       as _StatusSCDetn                 on  $projection.ServiceOrderItemUUID = _StatusSCDetn.StatusObjectUUID

//                                                                                        and _StatusSCDetn.StatusCode         = 'I0994'

  association [0..1] to I_SrvcMgmtObjectStatus         as _StatusSCDetn                 on  $projection.ServiceOrderItemUUID = _StatusSCDetn.SrvcMgmtObjectUUID
                                                                                        and _StatusSCDetn.SrvcMgmtObjectStatus = 'I0994'
//  association [0..1] to I_StatusObjectUUIDStatus       as _StatusReservation            on  $projection.ServiceOrderItemUUID = _StatusReservation.StatusObjectUUID

//                                                                                        and (

//                                                                                           _StatusReservation.StatusCode     = 'I8824'

//                                                                                           // or _StatusReservation.StatusCode  = 'I8850'

//                                                                                         )

  association [0..1] to I_SrvcMgmtObjectStatus         as _StatusReservation            on  $projection.ServiceOrderItemUUID = _StatusReservation.SrvcMgmtObjectUUID
                                                                                        and (
                                                                                           _StatusReservation.SrvcMgmtObjectStatus = 'I8824'
                                                                                           // or _StatusReservation.SrvcMgmtObjectStatus  = 'I8850'

                                                                                         )


  association [1]    to A_ServiceOrder                 as _ServiceOrder                 on  $projection.ServiceOrder = _ServiceOrder.ServiceOrder
  //Extensibility

  association [0..1] to E_ServiceDocumentItem          as _Extension                    on  _Extension.ServiceCategory   = 'BUS2000116'
                                                                                        and $projection.ServiceOrder     = _Extension.ServiceOrderItem
                                                                                        and $projection.ServiceOrderItem = _Extension.ServiceLineExternalID
  //External ID

  association [0..1] to I_CustMgmtExtRefID             as _CustMgmtExtRef               on  _CustMgmtExtRef.CustMgmtObjectType = 'BUS2000116'
                                                                                        and $projection.ServiceOrder           = _CustMgmtExtRef.CustMgmtDocument
                                                                                        and $projection.ServiceOrderItem       = _CustMgmtExtRef.CustMgmtDocumentItem

  //association [0..1] to I_ContingentWorker as _ServicePerformer on $projection.ServicePerformer = _ServicePerformer.BusinessPartner

  association [0..1] to I_CustMgmtPartner              as _ServicePerformer             on  _ServicePerformer.CustMgmtPartnerFunction      = '00000028'
                                                                                        and _ServicePerformer.CustMgmtPartFunctionCategory = '0091'
                                                                                        and $projection.ServiceOrder                       = _ServicePerformer.CustMgmtDocument
                                                                                        and $projection.ServiceOrderItem                   = _ServicePerformer.CustMgmtDocumentItem

  association [0..1] to I_SrvcOrdItmRefFSMSrvcActivity as _SrvcOrdItmRefFSMSrvcActivity on  $projection.ServiceDocumentItemCharUUID                      = _SrvcOrdItmRefFSMSrvcActivity.ServiceDocumentItemCharUUID
                                                                                        and _SrvcOrdItmRefFSMSrvcActivity.ServiceDocItmPrdcssrBusObjType = 'FSMACTY'

  association [0..*] to A_ServiceOrdItemUserStatus     as _SrvcOrdItemUserStatus        on  $projection.ServiceOrder     = _SrvcOrdItemUserStatus.ServiceOrder
                                                                                        and $projection.ServiceOrderItem = _SrvcOrdItemUserStatus.ServiceOrderItem

  association [0..*] to A_SrvcOrdItmPartner            as _Partner                      on  $projection.ServiceOrder     = _Partner.ServiceOrder
                                                                                        and $projection.ServiceOrderItem = _Partner.ServiceOrderItem

  association [0..*] to A_SrvcOrdItemDuration          as _Duration                     on  $projection.ServiceOrder     = _Duration.ServiceOrder
                                                                                        and $projection.ServiceOrderItem = _Duration.ServiceOrderItem

  association [0..*] to A_SrvcOrdItemAppointment       as _Appointment                  on  $projection.ServiceOrder     = _Appointment.ServiceOrder
                                                                                        and $projection.ServiceOrderItem = _Appointment.ServiceOrderItem

  association [0..*] to A_ServiceOrderItemDefect       as _Defect                       on  $projection.ServiceOrder     = _Defect.ServiceOrder
                                                                                        and $projection.ServiceOrderItem = _Defect.ServiceOrderItem

  association [0..1] to I_WBSElementBasicData          as _WBSElement                   on  _WBSElement.WBSElementInternalID = ServiceOrderItem.WBSElementInternalID

{

      /* ORDERADM_I */
  key ServiceDocument                                  as ServiceOrder,
  key ServiceDocumentItem                              as ServiceOrderItem,
      ServiceDocumentItemUUID                          as ServiceOrderItemUUID,
      @Semantics.uuid:true
      ServiceDocumentItemCharUUID,
      ServiceDocumentItemDescription                   as ServiceOrderItemDescription,
      ServiceObjectType,
      ServiceDocumentItemObjectType,
      Language,
      OriginallyRequestedProduct                       as Product,
      @Semantics: { quantity : {unitOfMeasure: 'QuantityUnit'} }
      ServiceDocumentItemQuantity                      as Quantity,
      ServiceDocItemQuantityUnit                       as QuantityUnit,

      @ObjectModel.readOnly: true
      ServiceDocItemChangedDateTime,
      
      @ObjectModel.readOnly: true
      ServiceDocItemChangedByUser,

      @ObjectModel.readOnly: true
      @Semantics.booleanIndicator:true
      //      case _StatusReservation.StatusIsActive

//      when 'X'

//      then 'X'

//      else ''   // Includes the null case

//      end                                              as SrvcOrdItmResvnIsExisting,

      case coalesce( _StatusReservation.SrvcMgmtObjectStatusIsInactive, 'X' )  // converts null to 'X'

      when 'X' then ''
      else 'X'
      end                                              as SrvcOrdItmResvnIsExisting,


      @ObjectModel.readOnly: true
      @Semantics: { quantity : {unitOfMeasure: 'QuantityUnit'} }
      CumulativeConfirmedQuantity                      as SrvcOrdItemReservedQuantity,
      ServiceDuration,
      ServiceDurationUnit,
      @ObjectModel.sapObjectNodeTypeReference: 'ServiceDocumentItemCategory'
      ServiceDocItemCategory                           as ServiceOrderItemCategory,
      @ObjectModel.sapObjectNodeTypeReference: 'SalesDocumentRjcnReason'
      ServiceDocItemRejectionReason                    as ServiceOrdItemRejectionReason,
      BillableControl,

      /* PARTNER */
      SoldToParty,
      ShipToParty,
      BillToParty,
      PayerParty,
      ContactPerson                                    as ContactPersonBusinessPartnerId,
      ResponsibleEmployee                              as PersonResponsible,
      ServiceEmployee                                  as ExecutingServiceEmployee,
      _ServicePerformer.CustMgmtBusinessPartner        as ServicePerformer,

      /* STATUS */
      //      ServiceDocumentItemIsOpen                        as ServiceOrderItemIsOpen,


      ServiceDocumentItemIsReleased                    as ServiceOrderItemIsReleased,
      //case ServiceDocumentItemStatus

      //when 'C' then 'X'

      //else ''

      //end                                              as ServiceOrderItemIsCompleted,


      case ServiceDocumentItemIsOpen
       when '' then
       case ServiceDocumentItemIsReleased
       when '' then 'X' else ''
       end
       else ''
       end                                             as ServiceOrderItemIsCompleted,

      ServiceDocumentItemIsRejected                    as ServiceOrderItemIsRejected,

      /* DOCFLOW - Preceding Document
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'cl_crms4_api_odata_srv_ord_itm'
      cast('' as crmt_object_id)                                            as  ReferenceServiceContract,
      cast('' as crmt_object_id)                                            as  ReferenceServiceContractItem, */
      _RefServiceContract.ReferenceServiceContract     as ReferenceServiceContract,
      _RefServiceContract.ReferenceServiceContractItem as ReferenceServiceContractItem,

      _RefServiceTemplate.RefServiceOrderTemplate      as RefServiceOrderTemplate,
      _RefServiceTemplate.RefServiceOrderTemplateItem  as RefServiceOrderTemplateItem,

      _RefServiceRequest.ReferenceServiceRequest       as ReferenceServiceRequest,
      _RefServiceRequest.ReferenceServiceRequestItem   as ReferenceServiceRequestItem,


      _ParentServiceDocItem.ServiceDocumentItem        as ParentServiceOrderItem,

      PlannedServiceStartDateTime,
      PlannedServiceEndDateTime,

      RequestedServiceStartDateTime,
      RequestedServiceEndDateTime,
      SrvcDocItemSLADueByDateTime,
      RequestedDeliveryUTCDateTime                     as ErlstRequestedDeliveryDateTime,

      ActualServiceDuration,
      ActualServiceDurationUnit,

      //SC Determination flag

      //      _StatusSCDetn.StatusIsActive                     as SrvcContrDetnIsSpprsd,

      cast( case coalesce( _StatusSCDetn.SrvcMgmtObjectStatusIsInactive, 'X' )
        when 'X' then ' '
        else 'X'
      end as vdm_j_statusisactive preserving type )    as SrvcContrDetnIsSpprsd,

      _CustMgmtExtRef.CustMgmtExtRefID                 as ReferenceServiceOrderItem,

      /* Shipping */
      ShippingCondition,

      //Inheritance of complex set

      @ObjectModel.readOnly: true
      SrvcDocItmPartReferenceItem,
      @ObjectModel.readOnly: true
      SrvcDocItmApptReferenceItem,
      @ObjectModel.readOnly: true
      SrvcDocItmApptRefObjectUUID,

      @Feature: 'BF:API_ESSENTIALSCOPE'
      SrvcDocItemIsUnplanned                           as SrvcOrdItemIsUnplanned,

      /********************************************************/
      /*********  FSM Specific Fields **************************/
      _SrvcOrdItmRefFSMSrvcActivity.FSMServiceActivity,
      //_ServiceOrder.FSMServiceCall                     as FSMServiceCall,

      /********************************************************/

      /********************************************************/
      /*********  Cloud Specific Fields **************************/

      //@feature: 'BF:API_ESSENTIALSCOPE'

      TimeSheetOvertimeCategory,

      //Service Team

      //@ObjectModel.editableFieldFor: 'RespyMgmtServiceTeamName'

      //@feature: 'BF:API_ESSENTIALSCOPE'

      RespyMgmtServiceTeam,

      // RespyMgmtServiceGlobalTeamID,

      //@feature: 'BF:API_ESSENTIALSCOPE'

      @ObjectModel.readOnly: true
      _ServiceTeamHeader.TeamName                      as RespyMgmtServiceTeamName,

      //@feature: 'BF:API_ESSENTIALSCOPE'

      _ServiceTeamHeader.RespyMgmtGlobalTeamID         as RespyMgmtGlobalTeamID,

      //@feature: 'BF:API_ESSENTIALSCOPE'

      ProfitCenter,

      @Feature: 'BF:API_ESSENTIALSCOPE'
      @ObjectModel.readOnly: true
      @ObjectModel.sapObjectNodeTypeReference: 'SrvcDocItemCreditStatus'
      SrvcDocItemCreditStatus                          as SrvcOrdItemCreditStatus,
      @ObjectModel.sapObjectNodeTypeReference: 'SrvcDocExecutionStatus'
      SrvcDocItemExecutionStatus                       as SrvcOrdItemExecutionStatus,

      //@Feature: 'BF:API_ESSENTIALSCOPE'

      @ObjectModel.sapObjectNodeTypeReference: 'PaymentTerms'
      PaymentTerms,
      //@Feature: 'BF:API_ESSENTIALSCOPE'

      @ObjectModel.sapObjectNodeTypeReference: 'PaymentMethod'
      PaymentMethod,
      //@Feature: 'BF:API_ESSENTIALSCOPE'

      SEPAMandate,
      //@Feature: 'BF:API_ESSENTIALSCOPE'

      @ObjectModel.readOnly: true
      @ObjectModel.sapObjectNodeTypeReference: 'SrvcSEPAMandateRelevance'
      SrvcSEPAMandateRelevance,
      //      @Feature: 'BF:API_ESSENTIALSCOPE'

      _WBSElement.WBSElementExternalID,

      /********************************************************/
      /********************************************************/

      /********************************************************/
      /*********  OP Specific Fields **************************/
      @Feature: 'BF:API_FULLSCOPE'
      ContractAccount,
      /********************************************************/
      /********************************************************/

      //Associations

      _ReferenceObject,
      _ProductReferenceObject,
      _Text,
      _Confirmation,
      _ServiceOrder,
      _PricingElement,
      _SrvcOrdItemUserStatus,
      //_SrvcOrdItmRefFSMSrvcActivity

      //@Feature: 'BF:API_FULLSCOPE'

      _Partner,
      _Duration,
      _Appointment,

      /********* OP Specific Associations **************************/
      @Feature: 'BF:API_FULLSCOPE'
      _Defect
      /************************************************************/
}

where
      ServiceObjectType              = 'BUS2000116' //  Service Process

  and ServiceDocumentItemIsQuotation is initial