A_BusSolnQtanBundleItem

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

define view A_BusSolnQtanBundleItem as select from I_ServiceDocumentItemEnhcd as BusSolnQtanBundleItem
  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 [1..1] to A_BusinessSolutionQuotation    as _BusinessSolutionQuotation on  $projection.BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation

  association [0..*] to A_BusSolnQtanItmConfign        as _Configurations               on  $projection.ConfigurationNumber               = _Configurations.VariantConfigurationInstance
                                                                                        and _Configurations.VarConfignInstceBusObjectType = 'CRM_OR_ITM'

  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,
          /* GENERAL INFO */
          ServiceDocItemCategory                                   as BusSolnQtanItemCategory,
          cast(OriginallyRequestedProduct as abap.char(40))                              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,
          cast( ResponsibleEmployee as abap.char( 12 )) as PersonResponsible,
          cast( ContactPerson as abap.numc( 10 ))       as ContactPerson,
          @ObjectModel.readOnly: true
          ConfigurationNumber,


          ContractAccount,

          BillingBlockReason,

          //BOM Item Node Number

          BillOfMaterialItemNodeNumber,

          //Configuration Date

          @Semantics.dateTime:true
          @ObjectModel.virtualElement
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CRMS4_API_SRVP_ITM_DURATION'
          cast( '00000000' as  timestamp )                                                                                                                 as SrvcDocItmProdConfignDateTime,


          _BusinessSolutionQuotation,
          _PriceElement,
          _ReferenceObject,
          _Configurations,
          _Text

}
where
      ServiceObjectType             = 'BUS2000116'
  and ServiceDocumentItemObjectType = 'BUS2000214'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSSOLNQTANITMEXTREFERENCE",
"I_SERVICEDOCUMENTITEMENHCD",
"I_UNITOFMEASURE"
],
"ASSOCIATED":
[
"A_BUSINESSSOLUTIONQUOTATION",
"A_BUSSOLNQTANITEMTEXT",
"A_BUSSOLNQTANITMCONFIGN",
"A_BUSSOLNQTANITMPRICEELEMENT",
"A_BUSSOLNQTANSRVCITMREFOBJ",
"E_SERVICEDOCUMENTITEM",
"I_BUSSOLNQTANITMEXTREFERENCE",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/