fac_ad_cds_t033G

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 fac_ad_cds_t033G.
-- 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: FACADV_T033G

CREATE VIEW fac_ad_cds_t033G AS
SELECT
  t033g.mandt AS mandt,
  t033g.anwnd AS anwnd,
  t033g.ktopl AS ktopl,
  t033g.ktosy AS ktosy,
  t033g.komo1 AS komo1,
  t033g.komo2 AS komo2,
  t033g.konto AS konto,
  symbol_text.ltext AS symbol_text,
  ktopl_text.ktplt AS ktopl_text,
  account_text.txt20 AS account_text,
  curr_text.ltext AS curr_text
FROM t033g
LEFT OUTER JOIN skat AS account_text ON ktopl = account_text.ktopl AND konto = account_text.saknr AND account_text.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN t033b AS application_text ON anwnd = application_text.anwnd AND application_text.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN t033j AS symbol_text ON anwnd = symbol_text.anwnd AND ktosy = symbol_text.ktosy AND symbol_text.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN t004t AS ktopl_text ON ktopl = ktopl_text.ktopl AND ktopl_text.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN tcurt AS curr_text ON komo1 = curr_text.waers AND curr_text.spras = $session.system_language  -- association [0..1]
;