UPOV_WLTST_MEDOC

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_WLTST_MEDOC.
-- 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_WLTST_MEDOC

CREATE VIEW UPOV_WLTST_MEDOC AS
SELECT
  wltst.wl_docnr AS DOCNR,
  wltst.wl_docyr AS DOCYR,
  cast('WELL_TEST' as oiu_me_mecls) AS MECLS,
  cast('WC_WTSTD' as oiu_me_metyp) AS METYP,
  cast(' ' as oiu_me_objnr) AS OBJNR,
  cast('WCMP' as oiu_me_mesrc) AS MESRC,
  cast( well_test.WL_NO as oiu_me_srcky) AS SRCKY,
  wltst.wctst_no AS SRC_DOCNR,
  wltst.doc_year AS SRC_DOCYR,
  cast('NA1' as oiu_me_uomgr) AS UOMGR,
  um_rule.conv_grp AS UMRSL,
  wltst.doc_year AS MEAYR,
  cast(right(left(tstmp_to_dats(well_prior.start_timestamp, 'UTC', $session.client,'NULL'),6) , 2) as oiu_me_meapd) as MEAPD AS clientNULL62asoiu_me_meapdasMEAPD,
  cast (dats_tims_to_tstmp(tstmp_to_dats(well_prior.start_timestamp,'UTC', $session.client,'NULL'), cast('000000' as abap.tims),'UTC', $session.client,'NULL') as oiu_me_meats) as MEATS AS clientNULLasoiu_me_meatsasMEATS,
  case when well_prior.changed_by is not null then 'X' end as XCHNG AS changed_byisnotnullthenXendasXCHNG,
  cast(' ' as oiu_me_xdelt) AS XDELT,
  well_test.OIU_CRUSER AS OIU_CRUSER,
  well_test.OIU_TIMESTAMP AS OIU_TIMESTAMP
FROM upot_int_wltest AS wltst
INNER JOIN UPOV_PR_WELLTEST_UOM AS well_test ON /* join condition not captured in parsed metadata */
INNER JOIN gho_well_prior AS well_prior ON /* join condition not captured in parsed metadata */
INNER JOIN gho_uom_rule_h AS um_rule ON /* join condition not captured in parsed metadata */
;