I_SubscriptionOrderItemPartner

DDL: I_SUBSCRIPTIONORDERITEMPARTNER Type: view_entity COMPOSITE Package: CRMS4_SOM_LEGACY

Item Partner

I_SubscriptionOrderItemPartner is a Composite CDS View that provides data about "Item Partner" in SAP S/4HANA. It reads from 1 data source (P_SrvcDocItemPartner) and exposes 9 fields with key fields SubscriptionOrder, SubscriptionOrderItem, CustMgmtPartnerFunction, CustMgmtBusinessPartner. It has 4 associations to related views. Part of development package CRMS4_SOM_LEGACY.

Data Sources (1)

SourceAliasJoin Type
P_SrvcDocItemPartner ItemPartner from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_ServiceDocumentItem _SubsOrderItem ItemPartner.ServiceDocument = _SubsOrderItem.ServiceDocument and ItemPartner.ServiceDocumentItem = _SubsOrderItem.SrvcDocItmPartReferenceItem and ItemPartner.ServiceObjectType = _SubsOrderItem.ServiceObjectType
[0..1] I_CustMgmtPartnerFuncText _PartnerFunction $projection.CustMgmtPartnerFunction = _PartnerFunction.PartnerFunction and _PartnerFunction.Language = $session.system_language
[0..1] I_BusinessPartner _BusinessPartner $projection.CustMgmtBusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_SubscriptionOrder _SubscriptionOrder $projection.SubscriptionOrder = _SubscriptionOrder.SubscriptionOrder

Annotations (8)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionOrder ServiceDocument
KEY SubscriptionOrderItem ServiceDocumentItem
KEY CustMgmtPartnerFunction P_SrvcDocItemPartner CustMgmtPartnerFunction
KEY CustMgmtBusinessPartner P_SrvcDocItemPartner CustMgmtBusinessPartner
CustMgmtPartFunctionCategory P_SrvcDocItemPartner CustMgmtPartFunctionCategory
ServiceObjectType P_SrvcDocItemPartner ServiceObjectType
_PartnerFunction _PartnerFunction
_BusinessPartner _BusinessPartner
_SubscriptionOrder _SubscriptionOrder
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}

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

define view entity I_SubscriptionOrderItemPartner
  as select from P_SrvcDocItemPartner as ItemPartner
  
   association [0..*] to   I_ServiceDocumentItem as _SubsOrderItem on  ItemPartner.ServiceDocument     = _SubsOrderItem.ServiceDocument
                                                                   and ItemPartner.ServiceDocumentItem = _SubsOrderItem.SrvcDocItmPartReferenceItem
                                                                   and ItemPartner.ServiceObjectType   = _SubsOrderItem.ServiceObjectType
                                                                   
  association [0..1] to I_CustMgmtPartnerFuncText as _PartnerFunction on  $projection.CustMgmtPartnerFunction = _PartnerFunction.PartnerFunction
                                                                      and _PartnerFunction.Language           = $session.system_language                                                                      
  association [0..1] to I_BusinessPartner         as _BusinessPartner on  $projection.CustMgmtBusinessPartner = _BusinessPartner.BusinessPartner  
  association [1..1] to I_SubscriptionOrder       as _SubscriptionOrder   on  $projection.SubscriptionOrder = _SubscriptionOrder.SubscriptionOrder
{

  key  ServiceDocument     as SubscriptionOrder,
  key  ServiceDocumentItem as SubscriptionOrderItem,
  key  ItemPartner.CustMgmtPartnerFunction,
  key  ItemPartner.CustMgmtBusinessPartner,
       ItemPartner.CustMgmtPartFunctionCategory,
       ItemPartner.ServiceObjectType,
      
       //Association SoldToParty

       _PartnerFunction,
       _BusinessPartner,
       _SubscriptionOrder
       
}
where
  ItemPartner.ServiceObjectType = 'BUS2000265'