/pra/ofs_V_Transfer_Det_Pv

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_Transfer_Det_Pv.
-- 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_CDSPTR

CREATE VIEW /pra/ofs_V_Transfer_Det_Pv AS
SELECT
  doc_no,
  doc_year,
  _dtl.item_no AS item_no,
  eff_from_dt,
  _chg.bukrs AS bukrs,
  _chg.vname AS vname,
  _chg.doi_no AS doi_no,
  cast(_dtl.oown_no as /pra/dte_ofs_oown_no) AS old_own_no,
  cast(_dtl.nw_own_no as /pra/dte_ofs_nown_no) AS new_own_no,
  eff_to_dt,
  doc_type,
  _doc_typet.doc_type_de AS doc_type_nm,
  doc_desc,
  status_cd,
  cast(_status_cdt.ddtext as /pra/dte_ofs_xfer_st_nm) AS status_cd_nm,
  process_dt,
  tfch_rsn_cd,
  genr_ppa_fl,
  cast(_dtl._o_own.own_nm as /pra/dte_ofs_oown_nm) AS old_own_nm,
  cast(_dtl._nw_own.own_nm as /pra/dte_ofs_nown_nm) AS new_own_nm,
  _dtl.interest AS interest,
  _dtl.ovrd_jib_fl AS ovrd_jib_fl,
  _dtl.ovrd_pay_cd AS ovrd_pay_cd,
  _dtl.ovrd_susp_cd AS ovrd_susp_cd,
  _chg._di.doi_nm AS doi_nm
FROM /pra/ofs_V_Transfer_Hdr_Pv
;