P_FXTransactionNominal

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 P_FXTransactionNominal.
-- 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: PFXTRANSNOM

CREATE VIEW P_FXTransactionNominal AS
SELECT
  ha.rfha AS deal_number,
  wzbetr AS Currency,
  ha.bukrs AS CompanyCode,
  cast(sanlf as ftr_gen_fin_instr_prod_categ) AS FinancialInstrProductCategory,
  ha.sgsart AS FinancialInstrumentProductType,
  rportb AS portfolio,
  rcntr AS cost_center,
  ps_posid AS wbs_element,
  atpa.settlfl AS settlfl
FROM vtbfha AS ha
INNER JOIN vtbfhazu AS hazu ON /* join condition not captured in parsed metadata */
INNER JOIN vtbfhapo AS hapo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN atpa ON /* join condition not captured in parsed metadata */
INNER JOIN vtiofzu AS iofzu ON /* join condition not captured in parsed metadata */
INNER JOIN vtifha AS ifha ON /* join condition not captured in parsed metadata */
INNER JOIN vtifhazu AS ihazu ON /* join condition not captured in parsed metadata */
INNER JOIN vtifhapo AS ihapo ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): vtbfha
;