I_BankAccountSignatoryPattern

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_BankAccountSignatoryPattern.
-- 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: IBKACCSIGPTN

CREATE VIEW I_BankAccountSignatoryPattern AS
SELECT
  cast( BankAccountInternalID as fclm_bam_acc_num ) AS BankAccountNumber,
  IBAN,
  BankCountry,
  Bank AS BankNumber,
  cast( '1234567890' as fclm_bam_acc_id ) AS BankAccountInternalID,
  cast( 'EUR' as waers_curc ) AS BankAccountCurrency,
  cast( '0001' as bukrs ) AS CompanyCode,
  cast( '' as prctr ) AS ProfitCenter,
  cast( '' as fb_segment) AS Segment,
  cast( '' as gsber ) AS BusinessArea,
  cast( '01' as fclm_bam_bk_acc_type_id ) AS BankAccountType,
  cast( '' as kokrs ) AS ControllingArea,
  cast( '' as butxt ) AS CompanyCodeName,
  cast( '' as fclm_bam_beneficiary_name ) AS BankAccountHolderName,
  cast( '' as swift ) AS BICNumber,
  cast( '' as banka ) AS BankName,
  cast( '01' as text40 ) AS ApprovalType,
  cast( '01' as fclm_bam_sign_pattern) AS SignatoryPattern,
  cast( '01' as bca_dte_rel_proc) AS ReleaseProcedure
FROM I_BankAccount
;