UPOV_PR_MPAPD_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_MPAPD_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_MPAPD_UOM

CREATE VIEW UPOV_PR_MPAPD_UOM AS
SELECT
  cast(MPAllocNr.rule_id as oiu_mpaph_no) AS MPAPH_NO,
  cast(VolumeType.vol_type as oiu_vl_type_cd) AS VT_CD,
  cast(NodeAllocRuleItem.alloc_material as matnr) AS MATNR,
  case when NodeAllocRuleItem.qty_reqd = '02' then '1' when NodeAllocRuleItem.qty_reqd = '01' then '2' when NodeAllocRuleItem.qty_reqd = '03' then '6' else '' end as VLI_CD AS qty_reqd03then6elseendasVLI_CD,
  cast(NodeAllocRuleItem.custom_calc_id as oiu_pr_frml_no) AS FRML_NO,
  cast(NodeAllocRuleHeader.created_by as ernam) AS OIU_CRUSER,
  cast(NodeAllocRuleHeader.created_tst as tzntstmps) AS OIU_TIMESTAMP
FROM gho_noderule_h AS NodeAllocRuleHeader
LEFT OUTER JOIN gho_noderule_i AS NodeAllocRuleItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upoc_udm_vtqt_mp AS VolumeType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_rule_id AS MPAllocNr ON /* join condition not captured in parsed metadata */
;