I_SubscrpnOrdItemPriceElement

DDL: I_SUBSCRPNORDITEMPRICEELEMENT Type: view_entity COMPOSITE

Item Price

I_SubscrpnOrdItemPriceElement is a Composite CDS View that provides data about "Item Price" in SAP S/4HANA. It reads from 2 data sources (I_PricingElement, I_ServiceDocumentEnhcd) and exposes 11 fields with key fields SubscriptionOrder, SubscriptionOrderItem, PricingProcedureStep, PricingProcedureCounter. It has 1 association to related views.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_PricingElement PricingElement from
I_ServiceDocumentEnhcd SubsOrderItemEnhcd inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SubscriptionOrder _SubscriptionOrder $projection.SubscriptionOrder = _SubscriptionOrder.SubscriptionOrder

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Item Price view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionOrder I_ServiceDocumentEnhcd ServiceDocument
KEY SubscriptionOrderItem I_PricingElement PricingDocumentItem
KEY PricingProcedureStep I_PricingElement PricingProcedureStep
KEY PricingProcedureCounter I_PricingElement PricingProcedureCounter
ConditionType I_PricingElement ConditionType
ConditionRateValue I_PricingElement ConditionRateValue
ConditionCurrency I_PricingElement ConditionCurrency
ConditionQuantity I_PricingElement ConditionQuantity
ConditionQuantityUnit I_PricingElement ConditionQuantityUnit
VariantCondition I_PricingElement VariantCondition
_SubscriptionOrder _SubscriptionOrder 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}

@EndUserText.label: 'Item Price'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}

define view entity I_SubscrpnOrdItemPriceElement
  as select from I_PricingElement       as PricingElement
    inner join   I_ServiceDocumentEnhcd as SubsOrderItemEnhcd on  SubsOrderItemEnhcd.PricingDocument   = PricingElement.PricingDocument
                                                              and SubsOrderItemEnhcd.ServiceObjectType = 'BUS2000265'
  association [1..1] to I_SubscriptionOrder as _SubscriptionOrder on $projection.SubscriptionOrder = _SubscriptionOrder.SubscriptionOrder
{
  key SubsOrderItemEnhcd.ServiceDocument     as SubscriptionOrder,
  key PricingElement.PricingDocumentItem     as SubscriptionOrderItem,
  key PricingElement.PricingProcedureStep    as PricingProcedureStep,
  key PricingElement.PricingProcedureCounter as PricingProcedureCounter,

      PricingElement.ConditionType           as ConditionType,

      PricingElement.ConditionRateValue      as ConditionRateValue,

      PricingElement.ConditionCurrency       as ConditionCurrency,

      @Semantics.quantity.unitOfMeasure: 'ConditionQuantityUnit'
      PricingElement.ConditionQuantity       as ConditionQuantity,

      PricingElement.ConditionQuantityUnit   as ConditionQuantityUnit,

      PricingElement.VariantCondition        as VariantCondition,

      @ObjectModel.readOnly: true
      @Semantics.booleanIndicator
      case PricingElement.ConditionInactiveReason
      when  '' then 'X'
      else ''
      end                                    as ConditionIsActive,
      
      //Association

      _SubscriptionOrder
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRICINGELEMENT",
"I_SERVICEDOCUMENTENHCD"
],
"ASSOCIATED":
[
"I_SUBSCRIPTIONORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More