C_MakeBankTransferTP

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_MakeBankTransferTP.
-- 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_MakeBankTransferTP AS
SELECT
  _PaymentRequest.PaymentRequest AS PaymentRequest,
  _PaymentRequest.ValueDate AS ValueDate,
  _PaymentRequest.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _PaymentRequest.PayingCompanyCode AS PayingCompanyCode,
  _PaymentRequest.PayingCompanyCodeName AS PayingCompanyCodeName,
  _PaymentRequest.PayingBankAccountInternalID AS PayingBankAccountInternalID,
  PayingBankAccount,
  _PayingBankAcctText[1: Language = $session.system_language].BankAccountDescription AS PayingBankAccountDescription,
  PayingHouseBank,
  PayingHouseBankAccount,
  PayeeHouseBank,
  PayeeHouseBankAccount,
  _PaymentRequest.PaymentRequestAmountInPaytCrcy AS PaymentRequestAmountInPaytCrcy,
  _PaymentRequest.PaymentRequestCurrency AS PaymentRequestCurrency,
  _PaymentRequest.PaymentMethod AS PaymentMethod,
  _PaymentRequest.PaymentMethodName AS PaymentMethodName,
  _PaymentRequest.PayeeBankAccountInternalID AS PayeeBankAccountInternalID,
  PayeeBankAccount,
  _PayeeBankAcctText[1: Language = $session.system_language].BankAccountDescription AS PayeeBankAccountDescription,
  cast( _PaymentRequest.PayeeCompanyCode as fclm_payee_companycode preserving type ) AS PayeeCompanyCode,
  cast(_PaymentRequest.PayeeCompanyCodeName as fclm_payee_cocodename preserving type ) AS PayeeCompanyCodeName,
  _PaymentRequest.CreatedByUser AS CreatedByUser,
  _PaymentRequest.CreatedByUserDescription AS CreatedByUserDescription,
  _PaymentRequest.StatusCode AS StatusCode,
  SystemStatusName,
  _PaymentRequest.PaymentRequestPostingDate AS PaymentRequestPostingDate,
  _PaymentRequest.Note AS Note,
  _PaymentRequest.ClearingAccountingDocument AS ClearingAccountingDocument,
  _PaymentRequest.RepetitiveCode AS RepetitiveCode,
  _PaymentRequest.PaytReqIsReleasedForPosting AS PaytReqIsReleasedForPosting,
  _PaymentRequest.PaytReqIsCompleted AS PaytReqIsCompleted,
  _PaymentRequest.PaytReqIsReleasedForPayment AS PaytReqIsReleasedForPayment,
  _PaymentRequest.IsReversed AS IsReversed,
  BankTransferReleaseAndPay,
  cast( BankInternalID as fclm_payer_bankkey preserving type ) AS PayingBankKey,
  cast(_PayingBank.BankName as fclm_payer_bankname preserving type ) AS BankName,
  cast( PayeeBankInternalID as fclm_payee_bankkey preserving type ) AS PayeeBankKey,
  cast( _PayeeBank.BankName as fclm_payee_bankname preserving type ) AS PayeeBankName,
  BankAccountRevision,
  IsSinglePayment,
  _PaymentRequest.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  _PaymentRequest.SupplyingCountry AS SupplyingCountry,
  _PaymentRequest.DataExchangeInstructionKey AS DataExchangeInstructionKey,
  _PaymentRequest.DataExchangeInstruction1 AS DataExchangeInstruction1,
  _PaymentRequest.DataExchangeInstruction2 AS DataExchangeInstruction2,
  _PaymentRequest.DataExchangeInstruction3 AS DataExchangeInstruction3,
  _PaymentRequest.DataExchangeInstruction4 AS DataExchangeInstruction4,
  _PaymentRequest.PaymentMethodSupplement AS PaymentMethodSupplement,
  _PaymentRequest.PaymentReference AS PaymentReference,
  _PaymentRequest.BankCountry AS Country,
  BankInternalID,
  BankCountry,
  cast( PayeeBankCountry as fclm_payee_bkcntry preserving type ) AS PayeeBankCountry,
  BankInternalID AS BankKey,
  PayeeBank,
  cast(_PayeeBank._Country._Text[1: Language = $session.system_language].CountryName as fclm_payee_cntryname preserving type ) AS PayeeCountryName,
  LogHandle,
  _PaymentRequest.PaymentRequestOrigin AS PaymentRequestOrigin,
  cast(_CountryText[1: Language = $session.system_language].CountryName as fclm_payer_supcntryname preserving type ) AS CountryName,
  cast(_BankCountryText[1: Language = $session.system_language].CountryName as fclm_payer_cntryname preserving type ) AS BankCountryName,
  _DataExchInstructionKeysText[1: Language = $session.system_language].DataExchInstructionKeyName AS DataExchInstructionKeyName
FROM I_MakeBankTransferTP AS _PaymentRequest
LEFT OUTER JOIN I_BankAccountText AS _PayingBankAcctText ON PayingBankAccountInternalID = _PayingBankAcctText.BankAccountInternalID  -- association [0..*]
LEFT OUTER JOIN I_BankAccountText AS _PayeeBankAcctText ON PayeeBankAccountInternalID = _PayeeBankAcctText.BankAccountInternalID  -- association [0..*]
LEFT OUTER JOIN I_Bank_2 AS _PayingBank ON BankCountry = _PayingBank.BankCountry AND BankInternalID = _PayingBank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_Bank_2 AS _PayeeBank ON PayeeBankCountry = _PayeeBank.BankCountry AND PayeeBankKey = _PayeeBank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_RepetitiveCodeVH AS _RepetitiveCodeVH ON RepetitiveCode = _RepetitiveCodeVH.RepetitiveCode AND PayingCompanyCode = _RepetitiveCodeVH.PayingCompanyCode AND PayingBankAccountInternalID = _RepetitiveCodeVH.PayingBankAccountInternalID AND PayingBankAccount = _RepetitiveCodeVH.PayingBankAccount  -- association [0..1]
LEFT OUTER JOIN C_CurrencyValueHelp AS _PaymentRequestCurrency ON PaymentRequestCurrency = _PaymentRequestCurrency.Currency  -- association [0..*]
LEFT OUTER JOIN C_ClrgAcctgDocWthBatQuickVw AS _TrackInfo ON PaymentRequest = _TrackInfo.PaymentRequest AND ClearingAccountingDocument = _TrackInfo.ClearingDocumentNumber  -- association [0..1]
;