C_RFM_OrdFlfmtApplJobHdr

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 C_RFM_OrdFlfmtApplJobHdr.
-- 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: CRFMOFAJH

CREATE VIEW C_RFM_OrdFlfmtApplJobHdr AS
SELECT
  SimulationJobUUID,
  ApplicationJobName,
  ApplicationJob,
  ApplicationLogHandle,
  PlannedStartDate,
  PlannedStartTime,
  cast( 0 as eve_tv_criticality ) AS StatusCriticality,
  cast( '' as abap.char(60) ) AS ApplicationJobStatusText,
  ApplicationJobDescription,
  CreatedByUser,
  ReleaseDateTime,
  LogNumber,
  RFMApplJobDocumentCategory,
  RFMApplJobIsSimulated,
  ReferenceApplicationJobName,
  ApplicationJobTemplate,
  ApplicationJobTemplateVersion,
  RFMApplJobApplication,
  RFM_SD_ApplJobAction,
  _OrdFlfmtApplJobActionTxt.RFM_SD_ApplJobActionName AS RFM_SD_ApplJobActionName,
  _OrdFlfmtJobApplVH.RFMApplJobApplicationName AS RFMApplJobApplicationName,
  _OrdFlfmtApplJobMsgCnt.ErrorCount AS ErrorCount,
  _OrdFlfmtApplJobMsgCnt.WarningCount AS WarningCount,
  _OrdFlfmtApplJobMsgCnt.SuccessCount AS SuccessCount,
  _OrdFlfmtApplJobTotDocCnt.NumberOfDocuments AS NumberOfDocuments,
  _OrdFlfmtApplJobDocsCnt.NumberOfErrorMsgDocuments AS NumberOfErrorMsgDocuments,
  _OrdFlfmtApplJobDocsCnt.NumberOfWarningMsgDocuments AS NumberOfWarningMsgDocuments,
  _OrdFlfmtApplJobDocsCnt.NumberOfInfoSuccessMsgDocs AS NumberOfInfoSuccessMsgDocs,
  cast ( '' as vbeln_va ) AS RFMApplJobDocument,
  cast ( 0 as tzntstmpl ) AS RFMApplJobEndDateTime
FROM I_RFM_OrdFlfmtApplJobHdr
LEFT OUTER JOIN C_RFM_OrdFlfmtApplJobDoc AS _OrdFlfmtApplJobDoc ON SimulationJobUUID = _OrdFlfmtApplJobDoc.SimulationJobUUID  -- association [1..*]
LEFT OUTER JOIN C_RFM_OrdFlfmtApplJobMsg AS _OrdFlfmtApplJobMsg ON SimulationJobUUID = _OrdFlfmtApplJobMsg.SimulationJobUUID  -- association [1..*]
LEFT OUTER JOIN C_RFM_OrdFlfmtApplJobMsgCnt AS _OrdFlfmtApplJobMsgCnt ON SimulationJobUUID = _OrdFlfmtApplJobMsgCnt.SimulationJobUUID  -- association [0..1]
LEFT OUTER JOIN C_RFM_OrdFlfmtApplJobTotDocCnt AS _OrdFlfmtApplJobTotDocCnt ON SimulationJobUUID = _OrdFlfmtApplJobTotDocCnt.SimulationJobUUID  -- association [1..1]
LEFT OUTER JOIN C_RFM_OrdFlfmtJobApplVH AS _OrdFlfmtJobApplVH ON RFMApplJobApplication = _OrdFlfmtJobApplVH.RFMApplJobApplication  -- association [1..1]
LEFT OUTER JOIN C_RFM_OrdFlfmtApplJobDocCnt AS _OrdFlfmtApplJobDocsCnt ON SimulationJobUUID = _OrdFlfmtApplJobDocsCnt.SimulationJobUUID  -- association [1..1]
LEFT OUTER JOIN I_RFM_OrdFlfmtApplJobActionTxt AS _OrdFlfmtApplJobActionTxt ON RFM_SD_ApplJobAction = _OrdFlfmtApplJobActionTxt.RFM_SD_ApplJobAction AND _OrdFlfmtApplJobActionTxt.Language = $session.system_language  -- association [1..1]
;