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,
  _PaymentRequest.PayeeCompanyCode AS PayeeCompanyCode,
  _PaymentRequest.PayeeCompanyCodeName 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,
  PayingBankAccountInternalID AS PayingBankKey,
  _PayingBank.BankName AS BankName,
  PayeeBankInternalID AS PayeeBankKey,
  _PayeeBank.BankName 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,
  PayeeBankCountry,
  BankInternalID AS BankKey,
  PayeeBank,
  _PayeeBank._Country._Text[1: Language = $session.system_language].CountryName AS PayeeCountryName,
  LogHandle
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 BankKey = _PayeeBank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON CreatedByUser = _UserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _PayingBankAcctIDVH ON PayingBankAccountInternalID = _PayingBankAcctIDVH.BankAccountInternalID AND PayingCompanyCode = _PayingBankAcctIDVH.CompanyCode AND PayingHouseBank = _PayingBankAcctIDVH.HouseBank AND PayingHouseBankAccount = _PayingBankAcctIDVH.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _TargetBankAcctIDVH ON PayeeBankAccountInternalID = _TargetBankAcctIDVH.BankAccountInternalID AND PayeeCompanyCode = _TargetBankAcctIDVH.CompanyCode AND PayeeHouseBank = _TargetBankAcctIDVH.HouseBank AND PayeeHouseBankAccount = _TargetBankAcctIDVH.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _PayingHouseBankVH ON PayingBankAccountInternalID = _PayingHouseBankVH.BankAccountInternalID AND PayingBankAccount = _PayingHouseBankVH.BankAccountNumber AND PayingCompanyCode = _PayingHouseBankVH.CompanyCode AND PayingHouseBank = _PayingHouseBankVH.HouseBank AND PayingHouseBankAccount = _PayingHouseBankVH.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _PayeeHouseBankVH ON PayeeBankAccountInternalID = _PayeeHouseBankVH.BankAccountInternalID AND PayeeBankAccount = _PayeeHouseBankVH.BankAccountNumber AND PayeeCompanyCode = _PayeeHouseBankVH.CompanyCode AND PayeeHouseBank = _PayeeHouseBankVH.HouseBank AND PayeeHouseBankAccount = _PayeeHouseBankVH.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _PayingBankAcctVH ON PayingBankAccountInternalID = _PayingBankAcctVH.BankAccountInternalID AND PayingCompanyCode = _PayingBankAcctVH.CompanyCode AND PayingHouseBank = _PayingBankAcctVH.HouseBank AND PayingHouseBankAccount = _PayingBankAcctVH.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _TargetBankAcctVH ON PayeeBankAccountInternalID = _TargetBankAcctVH.BankAccountInternalID AND PayeeCompanyCode = _TargetBankAcctVH.CompanyCode AND PayeeHouseBank = _TargetBankAcctVH.HouseBank AND PayeeHouseBankAccount = _TargetBankAcctVH.HouseBankAccount  -- 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 I_ClrgAcctgDocWthBatQuickVw AS _TrackInfo ON PaymentRequest = _TrackInfo.PaymentRequest AND ClearingAccountingDocument = _TrackInfo.ClearingDocumentNumber  -- association [0..1]
;