I_BankAcctIdVH

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 I_BankAcctIdVH.
-- 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: IBKACCIDVH

CREATE VIEW I_BankAcctIdVH AS
SELECT
  amd.acc_id AS BankAccountInternalID,
  amd.acc_num AS BankAccountNumber,
  _Text.BankAccountDescription AS BankAccountDescription,
  amd.waers AS BankAccountCurrency,
  amd.acc_type_id AS BankAccountType,
  _ContractType.BankAccountContractType AS BankAccountContractType,
  amd.bankl AS Bank,
  amd.banks AS BankCountry,
  amd.status AS BankAccountStatus,
  cast( bank.banka as fclm_cp_bank_name preserving type ) AS BankName,
  amd.iban AS IBAN,
  bank.swift AS SWIFTCode,
  linkage.HouseBank AS HouseBank,
  linkage.HouseBankAccount AS HouseBankAccount,
  amd.bukrs AS CompanyCode,
  amd.segment AS Segment,
  amd.prctr AS ProfitCenter,
  amd.cash_pool_id AS LeadingCashPoolID,
  amd.cash_pool_id_participant AS ParticipantCashPoolID,
  amd.cash_pool_target_amt_max AS MaxTargetAmount,
  amd.payment_method_l AS LeadingPaymentMethod,
  amd.payment_method_p AS ParticipantPaymentMethod,
  amd.tolerance_group AS CashToleranceGroup,
  amd.reconcile_intraday AS IntradayIsReconciled
FROM fclm_bam_amd AS amd
LEFT OUTER JOIN bnka AS bank ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FCLM_BAM_SINGLE_HBA AS linkage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Housebank AS _HouseBank ON HouseBank = _HouseBank.HouseBank AND CompanyCode = _HouseBank.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_BankAcctContrTypeVH AS _ContractType ON BankAccountType = _ContractType.BankAccountType  -- association [0..1]
LEFT OUTER JOIN I_BankAccountText AS _Text ON BankAccountInternalID = _Text.BankAccountInternalID AND _Text.Language = $session.system_language  -- association [0..1]
;