A_BusSolnQtanBundleItem

DDL: A_BUSSOLNQTANBUNDLEITEM Type: view COMPOSITE Package: ODATA_CRMS4_SOLUTIONQUOTATION

Solution Quotation Bundle Item

A_BusSolnQtanBundleItem is a Composite CDS View that provides data about "Solution Quotation Bundle Item" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 32 fields with key fields BusinessSolutionQuotation, BusSolutionQuotationItem. It has 8 associations to related views. Part of development package ODATA_CRMS4_SOLUTIONQUOTATION.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd BusSolnQtanBundleItem from

Associations (8)

CardinalityTargetAliasCondition
[0..*] A_BusSolnQtanItmPriceElement _PriceElement $projection.BusinessSolutionQuotation = _PriceElement.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _PriceElement.BusSolutionQuotationItem
[0..*] A_BusSolnQtanSrvcItmRefObj _ReferenceObject $projection.BusinessSolutionQuotation = _ReferenceObject.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _ReferenceObject.BusSolutionQuotationItem
[0..*] A_BusSolnQtanItemText _Text $projection.BusSolutionQuotationItem = _Text.BusSolutionQuotationItem and $projection.BusinessSolutionQuotation = _Text.BusinessSolutionQuotation
[1..1] A_BusinessSolutionQuotation _BusinessSolutionQuotation $projection.BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation
[0..*] A_BusSolnQtanItmConfign _Configurations $projection.ConfigurationNumber = _Configurations.VariantConfigurationInstance and _Configurations.VarConfignInstceBusObjectType = 'CRM_OR_ITM'
[0..1] I_BusSolnQtanItmExtReference _ExternalReference $projection.BusinessSolutionQuotation = _ExternalReference.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _ExternalReference.BusSolutionQuotationItem and _ExternalReference.BusSolnQtanItemExtReference <> ''
[0..1] E_ServiceDocumentItem _Extension _Extension.ServiceCategory = 'BUS2000116' and $projection.BusinessSolutionQuotation = _Extension.ServiceOrderItem and $projection.BusSolutionQuotationItem = _Extension.ServiceLineExternalID
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Solution Quotation Bundle Item view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ABSQBUNDLEITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionQuotation ServiceDocument
KEY BusSolutionQuotationItem ServiceDocumentItem
BusSolnQuotationItemUUID ServiceDocumentItemUUID
ParentBusSolnQuotationItem _ParentServiceDocItem ServiceDocumentItem
BusSolnQtanItemCategory ServiceDocItemCategory
Product
Quantity ServiceDocumentItemQuantity
QuantityUnit ServiceDocItemQuantityUnit
RequestedQuantityISOUnit _UnitOfMeasure UnitOfMeasureISOCode
BusSolnQtanItemDescription ServiceDocumentItemDescription
Language Language
BusSolnQtanItemExtReference _ExternalReference BusSolnQtanItemExtReference
ItemOrderProbabilityInPercent ItemOrderProbabilityInPercent
BusSolnQtanItemIsReleased ServiceDocumentItemIsReleased
BusSolnQtanItemIsAccepted QuotationIsAccepted
BusSolnQtanItemIsRejected ServiceDocumentItemIsRejected
BusSolnQtanItmRjcnReason ServiceDocItemRejectionReason
SoldToParty SoldToParty
ShipToParty ShipToParty
BillToParty BillToParty
PayerParty PayerParty
PersonResponsible
ContactPerson
ConfigurationNumber ConfigurationNumber
ContractAccount ContractAccount
BillingBlockReason BillingBlockReason
SrvcDocItmProdConfignDateTime
_BusinessSolutionQuotation _BusinessSolutionQuotation
_PriceElement _PriceElement
_ReferenceObject _ReferenceObject
_Configurations _Configurations
_Text _Text
@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,


          //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'