C_RFM_OrdFlfmtApplJobDoc

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_OrdFlfmtApplJobDoc.
-- 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: CRFMOFAJD

CREATE VIEW C_RFM_OrdFlfmtApplJobDoc AS
SELECT
  SimulationJobUUID,
  RFMApplJobDocument,
  RFMApplJobDocUpdtSts,
  RFMApplJobDocUpdtStsTxt,
  Criticality,
  RFMApplJobDemandType,
  _OrdFlfmtApplJobDocCnt.NumberOfErrorMsgDocuments AS NumberOfErrorMsgDocuments,
  _OrdFlfmtApplJobDocCnt.NumberOfWarningMsgDocuments AS NumberOfWarningMsgDocuments,
  _OrdFlfmtApplJobDocCnt.NumberOfInfoSuccessMsgDocs AS NumberOfInfoSuccessMsgDocs
FROM I_RFM_OrdFlfmtApplJobDoc
LEFT OUTER JOIN C_RFM_OrdFlfmtApplJobDocItem AS _OrdFlfmtApplJobDocItem ON SimulationJobUUID = _OrdFlfmtApplJobDocItem.SimulationJobUUID AND RFMApplJobDocument = _OrdFlfmtApplJobDocItem.RFMApplJobDocument  -- association [1..*]
LEFT OUTER JOIN P_RFM_OrdFlfmtApplJobDocCnt AS _OrdFlfmtApplJobDocCnt ON SimulationJobUUID = _OrdFlfmtApplJobDocCnt.SimulationJobUUID AND RFMApplJobDocument = _OrdFlfmtApplJobDocCnt.RFMApplJobDocument  -- association [1..1]
LEFT OUTER JOIN C_RFM_OrdFlfmtApplJobMsgDoc AS _OrdFlfmtApplJobMsgDoc ON SimulationJobUUID = _OrdFlfmtApplJobMsgDoc.SimulationJobUUID AND RFMApplJobDocument = _OrdFlfmtApplJobMsgDoc.RFMApplJobDocument  -- association [1..*]
;