Wb2_Cds_Cc_Flow_Tech

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 Wb2_Cds_Cc_Flow_Tech.
-- 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: WB2_V_CC_FLOW_T

CREATE VIEW Wb2_Cds_Cc_Flow_Tech AS
SELECT
  wcocof.ruuid AS ruuid,
  wcocof.knumv AS knumv,
  wcocof.kposn AS kposn,
  wcocof.stunr AS stunr,
  wcocof.zaehk AS zaehk,
  wcocof.num AS num,
  wcocof.guid AS guid,
  wcocof.doc_type_to AS doc_type_to,
  wcocof.docnr_to AS docnr_to,
  wcocof.doc_year_to AS doc_year_to,
  wcocof.knumh AS knumh,
  wcocof.kopos AS kopos,
  wcocof.kappl AS kappl,
  wcocof.kschl AS kschl,
  wcocof.flow_type AS flow_type,
  wcocof.kwert AS kwert,
  wcocof.waers AS waers,
  wcocof.kwert_hwaers AS kwert_hwaers,
  wcocof.hwaers AS hwaers,
  wcocof.budat AS budat,
  wcocof.settl_date AS settl_date,
  wcocof.gjahr AS gjahr,
  wcocof.werks AS werks,
  wcocof.bukrs AS bukrs,
  cast( substring( wcocof.kposn, 3, 4 ) as abap.numc( 4 )) AS kposn4_tech
FROM wcocof
;