R_SubscriptionContractTP

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 R_SubscriptionContractTP.
-- 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 R_SubscriptionContractTP AS
SELECT
  SubscriptionContract,
  SubscriptionContractType,
  SubscrpnContractDescription,
  SubscriptionContractUUID,
  ServiceObjectType,
  Language,
  SubscriptionContractPostingDte,
  SubscriptionContractStatus,
  SubscrpnContractIsCompleted,
  SubscriptionContractHasError,
  SbsConGTSEmbargoStatus,
  SbsConGTSScreeningStatus,
  SbsConGTSLglControlStatus,
  ServiceDocumentType,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  DistributionChannel,
  Division,
  ServiceOrganization,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPersonBusinessPartnerId,
  RespEmployeeBusinessPartnerId,
  PurchaseOrderByCustomer,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_SubscriptionContract
LEFT OUTER JOIN I_SbsMssProcgElmContrDocChg AS _SbsMssProcgElmContrDocChg ON _SbsMssProcgElmContrDocChg.SubscriptionContract = SubscriptionContract AND _SbsMssProcgElmContrDocChg.SubscrpnMassProcgElmntSts <> 'D'  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _Extension ON _Extension.ServiceCategory = 'BUS2000266' AND SubscriptionContract = _Extension.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN R_SubscriptionContractItemTP AS _Item ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrPartnerTP AS _SubscrpnContrPartner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrUserStatusTP AS _SubscrpnContrUserStatus ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrDurnTP AS _SubscrpnContrDurn ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrApptTP AS _SubscrpnContrAppt ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrKeyFigureTP AS _SubscrpnContrKeyFigure ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_SubscrpnContrChgProcTP AS _SubscrpnContrChgProc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrPrdcssrTP AS _SubscrpnContrPrdcssr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrSuccessorTP AS _SubscrpnContrSuccessor ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrLongTextTP AS _SubscrpnContrLongText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrHistoryTP AS _SubscrpnContrHistory ON /* condition not available in parsed metadata */  -- association [0..*]
;