LAW3_UI_USMM_COMPONENTS_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_COMPONENTS_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: LAW3UIQCOMPONENT

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