I_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 I_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 I_MakeBankTransferTP AS
SELECT
  payrq.PaymentRequest AS PaymentRequest,
  payrq.PayingCompanyCode AS PayingCompanyCode,
  payrq.CompanyCode AS CompanyCode,
  payrq.AccountingDocument AS AccountingDocument,
  payrq.FiscalYear AS FiscalYear,
  _CreatedBy.UserDescription AS CreatedByUserDescription,
  payrq.AccountingDocumentItem AS AccountingDocumentItem,
  payrq.PayeeName AS PayeeName,
  payrq.PayeeBankCountry AS PayeeBankCountry,
  payrq.PayeeBankControlKey AS PayeeBankControlKey,
  payrq.PayeeBank AS PayeeBank,
  payrq.PayeeBankInternalID AS PayeeBankInternalID,
  payrq.PayeeHouseBank AS PayeeHouseBank,
  payrq.PayeeHouseBankAccount AS PayeeHouseBankAccount,
  _PayeeBankAccountLink.BankAccountInternalID AS PayeeBankAccountInternalID,
  payrq.PayeeCompanyCode AS PayeeCompanyCode,
  payrq.BankDetailReference AS BankDetailReference,
  payrq.PayeeBankValueDate AS PayeeBankValueDate,
  payrq.ValueDate AS ValueDate,
  payrq.BankAccountHolderName AS BankAccountHolderName,
  payrq.BusinessArea AS BusinessArea,
  payrq.ReferenceTypeText AS ReferenceTypeText,
  payrq.HouseBank AS PayingHouseBank,
  payrq.HouseBankAccount AS PayingHouseBankAccount,
  cast('0000' as fclm_revision preserving type ) AS BankAccountRevision,
  _PayingBankAccountLink.BankAccountInternalID AS PayingBankAccountInternalID,
  _PayingBankAccountLink.BankAccountNumber AS PayingBankAccount,
  cast('' as banka) AS BankName,
  payrq.PayeeBankAccount AS PayeeBankAccount,
  cast('' as banka) AS PayeeBankName,
  cast('' as fclm_bam_description) AS PayeeBankAccountDescription,
  cast('' as fclm_bam_description) AS PayingBankAccountDescription,
  payrq.PaymentRequestCurrency AS PaymentRequestCurrency,
  payrq.PaymentRequestAmountInPaytCrcy AS PaymentRequestAmountInPaytCrcy,
  payrq.PaymentRequestAmountInCCCrcy AS PaymentRequestAmountInCCCrcy,
  payrq.CompanyCodeCurrency AS CompanyCodeCurrency,
  payrq.PaymentMethodSupplement AS PaymentMethodSupplement,
  payrq.PaymentMethod AS PaymentMethod,
  payrq.IsSinglePayment AS IsSinglePayment,
  payrq.PaymentReference AS PaymentReference,
  payrq.FinancialAccountType AS FinancialAccountType,
  payrq.GLAccount AS GLAccount,
  payrq.CreatedByUser AS CreatedByUser,
  payrq.PaytReqIsReleasedForPosting AS PaytReqIsReleasedForPosting,
  payrq.PaytReqIsCompleted AS PaytReqIsCompleted,
  payrq.PaytReqIsReleasedForPayment AS PaytReqIsReleasedForPayment,
  payrq.IsReversed AS IsReversed,
  payrq.ReversalReason AS ReversalReason,
  payrq.DataExchangeInstructionKey AS DataExchangeInstructionKey,
  payrq.DataExchangeInstruction1 AS DataExchangeInstruction1,
  payrq.DataExchangeInstruction2 AS DataExchangeInstruction2,
  payrq.DataExchangeInstruction3 AS DataExchangeInstruction3,
  payrq.DataExchangeInstruction4 AS DataExchangeInstruction4,
  payrq.PaymentRequestPostingDate AS PaymentRequestPostingDate,
  payrq.BankCountry AS BankCountry,
  payrq.BankInternalID AS BankInternalID,
  payrq.SupplierCountry AS SupplierCountry,
  payrq.SupplyingCountry AS SupplyingCountry,
  payrq.PaymentRequestOrigin AS PaymentRequestOrigin,
  payrq.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  payrq.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  payrq.CreationTime AS CreationTime,
  payrq.TaxID1 AS TaxID1,
  payrq.ClearingAccountingDocument AS ClearingAccountingDocument,
  payrq.BPBankAccountInternalID AS BPBankAccountInternalID,
  payrq.StatusCode AS StatusCode,
  payrq.ReferenceTypeText AS Note,
  payrq.PayeeTitle AS PayeeTitle,
  payrq.PayeePostalCode AS PayeePostalCode,
  payrq.PayeePOBox AS PayeePOBox,
  payrq.POBoxPostalCode AS POBoxPostalCode,
  payrq.PayeeAdditionalName2 AS PayeeAdditionalName2,
  payrq.PayeeAdditionalName3 AS PayeeAdditionalName3,
  payrq.PayeeAdditionalName4 AS PayeeAdditionalName4,
  payrq.PayeeCityName AS PayeeCityName,
  payrq.PayeeStreet AS PayeeStreet,
  payrq.PayeeCountry AS PayeeCountry,
  payrq.PayeeRegion AS PayeeRegion,
  payrq.PayeeLanguage AS PayeeLanguage,
  payrq.PayeeFaxNumber AS PayeeFaxNumber,
  payrq.PayeeTelephoneNumber AS PayeeTelephoneNumber,
  payrq.ClearingDate AS ClearingDate,
  cast( payrq.RepetitiveCode as rpcode ) AS RepetitiveCode,
  cast ( '' as fin_gl_boole ) AS BankTransferReleaseAndPay,
  payrq.PaymentReason AS PaymentReason,
  payrq.LogHandle AS LogHandle,
  _PaymentMethod.PaymentMethodName AS PaymentMethodName,
  companycode.Country AS CompanyCodeCountry,
  payrq._PayingCompanyCode.CompanyCodeName AS PayingCompanyCodeName,
  _PayeeCompanyCode.CompanyCodeName AS PayeeCompanyCodeName,
  '' AS IsUrgentPayment,
  cast ( '' as farp_payrq_type ) AS PaymentRequestType,
  cast('' as farp_changed_by ) AS LastChangedByUser,
  cast('000000' as ttet_dt_cr_time ) AS LastChangeTime,
  cast('00000000' as ttet_dt_chg_date ) AS LastChangeDate,
  cast('00000000' as farp_prq_cr_date ) AS CreationDateTime,
  cast('00000000' as farp_prq_cr_date ) AS LastChangeDateTime,
  payrq.HouseBank AS HouseBank,
  payrq.HouseBankAccount AS HouseBankAccount,
  _SystemStatusText.SystemStatusName AS SystemStatusName
