/pra/ofs_V_Owner_Leg_Chk_Dtl

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_Owner_Leg_Chk_Dtl.
-- 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_LCD

CREATE VIEW /pra/ofs_V_Owner_Leg_Chk_Dtl AS
SELECT
  bukrs,
  _leg_chk_hdr.cr_ck_no AS cr_ck_no,
  _leg_chk_hdr.cr_ck_sts_cd AS cr_ck_sts_cd,
  waers,
  chd_trans_am,
  chd_trans_qy,
  chd_pd_cd,
  chd_ck_no,
  chd_grv_qy,
  own_no,
  own_nm,
  concat(own_no, concat('/',own_nm)) AS owner,
  vname,
  doi_no,
  _di.doi_nm AS doi_nm,
  concat(vname,concat('/',concat(doi_no, concat('/',_di.doi_nm)))) AS venture_doi,
  wl_no,
  wc_no,
  _wc.name AS wc_nm,
  concat(wl_no, concat('/',concat(wc_no, concat('/',_wc.name)))) AS well,
  chd_sa_dt,
  chd_rej_fl
FROM /pra/ofs_V_Legacy_Chk_Dtl_Pv
LEFT OUTER JOIN oiu_do_di AS _di ON bukrs = _di.bukrs AND vname = _di.vname AND doi_no = _di.doi_no  -- association [0..1]
LEFT OUTER JOIN oiu_pr_wc AS _wc ON _wc.wl_no = wl_no AND _wc.wc_no = wc_no  -- association [0..1]
;