LAW3_UI_SYSTEM_I

DDL: LAW3_UI_SYSTEM_I SQL: LAW3UIQSYST Type: view
25 Fields 1 Data Sources

LAW3.0 System

LAW3_UI_SYSTEM_I is a CDS View that provides data about "LAW3.0 System" in SAP S/4HANA. It reads from 1 data source (law3d_system) and exposes 25 fields with key field systemguid.

Data Sources (1)

SourceAliasJoin Type
law3d_system law3d_system from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName LAW3UIQSYST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label LAW3.0 System view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY systemguid systemguid GUID
systemno systemno System Number
custno custno Customer Number
sysid sysid System ID
instno instno Inst. Number
uisystemid uisystemid LAW System ID
description description Well Code Des.
language language Report Text Language
useddatabase useddatabase Database system
saprelease saprelease SAP Release
sysstatus sysstatus System status
systemprod systemprod System Product
systempvers systempvers Product Version
rslawplugin rslawplugin Program Name
systemcdate systemcdate Created On
instlocation instlocation Location
instcontact instcontact Contact Person
localsystem localsystem
extsystemid extsystemid Ext. Syst. ID
crname crname Last Changed By
crdate crdate Sizing Date
crtime crtime Time Created
chname chname Changed By
chdate chdate Date Changed
chtime chtime Time Changed

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_SYSTEM_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: LAW3UIQSYST

CREATE VIEW LAW3_UI_SYSTEM_I AS
SELECT
  systemguid,
  systemno,
  custno,
  sysid,
  instno,
  uisystemid,
  description,
  language,
  useddatabase,
  saprelease,
  sysstatus,
  systemprod,
  systempvers,
  rslawplugin,
  systemcdate,
  instlocation,
  instcontact,
  localsystem,
  extsystemid,
  crname,
  crdate,
  crtime,
  chname,
  chdate,
  chtime
FROM law3d_system
;

Learn More