VFCLM_BAM_DDL_AMD

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.
-- 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_AMD_VW

CREATE VIEW VFCLM_BAM_DDL_AMD AS
SELECT
  header.acc_id AS AccountID,
  header.banks AS BankCountry,
  header.bankl AS BankKey,
  header.acc_num AS AccountNumber,
  header.acc_type_id AS AccountType,
  header.valid_from AS ValidFrom,
  header.valid_to AS ValidTo,
  header.iban AS IBAN,
  header.status AS Status,
  header.bukrs AS CompanyCode,
  header.prctr AS ProfitCenter,
  header.gsber AS BusinessArea,
  header.segment AS Segment,
  header.beneficial AS AccountHolder,
  header.bank_contact AS BankContact,
  header.rel_manager AS RelationshipManager,
  header.company_contact AS CompanyContact,
  header.account_supervisor AS AccountSupervisor,
  header.edbsum AS EoDImort,
  header.idbsum AS IntradayImport,
  header.bs_upload_time AS BankStatementUpload,
  header.created_at_dat AS CreatedAtDate,
  header.created_at_tim AS CreatedAtTime,
  header.created_by AS CreatedBy,
  header.opened_at_dat AS OpenedAtDate,
  header.opened_at_tim AS OpenedAtTime,
  header.opened_by AS OpenedBy,
  header.changed_at_dat AS ChangedAtDate,
  header.changed_at_tim AS ChangedAtTime,
  header.changed_by AS ChangedBy,
  header.closed_at_dat AS ClosedAtDate,
  header.closed_at_tim AS ClosedAtTime,
  header.closed_by AS ClosedBy,
  header.deleted_flag AS deleted_flag,
  header.importing_channel AS ImportingChannel,
  header.cutoff_time_d AS CutOffDomestic,
  header.cutoff_time_c AS CutOffCrossBorder,
  header.planned_closing_date AS PlannedClosingDate,
  header.upload_bs_flag AS UploadBSFlag,
  header.vgtyp AS TransactionCode,
  header.procstat_act AS ProcessingStatus,
  header.balstat_act AS DifferenceStatus,
  header.serstat_act AS SerialNumberStatus,
  header.reconstat_act AS ReconciliationStatus,
  header.exp_number AS ExpectedInterval,
  header.exp_rhyth AS ControlFrequency,
  header.calendar AS FactoryCalendar,
  header.sort_idx AS DisplayItem,
  header.amt_diff AS DifferenceAmount,
  header.control_key AS control_key,
  header.edbsum AS edbsum,
  header.Currency AS Currency,
  header.CompanyCodeDesp AS CompanyCodeDesp,
  header.HouseBankCompanyCode AS HouseBankCompanyCode,
  header.HouseBankCompanyCodeDesp AS HouseBankCompanyCodeDesp,
  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.cash_pool_id AS LeadingCashPoolID,
  header.cash_pool_id_participant AS ParticipantCashPoolID,
  header.account_sigs AS Signatories,
  header.account_lims AS OverdraftLimits,
  header.account_cdhdr AS ChangeHistory,
  header.tolerance_group AS CashToleranceGroup,
  header.reconcile_intraday AS IntradayIsReconciled
FROM FCLM_BAM_DDL_AMD_REV0 AS header
;