VFCLM_BAM_DDL_ACCOUNTINAPPROC2

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_ACCOUNTINAPPROC2.
-- 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: VFCLMACTAP2VW
-- Parameters: pLang : abap.lang

CREATE VIEW VFCLM_BAM_DDL_ACCOUNTINAPPROC2 AS
SELECT
  request_id,
  acc_id,
  revision,
  title,
  duedate,
  created_by,
  lastchged_by,
  created_on,
  lastchged_on,
  request_step,
  acc_num,
  acc_type_id,
  header.bukrs AS bukrs,
  t001.butxt AS butxt,
  bankl,
  banks,
  t005t.landx AS landx,
  t005t.landx50 AS landx50,
  iban,
  beneficial,
  bank_contact,
  gsber,
  prctr,
  rel_manager,
  status,
  acntstatus.ddtext AS status_text,
  valid_from,
  valid_to,
  reviewed_by,
  reviewed_on,
  AccountNotReviewed
FROM VFCLM_BAM_DDL_ACCOUNTINAPPROC AS header
LEFT OUTER JOIN t005t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_USERFULLNAME AS username ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_USERFULLNAME AS username2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_USERFULLNAME AS username3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_USERFULLNAME AS username4 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_ACCOUNTSTATUS AS acntstatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_BPUSERFULLNAME AS bpuser ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_BPUSERFULLNAME AS bpuser2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_REQSTATUS AS reqstatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_ACCOUNTACTION AS accaction ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_ACCNUMTXT AS accnumtxt ON /* join condition not captured in parsed metadata */
;