I_BUSSOLNORDFUPSUBSCRIPTION

CDS View

Follow-up Subscription Billing

I_BUSSOLNORDFUPSUBSCRIPTION is a CDS View in S/4HANA. Follow-up Subscription Billing. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_BusSolnOrdFUPSubscrpn view from COMPOSITE Follow-up Subscriptions
C_BSOrdItmProcFlwSubscrpnItem view inner CONSUMPTION Subscription Item Attrib for BSOrd Prgrs
P_BUSSOLNORDSUBSCRPNFLWVL1 view inner CONSUMPTION Solution Order Subscription Flow: Level1
R_BusSolnOrdFUPSubscrpnTP view_entity from TRANSACTIONAL Business Solution Order Follow up Subscription - TP 
@EndUserText.label: 'Follow-up Subscription Billing'

@ClientHandling.algorithm: #SESSION_VARIABLE

@AbapCatalog:{
  sqlViewName: 'IBSOFUPSUB',
  compiler.compareFilter: true,
  preserveKey: true
}

@VDM:{
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}

@AccessControl:{
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}

@Metadata.ignorePropagatedAnnotations: true
define view I_BusSolnOrdFUPSubscription
  as select from crmd_brelvonae
  association [0..*] to I_ServiceDocument as _BusinessSolutionOrder on  _BusinessSolutionOrder.ServiceObjectType   = 'BUS2000172'
                                                                    and _BusinessSolutionOrder.ServiceDocumentUUID = $projection.BusinessSolutionOrderUUID
{
  key relationid             as ServiceDocumentRelationUUID,
  key posno                  as ServiceDocRltnSequenceNumber,

      //Business Solution order

      objguid_a_sel          as BusinessSolutionOrderUUID,

      left(objkey_b_sel, 20 )  as SubscrpnBillgSubscription,

      //Associations

      _BusinessSolutionOrder

}
where
      objtype_a_sel = 'BUS2000172'
  and objtype_b_sel = 'SUBSCRPNH';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CRMD_BRELVONAE"
],
"ASSOCIATED":
[
"I_SERVICEDOCUMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More