I_InvgCsMCase

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 I_InvgCsMCase.
-- 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: IINVGCSMCASE

CREATE VIEW I_InvgCsMCase AS
SELECT
  ext_key AS InvgCsMCaseID,
  _cmg.case_guid AS InvgCsMCaseUUID,
  case_type AS InvgCsMCaseType,
  case_title AS InvgCsMCaseTitle,
  stat_orderno AS InvgCsMCaseStatusCode,
  stat_para AS InvgCsMStatPara,
  priority AS InvgCsMPriority,
  escal_reason AS InvgCsMEscalationReason,
  _icmcmg.security_level AS InvgCsMSecurityLevel,
  _icmcmg.hidden_flag AS InvgCsMIsHidden,
  _CmgAttributes.category_text AS InvgCsMCategoryDesc,
  cast ( _icmcmg.start_crime as crms4_icm_timestamp preserving type ) AS InvgCsMCaseStartCrimeDateTime,
  cast ( _icmcmg.end_crime as crms4_icm_timestamp preserving type ) AS InvgCsMCaseEndCrimeDateTime,
  cast ( _icmcmg.start_date as crms4_icm_timestamp preserving type ) AS InvgCsMCaseStartDateTime,
  cast ( _icmcmg.end_date as crms4_icm_timestamp preserving type ) AS InvgCsMCaseEndDateTime
FROM scmg_t_case_attr AS _cmg
INNER JOIN crmd_icm_cmg_att AS _icmcmg ON /* join condition not captured in parsed metadata */
INNER JOIN crmd_cmg_case_at AS _CmgAttributes ON /* join condition not captured in parsed metadata */
;