CRMS4_REPA_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_REPA_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.

CREATE VIEW CRMS4_REPA_I_SEARCH AS
SELECT
  objtype_h AS object_type,
  object_id,
  number_int,
  process_type,
  posting_date,
  description_h AS description,
  created_at_h,
  created_by_h,
  changed_at_h,
  changed_by_h,
  item_guid,
  created_at_i,
  created_by_i,
  changed_at_i,
  changed_by_i,
  created_at_i AS created_at,
  tstmp_to_dats( created_at_i, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as created_on_repa AS clientNULLascreated_on_repa,
  created_by_i AS created_by,
  changed_at_i AS changed_at,
  changed_by_i AS changed_by,
  objtype_i,
  header_guid,
  parent,
  product,
  ordered_prod,
  upper(_material.MaterialName) AS product_name,
  partner_prod,
  itm_language,
  itm_type,
  itm_usage,
  product_kind,
  _repa.person_resp AS person_resp,
  equipment_id,
  exponent10,
  stat_error,
  stat_open,
  order_qty,
  ref_msr_item,
  _repa.dis_channel AS dis_channel,
  _repa.division AS division,
  _repa.division_ori AS division_ori,
  _repa.sales_org AS sales_org,
  _repa.sales_office AS sales_office,
  _repa.sales_group AS sales_group,
  _repa.sales_org_sd AS sales_org_sd
FROM crms4d_repa_i AS _repai
LEFT OUTER JOIN CRMS4_PROC_TYPE AS _proc ON _repai.process_type = _proc.Process_Type  -- association [0..1]
LEFT OUTER JOIN CRMS4_LFCY_STATUS AS _lfcy ON _repai.stat_lifecycle = _lfcy.domvalue_l AND _lfcy.domname = 'CRMS4_STAT_LIFECYCLE'  -- association [0..1]
LEFT OUTER JOIN I_InhRepairItemStatusText AS _lfcy_usr ON _repai.stat_lifecycle = _lfcy_usr.InhRepairItemStatus AND _repai.itm_type = _lfcy_usr.InhRepairItemCategory AND _lfcy_usr.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN CRMS4_ERRO_STATUS AS _erro ON _repai.stat_error = _erro.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_OPEN_STATUS AS _open ON _repai.stat_open = _open.domvalue_l  -- association [0..1]
LEFT OUTER JOIN I_InhRepairItemAvailyStatusTxt AS _avail ON _repai.stat_repair_availability = _avail.InhRepairItemAvailyStatus AND _avail.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN CRMS4_REF_OBJECT AS _refobj ON _repai.object_id = _refobj.object_id AND _repai.objtype_h = _refobj.objtype_h AND _repai.number_int = _refobj.number_int  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _material ON _repai.ordered_prod = _material.Material AND _material.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN crms4d_repa_i AS _parent ON _repai.parent = _parent.item_guid  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = _repai.equipment_id AND _EquipmentText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _SystemStatus ON _SystemStatus.SrvcMgmtObjectUUID = _repai.item_guid AND _SystemStatus.SrvcMgmtObjectStatus = 'I1002' AND _SystemStatus.SrvcMgmtObjectStatusIsInactive = ' '  -- association [0..1]
LEFT OUTER JOIN CRMS4_REPA_H_SEARCH AS _repa ON _repa.header_guid = _repai.header_guid  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _ship ON _repai.ship_to_party = _ship.BusinessPartner  -- association [0..1]
;