VFCLM_BAM_DDL_ACCOUNTINAPPROC

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_ACCOUNTINAPPROC.
-- 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: VFCLMACTAPVW

CREATE VIEW VFCLM_BAM_DDL_ACCOUNTINAPPROC AS
SELECT
  reqheader.request_id AS request_id,
  reqaccount.acc_id AS acc_id,
  reqaccount.revision AS revision,
  reqheader.title AS title,
  reqheader.duedate AS duedate,
  reqheader.created_by AS created_by,
  reqheader.lastchged_by AS lastchged_by,
  reqheader.created_on AS created_on,
  reqheader.created_tm AS created_tm,
  cast( DATS_TIMS_TO_TSTMP( reqheader.created_on, reqheader.created_tm, abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL') as timestamp ) as created_at AS clientNULLastimestampascreated_at,
  reqheader.lastchged_on AS lastchged_on,
  reqheader.lastchged_tm AS lastchged_tm,
  cast( DATS_TIMS_TO_TSTMP( reqheader.lastchged_on, reqheader.lastchged_tm, abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL') as timestamp ) as lastchged_at AS clientNULLastimestampaslastchged_at,
  reqheader.request_step AS request_step,
  account.acc_num AS acc_num,
  account.acc_type_id AS acc_type_id,
  account.bukrs AS bukrs,
  account.bankl AS bankl,
  account.banks AS banks,
  account.iban AS iban,
  account.beneficial AS beneficial,
  account.bank_contact AS bank_contact,
  account.gsber AS gsber,
  account.prctr AS prctr,
  account.rel_manager AS rel_manager,
  account.status AS status,
  account.valid_from AS valid_from,
  account.valid_to AS valid_to,
  reviewlog.reviewed_by AS reviewed_by,
  reviewlog.reviewed_on AS reviewed_on,
  '' AS AccountNotReviewed
FROM fclm_bam_reqacnt AS reqaccount
INNER JOIN fclm_bam_req AS reqheader ON /* join condition not captured in parsed metadata */
INNER JOIN FCLM_BAM_DDL_AMD_BASE_NO_HBA AS account ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fclm_bam_revwlog AS reviewlog ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): fclm_bam_reqacnt
;