I_BkPaytRunDocExtData

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_BkPaytRunDocExtData.
-- 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 I_BkPaytRunDocExtData AS
SELECT
  PaymentRunDate,
  PaymentRunID,
  PayingCompanyCode,
  Supplier,
  Customer,
  PaymentRecipient,
  PaymentDocument,
  PaymentRunMergeDate,
  PaymentRunMergeIdentifier,
  HouseBank,
  HouseBankAccount,
  PaymentMethod,
  PaymentMethodSupplement,
  PaymentCurrency,
  PaymentDocumentPostingDate,
  ValueDate,
  PayeeBankValueDate,
  PaidItemDueDate,
  PaymentBatch,
  PaymentRunIsProposal,
  SupplierClerkIDBySupplier,
  BankAccountHolderName,
  AccountingClerk,
  PaidAmountInPaytCurrency,
  AmountInCompanyCodeCurrency,
  PayeeBankControlKey,
  BankControlKey,
  BankCountry,
  PaymentRunDocumentPayeeBankKey,
  PayeeBank,
  BusinessArea,
  CashDiscountAmtInTransacCrcy,
  CashDiscountAmtInCoCodeCrcy,
  SupplierCityName,
  PayeeCityName,
  SupplierCountry,
  PayeeBankCountry,
  District,
  EDIPaymentOrderStatus,
  EDIPaymentAdviceStatus,
  PaymentRequestPaymentGroup,
  BankInternalID,
  Bank,
  HouseBankIBAN,
  PayeeIBAN,
  DataExchangeInstructionKey,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  PaymentReason,
  DirectDebitType,
  LostCashDiscountInTransacCrcy,
  LostCashDiscountInCoCodeCrcy,
  FunctionalCurrency,
  PaymentAmountInFunctionalCrcy,
  CashDiscountAmountInFuncnlCrcy,
  SupplierName,
  SupplierAdditionalName,
  CustomerName,
  CustomerAdditionalName,
  PayeeName,
  PayeeAdditionalName,
  PayeeTitle,
  AddressID,
  NumberOfTextLines,
  NumberOfPaidItems,
  BankAccount,
  BankAccountLongID,
  POBoxDeviatingCityName,
  POBoxPostalCode,
  PayeePOBoxPostalCode,
  PayeePostalCode,
  PayeeBankAccount,
  PayeeBankAccountLongID,
  PayeeCountry,
  PayeeLanguage,
  PayeePOBox,
  PayeeStreet,
  PaymentReference,
  PersonnelNumber,
  POBox,
  PostalCode,
  PostingDate,
  BankAccountReferenceText,
  Region,
  PaymentOrder,
  SendingCompanyCode,
  SEPASequenceType,
  StreetAddressName,
  SWIFTCode,
  SEPAMandateUUID,
  SupplierRegion,
  ExchangeRate,
  PaymentOrigin,
  BillOfExchangeIssueDate,
  BillOfExchangeDueDate,
  PaymentsGroupingCriterion,
  SWIFTTransactionReferenceUUID,
  BusinessPlace,
  BankChainBank1Type,
  BankChainBank1Country,
  BankChainBank1,
  BankChainBank1BankAccount,
  BankChainBank1ControlKey,
  BankChainBank1DetailReference,
  BankChainBank1IBAN,
  BankChainBank2Type,
  BankChainBank2Country,
  BankChainBank2,
  BankChainBank2BankAccount,
  BankChainBank2ControlKey,
  BankChainBank2DetailReference,
  BankChainBank2IBAN,
  BankChainBank3Type,
  BankChainBank3Country,
  BankChainBank3,
  BankChainBank3BankAccount,
  BankChainBank3ControlKey,
  BankChainBank3DetailReference,
  BankChainBank3IBAN,
  PayeePaymentSystem,
  PayeeAliasType,
  PayeeAliasName,
  CompanyCodeCurrency,
  Country,
  FiscalYearVariant,
  SWIFTGPIReason,
  PaymentBatchItemCurrentStatus,
  PaymentBatchRuleCurrency,
  IsUrgentPayment,
  PaymentMethodName,
  AliasTypeText,
  PaymentBatchItem,
  BatchUUID,
  FinancialAccountType,
  _FiscalCalendarDate.FiscalYear AS FiscalYear,
  cast(_BkPaytRunDocMergeData.PaymentRunMergeIdentifier as payt_run_doc_paytrunfileid preserving type ) AS PaymentRunFileIdentifier,
  cast(_BkPaytRunDocMergeData.PaymentRunMergeDate as payt_run_doc_paytrunfiledte preserving type ) AS PaymentRunFileDate,
  _BkPaytRunDocMergeData.PaymentBatch AS MergeBatchNumber,
  _CountryPayee.Description AS PayeeCountryName,
  _CountryPayeeBank.Description AS PayeeBankCountryName,
  _CountryBank.Description AS BankCountryName,
  _CountryBankChain1.Description AS BankChainBank1CountryName,
  _CountryBankChain2.Description AS BankChainBank2CountryName,
  _CountryBankChain3.Description AS BankChainBank3CountryName,
  _PaymentOrigin.OriginName AS OriginName,
  _PaymentBatch.PaymentBatchCurrentStatus AS PaymentBatchCurrentStatus,
  cast( _PaymentReasonText.PaymentReasonText as payt_run_doc_paymentreasontext preserving type ) AS PaymentReasonText
