LAW3_UI_USMM_SYSTEM_LIST_C

DDL: LAW3_UI_USMM_SYSTEM_LIST_C SQL: LAW3UIQSYSLIST Type: view
15 Fields 2 Data Sources

LAW3.0 Infromation system: System List

LAW3_UI_USMM_SYSTEM_LIST_C is a CDS View that provides data about "LAW3.0 Infromation system: System List" in SAP S/4HANA. It reads from 2 data sources (LAW3_UI_MEASUREMENT_STATUSES_C, LAW3_UI_USMM_SYSTEMS_I) and exposes 15 fields with key field systemno.

Data Sources (2)

SourceAliasJoin Type
LAW3_UI_MEASUREMENT_STATUSES_C LAW3_UI_MEASUREMENT_STATUSES_C left_outer
LAW3_UI_USMM_SYSTEMS_I Systems from

Parameters (2)

NameTypeDefault
p_datasetguid guid
p_language sylangu

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName LAW3UIQSYSLIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label LAW3.0 Infromation system: System List view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY systemno LAW3_UI_USMM_SYSTEMS_I systemno System Number
instno LAW3_UI_USMM_SYSTEMS_I instno Inst. Number
sysid LAW3_UI_USMM_SYSTEMS_I sysid System ID
sysstatus LAW3_UI_USMM_SYSTEMS_I sysstatus System status
saprelease LAW3_UI_USMM_SYSTEMS_I saprelease SAP Release
measdate LAW3_UI_USMM_SYSTEMS_I measdate Measurement date
meastime LAW3_UI_USMM_SYSTEMS_I meastime Measurement Time
measuser LAW3_UI_USMM_SYSTEMS_I measuser Measured By
status LAW3_UI_USMM_SYSTEMS_I status Workflow Status
resultdate LAW3_UI_USMM_SYSTEMS_I resultdate Date
useddatabase LAW3_UI_USMM_SYSTEMS_I useddatabase Database system
pricelist LAW3_UI_USMM_SYSTEMS_I pricelist Pricelist
measstatus LAW3_UI_USMM_SYSTEMS_I measstatus Status
text Status text User Group
extsystemid LAW3_UI_USMM_SYSTEMS_I extsystemid Ext. Syst. ID

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_SYSTEM_LIST_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: LAW3UIQSYSLIST
-- Parameters: p_datasetguid : guid, p_language : sylangu

CREATE VIEW LAW3_UI_USMM_SYSTEM_LIST_C AS
SELECT
  Systems.systemno AS systemno,
  Systems.instno AS instno,
  Systems.sysid AS sysid,
  Systems.sysstatus AS sysstatus,
  Systems.saprelease AS saprelease,
  Systems.measdate AS measdate,
  Systems.meastime AS meastime,
  Systems.measuser AS measuser,
  Systems.status AS status,
  Systems.resultdate AS resultdate,
  Systems.useddatabase AS useddatabase,
  Systems.pricelist AS pricelist,
  Systems.measstatus AS measstatus,
  Status.text AS text,
  Systems.extsystemid AS extsystemid
FROM LAW3_UI_USMM_SYSTEMS_I AS Systems
LEFT OUTER JOIN LAW3_UI_MEASUREMENT_STATUSES_C ON /* join condition not captured in parsed metadata */
;

Learn More