VFCLM_BAM_DDL_ACCLINK

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 VFCLM_BAM_DDL_ACCLINK.
-- 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: VFCLMBAMACLVW

CREATE VIEW VFCLM_BAM_DDL_ACCLINK AS
SELECT
  header.acc_id AS acc_id,
  header.acc_num AS acc_num,
  header.acc_type_id AS acc_type_id,
  header.valid_from AS valid_from,
  header.valid_to AS valid_to,
  header.bukrs AS bukrs,
  header.bankl AS bankl,
  header.banks AS banks,
  header.iban AS iban,
  header.prctr AS prctr,
  header.gsber AS gsber,
  header.segment AS segment,
  header.beneficial AS beneficial,
  header.bank_contact AS bank_contact,
  header.deleted_flag AS deleted_flag,
  header.status AS status,
  'X' AS CentralBAMAccount,
  linkage.valid_from AS Linkage_valid_from,
  linkage.valid_to AS Linkage_valid_to,
  linkage.herku AS Linkage_herku,
  linkage.bukrs AS Linkage_bukrs,
  linkage.hbkid AS Linkage_hbkid,
  linkage.hktid AS Linkage_hktid,
  linkage.remoteaccount AS Linkage_remoteaccount,
  linkage.is_reused AS Linkage_is_reused,
  header.Currency AS Currency
FROM FCLM_BAM_DDL_AMD_BASE_NO_HBA AS header
LEFT OUTER JOIN fclm_bam_aclink2 AS linkage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fclm_bam_ac_type AS FCLM_BAM_AC_TYPE ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): FCLM_BAM_DDL_AMD_BASE_NO_HBA
;