R_BankAccount

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 R_BankAccount.
-- 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 R_BankAccount AS
SELECT
  acc_id AS BankAccountInternalID,
  revision AS BankAccountRevision,
  banks AS BankCountry,
  bankl AS BankInternalID,
  acc_num AS BankAccountNumber,
  acc_type_id AS BankAccountInternalType,
  _ContractType.BankAccountContractType AS BankAccountContractType,
  valid_from AS ValidityStartDate,
  valid_to AS ValidityEndDate,
  IBAN,
  status AS BankAccountStatus,
  bukrs AS CompanyCode,
  prctr AS ProfitCenter,
  gsber AS BusinessArea,
  Segment,
  beneficial AS BankAccountHolderName,
  bank_contact AS BankContactPerson,
  rel_manager AS BankRelationshipManager,
  company_contact AS CompanyContactPerson,
  account_supervisor AS BankAccountSupervisor,
  created_by AS CreatedByUser,
  opened_by AS OpenedByUser,
  changed_by AS LastChangedByUser,
  reviewed_by AS ReviewedByUser,
  closed_by AS ClosedByUser,
  deleted_flag AS IsMarkedForDeletion,
  cutoff_time_d AS DomesticCutOffTime,
  cutoff_time_c AS CrossBorderCutOffTime,
  planned_closing_date AS PlannedClosingDate,
  created_at_dat AS CreationDate,
  created_at_tim AS CreationTime,
  opened_at_dat AS OpenedDate,
  opened_at_tim AS OpenedTime,
  changed_at_dat AS LastChangeDate,
  changed_at_tim AS LastChangeTime,
  closed_at_dat AS ClosedDate,
  closed_at_tim AS ClosedTime,
  control_key AS BankControlKey,
  iban_valid_from AS IBANValidityStartDate,
  vgtyp AS PaymentTransactionTypeGroup,
  waers AS BankAccountCurrency,
  cash_pool_id AS LeadingCashPoolID,
  cash_pool_id_participant AS ParticipantCashPoolID,
  cash_pool_target_amt_max AS MaxTargetAmount,
  cash_pool_transfer_amt_min AS MinTransferAmount,
  payment_method_l AS LeadingPaymentMethod,
  payment_method_p AS ParticipantPaymentMethod,
  payment_service_provider AS PaymentServiceProvider,
  tolerance_group AS CashToleranceGroup,
  reconcile_intraday AS IntradayIsReconciled,
  objnr AS TreasuryFinancialObject,
  bs_upload_time AS BankStatementCheckTime,
  edbsum AS BankStatementImportMethod,
  idbsum AS IntraDayBankStateImportMethod,
  importing_channel AS BankStatementImportChannel,
  upload_bs_flag AS IsUploadOfIntraDayStatement,
  reconcile_bs_endofday AS BkStmntEndOfDayIsReconciled,
  ihb_servicer AS IHBAccountHolder,
  acct_charc_id AS BankAccountCharacteristic
FROM fclm_bam_amd
LEFT OUTER JOIN I_BankAccountInternalType AS _ContractType ON BankAccountInternalType = _ContractType.BankAccountInternalType  -- association [0..1]
LEFT OUTER JOIN I_Bank_2 AS _Bank ON BankCountry = _Bank.BankCountry AND BankInternalID = _Bank.BankInternalID  -- association [1..1]
;