LAW3_UI_USMM_SYSTEMS_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_SYSTEMS_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: LAW3UIQSYSTEMS

CREATE VIEW LAW3_UI_USMM_SYSTEMS_I AS
SELECT
  Dataset.datasetguid AS datasetguid,
  System.systemguid AS systemguid,
  Dataset.datasetid AS datasetid,
  Dataset.status AS status,
  Dataset.description AS description,
  Dataset.emailsender AS emailsender,
  Dataset.sendcomment AS sendcomment,
  Dataset.transferdate AS transferdate,
  Dataset.transfertime AS transfertime,
  Dataset.transfertype AS transfertype,
  Dataset.sdccn_instno AS sdccn_instno,
  Dataset.sdccn_reqsid AS sdccn_reqsid,
  Dataset.nmpcomment AS nmpcomment,
  Dataset.crname AS crname,
  Dataset.crdate AS crdate,
  Dataset.crtime AS crtime,
  Dataset.chname AS chname,
  Dataset.chdate AS chdate,
  Dataset.chtime AS chtime,
  Dataset.pc_timestamp AS pc_timestamp,
  Dataset.pc_auto_flag AS pc_auto_flag,
  System.systemno AS systemno,
  System.sysid AS sysid,
  System.instno AS instno,
  System.hwkey AS hwkey,
  System.useddatabase AS useddatabase,
  System.saprelease AS saprelease,
  System.pricelist AS pricelist,
  System.resultdate AS resultdate,
  System.sysstatus AS sysstatus,
  System.measstatus AS measstatus,
  System.measuser AS measuser,
  System.measdate AS measdate,
  System.meastime AS meastime,
  System.extsystemid AS extsystemid
FROM law3d_dataset AS Dataset
INNER JOIN law3d_usmm_syst AS System ON /* join condition not captured in parsed metadata */
;