VFCLM_BAM_DDL_ACCOUNTPREQUEST

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_ACCOUNTPREQUEST.
-- 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: VFCLMACTPRVW

CREATE VIEW VFCLM_BAM_DDL_ACCOUNTPREQUEST AS
SELECT
  fclm_bam_amd.acc_id AS acc_id,
  fclm_bam_amd.acc_num AS acc_num,
  fclm_bam_amd.acc_type_id AS acc_type_id,
  fclm_bam_amd.bukrs AS bukrs,
  fclm_bam_amd.bankl AS bankl,
  fclm_bam_amd.banks AS banks,
  fclm_bam_amd.status AS status,
  fclm_bam_amd.iban AS iban,
  fclm_bam_amd.beneficial AS beneficial,
  fclm_bam_amd.bank_contact AS bank_contact,
  fclm_bam_amd.gsber AS gsber,
  fclm_bam_amd.prctr AS prctr,
  fclm_bam_amd.rel_manager AS rel_manager,
  fclm_bam_amd.valid_from AS valid_from,
  fclm_bam_amd.valid_to AS valid_to,
  fclm_bam_amd.control_key AS control_key,
  fclm_bam_amd.edbsum AS edbsum,
  fclm_bam_amd.Currency AS waers,
  bnka.swift AS swift,
  bnka.banka AS banka,
  t001.butxt AS butxt,
  VFCLM_BAM_DDL_ACCOUNTINAPPROC.request_id AS request_id,
  VFCLM_BAM_DDL_ACCOUNTINAPPROC.title AS title,
  VFCLM_BAM_DDL_ACCOUNTINAPPROC.duedate AS duedate,
  VFCLM_BAM_DDL_ACCOUNTINAPPROC.created_by AS created_by,
  VFCLM_BAM_DDL_ACCOUNTINAPPROC.lastchged_by AS lastchged_by,
  VFCLM_BAM_DDL_ACCOUNTINAPPROC.created_on AS created_on,
  VFCLM_BAM_DDL_ACCOUNTINAPPROC.lastchged_on AS lastchged_on,
  VFCLM_BAM_DDL_ACCOUNTINAPPROC.AccountNotReviewed AS AccountNotReviewed
FROM FCLM_BAM_DDL_AMD_BASE_NO_HBA AS fclm_bam_amd
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN bnka ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_ACCOUNTINAPPROC ON /* join condition not captured in parsed metadata */
;