I_SubscriptionOrder

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 I_SubscriptionOrder.
-- 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 I_SubscriptionOrder AS
SELECT
  ServiceDocument AS SubscriptionOrder,
  ServiceObjectType,
  ServiceDocumentType,
  ServiceDocumentUUID AS SubscriptionOrderUUID,
  ServiceDocumentDescription AS SubscriptionOrderDescription,
  ServiceDocCreationDateTime AS CreationDateTime,
  ServiceDocChangedDateTime AS LastChangeDateTime,
  ServiceDocumentCreatedByUser AS CreatedByUser,
  ServiceDocumentChangedByUser AS LastChangedByUser,
  PricingDocument,
  PricingProcedure,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  ServiceDocumentIsOpen AS SubscrpnOrdIsOpen,
  ServiceDocumentHasError AS SubscrpnOrdHasError,
  SrvcDocRejectionStatus,
  SrvcDocGTSEmbargoStatus AS SubsOrdGTSEmbargoStatus,
  SrvcDocGTSScreeningStatus AS SubsOrdGTSScreeningStatus,
  SrvcDocGTSLglControlStatus AS SubsOrdGTSLglControlStatus,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  cast( ContactPerson as abap.numc( 10 )) AS ContactPerson,
  cast( ResponsibleEmployee as abap.char( 12 )) AS PersonResponsible,
  RequestedServiceStartDateTime,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  PaymentTerms,
  TransactionCurrency
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcOrdStatus ON SubscriptionOrderUUID = _SrvcOrdStatus.StatusObjectUUID AND ( _SrvcOrdStatus.StatusCode = 'I1002' OR _SrvcOrdStatus.StatusCode = 'I1003' OR _SrvcOrdStatus.StatusCode = 'I1004' OR _SrvcOrdStatus.StatusCode = 'I1005' ) AND _SrvcOrdStatus.StatusIsActive = 'X'  -- association [0..1]
LEFT OUTER JOIN I_SubscriptionOrderItem AS _SubscriptionOrderItem ON SubscriptionOrder = _SubscriptionOrderItem.SubscriptionOrder  -- association [0..*]
LEFT OUTER JOIN I_SubscriptionOrderPartner AS _SubscriptionOrderPartner ON SubscriptionOrder = _SubscriptionOrderPartner.SubscriptionOrder  -- association [0..*]
LEFT OUTER JOIN I_SubscriptionOrderUserStatus AS _SubscriptionOrderUserStatus ON SubscriptionOrder = _SubscriptionOrderUserStatus.SubscriptionOrder  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnOrdExternalReference AS _ExternalReference ON SubscriptionOrder = _ExternalReference.SubscriptionOrder  -- association [0..1]
LEFT OUTER JOIN I_SubscrpnOrdFUPSubscrpnContr AS _FollowUpContract ON SubscriptionOrder = _FollowUpContract.SubscriptionOrder  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnOrdFUPSalesOrder AS _FollowUpSalesOrder ON SubscriptionOrder = _FollowUpSalesOrder.SubscriptionOrder  -- association [0..*]
LEFT OUTER JOIN I_ChgOrdPrdcssrBusSolnQtan AS _PredecessorQuotation ON SubscriptionOrder = _PredecessorQuotation.SubscriptionOrder  -- association [0..*]
LEFT OUTER JOIN I_ChgOrdPrdcssrSubscrpnContr AS _PredecessorContract ON SubscriptionOrder = _PredecessorContract.SubscriptionOrder  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementExternalID = _WBSElement.WBSElementExternalID  -- association [0..*]
;