LAW3_UI_DATASETS_I

DDL: LAW3_UI_DATASETS_I SQL: LAW3UIQDATASET Type: view Package: SLAW3
20 Fields 1 Data Sources

LAW3.0 Datasets

LAW3_UI_DATASETS_I is a CDS View that provides data about "LAW3.0 Datasets" in SAP S/4HANA. It reads from 1 data source (law3d_dataset) and exposes 20 fields with key field datasetguid. Part of development package SLAW3.

Data Sources (1)

SourceAliasJoin Type
law3d_dataset law3d_dataset from

Annotations (5)

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

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY datasetguid datasetguid Object GUID
datasetid datasetid LAW Measurement ID
status status Workflow Status
description description Well Code Des.
emailsender emailsender E-Mail Address
sendcomment sendcomment Comment
transferdate transferdate Transfer Date
transfertime transfertime Transfer Time
transfertype transfertype Transfer Type
sdccn_instno sdccn_instno Number
sdccn_reqsid sdccn_reqsid SAP System ID
nmpcomment nmpcomment Comment
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
pc_timestamp pc_timestamp Time Stamp
pc_auto_flag pc_auto_flag Boolean Variable (X = True, - = False, Space = Unknown)

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_DATASETS_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: LAW3UIQDATASET

CREATE VIEW LAW3_UI_DATASETS_I AS
SELECT
  datasetguid,
  datasetid,
  status,
  description,
  emailsender,
  sendcomment,
  transferdate,
  transfertime,
  transfertype,
  sdccn_instno,
  sdccn_reqsid,
  nmpcomment,
  crname,
  crdate,
  crtime,
  chname,
  chdate,
  chtime,
  pc_timestamp,
  pc_auto_flag
FROM law3d_dataset
;

Learn More