C_HouseBankAccount

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 C_HouseBankAccount.
-- 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: CHBACCT

CREATE VIEW C_HouseBankAccount AS
SELECT
  HouseBankAcct.CompanyCode AS CompanyCode,
  HouseBankAcct.HouseBank AS HouseBank,
  HouseBankAcct.HouseBankAccount AS HouseBankAccount,
  cast ( _Text.HouseBankAccountDescription as fclm_bam_description ) AS HouseBankAccountDescription,
  HouseBankAcct.BankAccountInternalID AS BankAccountInternalID,
  _BankAccount._BankAccountCurrency.BankAccountCurrency AS BankAccountCurrency,
  HouseBankAcct.BankAccount AS BankAccount,
  HouseBankAcct.BankAccountAlternative AS BankAccountAlternative,
  HouseBankAcct._HouseBankAccount.GLAccount AS GLAccount,
  cast('' as fis_glaccthier) AS GLAccountHierarchy,
  cast('' as fis_glacct_hrynid_50) AS GLAccountHierarchyNode,
  HouseBankAcct._CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  HouseBankAcct._CompanyCode.CompanyCodeName AS CompanyCodeName,
  HouseBankAcct._HouseBank.BankCountry AS BankCountry,
  _BankAccount._BankCountry._Text[Language = $session.system_language].CountryName AS CountryName,
  HouseBankAcct._HouseBank.BankInternalID AS Bank,
  HouseBankAcct._HouseBank._Bank.BankName AS BankName,
  _BankAccount.IBAN AS IBAN,
  _BankAccount.PaymentTransactionTypeGroup AS PaymentTransactionTypeGroup,
  HouseBankAcct.DataMedExchangeIdentification AS DataMedExchangeIdentification,
  HouseBankAcct.ReferenceInfo AS ReferenceInfo
FROM I_Bankaccountlinkage AS HouseBankAcct
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _Text ON CompanyCode = _Text.CompanyCode AND HouseBank = _Text.HouseBank AND HouseBankAccount = _Text.HouseBankAccount AND _Text.Language = $session.system_language association[0..*] to C_HierRuntimeRprstnDplLeafNode as _GLAccountHierLeafNode on glaccount = _GLAccountHierLeafNode.UnivHierarchyBusinessEntity AND chartofaccounts = _GLAccountHierLeafNode.HierarchyNodeClass AND _GLAccountHierLeafNode.ValidityStartDate <= $session.system_date AND _GLAccountHierLeafNode.ValidityEndDate >= $session.system_date AND _GLAccountHierLeafNode.HierarchyType = 'FSVN'  -- association [0..1]
;