I_BkRelshpDocBankAccount

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_BkRelshpDocBankAccount.
-- 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: IBKRELDOCBKACCT

CREATE VIEW I_BkRelshpDocBankAccount AS
SELECT
  BankAccountInternalID,
  BankCountry,
  Bank,
  BankAccountNumber,
  BankAccountType,
  _ContractType.BankAccountContractType AS BankAccountContractType,
  ValidityStartDate,
  ValidityEndDate,
  IBAN,
  BankAccountStatus,
  CompanyCode,
  ProfitCenter,
  BusinessArea,
  Segment,
  BankAccountHolderName,
  BankContactPerson,
  BankRelationshipManager,
  CompanyContactPerson,
  BankAccountSupervisor,
  CreatedByUser,
  OpenedByUser,
  LastChangedByUser,
  ReviewedByUser,
  ClosedByUser,
  IsMarkedForDeletion,
  DomesticCutOffTime,
  CrossBorderCutOffTime,
  PlannedClosingDate,
  CreationDate,
  CreationTime,
  OpenedDate,
  OpenedTime,
  LastChangeDate,
  LastChangeTime,
  ClosedDate,
  ClosedTime,
  BankControlKey,
  IBANValidityStartDate,
  PaymentTransactionTypeGroup,
  BankAccountCurrency,
  LeadingCashPoolID,
  ParticipantCashPoolID,
  MaxTargetAmount,
  MinTransferAmount,
  LeadingPaymentMethod,
  ParticipantPaymentMethod,
  PaymentServiceProvider,
  CashToleranceGroup,
  IntradayIsReconciled,
  TreasuryFinancialObject,
  BankStatementCheckTime,
  BankStatementImportMethod,
  IntraDayBankStateImportMethod,
  BankStatementImportChannel,
  IsUploadOfIntraDayStatement,
  EndOfDayIsReconciled,
  IHBAccountHolder,
  _BankGroup.BankGroup AS BankGroup,
  _BankGroup.BusinessPartnerName AS BusinessPartnerName,
  _CompanyCode.Country AS CompanyCodeCountry,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _BankAccountText.BankAccountDescription AS BankAccountDescription,
  _Bank.BankName AS BankName,
  _HouseBankAccount.HouseBank AS HouseBank,
  _HouseBankAccount.HouseBankAccount AS HouseBankAccount
FROM I_BkRelshpDocBkAcctBasic
LEFT OUTER JOIN I_BankAcctContrTypeVH AS _ContractType ON BankAccountType = _ContractType.BankAccountType  -- association [0..1]
LEFT OUTER JOIN I_BankAccountType AS _BankAccountType ON BankAccountType = _BankAccountType.BankAccountType  -- association [0..*]
LEFT OUTER JOIN I_Bank AS _Bank ON Bank = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_Country AS _BankCountry ON BankCountry = _BankCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_BankHierBankGroupMapping AS _BankGroup ON BankAccountInternalID = _BankGroup.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BankAccountText AS _BankAccountText ON BankAccountInternalID = _BankAccountText.BankAccountInternalID AND _BankAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SingleActiveHouseBankAccount AS _HouseBankAccount ON BankAccountInternalID = _HouseBankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountStatus AS _BankAccountStatus ON BankAccountStatus = _BankAccountStatus.BankAccountStatus AND _BankAccountStatus.Language = $session.system_language  -- association [0..1]
;