I_SubscrpnOrdExternalReference

DDL: I_SUBSCRPNORDEXTERNALREFERENCE Type: view_entity COMPOSITE

External Reference

I_SubscrpnOrdExternalReference is a Composite CDS View that provides data about "External Reference" in SAP S/4HANA. It reads from 1 data source (crms4d_ext_ref) and exposes 2 fields with key field SubscriptionOrder. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
crms4d_ext_ref crms4d_ext_ref from

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 External Reference view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionOrder object_id
_SubscriptionOrder _SubscriptionOrder
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}

@EndUserText.label: 'External Reference'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}
define view entity I_SubscrpnOrdExternalReference
  as select from crms4d_ext_ref
  association [1..1] to I_SubscriptionOrder as _SubscriptionOrder on $projection.SubscriptionOrder = _SubscriptionOrder.SubscriptionOrder

{
  key object_id as SubscriptionOrder,

      //Association

      _SubscriptionOrder
}
where
      objtype_h  = 'BUS2000265' // Subscription Process

  and number_int = '000000' // Header