UPOV_PR_MPVL_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_MPVL_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_MPVL_UOM

CREATE VIEW UPOV_PR_MPVL_UOM AS
SELECT
  mpvl.mpvl_no AS MPVL_NO,
  mpvl.mpvl_year AS MPVL_YEAR,
  cast(mpLabel.converted_label as oiu_mp_no) AS MP_NO,
  vtqt.vol_type AS VT_CD,
  cast('A' as oiu_vc_cd) AS VC_CD,
  stdh.trnsp_no AS TRNSP_NO,
  stdh.trnsp_ref_no AS TRNSP_REF_NO,
  stdh.alloc_material AS MATNR,
  cast(stdh.frequency as oiu_freq_cd) AS FREQ_CD,
  cast(dnLabel.converted_label as oiu_dn_no) AS DN_NO,
  cast(' ' as oiu_trnsp_mth_cd) AS TRNSP_MTH_CD,
  cast(' ' as oiu_ct_no) AS CT_NO,
  cast(stdh.tkt_no as oiu_tkt_no) AS TKT_NO,
  case stdh.tkt_no when '' then cast('0' as oiu_tkt_timestmp) else dats_tims_to_tstmp( imrge.idate, imrge.itime,'UTC' , $session.client, 'NULL' ) end as TKT_TIMESTAMP AS clientNULLendasTKT_TIMESTAMP,
  cast( case stdh.frequency when 'Y' then concat(concat(left(tstmp_to_dats(stdh.prod_timestamp,iflot.gho_pn_tz,$session.client,'NULL'),4),'12'),'31') when 'M' then dats_add_days(dats_add_months(cast( concat(left(tstmp_to_dats(stdh.prod_timestamp,iflot.gho_pn_tz,$session.client,'NULL'), 6), '01') as abap.dats),1, 'UNCHANGED'),-1, 'UNCHANGED') else tstmp_to_dats(stdh.prod_timestamp,iflot.gho_pn_tz,$session.client,'NULL') end as oiu_prd_dt) as PRD_DT AS clientNULLendasoiu_prd_dtasPRD_DT,
  stdh.created_tst AS ENT_TIMESTAMP,
  imrge.idate AS EFF_FROM_DT,
  cast( case stdh.frequency when 'D' then imrge.idate when 'Y' then concat(concat(left(imrge.idate,4),'12'),'31') when 'M' then dats_add_days(dats_add_months(cast( concat(left(imrge.idate, 6), '01') as abap.dats),1, 'UNCHANGED'),-1, 'UNCHANGED') else imrge.idate end as oiu_eff_to_dt) as EFF_TO_DT AS idateendasoiu_eff_to_dtasEFF_TO_DT,
  dats_tims_to_tstmp(imrge.idate, cast('000000' as abap.tims), 'UTC', $session.client, 'NULL') as METER_START AS clientNULLasMETER_START,
  dats_tims_to_tstmp(cast( case stdh.frequency when 'D' then imrge.idate when 'Y' then concat(concat(left(imrge.idate,4),'12'),'31') when 'M' then dats_add_days(dats_add_months(cast( concat(left(imrge.idate, 6), '01') as abap.dats),1, 'UNCHANGED'),-1, 'UNCHANGED') else imrge.idate end as abap.dats), cast('235959' as abap.tims), 'UTC', $session.client, 'NULL') as METER_STOP AS clientNULLasMETER_STOP,
  StandardVolume.ConversionGroup AS CONV_GRP,
  cast(' ' as oiu_tkbtry_mp_no) AS TKBTRY_MP_NO,
  cast('1' as oiu_vs_cd) AS VS_CD,
  vcqc.vol_cat AS VL_CAT_CD,
  cast(' ' as oiu_ld_oil_dn_no) AS LD_OIL_DN_NO,
  cast(' ' as oiu_ld_oil_wl_no) AS LD_OIL_WL_NO,
  cast(' ' as oiu_ld_oil_wc_no) AS LD_OIL_WC_NO,
  cast(' ' as oiu_ld_oil_mp_no) AS LD_OIL_MP_NO,
  cast(StandardVolume.StdVolume as abap.quan( 13, 3 )) AS STD_VOL,
  StandardVolume.Unit AS STD_VOL_U,
  cast(StandardEnergy.StdVolume as abap.quan( 13, 3 )) AS ENERGY,
  StandardEnergy.Unit AS ENERGY_U,
  cast('0' as oiu_mol_volume) AS MOL_VOLUME,
  cast(StandardHvalue.StdVolume as abap.quan( 13, 3 )) AS HEAT_VAL,
  StandardHvalue.Unit AS HEAT_VAL_U,
  cast(StandardDensity.StdVolume as oiu_bdich) AS BASE_DENSITY,
  cast(StandardDensity.Unit as oiu_bdneh) AS BASE_DENSITY_U,
  cast(' ' as oiu_dntyp) AS DENTYP,
  cast(' ' as oiu_rec_type_cd) AS REC_TYPE_CD,
  cast(' ' as oiu_edi_sts_cd) AS EDI_STS_CD,
  cast(mpvl.me_docnr as oiu_me_docnr) AS ME_DOCNR,
  cast(mpvl.me_docyr as oiu_me_docyr) AS ME_DOCYR,
  cast(' ' as oiu_orig_mp_no) AS ORIG_MP_NO,
  cast( case stdh.frequency when 'D' then imrge.idate when 'Y' then concat(concat(left(imrge.idate,4),'12'),'31') when 'M' then dats_add_days(dats_add_months(cast( concat(left(imrge.idate, 6), '01') as abap.dats),1, 'UNCHANGED'),-1, 'UNCHANGED') else imrge.idate end as oiu_inv_dt) as INVT_DT AS idateendasoiu_inv_dtasINVT_DT,
  stdh.created_by AS OIU_CRUSER,
  stdh.created_tst AS OIU_TIMESTAMP,
  cast(' ' as oiu_ld_oil_wo_recov) AS LD_OIL_WO_RECOV
FROM upot_int_mpvnqci AS mpvl
INNER JOIN gho_imrg_std_h AS stdh 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 upot_int_nobj AS dnLabel ON /* join condition not captured in parsed metadata */
INNER JOIN upot_int_nobj AS mpLabel ON /* join condition not captured in parsed metadata */
INNER JOIN upoc_udm_vtqt_mp AS vtqt 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 */
INNER JOIN gho_imrg_ext AS imrge ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPO_INT_V_STD_VOL_DIM AS StandardVolume ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPO_INT_V_STD_VOL_DIM AS StandardEnergy ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPO_INT_V_STD_VOL_DIM AS StandardHvalue ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN UPO_INT_V_STD_VOL_DIM AS StandardDensity ON /* join condition not captured in parsed metadata */
;