A_BusSolnOrdItmSubscrpnPrAgrmt

DDL: A_BUSSOLNORDITMSUBSCRPNPRAGRMT Type: view BASIC

Subscription Billing Price Agreement

A_BusSolnOrdItmSubscrpnPrAgrmt is a Basic CDS View that provides data about "Subscription Billing Price Agreement" in SAP S/4HANA. It reads from 1 data source (I_BusSolnOrdItmSubscrpnPrAgrmt) and exposes 19 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem, SubscriptionRateElement, SubscriptionRateSubElement, SubscrpnBillgPrcElmntSpec. It has 2 associations to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_BusSolnOrdItmSubscrpnPrAgrmt I_BusSolnOrdItmSubscrpnPrAgrmt from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_BusinessSolutionOrder _BusinessSolutionOrder $projection.BusinessSolutionOrder = _BusinessSolutionOrder.BusinessSolutionOrder
[1..1] A_BusSolnOrdSubscrpnBillgItem _SubscriptionBillingItem $projection.BusinessSolutionOrder = _SubscriptionBillingItem.BusinessSolutionOrder and $projection.BusinessSolutionOrderItem = _SubscriptionBillingItem.BusinessSolutionOrderItem

Annotations (15)

NameValueLevelField
EndUserText.label Subscription Billing Price Agreement view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ABSOSUBPRCAGRMNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API 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 #B view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder BusinessSolutionOrder
KEY BusinessSolutionOrderItem BusinessSolutionOrderItem
KEY SubscriptionRateElement SubscriptionRateElement
KEY SubscriptionRateSubElement SubscriptionRateSubElement
KEY SubscrpnBillgPrcElmntSpec SubscrpnBillgPrcElmntSpec
KEY SubscrpnBillgPricingField SubscrpnBillgPricingField
KEY SubscrpnBillgPrcAgreementLine SubscrpnBillgPrcAgreementLine
SubscrpnBillgPricingScaleType SubscrpnBillgPricingScaleType
SubscrpnBillgCndnCalcType SubscrpnBillgCndnCalcType
ConditionScaleQuantityUnit ConditionScaleQuantityUnit
ConditionScaleAmountCurrency ConditionScaleAmountCurrency
ConditionRateValue ConditionRateValue
ConditionCurrency ConditionCurrency
ConditionQuantity ConditionQuantity
ConditionQuantityUnit ConditionQuantityUnit
ConditionRateRatio ConditionRateRatio
SbscrBilgCndnScaleLineIsUnlmtd SbscrBilgCndnScaleLineIsUnlmtd
_SubscriptionBillingItem _SubscriptionBillingItem
_BusinessSolutionOrder _BusinessSolutionOrder 
@EndUserText.label: 'Subscription Billing Price Agreement'

@ClientHandling.algorithm: #SESSION_VARIABLE

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

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

@AccessControl:{
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   createEnabled: true,
   updateEnabled: true,
   deleteEnabled: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #L
   }
}
@Metadata.ignorePropagatedAnnotations: true
define view A_BusSolnOrdItmSubscrpnPrAgrmt
  as select from I_BusSolnOrdItmSubscrpnPrAgrmt
  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
  {
  key BusinessSolutionOrder,
  key BusinessSolutionOrderItem,
  key SubscriptionRateElement, 
  key SubscriptionRateSubElement, 
  key SubscrpnBillgPrcElmntSpec, 
  key SubscrpnBillgPricingField,  
  key SubscrpnBillgPrcAgreementLine,
      SubscrpnBillgPricingScaleType,
      SubscrpnBillgCndnCalcType, 
      @Semantics.quantity.unitOfMeasure: 'ConditionScaleQuantityUnit'
      case  ConditionScaleQuantity 
      when 999999999999.999
      then 0
      else ConditionScaleQuantity 
      end as
      ConditionScaleQuantity , 
      @Semantics.unitOfMeasure: true
      ConditionScaleQuantityUnit,      
      @Semantics.amount.currencyCode: 'ConditionScaleAmountCurrency'
      case ConditionScaleAmount
      when 9999999999999.99
      then 0
      else ConditionScaleAmount
      end  as
      ConditionScaleAmount,       
      ConditionScaleAmountCurrency,
      ConditionRateValue,
      ConditionCurrency, 
      @Semantics.quantity.unitOfMeasure: 'ConditionQuantityUnit'
      ConditionQuantity,
      @Semantics.unitOfMeasure: true
      ConditionQuantityUnit,
      ConditionRateRatio,
      SbscrBilgCndnScaleLineIsUnlmtd,
      _SubscriptionBillingItem,
      _BusinessSolutionOrder 

 }

Learn More