/pra/ofs_V_Legacy_Owner

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 /pra/ofs_V_Legacy_Owner.
-- 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: /PRA/OFS_CDS_BA

CREATE VIEW /pra/ofs_V_Legacy_Owner AS
SELECT
  ba_ba_no,
  ba_seq_no,
  address_key AS own_no,
  bukrs,
  _cocd.waers AS waers,
  _vendor.land1 AS land1,
  _vendor.name1 AS own_nm,
  _vendor.name2 AS name2,
  _vendor.ort01 AS ort01,
  _vendor.pstlz AS pstlz,
  _vendor.regio AS regio,
  _vendor.stras AS stras,
  _vendor.adrnr AS adrnr,
  _vendor.anred AS anred,
  _vendor.ktokk AS ktokk,
  _vendor.kunnr AS kunnr,
  _vendor.telf1 AS telf1,
  _vendor.telf2 AS telf2,
  _vendor.telfx AS telfx
FROM oiuh_cm_ba
LEFT OUTER JOIN lfa1 AS _vendor ON _vendor.lifnr = own_no  -- association [0..1]
LEFT OUTER JOIN t001 AS _cocd ON _cocd.bukrs = bukrs  -- association [0..1]
;