VFCLM_BAM_DDL_AMD_REV

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_AMD_REV.
-- 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_AMDREV

CREATE VIEW VFCLM_BAM_DDL_AMD_REV AS
SELECT
  FCLM_BAM_DDL_AMD_BASE.acc_id AS acc_id,
  FCLM_BAM_DDL_AMD_BASE.revision AS revision,
  FCLM_BAM_DDL_AMD_BASE.CompanyCodeDesp AS CompanyCodeDesp,
  FCLM_BAM_DDL_AMD_BASE.Currency AS Currency,
  FCLM_BAM_DDL_AMD_BASE.HouseBankCompanyCode AS HouseBankCompanyCode,
  FCLM_BAM_DDL_AMD_BASE.HouseBankCompanyCodeDesp AS HouseBankCompanyCodeDesp,
  FCLM_BAM_DDL_AMD_BASE.abwae AS abwae,
  FCLM_BAM_DDL_AMD_BASE.acc_num AS acc_num,
  FCLM_BAM_DDL_AMD_BASE.acc_type_id AS acc_type_id,
  FCLM_BAM_DDL_AMD_BASE.bank_contact AS bank_contact,
  FCLM_BAM_DDL_AMD_BASE.bankl AS bankl,
  FCLM_BAM_DDL_AMD_BASE.bankn AS bankn,
  FCLM_BAM_DDL_AMD_BASE.banks AS banks,
  FCLM_BAM_DDL_AMD_BASE.beneficial AS beneficial,
  FCLM_BAM_DDL_AMD_BASE.bnkn2 AS bnkn2,
  FCLM_BAM_DDL_AMD_BASE.bukrs AS bukrs,
  FCLM_BAM_DDL_AMD_BASE.cash_pool AS cash_pool,
  FCLM_BAM_DDL_AMD_BASE.cash_pool_id AS cash_pool_id,
  FCLM_BAM_DDL_AMD_BASE.changed_at AS changed_at,
  FCLM_BAM_DDL_AMD_BASE.changed_by AS changed_by,
  FCLM_BAM_DDL_AMD_BASE.closed_at AS closed_at,
  FCLM_BAM_DDL_AMD_BASE.closed_by AS closed_by,
  FCLM_BAM_DDL_AMD_BASE.control_key AS control_key,
  FCLM_BAM_DDL_AMD_BASE.created_at AS created_at,
  FCLM_BAM_DDL_AMD_BASE.created_by AS created_by,
  FCLM_BAM_DDL_AMD_BASE.deleted_flag AS deleted_flag,
  FCLM_BAM_DDL_AMD_BASE.dtaai AS dtaai,
  FCLM_BAM_DDL_AMD_BASE.edbsum AS edbsum,
  FCLM_BAM_DDL_AMD_BASE.fdgrp AS fdgrp,
  FCLM_BAM_DDL_AMD_BASE.gsber AS gsber,
  FCLM_BAM_DDL_AMD_BASE.hbid1 AS hbid1,
  FCLM_BAM_DDL_AMD_BASE.hbid2 AS hbid2,
  FCLM_BAM_DDL_AMD_BASE.hbkid AS hbkid,
  FCLM_BAM_DDL_AMD_BASE.hkid1 AS hkid1,
  FCLM_BAM_DDL_AMD_BASE.hkid2 AS hkid2,
  FCLM_BAM_DDL_AMD_BASE.hkont AS hkont,
  FCLM_BAM_DDL_AMD_BASE.hktid AS hktid,
  FCLM_BAM_DDL_AMD_BASE.iban AS iban,
  FCLM_BAM_DDL_AMD_BASE.idbsum AS idbsum,
  FCLM_BAM_DDL_AMD_BASE.mandt AS mandt,
  FCLM_BAM_DDL_AMD_BASE.mindt AS mindt,
  FCLM_BAM_DDL_AMD_BASE.opened_at AS opened_at,
  FCLM_BAM_DDL_AMD_BASE.opened_by AS opened_by,
  FCLM_BAM_DDL_AMD_BASE.prctr AS prctr,
  FCLM_BAM_DDL_AMD_BASE.refzl AS refzl,
  FCLM_BAM_DDL_AMD_BASE.rel_manager AS rel_manager,
  FCLM_BAM_DDL_AMD_BASE.reviewed_at AS reviewed_at,
  FCLM_BAM_DDL_AMD_BASE.reviewed_by AS reviewed_by,
  FCLM_BAM_DDL_AMD_BASE.segment AS segment,
  FCLM_BAM_DDL_AMD_BASE.status AS status,
  FCLM_BAM_DDL_AMD_BASE.valid_from AS valid_from,
  FCLM_BAM_DDL_AMD_BASE.valid_to AS valid_to,
  FCLM_BAM_DDL_AMD_BASE.wekon AS wekon,
  FCLM_BAM_DDL_AMD_BASE.wikon AS wikon,
  FCLM_BAM_DDL_AMD_BASE.wkkon AS wkkon,
  FCLM_BAM_DDL_AMD_BASE.account_lims AS account_lims,
  FCLM_BAM_DDL_AMD_BASE.account_sigs AS account_sigs
FROM FCLM_BAM_DDL_AMD_BASE
;