I_BankAccountWithRevision

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_BankAccountWithRevision.
-- 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: IBANKACCTWR

CREATE VIEW I_BankAccountWithRevision AS
SELECT
  amd.acc_id AS BankAccountInternalID,
  amd.revision AS BankAccountRevision,
  amd.banks AS BankCountry,
  amd.bankl AS Bank,
  amd.acc_num AS BankAccountNumber,
  amd.acc_type_id AS BankAccountType,
  amd.valid_from AS ValidityStartDate,
  amd.valid_to AS ValidityEndDate,
  amd.iban AS IBAN,
  amd.status AS BankAccountStatus,
  amd.cash_pool_id AS LeadingCashPoolID,
  amd.bukrs AS CompanyCode,
  amd.prctr AS ProfitCenter,
  amd.gsber AS BusinessArea,
  amd.segment AS Segment,
  amd.beneficial AS BankAccountHolderName,
  amd.bank_contact AS BankContactPerson,
  amd.rel_manager AS BankRelationshipManager,
  amd.company_contact AS CompanyContactPerson,
  amd.account_supervisor AS BankAccountSupervisor,
  amd.edbsum AS BankStatementImportMethod,
  amd.idbsum AS IntraDayBankStateImportMethod,
  amd.bs_upload_time AS BankStatementCheckTime,
  amd.created_by AS CreatedByUser,
  amd.opened_by AS OpenedByUser,
  amd.changed_by AS LastChangedByUser,
  amd.reviewed_by AS ReviewedByUser,
  amd.closed_by AS ClosedByUser,
  amd.importing_channel AS BankStatementImportChannel,
  amd.cutoff_time_d AS DomesticCutOffTime,
  amd.cutoff_time_c AS CrossBorderCutOffTime,
  amd.planned_closing_date AS PlannedClosingDate,
  amd.upload_bs_flag AS IsUploadOfIntraDayStatement,
  amd.created_at_dat AS CreationDate,
  amd.created_at_tim AS CreationTime,
  amd.opened_at_dat AS OpenedDate,
  amd.changed_at_dat AS LastChangeDate,
  amd.changed_at_tim AS LastChangeTime,
  amd.closed_at_dat AS ClosedDate,
  amd.closed_at_tim AS ClosedTime,
  amd.control_key AS BankControlKey,
  amd.iban_valid_from AS IBANValidityStartDate,
  amd.objnr AS ArchObjectNumber,
  amd.vgtyp AS PaymentTransactionTypeGroup,
  amd.procstat_act AS ProcessingStatus,
  amd.balstat_act AS DifferenceStatus,
  amd.serstat_act AS SerialNumberStatus,
  amd.reconstat_act AS ReconciliationStatus,
  amd.exp_number AS ExpectedInterval,
  amd.exp_rhyth AS ControlFrequency,
  amd.calendar AS FactoryCalendar,
  amd.sort_idx AS DisplayItem,
  amd.amt_diff AS DifferenceAmount,
  amd.waers AS BankAccountCurrency,
  amd.cash_pool_id_participant AS ParticipantCashPoolID,
  amd.cash_pool_target_amt_max AS MaxTargetAmount,
  amd.cash_pool_target_amt_min AS MinTargetAmount,
  amd.cash_pool_transfer_amt_min AS MinTransferAmount,
  amd.payment_method_l AS LeadingPaymentMethod,
  amd.payment_method_p AS ParticipantPaymentMethod,
  amd.payment_service_provider AS PaymentServiceProvider,
  _Rev.activated_by AS BankAccountRevActivatedByUser
FROM I_ValidBankAccountWithRevision AS validAmd
LEFT OUTER JOIN fclm_bam_amd AS amd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fclm_bam_rev AS _Rev ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BankAccountTextRev AS _AccountTextInCurrentLang ON BankAccountInternalID = _AccountTextInCurrentLang.BankAccountInternalID AND BankAccountRevision = _AccountTextInCurrentLang.BankAccountRevision  -- association [0..*]
LEFT OUTER JOIN I_Bank_2 AS _Bank ON BankCountry = _Bank.BankCountry AND Bank = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BankContact ON BankContactPerson = _BankContact.BusinessPartner  -- association [0..1]
;