VFCLM_BAM_DDL_REVIEWSTATUS

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_REVIEWSTATUS.
-- 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: VFCLMRVLOGVW

CREATE VIEW VFCLM_BAM_DDL_REVIEWSTATUS AS
SELECT
  reqheader.request_id AS request_id,
  reqaccount.acc_id AS acc_id,
  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.lastchged_on AS lastchged_on,
  reqheader.request_step AS request_step,
  account.AccountNumber AS acc_num,
  account.AccountType AS acc_type_id,
  account.CompanyCode AS bukrs,
  account.BankKey AS bankl,
  account.BankCountry AS banks,
  account.IBAN AS IBAN,
  account.AccountHolder AS beneficial,
  account.BankContact AS bank_contact,
  account.BusinessArea AS gsber,
  account.ProfitCenter AS prctr,
  account.RelationshipManager AS rel_manager,
  account.Status AS Status,
  account.ValidFrom AS valid_from,
  account.ValidFrom AS valid_to,
  account.Segment AS Segment,
  account.Language AS Language,
  account.BankNumber AS BankNumber,
  account.Description AS Description,
  account.EoDImort AS EoDImort,
  account.IntradayImport AS IntradayImport,
  account.BankStatementUpload AS BankStatementUpload,
  account.CreatedAtDate AS CreatedAtDate,
  account.CreatedAtTime AS CreatedAtTime,
  account.CreatedBy AS CreatedBy,
  account.OpenedAtDate AS OpenedAtDate,
  account.OpenedAtTime AS OpenedAtTime,
  account.OpenedBy AS OpenedBy,
  account.ChangedAtDate AS ChangedAtDate,
  account.ChangedAtTime AS ChangedAtTime,
  account.ChangedBy AS ChangedBy,
  account.ClosedAtDate AS ClosedAtDate,
  account.ClosedAtTime AS ClosedAtTime,
  account.ClosedBy AS ClosedBy,
  account.CutOffDomestic AS CutOffDomestic,
  account.CutOffCrossBorder AS CutOffCrossBorder,
  account.PlannedClosingDate AS PlannedClosingDate,
  account.UploadBSFlag AS UploadBSFlag,
  account.Currency AS Currency,
  account.CompanyCodeDesp AS CompanyCodeDesp,
  account.abwae AS abwae,
  account.bankn AS bankn,
  account.bnkn2 AS bnkn2,
  account.dtaai AS dtaai,
  account.fdgrp AS fdgrp,
  account.hbid1 AS hbid1,
  account.hbid2 AS hbid2,
  account.hkid1 AS hkid1,
  account.hkid2 AS hkid2,
  account.mindt AS mindt,
  account.refzl AS refzl,
  account.wekon AS wekon,
  account.wikon AS wikon,
  account.wkkon AS wkkon,
  reviewlog.reviewed_by AS reviewed_by,
  reviewlog.reviewed_on AS reviewed_on,
  account.Banka AS banka,
  account.Swift AS swift,
  account.hbkid AS hbkid,
  account.hktid AS hktid,
  account.InApprovalProcess AS InApprovalProcess,
  account.AccountTypeDesp AS AccountTypeDesp,
  account.StatusDesp AS StatusDesp,
  account.CurrencyDesp AS CurrencyDesp,
  account.BusinessAreaDesp AS BusinessAreaDesp,
  account.SegmentDesp AS SegmentDesp,
  account.EoDImportDesp AS EoDImportDesp,
  account.BankCountryDesp AS BankCountryDesp,
  account.AccountNumberDesp AS AccountNumberDesp
FROM fclm_bam_reqacnt AS reqaccount
INNER JOIN fclm_bam_req AS reqheader ON /* join condition not captured in parsed metadata */
INNER JOIN VFCLM_BAM_DDL_AMD_WTTHDESP2 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 */
;