fac_ad_cds_t001u

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_t001u.
-- 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_T001U

CREATE VIEW fac_ad_cds_t001u AS
SELECT
  vbukr,
  abukr,
  komok,
  post_cocd.butxt AS vbukr_text,
  clear_cocd.butxt AS abukr_text,
  konts,
  debit_acc_text[1:spras = $session.system_language].txt20 AS konts_text,
  konth,
  credit_acc_text[1:spras = $session.system_language].txt20 AS konth_text,
  bschs,
  debit_pk_text[1:spras = $session.system_language and umskz = umskz].ltext AS bschs_text,
  bschh,
  credit_pk_text[1:spras = $session.system_language and umskz = umskz].ltext AS bschh_text,
  umskz,
  active,
  debit_pk.koart AS koart_debit,
  credit_pk.koart AS koart_credit
FROM t001u
INNER JOIN t001 AS post_cocd ON /* join condition not captured in parsed metadata */
INNER JOIN t001 AS clear_cocd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN skat AS debit_acc_text ON konts = debit_acc_text.saknr AND post_cocd.ktopl = debit_acc_text.ktopl  -- association [0..*]
LEFT OUTER JOIN skat AS credit_acc_text ON konth = credit_acc_text.saknr AND post_cocd.ktopl = credit_acc_text.ktopl  -- association [0..*]
LEFT OUTER JOIN tbslt AS debit_pk_text ON bschs = debit_pk_text.bschl  -- association [0..*]
LEFT OUTER JOIN tbslt AS credit_pk_text ON bschh = credit_pk_text.bschl  -- association [0..*]
LEFT OUTER JOIN tbsl AS debit_pk ON bschs = debit_pk.bschl  -- association [0..1]
LEFT OUTER JOIN tbsl AS credit_pk ON bschh = credit_pk.bschl  -- association [0..1]
;