LAW3_UI_USMM_ENGINES_C

DDL: LAW3_UI_USMM_ENGINES_C SQL: LAW3UIQENGNS Type: view
11 Fields 3 Data Sources

LAW3.0 Infromation system: Engines

LAW3_UI_USMM_ENGINES_C is a CDS View that provides data about "LAW3.0 Infromation system: Engines" in SAP S/4HANA. It reads from 3 data sources (LAW3_UI_USMM_ENGINES_I, LAW3_UI_APPLICATIONS_I, LAW3_UI_APPLICATIONS_UNITS_I) and exposes 11 fields with key fields systemno, instno, sysid, sapclient, application.

Data Sources (3)

SourceAliasJoin Type
LAW3_UI_USMM_ENGINES_I Engines from
LAW3_UI_APPLICATIONS_I LAW3_UI_APPLICATIONS_I left_outer
LAW3_UI_APPLICATIONS_UNITS_I LAW3_UI_APPLICATIONS_UNITS_I left_outer

Parameters (2)

NameTypeDefault
p_datasetguid guid
p_language sylangu

Annotations (5)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY systemno LAW3_UI_USMM_ENGINES_I systemno System Number
KEY instno LAW3_UI_USMM_ENGINES_I instno Inst. Number
KEY sysid LAW3_UI_USMM_ENGINES_I sysid System ID
KEY sapclient LAW3_UI_USMM_ENGINES_I sapclient Client ID
KEY application LAW3_UI_USMM_ENGINES_I applic SSL Client Identity
KEY appunit LAW3_UI_USMM_ENGINES_I unit UoM
unitname Unit unitname Unit
startdate LAW3_UI_USMM_ENGINES_I startdate Valid From
enddate LAW3_UI_USMM_ENGINES_I enddate Term to
counter LAW3_UI_USMM_ENGINES_I counter Version
currency LAW3_UI_USMM_ENGINES_I currency Valuation Crcy

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_ENGINES_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: LAW3UIQENGNS
-- Parameters: p_datasetguid : guid, p_language : sylangu

CREATE VIEW LAW3_UI_USMM_ENGINES_C AS
SELECT
  Engines.systemno AS systemno,
  Engines.instno AS instno,
  Engines.sysid AS sysid,
  Engines.sapclient AS sapclient,
  Engines.applic AS application,
  Engines.unit AS appunit,
  Unit.unitname AS unitname,
  Engines.startdate AS startdate,
  Engines.enddate AS enddate,
  Engines.counter AS counter,
  Engines.currency AS currency
FROM LAW3_UI_USMM_ENGINES_I AS Engines
LEFT OUTER JOIN LAW3_UI_APPLICATIONS_I ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN LAW3_UI_APPLICATIONS_UNITS_I ON /* join condition not captured in parsed metadata */
;

Learn More