LAW3_UI_MASTER_DATA_SYSTEMS_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_MASTER_DATA_SYSTEMS_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: LAW3UIQMDSYSTEM
-- Parameters: p_language : sylangu

CREATE VIEW LAW3_UI_MASTER_DATA_SYSTEMS_C AS
SELECT
  System.systemguid AS systemguid,
  System.instno AS instno,
  System.sysid AS sysid,
  SystemStatus.Text AS Text,
  MeasStatus.text AS Measurerelevant,
  System.description AS description,
  System.custno AS custno,
  System.systemno AS systemno,
  System.uisystemid AS uisystemid,
  System.language AS language,
  System.useddatabase AS useddatabase,
  System.saprelease AS saprelease,
  System.sysstatus AS sysstatus,
  System.systemprod AS systemprod,
  System.systempvers AS systempvers,
  System.rslawplugin AS rslawplugin,
  System.systemcdate AS systemcdate,
  System.instlocation AS instlocation,
  System.instcontact AS instcontact,
  System.localsystem AS localsystem,
  System.extsystemid AS extsystemid,
  System.crname AS crname,
  System.crdate AS crdate,
  System.crtime AS crtime,
  System.chname AS chname,
  System.chdate AS chdate,
  System.chtime AS chtime
FROM LAW3_UI_SYSTEM_I AS System
LEFT OUTER JOIN LAW3_UI_SYSTEM_MEASURE_STAT_C ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN LAW3_UI_SH_SYSTEM_STATUS_C AS SystemStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN LAW3_UI_NOMEASURE_REASON_I ON /* join condition not captured in parsed metadata */
;