LAW3_UI_USMM_ENGINES_OLD_C

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_OLD_C.
-- 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: LAW3UIQENGINOLDC
-- Parameters: p_datasetguid : guid, p_language : sylangu

CREATE VIEW LAW3_UI_USMM_ENGINES_OLD_C AS
SELECT
  Engines.systemno AS systemno,
  Engines.instno AS instno,
  Engines.sysid AS sysid,
  Engines.sapclient AS sapclient,
  Engines.applic AS application,
  Engines.unit AS appunit,
  Unit.unitname AS unitname,
  Engines.startdate AS startdate,
  Engines.enddate AS enddate,
  Engines.counter AS counter
FROM LAW3_UI_USMM_ENGINES_OLD_I AS Engines
LEFT OUTER JOIN LAW3_UI_APPLICATIONS_I ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN LAW3_UI_APPLICATIONS_UNITS_I ON /* join condition not captured in parsed metadata */
;