A_BusSolnQtanSalesItem

DDL: A_BUSSOLNQTANSALESITEM Type: view COMPOSITE

Sales Item

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

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Associations (10)

CardinalityTargetAliasCondition
[0..*] A_BusSolnQtanItmPriceElement _PriceElement $projection.BusinessSolutionQuotation = _PriceElement.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _PriceElement.BusSolutionQuotationItem
[0..*] A_BusSolnQtanItemText _Text $projection.BusinessSolutionQuotation = _Text.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _Text.BusSolutionQuotationItem
[0..*] A_BusSolnQtanItmFUPSalesOrder _SalesOrder $projection.BusinessSolutionQuotation = _SalesOrder.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _SalesOrder.BusSolutionQuotationItem
[0..*] A_BusSolnQtanItmFUPSrvcOrder _ServiceOrder $projection.BusinessSolutionQuotation = _ServiceOrder.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _ServiceOrder.BusSolutionQuotationItem
[1..1] A_BusinessSolutionQuotation _BusinessSolutionQuotation $projection.BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation
[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..*] A_BusSolnQtanItmConfign _Configurations $projection.ConfigurationNumber = _Configurations.VariantConfigurationInstance
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure
[0..1] I_BusSolnQtanItmExtReference _LegalCntrctItmExtReference $projection.BusinessSolutionQuotation = _LegalCntrctItmExtReference.BusinessSolutionQuotation and $projection.BusSolutionQuotationItem = _LegalCntrctItmExtReference.BusSolutionQuotationItem and _LegalCntrctItmExtReference.LegalContractItemExtReference <> ''

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Item view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ABSQSALESITEM 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 (41)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionQuotation ServiceDocument
KEY BusSolutionQuotationItem ServiceDocumentItem
BusSolnQuotationItemUUID ServiceDocumentItemUUID
ParentBusSolnQuotationItem _ParentServiceDocItem ServiceDocumentItem
BusSolnQtanItemCategory ServiceDocItemCategory
Product OriginallyRequestedProduct
Quantity ServiceDocumentItemQuantity
QuantityUnit ServiceDocItemQuantityUnit
RequestedQuantityISOUnit _UnitOfMeasure UnitOfMeasureISOCode
BusSolnQtanItemDescription ServiceDocumentItemDescription
Language Language
BusSolnQtanItemExtReference _ExternalReference BusSolnQtanItemExtReference
LegalContractItemExtReference _LegalCntrctItmExtReference LegalContractItemExtReference
ItemOrderProbabilityInPercent ItemOrderProbabilityInPercent
BusSolnQtanItemIsReleased ServiceDocumentItemIsReleased
BusSolnQtanItemIsAccepted QuotationIsAccepted
BusSolnQtanItemIsRejected ServiceDocumentItemIsRejected
BusSolnQtanItmRjcnReason ServiceDocItemRejectionReason
SoldToParty SoldToParty
ShipToParty ShipToParty
BillToParty BillToParty
PayerParty PayerParty
PersonResponsible ResponsibleEmployee
ContactPerson ContactPerson
PaymentTerms PaymentTerms
IncotermsPart1 IncotermsPart1
IncotermsPart2 IncotermsPart2
DeliveryPriority DeliveryPriority
PartialDeliveryIsAllowed PartialDeliveryIsAllowed
OrderCombinationIsAllowed OrderCombinationIsAllowed
ContractAccount ContractAccount
ConfigurationNumber ConfigurationNumber
BillingBlockReason BillingBlockReason
BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber
SrvcDocItmProdConfignDateTime
_PriceElement _PriceElement
_Text _Text
_SalesOrder _SalesOrder
_ServiceOrder _ServiceOrder
_BusinessSolutionQuotation _BusinessSolutionQuotation
_Configurations _Configurations
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Sales Item'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ABSQSALESITEM',
  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_BusSolnQtanSalesItem
  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_BusSolnQtanItemText         as _Text                      on  $projection.BusinessSolutionQuotation = _Text.BusinessSolutionQuotation
                                                                                    and $projection.BusSolutionQuotationItem  = _Text.BusSolutionQuotationItem

  association [0..*] to A_BusSolnQtanItmFUPSalesOrder as _SalesOrder                on  $projection.BusinessSolutionQuotation = _SalesOrder.BusinessSolutionQuotation
                                                                                    and $projection.BusSolutionQuotationItem  = _SalesOrder.BusSolutionQuotationItem
  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..*] to A_BusSolnQtanItmConfign       as _Configurations            on  $projection.ConfigurationNumber = _Configurations.VariantConfigurationInstance
  association [0..1] to I_UnitOfMeasure               as _UnitOfMeasure             on  $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure

  //Solution Quote FPS1 Developments

  association [0..1] to I_BusSolnQtanItmExtReference  as _LegalCntrctItmExtReference on  $projection.BusinessSolutionQuotation                     =  _LegalCntrctItmExtReference.BusinessSolutionQuotation
                                                                                     and $projection.BusSolutionQuotationItem                      =  _LegalCntrctItmExtReference.BusSolutionQuotationItem
                                                                                     and _LegalCntrctItmExtReference.LegalContractItemExtReference <> ''

{
  key   ServiceDocument                           as BusinessSolutionQuotation,
  key   ServiceDocumentItem                       as BusSolutionQuotationItem,
        ServiceDocumentItemUUID                   as BusSolnQuotationItemUUID,
        _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,

         //Solution Quote FPS1 Developments

        _LegalCntrctItmExtReference.LegalContractItemExtReference,

        ItemOrderProbabilityInPercent,

        /* STATUS */
        ServiceDocumentItemIsReleased             as BusSolnQtanItemIsReleased,

        case
        when ServiceDocumentItemStatus = 'C'
        then 'X'
        else ''
        end                                       as BusSolnQtanItemIsCompleted,

        QuotationIsAccepted                       as BusSolnQtanItemIsAccepted,
        ServiceDocumentItemIsRejected             as BusSolnQtanItemIsRejected,
        ServiceDocItemRejectionReason             as BusSolnQtanItmRjcnReason,

        /* PARTNERS */
        @ObjectModel.readOnly: true
        SoldToParty,
        ShipToParty,
        BillToParty,
        PayerParty,
        ResponsibleEmployee                       as PersonResponsible,
        ContactPerson,

        PaymentTerms,

        /* SHIPPING */
        IncotermsPart1,
        IncotermsPart2,
        //                     ModeOfTransport,

        DeliveryPriority,
        PartialDeliveryIsAllowed,
        OrderCombinationIsAllowed,

        //                     MaxNmbrOfPartialDelivery,

        ContractAccount,
        @ObjectModel.readOnly: true
        ConfigurationNumber,

        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,


        _PriceElement,
        _Text,
        _SalesOrder,
        _ServiceOrder,
        _BusinessSolutionQuotation,
        _Configurations

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