UPO_INT_V_ALLOC_DATA

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 UPO_INT_V_ALLOC_DATA.
-- 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_ALLOC_DATA
-- Parameters: P_ALLOC_RUN_ID : gho_alloc_run_id

CREATE VIEW UPO_INT_V_ALLOC_DATA AS
SELECT
  item_res.alloc_run_id AS alloc_run_id,
  item_res.wcdvlh_no AS wcdvlh_no,
  header_res.netid AS netid,
  header_res.medium AS medium,
  item_res.dest_node_id AS dest_node_id,
  mpLabel.converted_label AS origin_mp_no,
  wlwc.gho_wc_ref_id AS well_floc,
  wlLabel.converted_label AS wl_no,
  wcLabel.converted_label AS wc_no,
  dnLabel.converted_label AS dn_no,
  tstmp_to_dats(item_res.eff_from_dt,iflot.gho_pn_tz,$session.client,'NULL') AS eff_from_dt,
  tstmp_to_dats(item_res.eff_to_dt,iflot.gho_pn_tz,$session.client,'NULL') AS eff_to_dt,
  tstmp_to_dats(dats_tims_to_tstmp(header_res.prod_date,header_res.prod_time,'UTC',$session.client,'NULL'),iflot.gho_pn_tz,$session.client,'NULL') AS prod_date,
  dats_tims_to_tstmp(header_res.prod_date,header_res.prod_time,'UTC',$session.client,'NULL') AS prod_tstmp,
  uom_irule.dimension AS dimension,
  header_res.frequency AS frequency,
  item_res.material AS material,
  item_res.matnr AS matnr,
  item_res.qty_type AS qty_type,
  item_res.qty_category AS qty_category,
  item_res.prd_hrs AS prd_hrs,
  vtqt.vol_type AS vol_type,
  vcqc.vol_cat AS vol_cat,
  uom_hrule.conv_grp AS CONV_GRP,
  item_res.theo_act_ind AS theo_act_ind,
  item_res.unit AS unit,
  item_res.volume AS std_vol,
  theo.unit AS theo_unit,
  theo.volume AS theo_val,
  theo_g.volume AS theo_g_vol,
  ReceiptMeter.volume AS glg_vol,
  ReceiptMeter.theo_act_ind AS theo_g_ind,
  item_res.tkt_no AS TKT_NO,
  item_res.tkt_timestamp AS TKT_TIMESTAMP,
  item_res.trnsp_no AS trnsp_no,
  item_res.trnsp_ref_no AS trnsp_ref_no,
  item_res.invt_dt AS INVT_DT,
  xwlLabel.tplnr AS xref_wl_no,
  xwcLabel.tplnr AS xref_wc_no,
  item_res.orig_no AS ORIG_NO,
  item_res.orig_doc_year AS ORIG_DOC_YEAR,
  iflot.gho_pn_tz AS gho_pn_tz
FROM gho_allocres_h AS header_res
INNER JOIN gho_allocres_i AS item_res ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gho_allocres_i AS theo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gho_allocres_i AS theo_g ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gho_allocres_i AS ReceiptMeter 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_disposition AS dispo ON /* join condition not captured in parsed metadata */
INNER JOIN upots_udm_vcqc AS vcqc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upoc_udm_vtqt_mp AS vtqt ON /* join condition not captured in parsed metadata */
INNER JOIN gho_uom_rule_i AS uom_irule 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 mpLabel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_nobj AS wlLabel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_nobj AS wcLabel 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_nobj AS xwlLabel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_nobj AS xwcLabel ON /* join condition not captured in parsed metadata */
;