TOE_CDS_TRM_DEALS

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 TOE_CDS_TRM_DEALS.
-- 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: TOEV_TR_DEALS
-- Parameters: p_keydate : dats

CREATE VIEW TOE_CDS_TRM_DEALS AS
SELECT
  ha.rfha AS deal_number,
  ha.bukrs AS company_code,
  rportb AS portfolio,
  rcntr AS cost_center,
  ps_posid AS wbs_element,
  country,
  fb_segment AS segment
FROM vtbfha AS ha
INNER JOIN vtbfhazu AS hazu ON /* join condition not captured in parsed metadata */
INNER JOIN vtbfhapo AS hapo ON /* join condition not captured in parsed metadata */
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN atpa ON /* join condition not captured in parsed metadata */
INNER JOIN refh ON /* join condition not captured in parsed metadata */
INNER JOIN vtiof AS iof ON /* join condition not captured in parsed metadata */
INNER JOIN vtiofzu AS iofzu ON /* join condition not captured in parsed metadata */
INNER JOIN vtifha AS ifha ON /* join condition not captured in parsed metadata */
INNER JOIN vtifhazu AS ihazu ON /* join condition not captured in parsed metadata */
INNER JOIN vtifhapo AS ihapo ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): vtbfha
;