I_BankAcctNumberVH

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

CREATE VIEW I_BankAcctNumberVH AS
SELECT
  amd.acc_id AS BankAccountInternalID,
  amd.acc_num AS BankAccountNumber,
  desc.description AS BankAccountDescription,
  amd.waers AS BankAccountCurrency,
  amd.bukrs AS CompanyCode,
  amd.acc_type_id AS BankAccountType,
  amd.bankl AS Bank,
  amd.banks AS BankCountry,
  amd.iban AS IBAN,
  bank.swift AS SWIFTCode,
  linkage.HouseBank AS HouseBank,
  linkage.HouseBankAccount AS HouseBankAccount
FROM fclm_bam_amd AS amd
LEFT OUTER JOIN fclm_bam_amd_t AS desc ON /* join condition not captured in parsed metadata */
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_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
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]
;