FCLM_BAM_DDL_AMD_DB

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_DB.
-- 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_AMDDB

CREATE VIEW FCLM_BAM_DDL_AMD_DB 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.vgtyp AS vgtyp,
  header.procstat_act AS procstat_act,
  header.balstat_act AS balstat_act,
  header.serstat_act AS serstat_act,
  header.exp_number AS exp_number,
  header.exp_rhyth AS exp_rhyth,
  header.calendar AS calendar,
  header.sort_idx AS sort_idx,
  header.amt_diff AS amt_diff,
  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.objnr AS objnr,
  header.waers AS waers
FROM fclm_bam_amd AS header
;