FROM I_MakeBkTransfWithFilter AS payrq
INNER JOIN I_CompanyCode AS companycode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PaymentMethod AS _PaymentMethod ON CompanyCodeCountry = _PaymentMethod.Country AND PaymentMethod = _PaymentMethod.PaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_BankAccountValidLinkage AS _PayingBankAccountLink ON payrq.PayingCompanyCode = _PayingBankAccountLink.CompanyCode AND payrq.HouseBank = _PayingBankAccountLink.HouseBank AND payrq.HouseBankAccount = _PayingBankAccountLink.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_BankAccountValidLinkage AS _PayeeBankAccountLink ON payrq.PayeeCompanyCode = _PayeeBankAccountLink.CompanyCode AND payrq.PayeeHouseBank = _PayeeBankAccountLink.HouseBank AND payrq.PayeeHouseBankAccount = _PayeeBankAccountLink.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _SystemStatusText ON StatusCode = _SystemStatusText.SystemStatus AND _SystemStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PayeeCompanyCode ON PayeeCompanyCode = _PayeeCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedBy ON CreatedByUser = _CreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _PayingHouseBankAccountText ON PayingCompanyCode = _PayingHouseBankAccountText.CompanyCode AND PayingHouseBank = _PayingHouseBankAccountText.HouseBank AND PayingHouseBankAccount = _PayingHouseBankAccountText.HouseBankAccount  -- association [1..*]
LEFT OUTER JOIN I_HouseBankAccountText AS _PayeeHouseBankAccountText ON PayeeCompanyCode = _PayeeHouseBankAccountText.CompanyCode AND PayeeHouseBank = _PayeeHouseBankAccountText.HouseBank AND PayeeHouseBankAccount = _PayeeHouseBankAccountText.HouseBankAccount  -- association [1..*]
LEFT OUTER JOIN I_DataExchInstructionKeysText AS _DataExchInstructionKeysText ON BankCountry = _DataExchInstructionKeysText.BankCountryKey AND PaymentMethod = _DataExchInstructionKeysText.PaymentMethod AND DataExchangeInstructionKey = _DataExchInstructionKeysText.DataExchangeInstructionKey  -- association [1..*]
LEFT OUTER JOIN I_CountryText AS _CountryText ON SupplyingCountry = _CountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_Paymentmethodsupplementtext AS _PmtMetdSupmntText ON PaymentMethodSupplement = _PmtMetdSupmntText.PaymentMethodSupplement  -- association [0..*]
;