A_BusSolnQtanServiceItem

DDL: A_BUSSOLNQTANSERVICEITEM Type: view COMPOSITE

Service Item

A_BusSolnQtanServiceItem is a Composite CDS View that provides data about "Service Item" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 44 fields with key fields BusinessSolutionQuotation, BusSolutionQuotationItem. It has 10 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd BusSolnQtanServiceItem from

Associations (10)

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_BusSolnQtanItmFUPSrvcOrder _ServiceOrder $projection.BusinessSolutionQuotation = _ServiceOrder.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _ServiceOrder.BusSolutionQuotationItem
[1..1] I_ServiceDocumentItemPrdcssr_2 _ReferenceServiceContract $projection.ServiceDocumentItemCharUUID = _ReferenceServiceContract.ServiceDocumentItemCharUUID and _ReferenceServiceContract.ServiceDocumentItemObjectType = 'BUS2000140'
[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
[0..*] A_BusSolnQtanItmConfign _Configurations $projection.ConfigurationNumber = _Configurations.VariantConfigurationInstance

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Service Item view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ABSQSRVITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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 (44)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionQuotation ServiceDocument
KEY BusSolutionQuotationItem ServiceDocumentItem
BusSolnQuotationItemUUID ServiceDocumentItemUUID
ServiceDocumentItemCharUUID ServiceDocumentItemCharUUID
ParentBusSolnQuotationItem _ParentServiceDocItem ServiceDocumentItem
BusSolnQtanItemCategory ServiceDocItemCategory
Product OriginallyRequestedProduct
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 ResponsibleEmployee
ContactPerson ContactPerson
PaymentTerms PaymentTerms
ServiceTransactionChargeType ServiceTransactionChargeType
SrvcTransactionValuationType SrvcTransactionValuationType
ReferenceServiceContract
ReferenceServiceContractItem
ServiceProfile ServiceProfile
ResponseProfile ResponseProfile
MasterWarranty MasterWarranty
BillableControl BillableControl
ContractAccount ContractAccount
BillingBlockReason BillingBlockReason
BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber
SrvcDocItmProdConfignDateTime
ConfigurationNumber ConfigurationNumber
_BusinessSolutionQuotation _BusinessSolutionQuotation
_PriceElement _PriceElement
_ReferenceObject _ReferenceObject
_Text _Text
_ServiceOrder _ServiceOrder
_Configurations _Configurations
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Service Item'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ABSQSRVITEM',
  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_BusSolnQtanServiceItem
  as select from I_ServiceDocumentItemEnhcd as BusSolnQtanServiceItem
  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_BusSolnQtanItmFUPSrvcOrder   as _ServiceOrder              on  $projection.BusinessSolutionQuotation = _ServiceOrder.BusinessSolutionQuotation
                                                                                     and $projection.BusSolutionQuotationItem  = _ServiceOrder.BusSolutionQuotationItem
  association [1..1] to I_ServiceDocumentItemPrdcssr_2 as _ReferenceServiceContract  on  $projection.ServiceDocumentItemCharUUID                 = _ReferenceServiceContract.ServiceDocumentItemCharUUID
                                                                                     and _ReferenceServiceContract.ServiceDocumentItemObjectType = 'BUS2000140'
  //                                                                                   and _ReferenceServiceContract.CharcLength                   = 32

  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

  //OP2023-FPS01

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

{
  key     ServiceDocument                                          as BusinessSolutionQuotation,
  key     ServiceDocumentItem                                      as BusSolutionQuotationItem,
          ServiceDocumentItemUUID                                  as BusSolnQuotationItemUUID,
          ServiceDocumentItemCharUUID,
          _ParentServiceDocItem.ServiceDocumentItem                as ParentBusSolnQuotationItem,
          /* GENERAL INFO */
          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,


          /* SERVICE CONTRACT WARRANTY */
          ServiceTransactionChargeType,
          SrvcTransactionValuationType,

          _ReferenceServiceContract._ServiceDocItm.ServiceDocument as ReferenceServiceContract,
          _ReferenceServiceContract._ServiceDocItm.ServiceDocumentItem as ReferenceServiceContractItem,
          ServiceProfile,
          ResponseProfile,
          MasterWarranty,
          BillableControl,

          ContractAccount,

          BillingBlockReason,

          // OP2023-FPS01

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

          @ObjectModel.readOnly: true
          ConfigurationNumber,


          _BusinessSolutionQuotation,
          _PriceElement,
          _ReferenceObject,
          _Text,
          _ServiceOrder,
          _Configurations

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