I_TreasuryPaymentRequest

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_TreasuryPaymentRequest.
-- 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_TreasuryPaymentRequest AS
SELECT
  payment.company_code AS PaymentCompanyCode,
  cast(payment.prq_keyno as ftr_gen_payment_request) AS PaymentRequest,
  cast(payment.payment_awkey as ftr_gen_payment_req_ref_key) AS PaytReqOriglReferenceDocument,
  cast(payment.bustransid as ftr_gen_business_transaction) AS TreasuryBusinessTransaction,
  payment.valuation_area AS TreasuryValuationArea,
  payment.flow_number AS TreasuryTransactionFlow,
  payment.belnr AS AccountingDocument,
  payment.posting_year AS FiscalYear,
  payment.payment_curr AS PaymentCurrency,
  payment.payment_amt AS AmountInPaymentCurrency,
  payment.payment_date AS PaymentDate,
  payment.sprsng AS TreasuryIndividualPayment,
  payment.scspay AS TrsyPaytGroupingSameDrctnIsRqd,
  payment.sign AS TreasuryPaymentFlowDirection,
  cast(payment.sprgrd as ftr_gen_payment_grouping) AS TreasuryPaymentRequestGrouping,
  cast(_PaymentGroupingDefinitionText.ddtext as ftr_gen_payment_grouping_name) AS TrsyPaytRequestGroupingName,
  cast(payment.paygr as ftr_gen_payreq_group_field) AS PaymentRequestPaymentGroup,
  payment.house_bank AS HouseBank,
  payment.house_bank_acc AS HouseBankAccount,
  payment.rpzahl AS PayerPayee,
  cast (_PayerPayee.PayerPayeeFullName as ftr_gen_payerpayee_full_name) AS PayerPayeeFullName,
  payment.rpbank AS BPBankAccountInternalID,
  payment.zwels AS ConsideredPaymentMethods,
  cast(payment.rpcode as ftr_gen_pymnt_req_add_instruct) AS PaytReqAdditionalInstructions,
  cast(payment.rp_text as ftr_gen_pymnt_req_add_ins_name) AS PaytReqAddlInstructionsName,
  payment.kunnr AS Customer,
  payment.lifnr AS Supplier,
  payment.gl_account AS GLAccount,
  payment.clearing_acc AS BankClearingGLAccount,
  cast(payment.reversal_date as ftr_gen_reversal_date) AS ReverseDocumentPostingDate,
  cast(payment.release_state as ftr_gen_payment_req_rel_status) AS TrsyPaytRequestReleaseStatus,
  cast(_PaymentRequestRelStatusText.ddtext as ftr_gen_pymnt_req_rel_st_name) AS TrsyPaytRequestRelStatusName,
  cast(payment.payment_state as ftr_gen_pymnt_req_status) AS TreasuryPaymentRequestStatus,
  cast(_PaymentRequestStatusText.ddtext as ftr_gen_pymnt_req_status_name) AS TrsyPaymentRequestStatusName,
  payment.sgtxt AS JournalEntryItemText,
  cast(payment.swift_text as ftr_gen_payrq_item_add_text ) AS TrsyPaytReqItemAdditionalText,
  payment.dtaws AS DataExchangeInstructionKey,
  payment.payment_reason AS PaymentReason,
  payment.position_oid AS TrsyPositionContextUUID
FROM trprt_payments AS payment
LEFT OUTER JOIN I_Housebank AS _HouseBank ON payment.company_code = _HouseBank.CompanyCode AND payment.house_bank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON payment.company_code = _HouseBankAccountText.CompanyCode AND payment.house_bank = _HouseBankAccountText.HouseBank AND payment.house_bank_acc = _HouseBankAccountText.HouseBankAccount AND _HouseBankAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON payment.lifnr = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON payment.kunnr = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_TrsyAcctItemPositionContext AS _TrsyAcctItemPosContext ON payment.position_oid = _TrsyAcctItemPosContext.TrsyPositionContextUUID  -- association [0..1]
;