/pf1/P_DB_OL

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 /pf1/P_DB_OL.
-- 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: /PF1/PV_OL_MGMT

CREATE VIEW /pf1/P_DB_OL AS
SELECT
  /pf1/db_olist.guid AS guid,
  /pf1/db_olist.ol_date AS ol_date,
  /pf1/db_olist.ol_no AS ol_no,
  /pf1/db_olist.ol_type AS ol_type,
  /pf1/db_olist.ref_ext AS ref_ext,
  /pf1/db_olist.ref_any_1 AS ref_any_1,
  /pf1/db_olist.ref_any_2 AS ref_any_2,
  /pf1/db_olist.ref_any_3 AS ref_any_3,
  /pf1/db_olist.ref_any_4 AS ref_any_4,
  /pf1/db_olist.ref_any_5 AS ref_any_5,
  /pf1/db_olist.disp_stat AS disp_stat,
  /pf1/db_olist.medium AS medium,
  /pf1/db_olist.channel AS channel,
  /pf1/db_olist.bulk_type AS bulk_type,
  /pf1/db_olist.ref_ext_no AS ref_ext_no,
  /pf1/db_olist.ref_ext_id AS ref_ext_id,
  /pf1/db_olist.laufd AS laufd,
  /pf1/db_olist.laufi AS laufi,
  /pf1/db_olist.tech_stat AS tech_stat,
  /pf1/db_olist.cnt_objects AS cnt_objects,
  /pf1/db_olist.fh_end_date AS fh_end_date,
  /pf1/db_olist.fh_end_time AS fh_end_time,
  /pf1/db_olist.crusr AS crusr,
  /pf1/db_olist.crdat AS crdat,
  /pf1/db_olist.crtim AS crtim,
  /pf1/db_olist.chusr AS chusr,
  /pf1/db_olist.chdat AS chdat,
  /pf1/db_olist.chtim AS chtim,
  /pf1/db_olist.rlusr AS rlusr,
  /pf1/db_olist.rldat AS rldat,
  /pf1/db_olist.rltim AS rltim,
  /pf1/db_olist.archive_flud AS archive_flud,
  /pf1/db_olist.rejection AS rejection
FROM /pf1/db_olist
;