C_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 C_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.

CREATE VIEW C_BankPaymentBatchItem AS
SELECT
  BatchUUID,
  PaymentBatchItem,
  PaymentBatch,
  cast( PaymentDocument as farp_vblnr ) AS PaymentDocument,
  BatchItem._FiscalCalendarDate.FiscalYear AS FiscalYear,
  Status,
  cast( _SystemStatusText[1:Language = $session.system_language].SystemStatusName as farp_bnk_com_btch_status_txt preserving type ) AS SystemStatusName,
  PaytBatItmHasMoreIncgStatuses,
  BankPaytIncgStatusMessage,
  IsUrgentPayment,
  PaymentRunID,
  PaymentRunDate,
  PayingCompanyCode,
  cast(BatchItem._CompanyCode.CompanyCodeName as farp_zbukrstxt) AS CompanyCodeName,
  CompanyCodeCurrency,
  BatchItem._PaymentProposalHeader.PaymentMethod AS PaymentMethod,
  BatchItem._PaymentProposalHeader._PaymentMethod.PaymentMethodName AS PaymentMethodName,
  PaymentAmountInRuleCrcy,
  PaymentBatchRuleCurrency,
  BatchItem._PaymentProposalHeader._DataExchangeInstructionKeys.DataExchangeCostAllocation AS DataExchangeCostAllocation,
  Supplier,
  cast(BatchItem._PaymentProposalHeader.SupplierName as suppliername) AS SupplierName,
  BatchItem._PaymentProposalHeader.PayeeName AS PayeeName,
  PaymentRecipient,
  cast(BatchItem._PaymentProposalHeader.HouseBank as farp_hbkid) AS HouseBank,
  BatchItem._PaymentProposalHeader.HouseBankAccount AS HouseBankAccount,
  BankAccountLongID,
  BatchItem._PaymentProposalHeader._Bank.BankName AS BankName,
  BatchItem._PaymentProposalHeader.BankCountry AS BankCountry,
  BatchItem._PaymentProposalHeader.BankInternalID AS BankInternalID,
  BatchItem._PaymentProposalHeader.HouseBankIBAN AS HouseBankIBAN,
  cast(BatchItem._PaymentProposalHeader.BankControlKey as farp_bnk_com_ubkon) AS BankControlKey,
  BatchItem._PaymentProposalHeader._Bank.SWIFTCode AS SWIFTCode,
  BankPaymentOrigin,
  PaymentBatchItemExtEndToEnd,
  PaymentBatchItemExternalStatus,
  cast(BatchItem._PaymentProposalHeader.PayeeBank as farp_bnk_com_dzbnkl) AS PayeeBank,
  PayeeBankAccountLongID,
  cast(BatchItem._PaymentProposalHeader._PayeeBank.BankName as farp_payeebanka) AS PayeeBankName,
  cast(BatchItem._PaymentProposalHeader.PayeeBankCountry as farp_dzbnks) AS PayeeBankCountry,
  cast(BatchItem._PaymentProposalHeader.SWIFTCode as farp_bnk_com_payee_swift) AS PayeeSWIFTCode,
  BatchItem._PaymentProposalHeader.PayeeIBAN AS PayeeIBAN,
  cast(BatchItem._PaymentProposalHeader.PayeeBankControlKey as farp_bnk_com_dzbkon) AS PayeeBankControlKey,
  cast(BatchItem._PaymentProposalHeader.PayeeBankInternalID as farp_bnk_com_dzbnky) AS PayeeBankInternalID,
  BatchItem._PaymentProposalHeader.PostingDate AS PostingDate,
  PaidItemDueDate,
  PaidAmountInPaytCurrency,
  cast( PaymentCurrency as fap_h2r_payt_currency preserving type ) AS PaymentCurrency,
  AmountInCompanyCodeCurrency,
  DataExchangeInstructionKey,
  BatchItem._PaymentProposalHeader._DataExchangeInstructionKeys.DataExchangeInstrnAddlInfo AS DataExchangeInstrnAddlInfo,
  BatchItem._PaymentProposalHeader.BillOfExchangeIssueDate AS BillOfExchangeIssueDate,
  BatchItem._PaymentProposalHeader.BillOfExchangeDueDate AS BillOfExchangeDueDate,
  Customer,
  cast( BatchItem._PaymentProposalHeader.CustomerName as farp_customer_name1_gp ) AS CustomerName,
  PaymentBatchMergeDate,
  PaymentBatchMerge,
  BatchItem._PaymentProposalHeader.BankPaymentGroupingOrigin AS BankPaymentGroupingOrigin,
  BatchItem._PaymentProposalHeader.PaymentRequestPaymentGroup AS PaymentRequestPaymentGroup,
  SWIFTGPIReason,
  cast( _GPIReasonText[1:Language = $session.system_language].PaymentStatusReasonName as bnk_com_rsn_desc preserving type ) AS SWIFTGPIReasonName,
  SWIFTGPIRsnToPaytStsRsn,
  BatchItem._PaymentProposalHeader.SWIFTTransactionReferenceUUID AS SWIFTTransactionReferenceUUID,
  _LastReason.PaymentStatusReasonByBank AS PaymentStatusReasonByBank,
  _LastReason.PaymentStatusReasonByBankName AS PaymentStatusReasonByBankName,
  _LastReason.PaymentStatusReason AS PaymentStatusReason,
  _LastReason.PaymentStatusReasonName AS PaymentStatusReasonName,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  BatchItem._Customer.CustomerAccountGroup AS CustomerAccountGroup,
  BatchItem._Customer.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  SwitchableAuthznCheckScenSts,
  BatchItem._PaymentProposalHeader.PayeePaymentSystem AS PayeePaymentSystem,
  BatchItem._PaymentProposalHeader.PayeeAliasType AS PayeeAliasType,
  BatchItem._PaymentProposalHeader.PayeeAliasName AS PayeeAliasName
