A_Opportunity

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 A_Opportunity.
-- 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 A_Opportunity AS
SELECT
  PresalesDocument AS Opportunity,
  PresalesDocumentProcessType AS OpportunityProcessType,
  PresalesDocumentDescription AS OpportunityDescription,
  PresalesDocumentUUID AS OpportunityUUID,
  PresalesDocumentOrigin AS OpportunityOrigin,
  PresalesDocumentPriority AS OpportunityPriority,
  PresalesDocumentGroup AS OpportunityGroup,
  OpportunityStatus,
  OpportunityStartDate,
  OpportunityEndDate,
  ChanceOfSuccessPercent,
  CurrentSalesStage,
  PostingDate,
  DistributionChannel,
  Division,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ResponsibleSalesOrganization,
  ServiceOrganization,
  ContactPerson,
  Prospect,
  PayerParty,
  Competitor,
  _ReferenceLead._PresalesDoc.PresalesDocument AS ReferenceLead
FROM I_PresalesDocumentEnhcd AS Opportunity
LEFT OUTER JOIN A_OpportunityItem AS _Item ON Opportunity = _Item.Opportunity  -- association [0..*]
LEFT OUTER JOIN A_OpportunityPersonResp AS _PersonResponsible ON Opportunity = _PersonResponsible.Opportunity  -- association [0..*]
LEFT OUTER JOIN A_OpportunitySalesRep AS _SalesRepresentative ON Opportunity = _SalesRepresentative.Opportunity  -- association [0..*]
LEFT OUTER JOIN I_PresalesDocumentPredecessor AS _ReferenceLead ON OpportunityUUID = _ReferenceLead.PresalesDocumentUUID AND _ReferenceLead.PresalesDocPrdcssrBusObjType = 'BUS2000108'  -- association [1]
LEFT OUTER JOIN A_OpportunityFUPServiceOrder AS _ServiceOrder ON Opportunity = _ServiceOrder.Opportunity  -- association [0..*]
LEFT OUTER JOIN A_OpportunityFUPSalesOrder AS _SalesOrder ON Opportunity = _SalesOrder.Opportunity  -- association [0..*]
LEFT OUTER JOIN A_OpportunityFUPSalesQuotation AS _SalesQuotation ON Opportunity = _SalesQuotation.Opportunity  -- association [0..*]
LEFT OUTER JOIN A_OpportunityText AS _Text ON Opportunity = _Text.Opportunity  -- association [0..*]
LEFT OUTER JOIN E_PresalesDocument AS _Extension ON _Extension.BusinessObjectType = 'BUS2000111' AND Opportunity = _Extension.PresalesDocument  -- association [0..1]
;