A_BusSolnOrdItmRateElement

DDL: A_BUSSOLNORDITMRATEELEMENT Type: view COMPOSITE

Subscription Billing Item Rate Elements

A_BusSolnOrdItmRateElement is a Composite CDS View that provides data about "Subscription Billing Item Rate Elements" in SAP S/4HANA. It reads from 1 data source (I_BusSolnOrderItemRateElement) and exposes 12 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem, SubscriptionRateElement, SubscriptionRateElementType. It has 3 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_BusSolnOrderItemRateElement I_BusSolnOrderItemRateElement from

Associations (3)

CardinalityTargetAliasCondition
[1..1] A_BusinessSolutionOrder _BusinessSolutionOrder $projection.BusinessSolutionOrder = _BusinessSolutionOrder.BusinessSolutionOrder
[1..1] A_BusSolnOrdSubscrpnBillgItem _SubscriptionBillingItem $projection.BusinessSolutionOrder = _SubscriptionBillingItem.BusinessSolutionOrder and $projection.BusinessSolutionOrderItem = _SubscriptionBillingItem.BusinessSolutionOrderItem
[0..*] A_BusSolnOrdItmRateElmntPrcElm _SubscriptionRateElmPriceElm $projection.BusinessSolutionOrder = _SubscriptionRateElmPriceElm.BusinessSolutionOrder and $projection.BusinessSolutionOrderItem = _SubscriptionRateElmPriceElm.BusinessSolutionOrderItem and $projection.SubscriptionRateElement = _SubscriptionRateElmPriceElm.SubscriptionRateElement

Annotations (12)

NameValueLevelField
EndUserText.label Subscription Billing Item Rate Elements view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ABSOSUBRATEELEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder BusinessSolutionOrder
KEY BusinessSolutionOrderItem BusinessSolutionOrderItem
KEY SubscriptionRateElement SubscriptionRateElement
KEY SubscriptionRateElementType SubscriptionRateElementType
SubscrpnRateElementTypeText SubscrpnRateElementTypeText
SubscrpnRateElementNetAmount SubscrpnRateElementNetAmount
SubscrpnRateElementGrossAmount SubscrpnRateElementGrossAmount
SubscrpnRateElementTaxAmount SubscrpnRateElementTaxAmount
Currency Currency
_BusinessSolutionOrder _BusinessSolutionOrder
_SubscriptionBillingItem _SubscriptionBillingItem
_SubscriptionRateElmPriceElm _SubscriptionRateElmPriceElm 
@EndUserText.label: 'Subscription Billing Item Rate Elements'

@ClientHandling.algorithm: #SESSION_VARIABLE

@AbapCatalog:{
  sqlViewName: 'ABSOSUBRATEELEM',
  compiler.compareFilter: true,
  preserveKey: true
}

@VDM:{
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}

@AccessControl:{
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}

@Metadata.ignorePropagatedAnnotations: true
define view A_BusSolnOrdItmRateElement
  as select from I_BusSolnOrderItemRateElement
  association [1..1] to A_BusinessSolutionOrder        as _BusinessSolutionOrder            on  $projection.BusinessSolutionOrder     = _BusinessSolutionOrder.BusinessSolutionOrder
  association [1..1] to A_BusSolnOrdSubscrpnBillgItem  as _SubscriptionBillingItem          on  $projection.BusinessSolutionOrder     = _SubscriptionBillingItem.BusinessSolutionOrder
                                                                                            and $projection.BusinessSolutionOrderItem = _SubscriptionBillingItem.BusinessSolutionOrderItem
  association [0..*] to A_BusSolnOrdItmRateElmntPrcElm as _SubscriptionRateElmPriceElm     on  $projection.BusinessSolutionOrder     = _SubscriptionRateElmPriceElm.BusinessSolutionOrder
                                                                                            and $projection.BusinessSolutionOrderItem = _SubscriptionRateElmPriceElm.BusinessSolutionOrderItem
                                                                                            and $projection.SubscriptionRateElement   = _SubscriptionRateElmPriceElm.SubscriptionRateElement
                                                                                                                                                                          
                                                                                      
{
  key BusinessSolutionOrder,
  key BusinessSolutionOrderItem,
 // key SubscriptionRateElementNumber,

      @ObjectModel.readOnly: true
  key SubscriptionRateElement,

      @ObjectModel.readOnly: true
      @ObjectModel.sapObjectNodeTypeReference: 'SrvcSubscrpnRateElmntType'
  key SubscriptionRateElementType,

      @ObjectModel.readOnly: true
      SubscrpnRateElementTypeText,

      @ObjectModel.readOnly: true
      @Semantics: { amount : {currencyCode: 'Currency'} }
      SubscrpnRateElementNetAmount,

      @ObjectModel.readOnly: true
      @Semantics: { amount : {currencyCode: 'Currency'} }
      SubscrpnRateElementGrossAmount,
      
      @ObjectModel.readOnly: true
      @Semantics: { amount : {currencyCode: 'Currency'} }
      SubscrpnRateElementTaxAmount,
      
      @Semantics.currencyCode: true
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      Currency,


      /* Associations */
      _BusinessSolutionOrder,
      _SubscriptionBillingItem,
      _SubscriptionRateElmPriceElm
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSSOLNORDERITEMRATEELEMENT"
],
"ASSOCIATED":
[
"A_BUSINESSSOLUTIONORDER",
"A_BUSSOLNORDITMRATEELMNTPRCELM",
"A_BUSSOLNORDSUBSCRPNBILLGITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More