UPOV_PR_MPAPH_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_MPAPH_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: UPOSPR_MPAPH_UOM

CREATE VIEW UPOV_PR_MPAPH_UOM AS
SELECT
  cast(mpLabel.converted_label as oiu_mp_no) AS MP_NO,
  cast(dnLabel.converted_label as oiu_dn_no) AS DN_NO,
  cast(NodeAllocRuleHeader.frequency as oiu_freq_cd) AS FREQ_CD,
  tstmp_to_dats(NodeAllocRuleHeader.valid_from, 'UTC', $session.client,'NULL') as EFF_FROM_DT AS clientNULLasEFF_FROM_DT,
  tstmp_to_dats(NodeAllocRuleHeader.valid_to, 'UTC', $session.client,'NULL') as EFF_TO_DT AS clientNULLasEFF_TO_DT,
  MappingTable.rule_id AS MPAPH_NO,
  NodeAllocRuleHeader.created_by AS OIU_CRUSER,
  NodeAllocRuleHeader.created_tst AS OIU_TIMESTAMP
FROM gho_noderule_h AS NodeAllocRuleHeader
LEFT OUTER JOIN upot_int_nobj AS mpLabel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_nobj AS dnLabel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_rule_id AS MappingTable ON /* join condition not captured in parsed metadata */
;