Fac_Ad_Cds_T030HB

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_T030HB.
-- 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_T030HB

CREATE VIEW Fac_Ad_Cds_T030HB AS
SELECT
  t030hb.ktopl AS ktopl,
  t030hb.bwber AS bwber,
  t030hb.hkont AS hkont,
  t030hb.waers AS waers,
  t030hb.lkorr AS lkorr,
  t030hb.lsrea AS lsrea,
  t030hb.lhrea AS lhrea,
  t030hb.lstra AS lstra,
  t030hb.lhtra AS lhtra,
  t030hb.lsbew AS lsbew,
  t030hb.lhbew AS lhbew,
  t030hb.lstrv AS lstrv,
  t030hb.lhtrv AS lhtrv,
  coa_text[1:spras = $session.system_language].ktplt AS ktopl_text,
  va_text[1:spras = $session.system_language].ltext AS bwber_text,
  gla_text[1:spras = $session.system_language].txt20 AS hkont_text,
  cur_text[1:spras = $session.system_language].ktext AS waers_text,
  skat_text1[1:spras = $session.system_language].txt20 AS lkorr_text,
  skat_text2[1:spras = $session.system_language].txt20 AS lsrea_text,
  skat_text3[1:spras = $session.system_language].txt20 AS lhrea_text,
  skat_text4[1:spras = $session.system_language].txt20 AS lstra_text,
  skat_text5[1:spras = $session.system_language].txt20 AS lhtra_text,
  skat_text6[1:spras = $session.system_language].txt20 AS lsbew_text,
  skat_text7[1:spras = $session.system_language].txt20 AS lhbew_text,
  skat_text8[1:spras = $session.system_language].txt20 AS lstrv_text,
  skat_text9[1:spras = $session.system_language].txt20 AS lhtrv_text
FROM t030hb
LEFT OUTER JOIN t004t AS coa_text ON ktopl = coa_text.ktopl  -- association [0..1]
LEFT OUTER JOIN t033t AS va_text ON bwber = va_text.bwber  -- association [0..1]
LEFT OUTER JOIN skat AS gla_text ON ktopl = gla_text.ktopl AND hkont = gla_text.saknr  -- association [0..1]
LEFT OUTER JOIN tcurt AS cur_text ON waers = cur_text.waers  -- association [0..1]
LEFT OUTER JOIN skat AS skat_text1 ON ktopl = skat_text1.ktopl AND lkorr = skat_text1.saknr  -- association [0..1]
LEFT OUTER JOIN skat AS skat_text2 ON ktopl = skat_text2.ktopl AND lsrea = skat_text2.saknr  -- association [0..1]
LEFT OUTER JOIN skat AS skat_text3 ON ktopl = skat_text3.ktopl AND lhrea = skat_text3.saknr  -- association [0..1]
LEFT OUTER JOIN skat AS skat_text4 ON ktopl = skat_text4.ktopl AND lstra = skat_text4.saknr  -- association [0..1]
LEFT OUTER JOIN skat AS skat_text5 ON ktopl = skat_text5.ktopl AND lhtra = skat_text5.saknr  -- association [0..1]
LEFT OUTER JOIN skat AS skat_text6 ON ktopl = skat_text6.ktopl AND lsbew = skat_text6.saknr  -- association [0..1]
LEFT OUTER JOIN skat AS skat_text7 ON ktopl = skat_text7.ktopl AND lhbew = skat_text7.saknr  -- association [0..1]
LEFT OUTER JOIN skat AS skat_text8 ON ktopl = skat_text8.ktopl AND lstrv = skat_text8.saknr  -- association [0..1]
LEFT OUTER JOIN skat AS skat_text9 ON ktopl = skat_text9.ktopl AND lhtrv = skat_text9.saknr  -- association [0..1]
;