I_FinTransPaymentDetail

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_FinTransPaymentDetail.
-- 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_FinTransPaymentDetail AS
SELECT
  PaymentDetail.bukrs AS CompanyCode,
  PaymentDetail.rfha AS FinancialTransaction,
  cast(PaymentDetail.ssign as ftr_flow_payment_amt_direction preserving type ) AS FinTransFlowPaytAmtDirection,
  cast(PaymentDetail.waers as tb_wzbetr preserving type ) AS FinTransFlowPaytAmtCrcy,
  PaymentDetail.sbewart AS FinTransFlowType,
  PaymentDetail.spayrq AS TrsyPaytRequestIsGenerated,
  PaymentDetail.hbkid AS HouseBank,
  PaymentDetail.hktid AS HouseBankAccount,
  cast(PaymentDetail.rpcode as farp_repetitive_code preserving type ) AS PaymentRepetitiveCode,
  PaymentDetail.rpzahl AS PayerPayee,
  PaymentDetail.rpbank AS PayerPayeeBankDetail,
  PaymentDetail.uzawe AS PaymentMethodSupplement,
  PaymentDetail.sprgrd AS TreasuryPaymentRequestGrouping,
  PaymentDetail.sprsng AS TreasuryPaymentIsIndividual,
  PaymentDetail.scspay AS TrsyPaytGroupingSameDrctnIsRqd,
  PaymentDetail.lzbkz AS StateCentralBankPaymentReason,
  cast(PaymentDetail.landl as ftr_payt_supplying_country preserving type ) AS TrsyPaymentSupplyingCountry
FROM vtbzv AS PaymentDetail
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransaction AS _FinTrans ON CompanyCode = _FinTrans.CompanyCode AND FinancialTransaction = _FinTrans.FinancialTransaction  -- association [0..1]
;