LAW3_UI_USMM_ENGINES_I

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 LAW3_UI_USMM_ENGINES_I.
-- 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: LAW3UIQENGINE

CREATE VIEW LAW3_UI_USMM_ENGINES_I AS
SELECT
  Parts.datasetguid AS datasetguid,
  Parts.systemguid AS systemguid,
  Parts.partid AS partid,
  Results.unit AS unit_rslt,
  substring(Results.genericid,11,4) AS applic,
  substring(Results.unit,7,4) AS unit,
  Results.perstart AS startdate,
  Results.perend AS enddate,
  Results.counter AS counter,
  Results.currency AS currency,
  Results.timestamp AS timestamp,
  Parts.datasetid AS datasetid,
  Parts.sysid AS sysid,
  Parts.instno AS instno,
  Parts.sapclient AS sapclient,
  Parts.systemno AS systemno,
  Parts.status AS status
FROM LAW3_UI_USMM_PARTS_I AS Parts
INNER JOIN law3d_usmm_exrsl AS Results ON /* join condition not captured in parsed metadata */
INNER JOIN law3d_usmm_currl AS Results ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): LAW3_UI_USMM_PARTS_I
;