LAW3_UI_MASTER_DATA_EXT_SYST_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_EXT_SYST_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: LAW3UIQMDEXTSYST
-- Parameters: p_language : sylangu

CREATE VIEW LAW3_UI_MASTER_DATA_EXT_SYST_C AS
SELECT
  ExtSystem.systemguid AS systemguid,
  cast('' as abap.char(30)) AS status,
  ExtSystem.systemno AS systemno,
  ExtSystem.sysid AS sysid,
  ExtSystem.instno AS instno,
  ExtSystem.extkeyfield AS extkeyfield,
  ExtSystem.extkeyvalue AS extkeyvalue,
  LAWSystem.instno AS lawinstno,
  LAWSystem.sysid AS lawsysid,
  LAWSystem.systemno AS lawsystemno,
  LAWSystem.custno AS lawcustno,
  LAWSystem.crdate AS lawcrdate,
  LAWSystem.Text AS lawtext
FROM LAW3_UI_EXTERNAL_SYSTEM_I AS ExtSystem
LEFT OUTER JOIN LAW3_UI_MASTER_DATA_SYSTEMS_C ON /* join condition not captured in parsed metadata */
;