A_BankAccountSignatoryDetails

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 A_BankAccountSignatoryDetails.
-- 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: ABKACCSIGDTL

CREATE VIEW A_BankAccountSignatoryDetails AS
SELECT
  cast( '0987654321' as fclm_bam_acc_id ) AS BankAccountInternalID,
  cast( '01' as fclm_bam_sequence ) AS Sequence,
  cast( 'A' as fclm_bam_signatory ) AS Signatory,
  cast( 'G01' as fclm_bam_sign_group_id ) AS SignatoryGroup,
  cast( 'G1' as fclm_bam_sign_pattern) AS SignatoryPattern,
  cast( 'G01' as fclm_bam_description) AS SignatoryGroupName,
  cast( 'EUR' as waers ) AS Currency,
  cast( '99991231' as fclm_bam_sign_valid_from ) AS BankAcctSignatoryStartDate,
  cast( '99991231' as fclm_bam_sign_valid_to ) AS BankAcctSignatoryEndDate,
  cast( 0 as fclm_bam_single_pay_amount) AS MaximumPaymentAmount,
  cast( 0 as fclm_bam_batch_pay_amount) AS MaximumPaymentBatchAmount,
  cast( 'EUR' as waers ) AS MinimumPaymentCurrency,
  cast( 0 as fclm_bam_min_payamount ) AS MinimumPaymentAmt,
  cast( 0 as fclm_bam_min_batchamount) AS MinimumPaymentBatchAmount,
  cast( '' as contactcardemailaddress ) AS EmailAddress
;