C_Sadl_Voc_So_DataPoint

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_Sadl_Voc_So_DataPoint.
-- 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.
-- SQL view name: CSADL_VOC_SO_DP

CREATE VIEW C_Sadl_Voc_So_DataPoint AS
SELECT
  BusinessPartnerKey,
  BusinessPartnerRole,
  EmailAddress,
  PhoneNumber,
  FaxNumber,
  WebAddress,
  AddressGuid,
  BusinessPartnerId,
  CompanyName,
  LegalForm,
  bp.CreatedBy AS CreatedBy,
  bp.CreatedAt AS CreatedAt,
  bp.ChangedBy AS ChangedBy,
  bp.ChangedAt AS ChangedAt,
  bp.CurrencyCode AS CurrencyCode,
  cast ((NetAmount) as abap.fltp ) * 5.0 / 50000.0 AS CustomerRating,
  BusinessPartnerGuid,
  GrossAmount AS SalesOrderVolume,
  NetAmount AS SalesOrderVolumeCalc,
  TaxAmount AS SalesOrderTaxVolume,
  TaxAmount AS SalesOrderTaxVolumeWithLabels,
  LifecycleStatus AS Status,
  BillingStatus,
  DeliveryStatus,
  OpportunityId,
  OverallStatus,
  '0' AS AcceptanceLowValue,
  '0' AS AcceptanceHighValue,
  '0' AS ToleranceLowValue,
  '0' AS ToleranceHighValue,
  '0' AS DeviationLowValue,
  '0' AS DeviationHighValue,
  '0' AS UpDifference,
  '0' AS StrongUpDifference,
  '0' AS DownDifference,
  '0' AS StrongDownDifference,
  11000 AS SalesOrderVolumeOkt,
  '3' AS Criticality,
  '3' AS TaxCriticality,
  '5000' AS TargetTaxValue,
  '5' AS TaxTrend,
  '01.11.2000' AS StartDate,
  '30.10.2016' AS EndDate
FROM I_Sadl_Voc_Businesspartner AS bp
LEFT OUTER JOIN I_Sadl_Voc_Salesorder AS so ON /* join condition not captured in parsed metadata */
;