UPOV_PR_MPVD_UOM

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_PR_MPVD_UOM.
-- 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_MPVD_UOM

CREATE VIEW UPOV_PR_MPVD_UOM AS
SELECT
  cast(meas_point.converted_label as oiu_mp_no ) AS MP_NO,
  tstmp_to_dats(net_obj_vdata.effective_from, 'UTC', $session.client,'NULL') as EFF_FROM_DT AS clientNULLasEFF_FROM_DT,
  tstmp_to_dats(net_obj_vdata.effective_to, 'UTC', $session.client,'NULL') as EFF_TO_DT AS clientNULLasEFF_TO_DT,
  cast(' ' as oib_hvcls) AS HVCLS,
  cast(' ' as oiu_crud_type_cd) AS CRUD_TYPE_CD,
  cast(' ' as oiu_sa_pt_fl) AS SA_PT_FL,
  cast(' ' as oiu_inactive_fl) AS INACTIVE_FL,
  net_obj_vdata.op_fl AS OP_FL,
  cast(' ' as oiu_sat_dry_cd) AS SAT_DRY_CD,
  cast(' ' as oiu_intra_nwk_fl) AS INTRA_NWK_FL,
  cast(' ' as oiu_plt_inlet_fl) AS PLT_INLET_FL,
  cast(' ' as oiu_strm_type_cd) AS STRM_TYPE_CD,
  cast(' ' as oiu_strm_dflt_fl) AS STRM_DFLT_FL,
  net_obj_vdata.rlf_usage_fl_mtr AS RLF_USAGE_FL,
  net_obj_vdata.bukrs AS COMPANY_CODE,
  net_obj_vdata.cost_centre AS COST_CENTER,
  cast(' ' as oiu_chrt_typ_cd) AS CHRT_TYP_CD,
  functional_loc.ernam AS OIU_CRUSER,
  dats_tims_to_tstmp(functional_loc.erdat, cast('000000' as abap.tims), 'UTC', $session.client,'NULL') as OIU_TIMESTAMP AS clientNULLasOIU_TIMESTAMP,
  cast('00' as oiu_pipl_open_pd) AS PIPL_OPEN_PD
FROM upot_udm_no_vd AS net_obj_vdata
LEFT OUTER JOIN upot_int_nobj AS meas_point ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN iflot AS functional_loc ON /* join condition not captured in parsed metadata */
;