FROM I_MonitorBankPaymentBatchItem AS BatchItem
LEFT OUTER JOIN C_BankPaymentBatch AS _PaymentBatch ON BatchUUID = _PaymentBatch.BatchUUID AND PaymentBatch = _PaymentBatch.PaymentBatch  -- association [1..1]
LEFT OUTER JOIN C_BankPaymentBatchItemSupplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN C_InstructionKeys AS _InstructionKeys ON bankcountry = _InstructionKeys.BankCountryKey AND paymentmethod = _InstructionKeys.PaymentMethod  -- association [0..*]
LEFT OUTER JOIN C_BankPaymentBatchBankDetails AS _BankDetails ON BatchUUID = _BankDetails.BatchUUID AND PaymentBatchItem = _BankDetails.PaymentBatchItem  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON CompanyCodeCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN C_BankPaymentIncgStatus AS _IncomingStatus ON PaymentBatch = _IncomingStatus.PaymentBatch AND PaymentBatchItem = _IncomingStatus.PaymentBatchItem  -- association [0..*]
LEFT OUTER JOIN C_PaymentLastStatusReason AS _LastReason ON PaymentBatch = _LastReason.PaymentBatch AND PaymentBatchItem = _LastReason.PaymentBatchItem  -- association [0..1]
LEFT OUTER JOIN C_PaymentStatusReason AS _StsReason ON PaymentBatch = _StsReason.PaymentBatch AND PaymentBatchItem = _StsReason.PaymentBatchItem  -- association [0..*]
LEFT OUTER JOIN I_PaymentStatusReasonText AS _GPIReasonText ON SWIFTGPIRsnToPaytStsRsn = _GPIReasonText.PaymentStatusReason  -- association [0..*]
LEFT OUTER JOIN I_SystemStatusText AS _SystemStatusText ON Status = _SystemStatusText.SystemStatus  -- association [0..*]
;