P_SrvcDocEnhcdWithCloudCheck

@AbapCatalog:
    {
        sqlViewName: 'PSRVDOCENHCD',
        compiler.compareFilter: true,
        preserveKey: true
    }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM: {
  viewType: #COMPOSITE,
  private:true
}
define view P_SrvcDocEnhcdWithCloudCheck
  as select from I_ServiceDocumentEnhcd as _DocEnhd
{
  key _DocEnhd.ServiceDocument,
  key _DocEnhd.ServiceDocumentType,
      _DocEnhd.ServiceDocumentDescription,
      _DocEnhd.ServiceDocumentTemplateType,
      _DocEnhd.ServiceObjectType,
      _DocEnhd.ServiceContractStartDate,
      _DocEnhd.ServiceContractEndDate,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      _DocEnhd.ServiceDocNetAmount,
      _DocEnhd.ServiceDocumentCreationDate,
      _DocEnhd.PostingDate,

      // Organizational units with the S/4 SD codes

      @ObjectModel.foreignKey.association: '_SalesOrganization'
      _DocEnhd.SalesOrganization,
      @ObjectModel.foreignKey.association: '_SalesOffice'
      _DocEnhd.SalesOffice,
      @ObjectModel.foreignKey.association: '_SalesGroup'
      _DocEnhd.SalesGroup,

      // Header Details

      _DocEnhd.ServiceDocumentUUID,
      _DocEnhd.ServiceDocumentCharUUID,

      // Partner Details

      @ObjectModel.foreignKey.association: '_SoldToParty'
      _DocEnhd.SoldToParty,
      @ObjectModel.foreignKey.association: '_SoldToPartyCountry'
      _DocEnhd.SoldToPartyCountry,
      @ObjectModel.foreignKey.association: '_SoldToPartyRegion'
      _DocEnhd.SoldToPartyRegion,
      @ObjectModel.foreignKey.association: '_ServiceTeam'
      _DocEnhd.ServiceTeam,
      @ObjectModel.foreignKey.association: '_RespEmployee'
      _DocEnhd.ResponsibleEmployee,
      @ObjectModel.foreignKey.association: '_ServiceEmployee'
      _DocEnhd.ServiceEmployee,
      @ObjectModel.foreignKey.association: '_ContactPerson'
      _DocEnhd.ContactPerson,
      @ObjectModel.foreignKey.association: '_ShipToParty'
      _DocEnhd.ShipToParty,
      @ObjectModel.foreignKey.association: '_BillToParty'
      _DocEnhd.BillToParty,
      _DocEnhd.PayerParty,

      // Status

      @ObjectModel.foreignKey.association: '_SrvcDocLifecycleStatus'
      _DocEnhd.ServiceDocumentStatus,
      @ObjectModel.foreignKey.association: '_ServiceDocHasError'
      _DocEnhd.ServiceDocumentHasError,
      @ObjectModel.foreignKey.association: '_ServiceDocBillingStatus'
      _DocEnhd.ServiceDocBillingStatus,
      @ObjectModel.foreignKey.association: '_SrvcDocIsRelForBillgSts'
      _DocEnhd.ServiceDocIsReleasedForBilling,
      @ObjectModel.foreignKey.association: '_ServiceDocumentIsOpen'
      _DocEnhd.ServiceDocumentIsOpen,
      _DocEnhd.ServiceDocumentIsQuotation,
      _DocEnhd.ServiceDocumentIsReleased,
      _DocEnhd.ServiceDocumentIsRejected,
      _DocEnhd.ServiceConfirmationIsFinal,
      @ObjectModel.foreignKey.association: '_ServiceContractCanclnSts'
      _DocEnhd.ServiceContractCanclnSts,

      // Service Request

      _DocEnhd.RecommendedServicePriority,
      _DocEnhd.ServiceDocumentUrgency,
      _DocEnhd.ServiceDocumentImpact,
      _DocEnhd.ServiceEscalationLevel,
      @ObjectModel.foreignKey.association: '_ServiceDocProblemCategory'
      _DocEnhd.ServiceDocumentProblemCategory,
      @ObjectModel.foreignKey.association: '_ServiceRisk'
      _DocEnhd.ServiceRisk,

      // Cancel Header

      _DocEnhd.ServiceDocumentCanclnParty,
      _DocEnhd.ServiceDocumentCanclnReason,

      // In-House Repair Reference

      _DocEnhd.ReferenceInHouseRepair,
      _DocEnhd.ReferenceInHouseRepairItem,
      _DocEnhd.RefInHouseRepairIsExisting,

      // Billing Set

      @ObjectModel.foreignKey.association: '_BillingBlockReason'
      _DocEnhd.BillingBlockReason,

      // Sales Set

      _DocEnhd.PurchaseOrderByCustomer,
      _DocEnhd.CustomerPurchaseOrderDate,
      @ObjectModel.foreignKey.association: '_SrvcDocumentRejectionReason'
      _DocEnhd.ServiceDocumentRejectionReason,
      @ObjectModel.foreignKey.association: '_Region'
      _DocEnhd.Region,


      // Activity

      @ObjectModel.foreignKey.association: '_ActivityCategory'
      _DocEnhd.BusinessActivityCategory,
      @ObjectModel.foreignKey.association: '_ServiceDocumentPriority'
      _DocEnhd.ServiceDocumentPriority,

      // Pricing Parameter Set

      @ObjectModel.foreignKey.association: '_PaymentTerms'
      _DocEnhd.PaymentTerms,
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      _DocEnhd.TransactionCurrency,


      // Organizational Unit Set

      @ObjectModel.foreignKey.association: '_SalesOrganizationOrgUnit_2'
      _DocEnhd.SalesOrganizationOrgUnitID,
      @ObjectModel.foreignKey.association: '_SalesOfficeOrgUnit_2'
      _DocEnhd.SalesOfficeOrgUnitID,
      @ObjectModel.foreignKey.association: '_SalesGroupOrgUnit_2'
      _DocEnhd.SalesGroupOrgUnitID,
      @ObjectModel.foreignKey.association: '_DistributionChannel'
      _DocEnhd.DistributionChannel,
      @ObjectModel.foreignKey.association: '_Division'
      _DocEnhd.Division,
      @ObjectModel.foreignKey.association: '_ServiceOrganizationOrgUnit_2'
      _DocEnhd.ServiceOrganization,
      @ObjectModel.foreignKey.association: '_RespSrvcOrganizationOrgUnit_2'
      _DocEnhd.ResponsibleServiceOrganization,

      // Associations to next level

      // Header Keys Assocations

      _DocEnhd._ServiceObjType,

      // Header Details Assocations

      _DocEnhd._ServiceDocumentType,

      _DocEnhd.ServiceDocumentCreatedByUser,
      _DocEnhd.ServiceDocumentChangedByUser,
      _DocEnhd.PricingDocument,
      _DocEnhd.PricingProcedure,
      _DocEnhd.RefBusinessSolutionOrder,

      // Service Organizational Units with S/4 Code

      _DocEnhd.RespyMgmtServiceTeam,


      // Partner Details Associations

      _DocEnhd._SoldToParty,
      _DocEnhd._RespEmployee,
      _DocEnhd._ServiceTeam,
      _DocEnhd._ServiceEmployee,
      _DocEnhd._ContactPerson,
      _DocEnhd._ShipToParty,
      _DocEnhd._BillToParty,
      _DocEnhd._SoldToPartyToCustomer,
      _DocEnhd._SoldToPartyCountry,
      _DocEnhd._SoldToPartyRegion,
      _DocEnhd._ServiceTeamHeader,

      // Status Assocations

      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SrvcDocLifecycleStatus'
      _DocEnhd._ServiceDocumentStatus,
      _DocEnhd._SrvcDocLifecycleStatus,      
      _DocEnhd._ServiceDocBillingStatus,
      _DocEnhd._SrvcDocIsRelForBillgSts,
      _DocEnhd._ServiceDocumentIsOpen,
      _DocEnhd._ServiceDocHasError,
      _DocEnhd._ServiceContractCanclnSts,

      // Billing Set Associations

      _DocEnhd._BillingBlockReason,

      // Activity Associations

      _DocEnhd._ActivityCategory,
      _DocEnhd._ServiceDocumentPriority,

      // Pricing Parameter Set

      _DocEnhd._TransactionCurrency,
      _DocEnhd._PaymentTerms,
      _DocEnhd._FixedPrice,

      // Organization Unit Set Assocations

      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SalesOrganizationOrgUnit_2'
      _DocEnhd._SalesOrganizationOrgUnit,
      _DocEnhd._SalesOrganizationOrgUnit_2,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SalesOfficeOrgUnit_2'
      _DocEnhd._SalesOfficeOrgUnit,
      _DocEnhd._SalesOfficeOrgUnit_2,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SalesGroupOrgUnit_2'
      _DocEnhd._SalesGroupOrgUnit,
      _DocEnhd._SalesGroupOrgUnit_2,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_ServiceOrganizationOrgUnit_2'
      _DocEnhd._ServiceOrganizationOrgUnit,
      _DocEnhd._ServiceOrganizationOrgUnit_2,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_RespSrvcOrganizationOrgUnit_2'
      _DocEnhd._RespSrvcOrganizationOrgUnit,
      _DocEnhd._RespSrvcOrganizationOrgUnit_2,


      _DocEnhd._SalesOrganization,
      _DocEnhd._SalesOffice,
      _DocEnhd._SalesGroup,
      _DocEnhd._DistributionChannel,
      _DocEnhd._Division,

      // Sales Set Assocaition

      _DocEnhd._Region,
      _DocEnhd._SrvcDocumentRejectionReason,

      // Service Request Association

      _DocEnhd._ServiceRisk,
      _DocEnhd._ServiceDocProblemCategory,

      // Association to Service Document Item

      _DocEnhd._ServiceDocItem,

      // Association to Service Document Enhanced views

      _DocEnhd._ServiceDocRefObj,
      _DocEnhd._ServiceDocPredecessor,
      _DocEnhd._ServiceDocSuccessor

}
where
       _DocEnhd.ServiceDocumentIsOpen          = 'X'
  and _DocEnhd.SrvcDocIsMaintServiceOrder != 'X'
  and  _DocEnhd.ServiceDocumentTemplateType    is initial
//  and  _DocEnhd.RefInHouseRepairIsExisting     is initial

  and(
       _DocEnhd.ServiceObjectType              = 'BUS2000112'
    or _DocEnhd.ServiceObjectType              = 'BUS2000116'
  )