P_SubscriptionContractHistory

DDL: P_SUBSCRIPTIONCONTRACTHISTORY Type: view_entity COMPOSITE

Subscription Contract History

P_SubscriptionContractHistory is a Composite CDS View that provides data about "Subscription Contract History" in SAP S/4HANA. It reads from 2 data sources (I_SubscriptionContract, I_SubscrpnContrExtIDHist) and exposes 11 fields with key fields SubscrpnContrItmHistSqnc, SubscriptionChangeOrder, SubscriptionChangeOrderItem.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_SubscriptionContract SubscriptionContract from
I_SubscrpnContrExtIDHist SubscrpnContrExtIDHist inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Subscription Contract History view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SubscrpnContrItmHistSqnc I_SubscrpnContrExtIDHist SubscrpnContrItmHistSqnc
KEY SubscriptionChangeOrder I_SubscrpnContrExtIDHist SubscriptionChangeOrder
KEY SubscriptionChangeOrderItem I_SubscrpnContrExtIDHist SubscriptionChangeOrderItem
SubscriptionContractExternalID I_SubscrpnContrExtIDHist SubscriptionContractExternalID
SubscriptionContract I_SubscriptionContract SubscriptionContract
SubscrpnChgOrdItmSts I_SubscrpnContrExtIDHist SubscrpnChgOrdItmSts
Product I_SubscrpnContrExtIDHist Product
SrvcTransChangeProcess I_SubscrpnContrExtIDHist SrvcTransChangeProcess
SrvcTransChangeProcessType I_SubscrpnContrExtIDHist SrvcTransChangeProcessType
SubscrpnChgOrdItmActvtnDteTme I_SubscrpnContrExtIDHist SubscrpnChgOrdItmActvtnDteTme
SrvcTransChangeProcessGroup I_SubscrpnContrExtIDHist SrvcTransChangeProcessGroup 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Subscription Contract History'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}

@VDM: {
  viewType: #COMPOSITE,
  private: true
}

define view entity P_SubscriptionContractHistory
  as select from I_SubscriptionContract   as SubscriptionContract
    inner join   I_SubscrpnContrExtIDHist as SubscrpnContrExtIDHist on SubscrpnContrExtIDHist.SubscriptionContract = SubscriptionContract.SubscriptionContract
{
  key SubscrpnContrExtIDHist.SubscrpnContrItmHistSqnc,
  key SubscrpnContrExtIDHist.SubscriptionChangeOrder,
  key SubscrpnContrExtIDHist.SubscriptionChangeOrderItem,

      SubscrpnContrExtIDHist.SubscriptionContractExternalID,
      SubscriptionContract.SubscriptionContract as SubscriptionContract,


      /* HISTORY DATA */
      SubscrpnContrExtIDHist.SubscrpnChgOrdItmSts,

      SubscrpnContrExtIDHist.Product,
      SubscrpnContrExtIDHist.SrvcTransChangeProcess,
      SubscrpnContrExtIDHist.SrvcTransChangeProcessType,
      @Semantics.dateTime:true
      SubscrpnContrExtIDHist.SubscrpnChgOrdItmActvtnDteTme,
      SubscrpnContrExtIDHist.SrvcTransChangeProcessGroup

}

Learn More