CRMS4_SERV_I_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_SERV_I_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_SERVISRCH

CREATE VIEW CRMS4_SERV_I_SEARCH AS
SELECT
  objtype_h AS object_type,
  object_id,
  number_int,
  period_date,
  settl_from,
  settl_to,
  bill_date,
  invcr_date,
  value_date,
  sepa_on,
  mandate_id,
  kind_date_to,
  chkl_step_id,
  chkl_step_id AS CHKLST_STEP_ID,
  chkl_step_no,
  chkl_prev_no,
  gi_quantity,
  billed_value,
  dlv_quantity,
  tstmp_to_dats( valid_from, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as valid_from AS clientNULLasvalid_from,
  tstmp_to_dats( valid_to, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as valid_to AS clientNULLasvalid_to,
  quot_start,
  quot_end,
  srv_cust_beg,
  srv_cust_end,
  srq_tot_unit,
  srv_rfirst,
  srv_rready,
  srv_close,
  contstart,
  contend,
  cont_end_ts,
  item_guid,
  item_guid AS GUID,
  created_at_i,
  created_at_i AS created_at,
  created_by_i,
  created_by_i AS created_by,
  changed_at_i,
  changed_at_i AS changed_at,
  changed_by_i,
  changed_by_i AS changed_by,
  objtype_i,
  header_guid,
  _Situation.SitnNumberOfInstances AS sit_num_itm,
  _refobj.equipment_id AS equipment_id,
  batch,
  parent,
  alternative,
  product,
  ordered_prod,
  partner_prod,
  description_i AS description,
  itm_language,
  number_ext,
  itm_type,
  order_date,
  itm_usage,
  product_kind,
  revacc_refid,
  ' ' AS tr_type,
  ' ' AS tr_type_desc,
  dis_channel,
  division,
  division_ori,
  sales_org,
  sales_office,
  sales_group,
  service_org,
  sales_org_sd,
  payer,
  _payr.BusinessPartnerFullName AS payer_list,
  person_resp,
  resp_group,
  service_team,
  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,
  statistical,
  net_value_i AS net_value,
  net_price_i,
  tax_amount_i,
  freight_i,
  subtotal1,
  subtotal2,
  subtotal3,
  subtotal4,
  subtotal5,
  subtotal6,
  netpr_uom,
  rec_duration,
  target_value,
  net_weight_i,
  volume_i,
  exponent10,
  comm_group,
  rebate_group,
  cash_disc,
  prc_group1,
  prc_group2,
  prc_group3,
  prc_group4,
  prc_group5,
  region,
  industry,
  cust_group1,
  cust_group2,
  cust_group3,
  cust_group4,
  cust_group5,
  po_date_sold,
  po_date_ship,
  usage_type,
  submission,
  rejection,
  probability,
  order_qty,
  order_qty AS quantity,
  dispo_flg,
  service_type,
  srv_escal,
  srv_serwi,
  srv_rule_id,
  incoterms1,
  incoterms2,
  ship_cond,
  over_dlv_tol,
  dlv_prio,
  ordercombind,
  part_dlv,
  dlv_group,
  part_dlv_itm,
  stat_credit,
  stat_error,
  stat_billing,
  stat_open,
  stat_cont_ts,
  asp_id_01,
  cat_id_01,
  asp_id_02,
  cat_id_02,
  priority,
  _prio.txt_long AS priority_txt,
  process_type,
  posting_date,
  created_at_h,
  created_by_h,
  changed_at_h,
  changed_by_h,
  btx_class,
  auth_scope,
  item_no_appt,
  prod_sel_type AS a3seltype,
  ci_contract_id AS a3extref,
  btmf_process,
  sc_group,
  sc_doc_guid,
  ccm_version,
  pool_agr_ref,
  int_obj_no,
  exist_vckey,
  root_config,
  rule_horizon,
  rule_date_to,
  cancproc,
  cancparty,
  canc_reason,
  ' ' AS ma_prod_id
FROM crms4d_serv_i AS _SRVI
LEFT OUTER JOIN I_BusinessPartner AS _sold ON _SRVI.sold_to_party = _sold.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ship ON _SRVI.ship_to_party = _ship.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _bill ON _SRVI.bill_to_party = _bill.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _payr ON _SRVI.payer = _payr.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _resp ON _SRVI.person_resp = _resp.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _cont ON _SRVI.contact_person = _cont.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _rgrp ON _SRVI.resp_group = _rgrp.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _srvt ON _SRVI.service_team = _srvt.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _semp ON _SRVI.service_employee = _semp.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _cacc ON _SRVI.contract_account = _cacc.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN scpriot AS _prio ON _SRVI.priority = _prio.priority AND _prio.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN CRMS4_PROC_TYPE AS _proc ON _SRVI.process_type = _proc.Process_Type  -- association [0..1]
LEFT OUTER JOIN CRMS4_LFCY_STATUS AS _lfcy ON _SRVI.stat_lifecycle = _lfcy.domvalue_l  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocCreditStatusText AS _credit ON _SRVI.stat_credit = _credit.DomainValue AND _credit.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocExecutionStatusText AS _maint ON _SRVI.stat_maintenance = _maint.DomainValue AND _maint.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN CRMS4_CANC_STATUS AS _canc ON _SRVI.stat_cancelled = _canc.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_RELE_STATUS AS _rele ON _SRVI.stat_released = _rele.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_QUOT_STATUS AS _quot ON _SRVI.stat_quotation = _quot.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_DELI_STATUS AS _deli ON _SRVI.stat_delivery = _deli.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_ERRO_STATUS AS _erro ON _SRVI.stat_error = _erro.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_GDIS_STATUS AS _gdis ON _SRVI.stat_goods_issue = _gdis.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_BILL_STATUS AS _bili ON _SRVI.stat_billing = _bili.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_FBIL_STATUS AS _fbil ON _SRVI.stat_for_billing = _fbil.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_OPEN_STATUS AS _open ON _SRVI.stat_open = _open.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_CHKLST_EXEC_STATUS AS _chkl ON _SRVI.stat_chklst_exec = _chkl.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_ACTIVATION_STATUS AS _acti ON _SRVI.stat_activation = _acti.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_COTS_STATUS AS _cots ON _SRVI.stat_cont_ts = _cots.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_ACPT_STATUS AS _acpt ON _SRVI.stat_cont_ts = _acpt.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_REF_OBJECT AS _refobj ON _SRVI.object_id = _refobj.object_id AND _SRVI.objtype_h = _refobj.objtype_h AND _SRVI.number_int = _refobj.number_int  -- association [0..*]
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON _SRVI.objtype_h = _ServiceDocItemExt.ServiceCategory AND _SRVI.object_id = _ServiceDocItemExt.ServiceOrderItem AND _SRVI.number_int = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN I_SitnInstceIndicator AS _Situation ON _SRVI.item_guid_char = _Situation.SitnInstceAnchorObjectKey  -- association [0..1]
;