R_BSOrdItmRateElementTP

DDL: R_BSORDITMRATEELEMENTTP Type: view_entity TRANSACTIONAL

Business Solution Order Item Rate Element - TP

R_BSOrdItmRateElementTP is a Transactional CDS View that provides data about "Business Solution Order Item Rate Element - TP" in SAP S/4HANA. It reads from 1 data source (I_BusSolnOrderItemRateElement) and exposes 14 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem, SubscriptionRateElementNumber. It has 4 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_BusSolnOrderItemRateElement I_BusSolnOrderItemRateElement from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ServiceDocument _SubscriptionBilling _SubscriptionBilling.ServiceObjectType = 'BUS2000172' and $projection.BusinessSolutionOrder = _SubscriptionBilling.ServiceDocument
[1..1] I_ServiceDocumentItem _SubscriptionBillingItem _SubscriptionBillingItem.ServiceObjectType = 'BUS2000172' and $projection.BusinessSolutionOrder = _SubscriptionBillingItem.ServiceDocument and $projection.BusinessSolutionOrderItem = _SubscriptionBillingItem.ServiceDocumentItem
[0..1] I_Currency _TransactionCurrency $projection.Currency = _TransactionCurrency.Currency
[1..1] R_BusinessSolutionOrderTP _BusinessSolutionOrderTP $projection.BusinessSolutionOrder = _BusinessSolutionOrderTP.BusinessSolutionOrder

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Business Solution Order Item Rate Element - TP view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder BusinessSolutionOrder
KEY BusinessSolutionOrderItem BusinessSolutionOrderItem
KEY SubscriptionRateElementNumber SubscriptionRateElementNumber
Currency _SubscriptionBillingItem TransactionCurrency
SubscriptionRateElement SubscriptionRateElement
SubscriptionRateElementType SubscriptionRateElementType
SubscrpnRateElementNetAmount SubscrpnRateElementNetAmount
SubscrpnRateElementGrossAmount SubscrpnRateElementGrossAmount
SubscrpnRateElementTaxAmount SubscrpnRateElementTaxAmount
_BusinessSolutionOrderItemTP _BusinessSolutionOrderItemTP
_BusinessSolutionOrderTP _BusinessSolutionOrderTP
_SubscriptionBilling _SubscriptionBilling
_SubscriptionBillingItem _SubscriptionBillingItem
_TransactionCurrency _TransactionCurrency 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@Metadata.ignorePropagatedAnnotations: true

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

@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

@EndUserText.label: 'Business Solution Order Item Rate Element - TP'

define view entity R_BSOrdItmRateElementTP
  as select from I_BusSolnOrderItemRateElement
  association        to parent R_BusinessSolutionOrderItemTP as _BusinessSolutionOrderItemTP on  $projection.BusinessSolutionOrder     = _BusinessSolutionOrderItemTP.BusinessSolutionOrder
                                                                                             and $projection.BusinessSolutionOrderItem = _BusinessSolutionOrderItemTP.BusinessSolutionOrderItem

  association [1..1] to I_ServiceDocument                    as _SubscriptionBilling         on  _SubscriptionBilling.ServiceObjectType = 'BUS2000172'
                                                                                             and $projection.BusinessSolutionOrder      = _SubscriptionBilling.ServiceDocument

  association [1..1] to I_ServiceDocumentItem                as _SubscriptionBillingItem     on  _SubscriptionBillingItem.ServiceObjectType = 'BUS2000172'
                                                                                             and $projection.BusinessSolutionOrder          = _SubscriptionBillingItem.ServiceDocument
                                                                                             and $projection.BusinessSolutionOrderItem      = _SubscriptionBillingItem.ServiceDocumentItem

//  association [1..1] to I_SrvcSubscrpnRateElmntTypeTxt       as _SubscrpnRateElementTypeText on  $projection.SubscriptionRateElementType = _SubscrpnRateElementTypeText.SubscriptionRateElementType

//                                                                                             and _SubscrpnRateElementTypeText.Language   = $session.system_language


  association [0..1] to I_Currency                           as _TransactionCurrency         on  $projection.Currency = _TransactionCurrency.Currency

  association [1..1] to R_BusinessSolutionOrderTP            as _BusinessSolutionOrderTP     on  $projection.BusinessSolutionOrder = _BusinessSolutionOrderTP.BusinessSolutionOrder
{
    //  @ObjectModel.foreignKey.association: '_SubscriptionBilling'

  key BusinessSolutionOrder,

   //   @ObjectModel.foreignKey.association: '_SubscriptionBillingItem'

  key BusinessSolutionOrderItem,
  key SubscriptionRateElementNumber,

      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      _SubscriptionBillingItem.TransactionCurrency as Currency,

      SubscriptionRateElement,

      @ObjectModel.sapObjectNodeTypeReference: 'SrvcSubscrpnRateElmntType'
      SubscriptionRateElementType,

//      SubscrpnRateElementTypeText,


      @Semantics.amount.currencyCode: 'Currency'
      SubscrpnRateElementNetAmount,

      @Semantics.amount.currencyCode: 'Currency'
      SubscrpnRateElementGrossAmount,

      @Semantics.amount.currencyCode: 'Currency'
      SubscrpnRateElementTaxAmount,

      // Associations

      _BusinessSolutionOrderItemTP,
      _BusinessSolutionOrderTP,
      _SubscriptionBilling,
      _SubscriptionBillingItem,
//      _SubscrpnRateElementTypeText,

      _TransactionCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSSOLNORDERITEMRATEELEMENT",
"I_SERVICEDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_SERVICEDOCUMENT",
"I_SERVICEDOCUMENTITEM",
"R_BUSINESSSOLUTIONORDERITEMTP",
"R_BUSINESSSOLUTIONORDERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More