UPOV_ALLOC_RESULTS_WC

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_ALLOC_RESULTS_WC.
-- 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_ALCRSLT_WC

CREATE VIEW UPOV_ALLOC_RESULTS_WC AS
SELECT
  header.alloc_run_id AS alloc_run_id,
  header.created_by AS created_by,
  header.created_tst AS created_tst,
  item.dest_node_id AS dest_node_id,
  cast(tstmp_to_dats(item.eff_from_dt,iflot.gho_pn_tz,$session.client,'NULL') as oiu_eff_from_dt) AS eff_from_dt,
  cast(tstmp_to_dats(item.eff_to_dt,iflot.gho_pn_tz,$session.client,'NULL') as oiu_eff_to_dt) AS eff_to_dt,
  cast(wl.converted_label as oiu_wl_no) AS wl_no,
  cast(wc.converted_label as oiu_wc_no) AS wc_no,
  cast(dn.converted_label as oiu_dn_no) AS dn_no,
  cast(tstmp_to_dats(dats_tims_to_tstmp(header.prod_date,header.prod_time,'UTC',$session.client,'NULL'),iflot.gho_pn_tz,$session.client,'NULL') as gho_start_date_alloc) AS prod_date,
  item.material AS material,
  item.matnr AS matnr,
  item.prd_hrs AS prd_hrs,
  item.days_prod AS days_prod,
  cast(tstmp_to_dats(dats_tims_to_tstmp(header.prod_date,header.prod_time,'UTC',$session.client,'NULL'),iflot.gho_pn_tz,$session.client,'NULL') as gho_start_date_alloc) AS invt_dt,
  uom_hrule.conv_grp AS conv_grp,
  iflot.gho_pn_tz AS gho_pn_tz
INNER JOIN gho_allocres_h AS header ON /* join condition not captured in parsed metadata */
INNER JOIN gho_allocres_i AS item ON /* join condition not captured in parsed metadata */
INNER JOIN t006 AS unit_dimension ON /* join condition not captured in parsed metadata */
INNER JOIN gho_uom_rule_h AS uom_hrule ON /* join condition not captured in parsed metadata */
INNER JOIN gho_iflot_ext AS iflot ON /* join condition not captured in parsed metadata */
INNER JOIN gho_iflot_ext AS wlwc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_nobj AS wl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_nobj AS wc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_nobj AS dn ON /* join condition not captured in parsed metadata */
;