I_BankPaymentBatchRuleBaseCust

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_BankPaymentBatchRuleBaseCust.
-- 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: ITBNKCUSTDEFALT

CREATE VIEW I_BankPaymentBatchRuleBaseCust AS
SELECT
  mandt AS SAPClient,
  cast(tbnk_cust_defalt.rule_curr as farp_bnk_rule_currency ) AS PaymentBatchRuleCurrency,
  cast(tbnk_cust_defalt.rule_kurst as farp_bnk_rule_kurst ) AS RuleExchangeRateType,
  cast(tbnk_cust_defalt.resub_ctr as farp_bnk_rule_resub_ctr) AS ResubmissionDays,
  cast(tbnk_cust_defalt.xlog_sign as farp_bnk_rule_xlog_sign) AS SignatureIsRequired
FROM tbnk_cust_defalt
LEFT OUTER JOIN I_Currency AS _PaymentBatchRuleCurrency ON PaymentBatchRuleCurrency = _PaymentBatchRuleCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_ExchangeRateType AS _PaytBatchRuleExchRateType ON RuleExchangeRateType = _PaytBatchRuleExchRateType.ExchangeRateType  -- association [1..1]
;