A_BusSolnQtanExpenseItem

@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Expense Item'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ABSQEXPITM',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   createEnabled: true,
   updateEnabled: true,
   deleteEnabled: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
@Metadata.ignorePropagatedAnnotations: true

define view A_BusSolnQtanExpenseItem
  as select from I_ServiceDocumentItemEnhcd
  association [0..*] to A_BusSolnQtanItmPriceElement as _PriceElement              on  $projection.BusinessSolutionQuotation = _PriceElement.BusinessSolutionQuotation
                                                                                   and $projection.BusSolutionQuotationItem  = _PriceElement.BusSolutionQuotationItem

  association [0..*] to A_BusSolnQtanSrvcItmRefObj   as _ReferenceObject           on  $projection.BusinessSolutionQuotation = _ReferenceObject.BusinessSolutionQuotation
                                                                                   and $projection.BusSolutionQuotationItem  = _ReferenceObject.BusSolutionQuotationItem

  association [0..*] to A_BusSolnQtanItemText        as _Text                      on  $projection.BusSolutionQuotationItem  = _Text.BusSolutionQuotationItem
                                                                                   and $projection.BusinessSolutionQuotation = _Text.BusinessSolutionQuotation
  association [0..*] to A_BusSolnQtanItmFUPSrvcOrder as _ServiceOrder              on  $projection.BusinessSolutionQuotation = _ServiceOrder.BusinessSolutionQuotation
                                                                                   and $projection.BusSolutionQuotationItem  = _ServiceOrder.BusSolutionQuotationItem
  association [1..1] to A_BusinessSolutionQuotation  as _BusinessSolutionQuotation on  $projection.BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation
  association [0..1] to I_BusSolnQtanItmExtReference as _ExternalReference         on  $projection.BusinessSolutionQuotation          =  _ExternalReference.BusinessSolutionQuotation
                                                                                   and $projection.BusSolutionQuotationItem           =  _ExternalReference.BusSolutionQuotationItem
                                                                                   and _ExternalReference.BusSolnQtanItemExtReference <> ''
  association [0..1] to E_ServiceDocumentItem        as _Extension                 on  _Extension.ServiceCategory            = 'BUS2000116'
                                                                                   and $projection.BusinessSolutionQuotation = _Extension.ServiceOrderItem
                                                                                   and $projection.BusSolutionQuotationItem  = _Extension.ServiceLineExternalID
  association [0..1] to I_UnitOfMeasure              as _UnitOfMeasure             on  $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure
{
  key     ServiceDocument                           as BusinessSolutionQuotation,
  key     ServiceDocumentItem                       as BusSolutionQuotationItem,
          ServiceDocumentItemUUID                   as BusSolnQuotationItemUUID,
          _ParentServiceDocItem.ServiceDocumentItem as ParentBusSolnQuotationItem,

          ServiceDocItemCategory                    as BusSolnQtanItemCategory,
          OriginallyRequestedProduct                as Product,
          @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
          ServiceDocumentItemQuantity               as Quantity,
          ServiceDocItemQuantityUnit                as QuantityUnit,
          _UnitOfMeasure.UnitOfMeasureISOCode       as RequestedQuantityISOUnit,
          ServiceDocumentItemDescription            as BusSolnQtanItemDescription,
          Language,
          _ExternalReference.BusSolnQtanItemExtReference,
          ItemOrderProbabilityInPercent,

          /* STATUS */
          ServiceDocumentItemIsReleased             as BusSolnQtanItemIsReleased,
          case ServiceDocumentItemStatus
          when 'C'  then 'X'
          else ''
          end                                       as BusSolnQtanItemIsCompleted,
          QuotationIsAccepted                       as BusSolnQtanItemIsAccepted,
          ServiceDocumentItemIsRejected             as BusSolnQtanItemIsRejected,
          ServiceDocItemRejectionReason             as BusSolnQtanItmRjcnReason,
          /* PARTNERS */
          SoldToParty,
          ShipToParty,
          BillToParty,
          PayerParty,
          ResponsibleEmployee                       as PersonResponsible,
          ContactPerson,

          PaymentTerms,

          BillingBlockReason,

          /* SERVICE CONTRACT WARRANTY */
          MasterWarranty,
          BillableControl,
          ContractAccount,
          _BusinessSolutionQuotation,
          _PriceElement,
          _ReferenceObject,
          _Text,
          _ServiceOrder
}
where
      ServiceObjectType             = 'BUS2000116'
  and ServiceDocumentItemObjectType = 'BUS2000159'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSSOLNQTANITMEXTREFERENCE",
"I_SERVICEDOCUMENTITEMENHCD",
"I_UNITOFMEASURE"
],
"ASSOCIATED":
[
"A_BUSINESSSOLUTIONQUOTATION",
"A_BUSSOLNQTANITEMTEXT",
"A_BUSSOLNQTANITMFUPSRVCORDER",
"A_BUSSOLNQTANITMPRICEELEMENT",
"A_BUSSOLNQTANSRVCITMREFOBJ",
"E_SERVICEDOCUMENTITEM",
"I_BUSSOLNQTANITMEXTREFERENCE",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/