FCLM_BAM_DDL_AMD_BASE_NO_HBA

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_DDL_AMD_BASE_NO_HBA.
-- 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: VFCLM_BAM_AMD_N

CREATE VIEW FCLM_BAM_DDL_AMD_BASE_NO_HBA AS
SELECT
  header.acc_id AS acc_id,
  header.revision AS revision,
  header.acc_num AS acc_num,
  header.acc_type_id AS acc_type_id,
  header.bank_contact AS bank_contact,
  header.bankl AS bankl,
  header.banks AS banks,
  header.beneficial AS beneficial,
  header.bukrs AS bukrs,
  header.cash_pool AS cash_pool,
  header.cash_pool_id AS cash_pool_id,
  header.changed_at AS changed_at,
  header.changed_by AS changed_by,
  header.closed_at AS closed_at,
  header.closed_by AS closed_by,
  header.control_key AS control_key,
  header.created_at AS created_at,
  header.created_by AS created_by,
  header.deleted_flag AS deleted_flag,
  header.edbsum AS edbsum,
  header.gsber AS gsber,
  header.iban AS iban,
  header.idbsum AS idbsum,
  header.mandt AS mandt,
  header.opened_at AS opened_at,
  header.opened_by AS opened_by,
  header.prctr AS prctr,
  header.rel_manager AS rel_manager,
  header.reviewed_at AS reviewed_at,
  header.reviewed_by AS reviewed_by,
  header.segment AS segment,
  header.status AS status,
  header.valid_from AS valid_from,
  header.valid_to AS valid_to,
  header.waers AS Currency,
  t001.butxt AS CompanyCodeDesp,
  account_sigs,
  account_lims
FROM FCLM_BAM_DDL_AMD_DB AS header
LEFT OUTER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_AMD_SIG AS account_sigs ON acc_id = account_sigs.AccountID  -- association [1..*]
LEFT OUTER JOIN VFCLM_BAM_DDL_AMD_LIM AS account_lims ON acc_id = account_lims.AccountID  -- association [1..*]
LEFT OUTER JOIN VFCLM_BAM_DDL_CDHDR AS account_cdhdr ON acc_id = account_cdhdr.AccountID  -- association [0..*]
;