I_PaytReqVariantPostingData

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_PaytReqVariantPostingData.
-- 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_PaytReqVariantPostingData AS
SELECT
  var_id AS PaymentRequestVariant,
  cast(name as farp_dznme1 preserving type) AS PayeeName,
  cast(acct_hold as bu_koinh preserving type) AS BankAccountHolderName,
  cast(bank_ctry as farp_dzbnks preserving type) AS PayeeBankCountry,
  bank_key AS PayeeBankInternalID,
  cast(bank_acct as farp_bnk_com_dzbnkn preserving type) AS PayeeBankAccount,
  cast(ctrl_key as farp_bnk_com_dzbkon preserving type) AS PayeeBankControlKey,
  cast(bank_ref as farp_prq_bkref preserving type) AS BankDetailReference,
  cast(comp_code as fis_bukrs preserving type) AS CompanyCode,
  bus_area AS BusinessArea,
  cast(acct_type as financialaccounttype preserving type) AS FinancialAccountType,
  debited_acct AS CustomerSupplierAccount,
  doc_ref_txt AS DocumentItemText,
  formofaddr AS PayeeTitle,
  postl_code AS PayeePostalCode,
  po_box AS PayeePOBox,
  pobx_pcd AS POBoxPostalCode,
  cast(name_2 as farp_dznme2 preserving type) AS PayeeAdditionalName2,
  cast(name_3 as farp_dznme3 preserving type) AS PayeeAdditionalName3,
  cast(name_4 as farp_dznme4 preserving type) AS PayeeAdditionalName4,
  cast(city as farp_dzort1 preserving type) AS PayeeCityName,
  cast(street as farp_dzstra preserving type) AS PayeeStreet,
  cast(country as farp_dzland preserving type) AS PayeeCountry,
  cast(region as farp_prq_dzregi preserving type) AS PayeeRegion,
  cast(langu as farp_prq_dzspra preserving type) AS PayeeLanguage,
  cast(fax_number as farp_telfx preserving type) AS PayeeFaxNumber,
  zpayment_system AS PaymentSystem,
  zalias_type AS AliasType,
  zbank_alias AS BPBankAccountAliasName
FROM tfiblffpvar
LEFT OUTER JOIN I_Customer AS _Customer ON CustomerSupplierAccount = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON CustomerSupplierAccount = _Supplier.Supplier  -- association [1..1]
;