R_SettlmtMgmtRefDocProcessFlow

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 R_SettlmtMgmtRefDocProcessFlow.
-- 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: RWLFSMTRFPROCFLW

CREATE VIEW R_SettlmtMgmtRefDocProcessFlow AS
SELECT
  ruuid AS SettlmtMgmtDocRelshpUUID,
  ref_doc_nr AS SettlmtRefDoc,
  cast( ref_doc_year as wlf_ref_doc_year_no_cnext preserving type ) AS SettlmtRefDocFiscalYear,
  ref_log_sys AS SettlmtRefDocLogicalSyst,
  posnv AS SettlmtRefDocItem,
  lftypv AS SettlmtRefDocCat,
  ref_doc_bukrs AS SettlmtRefDocCompanyCode,
  wbelnn AS SettlmtSubsqntRefDoc,
  posnn AS SettlmtSubsqntRefDocItem,
  lftypn AS SettlmtSubsqntDocCat,
  cast( erdat as wlf_created_on preserving type ) AS CreationDate,
  cast( erzet as wlf_created_at preserving type ) AS CreationTime,
  cast( ernam as wlf_created_by preserving type ) AS CreatedByUser,
  abartn AS SubsqntSettlmtCat,
  wdtypv AS PrecdgSettlmtMgmtDocCat,
  wdtypn AS SubsqntSettlmtMgmtDocCat,
  ref_use_case AS SettlmtRefDocBusProcCat
FROM wbrfn
LEFT OUTER JOIN I_SettlmtPrecdgDocCat AS _SettlmtPrecdgDocCat ON SettlmtRefDocCat = _SettlmtPrecdgDocCat.SettlmtPrecdgDocCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtSubsqntDocCat AS _SettlmtSubsqntDocCat ON SettlmtSubsqntDocCat = _SettlmtSubsqntDocCat.SettlmtSubsqntDocCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtCat AS _SubsqntSettlmtCat ON SubsqntSettlmtCat = _SubsqntSettlmtCat.SettlmtCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocCat AS _PrecdgSettlmtMgmtDocCat ON PrecdgSettlmtMgmtDocCat = _PrecdgSettlmtMgmtDocCat.SettlmtMgmtDocCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocCat AS _SubsqntSettlmtMgmtDocCat ON SubsqntSettlmtMgmtDocCat = _SubsqntSettlmtMgmtDocCat.SettlmtMgmtDocCat  -- association [0..1]
;