FCLM_BAM_T012K_E_BASE

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 FCLM_BAM_T012K_E_BASE.
-- 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: V_T012K_E_BASE

CREATE VIEW FCLM_BAM_T012K_E_BASE AS
SELECT
  hba.mandt AS mandt,
  distinct_hba.bukrs AS bukrs,
  distinct_hba.hbkid AS hbkid,
  distinct_hba.hktid AS hktid,
  hba.bankn AS bankn,
  acc.control_key AS bkont,
  acc.waers AS waers,
  hba.refzl AS refzl,
  hba.dtaai AS dtaai,
  hba.bnkn2 AS bnkn2,
  hba.fdgrp AS fdgrp,
  hba.abwae AS abwae,
  hba.hkont AS hkont,
  hba.wekon AS wekon,
  hba.mindt AS mindt,
  hba.hbid1 AS hbid1,
  hba.hkid1 AS hkid1,
  hba.hbid2 AS hbid2,
  hba.hkid2 AS hkid2,
  hba.wkkon AS wkkon,
  hba.wikon AS wikon,
  acc.status AS status,
  acctxt.langu AS spras,
  substring (acctxt.description, 1, 50) AS text1
FROM FCLM_BAM_DISTINCT_HBA_ENHANCED AS distinct_hba
INNER JOIN fclm_bam_aclink2 AS hba ON /* join condition not captured in parsed metadata */
INNER JOIN fclm_bam_amd AS acc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fclm_bam_amd_t AS acctxt ON /* join condition not captured in parsed metadata */
;