CRMS4_OPPT_SEARCH

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 CRMS4_OPPT_SEARCH.
-- 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: CRMS4_OPPTSEARCH

CREATE VIEW CRMS4_OPPT_SEARCH AS
SELECT
  object_type,
  object_id,
  _oppti.number_int AS number_int,
  _oppti.number_ext AS number_ext,
  _oppti.item_guid AS item_guid,
  _oppti.itm_type AS itm_type,
  net_weight_h,
  volume_h,
  net_value_h,
  tax_amount_h,
  freight_h,
  number_items,
  lead_id,
  lead_des,
  lead_guid,
  lead_type,
  lead_end,
  lead_start,
  valid_to,
  valid_from,
  exp_revenue,
  budget_bp,
  startdate,
  expect_end,
  curr_phase,
  phase_since,
  source,
  salescycle,
  type,
  status_since,
  header_guid,
  guid,
  process_type,
  posting_date,
  description,
  created_at_h,
  created_by_h,
  changed_at_h,
  changed_by_h,
  CREATED_AT,
  created_on,
  CREATED_BY,
  CHANGED_AT,
  changed_by,
  btx_class,
  auth_scope,
  object_id_ok,
  verify_date,
  dis_channel,
  division,
  division_ori,
  sales_org,
  sales_office,
  sales_group,
  service_org,
  sales_rep,
  payer,
  payer_list,
  person_resp,
  competitor,
  exchg_type,
  exchg_date,
  taxjurcode,
  ref_currency,
  currency,
  price_date,
  pmnttrms,
  price_grp,
  cust_group,
  exchg_rate,
  tax_dest_cty,
  tax_dest_reg,
  vat_reg_no,
  ac_indicator,
  region,
  industry,
  cust_group1,
  cust_group2,
  cust_group3,
  cust_group4,
  cust_group5,
  po_date_sold,
  po_date_ship,
  usage_type,
  submission,
  rejection,
  probability,
  stat_error,
  _oppti.ordered_prod AS ordered_prod,
  _oppti.ordered_prod AS product,
  _oppti.ordered_prod AS product_id
FROM CRMS4_OPPT_H_SEARCH AS _oppth
LEFT OUTER JOIN CRMS4_OPPT_I_SEARCH AS _oppti ON _oppth.header_guid = _oppti.header_guid  -- association [1..*]
;