I_BankPaymentBatchItem

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_BankPaymentBatchItem.
-- 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: IBNKPAYTBTCHITEM

CREATE VIEW I_BankPaymentBatchItem AS
SELECT
  cast(bnk_batch_item.item_no as farp_bnk_com_btch_cnt) AS PaymentBatchItem,
  bnk_batch_item.guid AS BatchUUID,
  cast(bnk_batch_item.batch_no as farp_bnk_btch_no) AS PaymentBatch,
  cast(bnk_batch_item.pay_grp_id as farp_bnk_com_pay_grp_id) AS PaymentGroup,
  cast(bnk_batch_item.lifnr as md_supplier) AS Supplier,
  cast(bnk_batch_item.kunnr as kunnr) AS Customer,
  cast(bnk_batch_item.empfg as farp_empfg) AS PaymentRecipient,
  bnk_batch_item.vblnr AS PaymentDocument,
  cast(bnk_batch_item.grpno as farp_grpno_fpm) AS PaymentsGroupingCriterion,
  cast(bnk_batch_item.laufd_o as farp_bnk_com_laufd) AS PaymentRunDate,
  cast(bnk_batch_item.laufi_o as farp_bnk_com_laufi) AS PaymentRunID,
  cast(bnk_batch_item.zbukr as farp_bnk_com_dzbukr) AS PayingCompanyCode,
  cast(bnk_batch_item.laufd as farp_bnk_com_btch_mrge_dat) AS PaymentBatchMergeDate,
  cast(bnk_batch_item.laufi as farp_bnk_com_btch_mrge_id) AS PaymentBatchMerge,
  cast(bnk_batch_item.xvorl as farp_xvorl) AS PaymentRunIsProposal,
  cast(bnk_batch_item.status as farp_bnk_com_btch_status_id) AS PaymentBatchStatus,
  cast(bnk_batch_item.amt_rulecu as farp_bnk_com_pymntamt_in_rulcu) AS PaymentAmountInRuleCrcy,
  cast(bnk_batch_item.hbkid as farp_hbkid) AS HouseBank,
  bnk_batch_item.paym_system AS BankPaymentOrigin,
  bnk_batch_item.cur_sts AS PaymentBatchItemCurrentStatus,
  bnk_batch_item.end_to_end_id_ext AS PaymentBatchItemExtEndToEnd,
  cast(' ' as farp_bnk_rule_currency) AS PaymentBatchRuleCurrency,
  cast(ext_stat as farp_bnk_com_btch_itm_ext_sts) AS PaymentBatchItemExternalStatus,
  cast(upper(gpi_code) as bnk_com_gpi_code) AS SWIFTGPIReason,
  SACF.chk_hmode AS SwitchableAuthznCheckScenSts
FROM bnk_batch_item
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _StatusObject ON PaymentBatchStatus = _StatusObject.StatusObjectUUID AND _StatusObject.StatusIsInactive != 'X'  -- association [0..1]
LEFT OUTER JOIN I_PaymentProposalHeader AS _PaymentProposalHeader ON PaymentDocument = _PaymentProposalHeader.PaymentDocument AND PaymentBatchMergeDate = _PaymentProposalHeader.PaymentRunDate AND PaymentBatchMerge = _PaymentProposalHeader.PaymentRunID AND PayingCompanyCode = _PaymentProposalHeader.PayingCompanyCode AND PaymentRunIsProposal = _PaymentProposalHeader.PaymentRunIsProposal AND Supplier = _PaymentProposalHeader.Supplier AND Customer = _PaymentProposalHeader.Customer AND PaymentRecipient = _PaymentProposalHeader.PaymentRecipient  -- association [1..1]
LEFT OUTER JOIN I_BankPaymentBatchRuleBaseCust AS _BankPaymentBatchRuleBaseCust ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON PayingCompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
;