LAW3_UI_USMM_ENGINE_CONS_I

DDL: LAW3_UI_USMM_ENGINE_CONS_I SQL: LAW3UIENGCONI Type: view Package: SLAW3
11 Fields 1 Data Sources

LAW3.0 Engine Consolidated

LAW3_UI_USMM_ENGINE_CONS_I is a CDS View that provides data about "LAW3.0 Engine Consolidated" in SAP S/4HANA. It reads from 1 data source (law3d_engine) and exposes 11 fields with key fields datasetguid, genericid, unit, perstart, perend. Part of development package SLAW3.

Data Sources (1)

SourceAliasJoin Type
law3d_engine law3d_engine from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName LAW3UIENGCONI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label LAW3.0 Engine Consolidated view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY datasetguid datasetguid Object GUID
KEY genericid genericid Generic ID
KEY unit unit UoM
KEY perstart perstart Start Date
KEY perend perend End Date
KEY currency currency Valuation Crcy
KEY timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
appname
appunit
counter counter Version
conscounter conscounter Counter Extended

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_ENGINE_CONS_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: LAW3UIENGCONI

CREATE VIEW LAW3_UI_USMM_ENGINE_CONS_I AS
SELECT
  datasetguid,
  genericid,
  unit,
  perstart,
  perend,
  currency,
  timestamp,
  substring( law3d_engine.genericid, 11, 4 ) AS appname,
  substring( law3d_engine.unit, 7, 4 ) AS appunit,
  counter,
  conscounter
FROM law3d_engine
;

Learn More