C_BankPaymentBatch

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_BankPaymentBatch.
-- 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_BankPaymentBatch AS
SELECT
  Batch.BatchUUID AS BatchUUID,
  Batch.PaymentBatch AS PaymentBatch,
  Batch.NumberOfPaymentRunDates AS NumberOfPaymentRunDates,
  Batch.PaymentRunDate AS PaymentRunDate,
  Batch.NumberOfPaymentRuns AS NumberOfPaymentRuns,
  Batch.PaymentRunID AS PaymentRunID,
  Batch.NumberOfPaymentDocuments AS NumberOfPaymentDocuments,
  Batch.PaymentDocument AS PaymentDocument,
  Batch.PostingDate AS PostingDate,
  Batch._FiscalCalendarDate.FiscalYear AS FiscalYear,
  Batch.BankPaymentOrigin AS BankPaymentOrigin,
  _CompanyCode.NumberOfCompanyCodes AS NumberOfCompanyCodes,
  case _CompanyCode.NumberOfCompanyCodes when 1 then _CompanyCode._CompanyCodeName.CompanyCodeName else '' end as CompanyCodeName AS CompanyCodeNameelseendasCompanyCodeName,
  Batch.IncomingPaymentFileUploadDate AS IncomingPaymentFileUploadDate,
  Batch.IncomingPaymentFile AS IncomingPaymentFile,
  Batch.NumberOfPayments AS NumberOfPayments,
  Batch.PaymentBatchRule AS PaymentBatchRule,
  Batch.PaymentBatchRuleDescription AS PaymentBatchRuleDescription,
  Batch.Status AS Status,
  Batch.PaymentBatchExternalStatus AS PaymentBatchExternalStatus,
  Batch.NumberOfPaytIncomingStatuses AS NumberOfPaytIncomingStatuses,
  Batch.BankPaytIncgStatusMessage AS BankPaytIncgStatusMessage,
  Batch.PaymentBatchAmountInCCCrcy AS PaymentBatchAmountInCCCrcy,
  Batch.BankPaymentBatchCurrency AS BankPaymentBatchCurrency,
  _HouseBank.NumberOfHouseBanks AS NumberOfHouseBanks,
  case Batch.HouseBank when '*' then '' else Batch.HouseBank end as HouseBank AS HouseBankendasHouseBank,
  case Batch.HouseBank when '*' then '' else Batch._HouseBank._Bank.BankName end as BankName AS BankNameendasBankName,
  Batch._HouseBank.BankCountry AS BankCountry,
  Batch.CurrentProcessor AS CurrentProcessor,
  _CurrentProcessorContactCard.FullName AS ProcessorUserName,
  Batch.CreatedByUser AS CreatedByUser,
  _CreatedByUserContactCard.FullName AS CreatedByUserName,
  Batch.CreationDate AS CreationDate,
  Batch.CreationTime AS CreationTime,
  Batch.MaxPaymentAmountInCCCrcy AS MaxPaymentAmountInCCCrcy,
  Batch.PaidAmountInPaytCurrency AS PaidAmountInPaytCurrency,
  Batch.PaymentCurrency AS PaymentCurrency,
  Batch.LastChangedByUser AS LastChangedByUser,
  _ChangedByUserContactCard.FullName AS LastChangedByUserName,
  Batch.LastChangeDate AS LastChangeDate,
  Batch.LastChangeTime AS LastChangeTime,
  Batch.TotalPaytBatchAmountInRuleCrcy AS TotalPaytBatchAmountInRuleCrcy,
  Batch.MaxPaymentAmountInRuleCrcy AS MaxPaymentAmountInRuleCrcy,
  Batch._BankPaymentBatchRuleBaseCust.PaymentBatchRuleCurrency AS PaymentBatchRuleCurrency,
  Batch.PaymentBatchGrouping1 AS PaymentBatchGrouping1,
  Batch.PaymentBatchGrouping2 AS PaymentBatchGrouping2,
  Batch.NumberOfBankAccounts AS NumberOfBankAccounts,
  Batch.HouseBankAccount AS HouseBankAccount,
  cast( '' as farp_bnk_com_more_approvers preserving type ) AS PaytBatchHasMoreReviewers,
  cast( '' as farp_bnk_com_approver ) AS ApproverName,
  cast( Batch.PaymentBatchUrgency as farp_payt_batch_urgency preserving type ) AS PaymentBatchUrgency,
  Batch.PaidItemDueDate AS PaidItemDueDate,
  Batch.NumberOfPaymentReferences AS NumberOfPaymentReferences,
  Batch.PaymentMediumReference AS PaymentMediumReference,
  Batch.NmbrOfSWIFTTransReference AS NmbrOfSWIFTTransReference,
  Batch.SWIFTTransactionReferenceUUID AS SWIFTTransactionReferenceUUID,
  Batch.PaymentBatchOrigin AS PaymentBatchOrigin,
  Batch.SWIFTGPIReasonCodes AS SWIFTGPIReasonCodes,
  Batch._PaymentRunDate AS _PaymentRunDate,
  Batch._PaymentRun AS _PaymentRun
FROM C_MonitorPaymentBatch AS Batch
LEFT OUTER JOIN C_BankPaymentBatchItem AS _BankPaymentBatchItem ON BatchUUID = _BankPaymentBatchItem.BatchUUID  -- association [1..*]
LEFT OUTER JOIN C_MntrPaymentHouseBankAccount AS _BankAccounts ON BatchUUID = _BankAccounts.BatchUUID  -- association [0..1]
LEFT OUTER JOIN C_MntrPaymentReferenceNumber AS _PaymentReferenceNumber ON BatchUUID = _PaymentReferenceNumber.BatchUUID  -- association [0..*]
LEFT OUTER JOIN C_BankPaymentBatchHouseBanks AS _HouseBanks ON BatchUUID = _HouseBanks.BatchUUID AND HouseBank = _HouseBanks.HouseBank  -- association [0..*]
LEFT OUTER JOIN P_BkPaytBatchHouseBank AS _HouseBank ON BatchUUID = _HouseBank.BatchUUID  -- association [0..1]
LEFT OUTER JOIN P_BkPaytBatchPayingCoCode AS _CompanyCode ON BatchUUID = _CompanyCode.BatchUUID  -- association [0..1]
LEFT OUTER JOIN C_BkPaytBatchHouseBankDetail AS _HouseBankDetail ON PaymentBatch = _HouseBankDetail.PaymentBatch  -- association [1..*]
LEFT OUTER JOIN C_BkPaytBatchPayeeBankDetail AS _PayeeBankDetail ON PaymentBatch = _PayeeBankDetail.PaymentBatch  -- association [1..*]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedByUserContactCard ON LastChangedByUser = _ChangedByUserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _CurrentProcessorContactCard ON CurrentProcessor = _CurrentProcessorContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN C_BankPaymentIncgStatus AS _IncomingStatus ON PaymentBatch = _IncomingStatus.PaymentBatch AND _IncomingStatus.PaymentBatchItem = '00000'  -- association [0..*]
LEFT OUTER JOIN C_PaymentStatusReason AS _StsReason ON PaymentBatch = _StsReason.PaymentBatch  -- association [0..*]
;