C_BSOrdItmProcFlwSubscrpnItem

DDL: C_BSORDITMPROCFLWSUBSCRPNITEM Type: view CONSUMPTION

Subscription Item Attrib for BSOrd Prgrs

C_BSOrdItmProcFlwSubscrpnItem is a Consumption CDS View that provides data about "Subscription Item Attrib for BSOrd Prgrs" in SAP S/4HANA. It reads from 4 data sources (I_BusSolnOrdFUPSubscription, I_BusSolnOrdItmFUPSubscription, I_ProviderContract, I_ProviderContractItem) and exposes 9 fields with key fields UI5NetworkGraphAttributeValue, ProviderContractItem. It has 1 association to related views.

4 data source(s) 9 fields

Data Sources (4)

SourceAliasJoin Type
I_BusSolnOrdFUPSubscription _FupSub inner
I_BusSolnOrdItmFUPSubscription _FupSubItm inner
I_ProviderContract _SubHeader from
I_ProviderContractItem _SubItem inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_BusSolnOrdSubsqntDocTypeText _DocumentType _DocumentType.UI5NetworkGraphDescription = 'SUBCITM'

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSBSCRPITMATTRIB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
EndUserText.label Subscription Item Attrib for BSOrd Prgrs view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY UI5NetworkGraphAttributeValue I_ProviderContract ProviderContract
KEY ProviderContractItem I_ProviderContractItem ProviderContractItem
SubscrpnBillgSubscriptionItem I_BusSolnOrdItmFUPSubscription SubscrpnBillgSubscriptionItem
CreationDate I_ProviderContract CreationDate
CAPrvdrContrStartDateTime I_ProviderContract CAPrvdrContrStartDateTime
CAPrvdrContrEndDateTime I_ProviderContract CAPrvdrContrEndDateTime
SoldProduct I_ProviderContractItem SoldProduct
UI5NetworkGraphStatus
UI5NetworkGraphDescription 
@AbapCatalog: {
    sqlViewName:            'CSBSCRPITMATTRIB',
    compiler.compareFilter: true,
    preserveKey:            true
}

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking : #REQUIRED

@ObjectModel.usageType: {
    dataClass:      #MIXED,
    serviceQuality: #C,
    sizeCategory:   #XL
}

@VDM: {
    viewType: #CONSUMPTION
}
@EndUserText.label: 'Subscription Item Attrib for BSOrd Prgrs'

define view C_BSOrdItmProcFlwSubscrpnItem
  as select from I_ProviderContract       as _SubHeader
    inner join   I_ProviderContractItem         as _SubItem   on _SubHeader.ProviderContract = _SubItem.ProviderContract
    inner join   I_BusSolnOrdFUPSubscription    as _FupSub    on _SubItem.ProviderContract = _FupSub.SubscrpnBillgSubscription
    inner join   I_BusSolnOrdItmFUPSubscription as _FupSubItm on _FupSub.ServiceDocumentRelationUUID = _FupSubItm.ServiceDocumentItmRelationUUID

  association [0..1] to P_BusSolnOrdSubsqntDocTypeText as _DocumentType on _DocumentType.UI5NetworkGraphDescription = 'SUBCITM'
{
  key _SubHeader.ProviderContract                                                          as UI5NetworkGraphAttributeValue,
  key _SubItem.ProviderContractItem,
      _FupSubItm.SubscrpnBillgSubscriptionItem,
      _SubHeader.CreationDate,
      _SubHeader.CAPrvdrContrStartDateTime,
      _SubHeader.CAPrvdrContrEndDateTime,
      _SubItem.SoldProduct,
      cast ( _SubItem.CAProviderContractStatus as fac_network_graph_status )               as UI5NetworkGraphStatus,

      @Semantics.text: true
      _DocumentType[1: Language = $session.system_language].UI5NetworkGraphDescriptionName as UI5NetworkGraphDescription
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSSOLNORDFUPSUBSCRIPTION",
"I_BUSSOLNORDITMFUPSUBSCRIPTION",
"I_PROVIDERCONTRACT",
"I_PROVIDERCONTRACTITEM",
"P_BUSSOLNORDSUBSQNTDOCTYPETEXT"
],
"ASSOCIATED":
[
"P_BUSSOLNORDSUBSQNTDOCTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More