UPOV_PPN_SET_MP

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 UPOV_PPN_SET_MP.
-- 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: UPOS_PR_SETMP

CREATE VIEW UPOV_PPN_SET_MP AS
SELECT
  ppn_ids.set_uuid AS SET_UUID,
  cast('PR' as abap.char(2)) AS SET_AREA,
  cast(funcloclabel_dn.strno as abap.char(20)) AS DN_NO,
  tstmp_to_dats( ppa_request.change_start_period, funcloclabel_dn.pntimezone, $session.client, 'NULL') as PRCS_DT AS clientNULLasPRCS_DT,
  cast(frequency.frequency_code as oiu_freq_cd) AS FREQ_CD,
  case when ppa_request.medium = 'OIL' then '1' when ppa_request.medium = 'GAS' then '2' when ppa_request.medium = 'WATER' then '5' else '' end as MAJPD_CD AS mediumWATERthen5elseendasMAJPD_CD,
  cast('' as abap.char(4)) AS BUKRS,
  cast('' as abap.char(6)) AS VNAME,
  cast('' as abap.char(5)) AS DOI_NO,
  cast('' as abap.char(10)) AS CT_NO,
  cast('' as abap.char(15)) AS WL_NO,
  cast('' as abap.char(5)) AS WC_NO,
  cast('' as abap.char(20)) AS MP_NO,
  cast('' as abap.char(1)) AS HAS_LTXT,
  cast('' as abap.char(1)) AS VCR_DEL_FL,
  cast('' as abap.char(20)) AS VL_DOC_NO,
  cast('' as abap.numc(4)) AS VL_DOC_YEAR,
  cast('' as abap.char(32)) AS XREF_VERSION,
  cast(ppa_request.ppa_req_reason as abap.char(40)) AS COMMENTS,
  ppa_request.created_on AS ACTION_DT,
  cast(ppa_request.audit_reaon_code as abap.char(2)) AS HL_PPA_RSN_CD,
  dats_tims_to_tstmp(ppa_request.created_on, ppa_request.created_tst, 'UTC', $session.client, 'NULL') as CREATED_ON AS clientNULLasCREATED_ON,
  dats_tims_to_tstmp(ppa_request.created_on, ppa_request.created_tst, 'UTC', $session.client, 'NULL') as UPDATED_ON AS clientNULLasUPDATED_ON,
  ppa_request.requester AS CREATED_BY,
  ppa_request.requester AS UPDATED_BY
FROM gho_ppa_request AS ppa_request
LEFT OUTER JOIN UPOV_NETOBJS AS funcloclabel_dn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_ppnuuid AS ppn_ids ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gho_frequency AS frequency ON /* join condition not captured in parsed metadata */
;