VFCLM_BAM_DDL_REVIEWSTATUST

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_REVIEWSTATUST.
-- 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: VFCLMRVLOGTVW
-- Parameters: plang : abap.lang

CREATE VIEW VFCLM_BAM_DDL_REVIEWSTATUST AS
SELECT
  header.request_id AS request_id,
  header.acc_id AS acc_id,
  header.title AS title,
  header.duedate AS duedate,
  header.created_by AS created_by,
  header.lastchged_by AS lastchged_by,
  header.created_on AS created_on,
  header.lastchged_on AS lastchged_on,
  header.request_step AS request_step,
  header.acc_num AS acc_num,
  header.acc_type_id AS acc_type_id,
  header.bukrs AS bukrs,
  header.bankl AS bankl,
  header.banks AS banks,
  header.IBAN AS IBAN,
  header.beneficial AS beneficial,
  header.bank_contact AS bank_contact,
  header.gsber AS gsber,
  header.prctr AS prctr,
  header.rel_manager AS rel_manager,
  header.Status AS Status,
  header.valid_from AS valid_from,
  header.valid_to AS valid_to,
  header.Segment AS Segment,
  header.BankNumber AS BankNumber,
  header.EoDImort AS EoDImort,
  header.IntradayImport AS IntradayImport,
  header.BankStatementUpload AS BankStatementUpload,
  header.CreatedAtDate AS CreatedAtDate,
  header.CreatedAtTime AS CreatedAtTime,
  header.CreatedBy AS CreatedBy,
  header.OpenedAtDate AS OpenedAtDate,
  header.OpenedAtTime AS OpenedAtTime,
  header.OpenedBy AS OpenedBy,
  header.ChangedAtDate AS ChangedAtDate,
  header.ChangedAtTime AS ChangedAtTime,
  header.ChangedBy AS ChangedBy,
  header.ClosedAtDate AS ClosedAtDate,
  header.ClosedAtTime AS ClosedAtTime,
  header.ClosedBy AS ClosedBy,
  header.CutOffDomestic AS CutOffDomestic,
  header.CutOffCrossBorder AS CutOffCrossBorder,
  header.PlannedClosingDate AS PlannedClosingDate,
  header.UploadBSFlag AS UploadBSFlag,
  header.Currency AS Currency,
  header.banka AS banka,
  header.swift AS swift,
  header.reviewed_by AS reviewed_by,
  header.reviewed_on AS reviewed_on,
  header.AccountInReview AS AccountInReview,
  header.abwae AS abwae,
  header.bankn AS bankn,
  header.bnkn2 AS bnkn2,
  header.dtaai AS dtaai,
  header.fdgrp AS fdgrp,
  header.hbid1 AS hbid1,
  header.hbid2 AS hbid2,
  header.hkid1 AS hkid1,
  header.hkid2 AS hkid2,
  header.mindt AS mindt,
  header.refzl AS refzl,
  header.wekon AS wekon,
  header.wikon AS wikon,
  header.wkkon AS wkkon,
  header.hbkid AS hbkid,
  header.hktid AS hktid,
  header.InApprovalProcess AS InApprovalProcess,
  header.CompanyCodeDesp AS CompanyCodeDesp,
  header.StatusDesp AS StatusDesp,
  header.Description AS Description,
  header.AccountTypeDesp AS AccountTypeDesp,
  header.CurrencyDesp AS CurrencyDesp,
  header.BusinessAreaDesp AS BusinessAreaDesp,
  header.SegmentDesp AS SegmentDesp,
  header.EoDImportDesp AS EoDImportDesp,
  header.BankCountryDesp AS BankCountryDesp,
  header.AccountNumberDesp AS AccountNumberDesp
FROM VFCLM_BAM_DDL_REVIEWSTATUS AS header
LEFT OUTER JOIN VFCLM_BAM_DDL_REQACTION AS statustxt ON /* join condition not captured in parsed metadata */
;