FROM I_BkPaytRunDocSettlementData
LEFT OUTER JOIN I_SystemStatusText AS _SystemStatusText ON PaymentBatchItemCurrentStatus = _SystemStatusText.SystemStatus AND _SystemStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _AccountingDocument ON PaymentDocument = _AccountingDocument.AccountingDocument AND fiscalyear = _AccountingDocument.FiscalYear AND PayingCompanyCode = _AccountingDocument.CompanyCode AND _AccountingDocument.ReverseDocument <> ''  -- association [0..1]
LEFT OUTER JOIN I_BkPaytRunDocBatchItemExist AS _BkPaytRunDocBatchItemExist ON PaymentDocument = _BkPaytRunDocBatchItemExist.PaymentDocument AND PaymentRunID = _BkPaytRunDocBatchItemExist.PaymentRunID AND PaymentRunDate = _BkPaytRunDocBatchItemExist.PaymentRunDate AND PayingCompanyCode = _BkPaytRunDocBatchItemExist.PayingCompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BkPaytRunDocPaytMda AS _BkPaytRunDocPaytMda ON PaymentRunFileIdentifier = _BkPaytRunDocPaytMda.PaymentRunID AND PaymentRunFileDate = _BkPaytRunDocPaytMda.PaymentRunDate  -- association [0..1]
LEFT OUTER JOIN I_BkPaytRunDocExtToIntRsnCodes AS _BkPaytRunDocExtToIntRsnCodes ON SWIFTGPIReason = _BkPaytRunDocExtToIntRsnCodes.ReasonCodeExternal  -- association [0..1]
LEFT OUTER JOIN I_BkPaytRunDocLastStatusReason AS _PaymentLastStatusReason ON PaymentBatch = _PaymentLastStatusReason.PaymentBatch AND PaymentBatchItem = _PaymentLastStatusReason.PaymentBatchItem  -- association [1..1]
LEFT OUTER JOIN I_FiscalCalendarDate AS _FiscalCalendarDate ON FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant AND PaymentDocumentPostingDate = _FiscalCalendarDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_BkPaytRunDocPaytOriginVH AS _PaymentOrigin ON PaymentOrigin = _PaymentOrigin.PaymentRequestOrigin  -- association [0..1]
LEFT OUTER JOIN I_CountryVH AS _CountryPayee ON PayeeCountry = _CountryPayee.Country  -- association [0..1]
LEFT OUTER JOIN I_CountryVH AS _CountryPayeeBank ON PayeeBankCountry = _CountryPayeeBank.Country  -- association [0..1]
LEFT OUTER JOIN I_CountryVH AS _CountryBank ON BankCountry = _CountryBank.Country  -- association [0..1]
LEFT OUTER JOIN I_CountryVH AS _CountryBankChain1 ON BankChainBank1Country = _CountryBankChain1.Country  -- association [0..1]
LEFT OUTER JOIN I_CountryVH AS _CountryBankChain2 ON BankChainBank2Country = _CountryBankChain2.Country  -- association [0..1]
LEFT OUTER JOIN I_CountryVH AS _CountryBankChain3 ON BankChainBank3Country = _CountryBankChain3.Country  -- association [0..1]
LEFT OUTER JOIN I_BankPaymentBatch AS _PaymentBatch ON BatchUUID = _PaymentBatch.BatchUUID  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _SystemStatusTextBatchHeader ON PaymentBatchCurrentStatus = _SystemStatusTextBatchHeader.SystemStatus AND _SystemStatusTextBatchHeader.Language = $session.system_language  -- association [0..1]
;