VFCLM_BAM_DDL_AMD_HBA_WITHDESP

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_AMD_HBA_WITHDESP.
-- 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: VFCLM_BAM_AMDHBA

CREATE VIEW VFCLM_BAM_DDL_AMD_HBA_WITHDESP AS
SELECT
  header.AccountID AS AccountID,
  header.Language AS Language,
  header.BankCountry AS BankCountry,
  header.BankKey AS BankKey,
  header.Banka AS Banka,
  header.Swift AS Swift,
  header.BankNumber AS BankNumber,
  header.AccountNumber AS AccountNumber,
  header.AccountType AS AccountType,
  header.ValidFrom AS ValidFrom,
  header.ValidTo AS ValidTo,
  header.IBAN AS IBAN,
  header.Description AS Description,
  header.Status AS Status,
  header.HouseBankCompanyCode AS CompanyCode,
  header.ProfitCenter AS ProfitCenter,
  header.BusinessArea AS BusinessArea,
  header.Segment AS Segment,
  header.AccountHolder AS AccountHolder,
  header.BankContact AS BankContact,
  header.RelationshipManager AS RelationshipManager,
  header.CompanyContact AS CompanyContact,
  header.AccountSupervisor AS AccountSupervisor,
  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.ImportingChannel AS ImportingChannel,
  header.CutOffDomestic AS CutOffDomestic,
  header.CutOffCrossBorder AS CutOffCrossBorder,
  header.PlannedClosingDate AS PlannedClosingDate,
  header.UploadBSFlag AS UploadBSFlag,
  header.Currency AS Currency,
  header.HouseBankCompanyCodeDesp AS CompanyCodeDesp,
  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.hbkid AS hbkid,
  header.hkid1 AS hkid1,
  header.hkid2 AS hkid2,
  header.hkont AS hkont,
  header.hktid AS hktid,
  header.mindt AS mindt,
  header.refzl AS refzl,
  header.wekon AS wekon,
  header.wikon AS wikon,
  header.wkkon AS wkkon,
  header.InApprovalProcess AS InApprovalProcess,
  header.AccountTypeDesp AS AccountTypeDesp,
  header.StatusDesp AS StatusDesp,
  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_AMD_WTTHDESP2 AS header
;