I_SlsCndnMassMaintJobHistItem

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_SlsCndnMassMaintJobHistItem.
-- 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 I_SlsCndnMassMaintJobHistItem AS
SELECT
  massjobmsggrp.jobuuid AS ConditionJobUUID,
  massjobmsggrp.itemno AS ConditionJobItemNo,
  _MassMaintJobHist.CreatedByUser AS CreatedByUser,
  massjobmsggrp.status AS ConditionJobItemStatus,
  _ConditionJobItemStatusText.CndnRecdImportStatusText AS ConditionJobItemStatusText,
  massjobmsggrp.msgid AS SystemMessageIdentification,
  massjobmsggrp.msgno AS SystemMessageNumber,
  replace_regexpr( pcre => '&1|&2|&3|&4', value => msgtext.text, with => '*', result_length => 73 ) AS SystemMessageText,
  massjobmsggrp.count_per_group AS CndnNrOfEntryPerMessageGroup,
  massjobmsggrp.kschlstring AS ConditionTypesString
FROM cndn_mjob_msggrp AS massjobmsggrp
LEFT OUTER JOIN I_SlsCndnRecdImprtStatusText AS _ConditionJobItemStatusText ON ConditionJobItemStatus = _ConditionJobItemStatusText.CndnRecdImportStatus AND _ConditionJobItemStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SlsCndnMassMaintJobHist AS _MassMaintJobHist ON ConditionJobUUID = _MassMaintJobHist.ConditionJobUUID  -- association [1..1]
;