I_SlsCndnMassMaintJobHist

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_SlsCndnMassMaintJobHist.
-- 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_SlsCndnMassMaintJobHist AS
SELECT
  jobuuid AS ConditionJobUUID,
  job_name AS ConditionJobName,
  ernam AS CreatedByUser,
  create_time_utc AS ConditionTaskCreationDateTime,
  cast(substring(cast(create_time_utc as abap.char(32)),1,8) as abap.dats) AS CreatedAtDate,
  planned_start_time_utc AS CndnJobPlannedStartDateTime,
  error_lines AS ConditionNumberOfErrors,
  success_lines AS ConditionNumberOfSuccess,
  mass_maintenance_status AS ConditionTaskStatus,
  _ConditionTaskStatusText.CndnRecdImportStatusText AS ConditionTaskStatusText,
  datab AS ConditionValidityStartDate,
  datbi AS ConditionValidityEndDate,
  datab_shift AS CndnStartDateShiftTimeInterval,
  datab_shift_unit AS CndnStrtDtShftTimeIntervalUnit,
  _StartDateShiftUnitText.CndnStrtDtShftTmeIntvlUnitText AS CndnStrtDtShftTmeIntvlUnitText,
  datbi_shift AS CndnEndDateShiftTimeInterval,
  datbi_shift_unit AS CndnEndDteShftTimeIntervalUnit,
  _EndDateShiftUnitText.CndnStrtDtShftTmeIntvlUnitText AS CndnEndDteShftTmeIntvlUnitText,
  kbetr_amount AS ConditionRateAmount,
  konwa_amount AS ConditionCurrency,
  kbetr_ratio AS ConditionRateRatio,
  konwa_ratio AS ConditionRateRatioUnit,
  kproae AS ConditionRateChangePercent,
  krund AS ConditionRoundingRuleRoutine,
  _RoundingRuleRoutineText.CndnRoundingRuleRoutineText AS CndnRoundingRuleRoutineText
FROM cndn_mjob_hist
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_SlsCndnShftTmeIntvlUnitText AS _StartDateShiftUnitText ON CndnStrtDtShftTimeIntervalUnit = _StartDateShiftUnitText.CndnStrtDtShftTimeIntervalUnit AND _StartDateShiftUnitText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SlsCndnShftTmeIntvlUnitText AS _EndDateShiftUnitText ON CndnEndDteShftTimeIntervalUnit = _EndDateShiftUnitText.CndnStrtDtShftTimeIntervalUnit AND _EndDateShiftUnitText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SlsCndnRndngRuleRoutineText AS _RoundingRuleRoutineText ON ConditionRoundingRuleRoutine = _RoundingRuleRoutineText.ConditionRoundingRuleRoutine AND _RoundingRuleRoutineText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SlsCndnRecdImprtStatusText AS _ConditionTaskStatusText ON ConditionTaskStatus = _ConditionTaskStatusText.CndnRecdImportStatus AND _ConditionTaskStatusText.Language = $session.system_language  -- association [0..1]
;