C_SubscriptionOrderDEX

DDL: C_SUBSCRIPTIONORDERDEX Type: view_entity CONSUMPTION
41 Fields 1 Data Sources 2 Associations

Data Extract Subscription Order

C_SubscriptionOrderDEX is a Consumption CDS View (Fact) that provides data about "Data Extract Subscription Order" in SAP S/4HANA. It reads from 1 data source (R_SubscriptionOrderTP) and exposes 41 fields with key fields SubscriptionOrder, ServiceObjectType. It has 2 associations to related views.

SAP Help Documentation

CategoryData Extraction
Data CategoryFact
StatusLegal Control Status
Purpose
This CDS view is app-independent and is available for all external consumers who want to extract subscription order header fields to SAP Business Warehouse (SAP BW) or other external systems. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: Authorization Object Description CRMS4_SLSO Sales Organizational Units of Service Transactions CRMS4_SOLO Authorization Object for Solution Order CRM_CON_SE Authorization Object CRM Order - Bus.Ob.Service Confirmation CRM_CO_SE Authorization Object CRM Order - Bus. Ob. Service Contract CRM_INCDNT Authorization Object CRM Order: Incident Management CRM_ORD_OE Authorization Object CRM Order - Allowed Organ. Units CRM_ORD_OP Authorization Object CRM Order - Own Documents CRM_ORD_PR Authorization Object CRM Order - Business Transaction Type CRM_SEO Authorization Object CRM Order-Business Object Service Order

Structure
Important Fields Important fields in this view include the following: Field Name Description SubscriptionOrder Key Transaction ID ServiceObjectType Key Trans. Cat. ServiceDocumentType Transaction Type SubscriptionOrderUUID Object GUID SubscriptionOrderDescription Transaction Descr. CreationDateTime Created On LastChangeDateTime Changed On CreatedByUser Created By LastChangedByUser Changed By PurchaseOrderByCustomer Ext. Reference CustomerPurchaseOrderDate Reference Doc. Date SubscrpnOrderIsNew Checkbox SubscrpnOrdIsInProcess Checkbox SubscrpnOrdIsReleased Checkbox SubscrpnOrdIsCompleted Checkbox SubscrpnOrdIsOpen Open SubscrpnOrdHasError Error Status SrvcDocRejectionStatus Rejection Status SubsOrdGTSEmbargoStatus Embargo Status SubsOrdGTSScreeningStatus Screening Status SubsOrdGTSLglControlStatus Legal Control Status SoldToParty Sold-To Party ShipToParty Ship-To Party BillToParty Bill-To Party PayerParty Payer ContactPerson Contact Person PersonResponsible Employee Responsible RequestedServiceStartDateTime Service Req. Start SalesOrganization Sales Organization DistributionChannel Distribution Channel Division Division SalesOffice Sales Office SalesGroup Sales Group SalesOrganizationOrgUnitID Sales Org. ID SalesOfficeOrgUnitID Sales Office SalesGroupOrgUnitID Sales Group ServiceOrganization Service Organization PaymentTerms Terms of Payment TransactionCurrency Currency WBSElementExternalID WBS Element

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
R_SubscriptionOrderTP R_SubscriptionOrderTP from

Associations (2)

CardinalityTargetAliasCondition
[0..1] E_ServiceDocument _ExtensionHdr $projection.ServiceObjectType = _ExtensionHdr.ServiceCategory and $projection.SubscriptionOrder = _ExtensionHdr.ServiceOrder
[0..*] C_SubscriptionOrderItemDEX _SubscriptionOrderItemDEX

Annotations (11)

NameValueLevelField
EndUserText.label Data Extract Subscription Order view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name SubscriptionOrder view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionOrder SubscriptionOrder
KEY ServiceObjectType ServiceObjectType Object Type
ServiceDocumentType ServiceDocumentType Transaction Type
SubscriptionOrderUUID SubscriptionOrderUUID
SubscriptionOrderDescription SubscriptionOrderDescription
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
CustomerPurchaseOrderDate CustomerPurchaseOrderDate Purchase Order Date
SubscrpnOrderIsNew SubscrpnOrderIsNew
SubscrpnOrdIsInProcess SubscrpnOrdIsInProcess
SubscrpnOrdIsReleased SubscrpnOrdIsReleased
SubscrpnOrdIsCompleted SubscrpnOrdIsCompleted
SubscrpnOrdIsOpen SubscrpnOrdIsOpen
SubscrpnOrdHasError SubscrpnOrdHasError
SrvcDocRejectionStatus SrvcDocRejectionStatus
SubsOrdGTSEmbargoStatus SubsOrdGTSEmbargoStatus
SubsOrdGTSScreeningStatus SubsOrdGTSScreeningStatus
SubsOrdGTSLglControlStatus SubsOrdGTSLglControlStatus
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
ContactPerson ContactPerson Contact Person
PersonResponsible PersonResponsible Employee Responsible
RequestedServiceStartDateTime RequestedServiceStartDateTime
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
PaymentTerms PaymentTerms Pyt Terms
TransactionCurrency TransactionCurrency Transaction Currency
WBSElementExternalID WBSElementExternalID WBS Element External ID
_SubscriptionOrderItemDEX _SubscriptionOrderItemDEX

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_SubscriptionOrderDEX.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_SubscriptionOrderDEX AS
SELECT
  SubscriptionOrder,
  ServiceObjectType,
  ServiceDocumentType,
  SubscriptionOrderUUID,
  SubscriptionOrderDescription,
  CreationDateTime,
  LastChangeDateTime,
  CreatedByUser,
  LastChangedByUser,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  SubscrpnOrderIsNew,
  SubscrpnOrdIsInProcess,
  SubscrpnOrdIsReleased,
  SubscrpnOrdIsCompleted,
  SubscrpnOrdIsOpen,
  SubscrpnOrdHasError,
  SrvcDocRejectionStatus,
  SubsOrdGTSEmbargoStatus,
  SubsOrdGTSScreeningStatus,
  SubsOrdGTSLglControlStatus,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPerson,
  PersonResponsible,
  RequestedServiceStartDateTime,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  PaymentTerms,
  TransactionCurrency,
  WBSElementExternalID
FROM R_SubscriptionOrderTP
LEFT OUTER JOIN E_ServiceDocument AS _ExtensionHdr ON ServiceObjectType = _ExtensionHdr.ServiceCategory AND SubscriptionOrder = _ExtensionHdr.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN C_SubscriptionOrderItemDEX AS _SubscriptionOrderItemDEX ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More