I_PaymentRequestTP

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_PaymentRequestTP.
-- 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.
-- SQL view name: IPAYMENTREQTP

CREATE VIEW I_PaymentRequestTP AS
SELECT
  _PaymentRequest.PaymentRequest AS PaymentRequest,
  _PaymentRequest.CreatedByUser AS CreatedByUser,
  _PaymentRequest.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _PaymentRequest.PaymentRequestAmountInPaytCrcy AS PaymentRequestAmountInPaytCrcy,
  _PaymentRequest.PaymentRequestCurrency AS PaymentRequestCurrency,
  _PaymentRequest.PaymentRequestAmountInCCCrcy AS PaymentRequestAmountInCCCrcy,
  _PaymentRequest.CompanyCodeCurrency AS CompanyCodeCurrency,
  _PaymentRequest.PayeeName AS PayeeName,
  _PaymentRequest.PayeeBankCountry AS PayeeBankCountry,
  _PaymentRequest.PayeeBankInternalID AS PayeeBankInternalID,
  _PaymentRequest.BankDetailReference AS BankDetailReference,
  _PaymentRequest.PayeeBankControlKey AS PayeeBankControlKey,
  _PaymentRequest.PayeeBank AS PayeeBank,
  cast(_PaymentRequest.PayeeBankAccount as fap_bpa_dzbnkn) AS PayeeBankAccount,
  _PaymentRequest.BankAccountHolderName AS BankAccountHolderName,
  _PaymentRequest.PayeeTitle AS PayeeTitle,
  _PaymentRequest.PayeePostalCode AS PayeePostalCode,
  _PaymentRequest.PayeePOBox AS PayeePOBox,
  _PaymentRequest.POBoxPostalCode AS POBoxPostalCode,
  _PaymentRequest.PayeeAdditionalName2 AS PayeeAdditionalName2,
  _PaymentRequest.PayeeAdditionalName3 AS PayeeAdditionalName3,
  _PaymentRequest.PayeeAdditionalName4 AS PayeeAdditionalName4,
  _PaymentRequest.PayeeCityName AS PayeeCityName,
  _PaymentRequest.PayeeStreet AS PayeeStreet,
  _PaymentRequest.PayeeCountry AS PayeeCountry,
  _PaymentRequest.PayeeRegion AS PayeeRegion,
  _PaymentRequest.PayeeLanguage AS PayeeLanguage,
  _PaymentRequest.PayeeFaxNumber AS PayeeFaxNumber,
  _PaymentRequest.PayeeTelephoneNumber AS PayeeTelephoneNumber,
  _PaymentRequest.PayeeIBAN AS PayeeIBAN,
  _PaymentRequest.ReferenceTypeText AS ReferenceTypeText,
  _PaymentRequest.PaymentReference AS PaymentReference,
  _PaymentRequest.CompanyCode AS CompanyCode,
  _PaymentRequest.BusinessArea AS BusinessArea,
  case when _AccountingDocItem002.DocumentItemText is null then _PaymentRequest._PaytReqChangeAndPost.DocumentItemText else _AccountingDocItem002.DocumentItemText end as DocumentItemText AS DocumentItemTextendasDocumentItemText,
  _PaymentRequest.PayingCompanyCode AS PayingCompanyCode,
  _PaymentRequest.HouseBank AS HouseBank,
  _PaymentRequest.HouseBankAccount AS HouseBankAccount,
  _PaymentRequest.AccountingDocument AS AccountingDocument,
  _PaymentRequest.ClearingAccountingDocument AS ClearingAccountingDocument,
  _PaymentRequest.ClearingDate AS ClearingDate,
  _CalendarDateForCompanyCode.FiscalYear AS ClearingFiscalYear,
  _PaymentRequest.PaymentMethod AS PaymentMethod,
  _PaymentRequest.PaymentMethodSupplement AS PaymentMethodSupplement,
  _PaymentRequest.IsSinglePayment AS IsSinglePayment,
  _PaymentRequest.ValueDate AS ValueDate,
  _PaymentRequest.DataExchangeInstructionKey AS DataExchangeInstructionKey,
  _PaymentRequest.DataExchangeInstruction1 AS DataExchangeInstruction1,
  _PaymentRequest.DataExchangeInstruction2 AS DataExchangeInstruction2,
  _PaymentRequest.DataExchangeInstruction3 AS DataExchangeInstruction3,
  _PaymentRequest.DataExchangeInstruction4 AS DataExchangeInstruction4,
  _PaymentRequest._DataExchangeInstructionKeys.IsUrgentPayment AS IsUrgentPayment,
  _PaymentRequest.PaymentRequestOrigin AS PaymentRequestOrigin,
  _PaymentRequest.ReleaseDate AS ReleaseDate,
  _PaymentRequest.ReleasedByUser AS ReleasedByUser,
  _PaymentRequest.PaymentRequestPostingDate AS PaymentRequestPostingDate,
  _PaymentRequest.PostingCreatedByUser AS PostingCreatedByUser,
  _PaymentRequest.PaytReqIsReleasedForPosting AS PaytReqIsReleasedForPosting,
  _PaymentRequest.PaytReqIsCompleted AS PaytReqIsCompleted,
  _PaymentRequest.PaytReqIsReleasedForPayment AS PaytReqIsReleasedForPayment,
  _PaymentRequest.IsReversed AS IsReversed,
  _PaymentRequest.ReversalReason AS ReversalReason,
  _PaymentRequest.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  _PaymentRequest.SupplyingCountry AS SupplyingCountry,
  _PaymentRequest.TaxID1 AS TaxID1,
  _PaymentRequest._PaytReqChangeAndPost.BankChain AS BankChain,
  cast( _BankType.PaymentRequestType as farp_payrq_type ) AS PaymentRequestType,
  _BankType.CustomerBankType AS CustomerBankType,
  _BankType.SupplierBankType AS SupplierBankType,
  _PaymentRequest._PaytReqChangeAndPost.LastChangedByUser AS LastChangedByUser,
  _PaymentRequest._PaytReqChangeAndPost.LastChangeTime AS LastChangeTime,
  _PaymentRequest._PaytReqChangeAndPost.LastChangeDate AS LastChangeDate,
  _PaymentRequest._PaytReqChangeAndPost.CreationTime AS CreationTime,
  cast(' ' as fibl_opvar) AS PaymentRequestVariant,
  _PaymentRequest.PaymentRepetitiveCode AS PaymentRepetitiveCode,
  _PaymentRequest.PayeePaymentSystem AS PayeePaymentSystem,
  _PaymentRequest.PayeeAliasType AS PayeeAliasType,
  _PaymentRequest.PayeeAliasName AS PayeeAliasName,
  _PaymentRequest.FiscalYear AS FiscalYear,
  _PaymentRequest.BankCountry AS BankCountry,
  _PaymentRequest.BankInternalID AS BankInternalID,
  _PaymentRequest.GLAccount AS GLAccount,
  _PaymentRequest.StatusCode AS StatusCode,
  _PayingCompanyCode.FiscalYearVariant AS FiscalYearVariant,
  _PaymentRequest.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  _PaymentRequest.AdditionalCurrency1 AS AdditionalCurrency1,
  _PaymentRequest.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  _PaymentRequest.AdditionalCurrency2 AS AdditionalCurrency2,
  _PaymentRequest.PaymentReason AS PaymentReason,
  cast('' as abap_boolean) AS BankAliasEntryIsSelected,
  _PaymentRequest._PaytReqAdditionalInfo[1:PaymentRequestNotificationType = 'Q'].PaymentRequestReferenceText AS PaymentRequestReferenceText,
  _PaymentRequest._PayeeBank AS _PayeeBank,
  _PaymentRequest._Bank AS _Bank,
  _PaymentRequest._HouseBankAccount AS _HouseBankAccount,
  _PaymentRequest._BusinessAreaText AS _BusinessAreaText,
  _PaymentRequest._CompanyCode AS _CompanyCode,
  _PaymentRequest._PayingCompanyCode AS _PayingCompanyCode,
  _PaymentRequest._PaymentRequestCurrency AS _PaymentRequestCurrency,
  _PaymentRequest._CompanyCodeCurrency AS _CompanyCodeCurrency,
  _PaymentRequest._AdditionalCurrency1 AS _AdditionalCurrency1,
  _PaymentRequest._AdditionalCurrency2 AS _AdditionalCurrency2,
  _PaymentRequest._DataExchangeInstructionKeys AS _DataExchangeInstructionKeys,
  _PaymentRequest._PaymentMethod AS _PaymentMethod,
  _PaymentRequest._PaytReqChangeAndPost AS _PaytReqChangeAndPost,
  _PaymentRequest._SystemStatusText AS _SystemStatusText,
  _PaymentRequest._ReversalReason AS _ReversalReason,
  _PaymentRequest._CalendarDateForCompanyCode AS _CalendarDateForCompanyCode,
  _PaymentRequest._PaymentReason AS _PaymentReason
FROM I_PaymentRequest AS _PaymentRequest
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _AccountingDocItem002 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN P_PFFPCustomerSupplierBankType AS _BankType ON PaymentRequest = _BankType.PaymentRequest  -- association [1..1]
LEFT OUTER JOIN E_PaymentRequest AS _Extension ON PaymentRequest = _Extension.PaymentRequest  -- association [1..1]
;