C_BSQPMSubscriptionOrder

DDL: C_BSQPMSUBSCRIPTIONORDER Type: view_entity CONSUMPTION

Subscription Order Attribute

C_BSQPMSubscriptionOrder is a Consumption CDS View that provides data about "Subscription Order Attribute" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentEnhcd) and exposes 6 fields with key field ServiceDocument. It has 1 association to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentEnhcd ServiceDocument from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_ServiceDocument _Extension _Extension.ServiceCategory = 'BUS2000265' and _Extension.ServiceOrder = ServiceDocument.ServiceDocument

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Subscription Order Attribute view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocument I_ServiceDocumentEnhcd ServiceDocument
NetAmount I_ServiceDocumentEnhcd ServiceDocNetAmount
TransactionCurrency TransactionCurrency
ServiceDocumentStatus I_ServiceDocumentEnhcd ServiceDocumentStatus
ServiceDocumentStatusName
PostingDate I_ServiceDocumentEnhcd PostingDate 
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Subscription Order Attribute'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
   dataClass:      #MIXED,
     serviceQuality: #C,
     sizeCategory:   #XXL
}
@VDM.viewType: #CONSUMPTION
define view entity C_BSQPMSubscriptionOrder
  as select from I_ServiceDocumentEnhcd as ServiceDocument
  association [0..1] to E_ServiceDocument as _Extension on  _Extension.ServiceCategory = 'BUS2000265'
                                                        and _Extension.ServiceOrder    = ServiceDocument.ServiceDocument
{
      @UI.hidden: true
  key ServiceDocument.ServiceDocument     as ServiceDocument,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      ServiceDocument.ServiceDocNetAmount as NetAmount,
      @UI.hidden: true
      TransactionCurrency,
      @ObjectModel.text.element: [ 'ServiceDocumentStatusName' ]
      ServiceDocument.ServiceDocumentStatus,
      @UI.hidden: true
      @Semantics.text: true
      _SrvcDocLifecycleStatus._ServiceDocumentStatusText[1: Language=$session.system_language].ServiceDocumentStatusName,
      ServiceDocument.PostingDate         as PostingDate
}
where
  ServiceObjectType = 'BUS2000265'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTENHCD",
"I_SRVCDOCLIFECYCLESTATUS",
"I_SRVCDOCLIFECYCLESTATUSTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More