CRMS4_SERV_A_SRC

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_SERV_A_SRC.
-- 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_SERVASRCH

CREATE VIEW CRMS4_SERV_A_SRC AS
SELECT
  object_type,
  object_id,
  category,
  category_txt,
  priority,
  priority_txt,
  period_date,
  settl_from,
  settl_to,
  bill_date,
  invcr_date,
  value_date,
  sepa_on,
  mandate_id,
  kind_date_to,
  net_weight_h,
  volume_h,
  NET_VALUE,
  tax_amount_h,
  freight_h,
  number_items,
  valid_from,
  valid_to,
  quot_start,
  quot_end,
  srv_cust_beg,
  srv_cust_end,
  srq_tot_unit,
  srv_rfirst,
  srv_rready,
  srv_close,
  contstart,
  contend,
  date_start,
  date_end,
  due_on,
  header_guid,
  GUID,
  process_type,
  posting_date,
  description,
  DESCRIPTION_UC,
  created_at_h,
  CREATED_AT,
  CREATED_ON,
  changed_at_h,
  CHANGED_AT,
  CHANGED_ON,
  created_by_h,
  CREATED_BY,
  changed_by_h,
  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_org_sd,
  SOLD_TO_PARTY_LIST,
  payer,
  payer_list,
  person_resp,
  resp_group,
  service_team,
  INBOX_ASSIGNED_TO_list,
  INBOX_GROUP_ASSIGNED_list,
  INBOX_ACCOUNT_list,
  INBOX_CONTACT_PERSON_list,
  payplan_type,
  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,
  incoterms1,
  incoterms2,
  ship_cond,
  over_dlv_tol,
  dlv_prio,
  ordercombind,
  part_dlv,
  dlv_group,
  part_dlv_itm,
  rec_priority,
  urgency,
  impact,
  escalation,
  risk,
  is_updated,
  chklst_id,
  wp_fixval,
  stat_credit,
  stat_error,
  stat_billing,
  stat_open,
  inbox_status,
  stat_ico,
  asp_id_01,
  cat_id_01,
  asp_id_02,
  cat_id_02,
  rule_horizon,
  rule_date_to,
  cancproc,
  cancparty,
  canc_reason,
  SIT_NUM_TOT
FROM CRMS4_SERV_H_SEARCH AS _SERVH
LEFT OUTER JOIN CRMS4_SERV_I_SEARCH AS _SERVI ON _SERVH.header_guid = _SERVI.header_guid  -- association [0..*]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON _SERVH.object_type = _ServiceDocumentExt.ServiceCategory AND _SERVH.object_id = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
;