LAW3_UI_DATASETS_C

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_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: LAW3UIQDATASETS
-- Parameters: p_language : sylangu

CREATE VIEW LAW3_UI_DATASETS_C AS
SELECT
  Dataset.datasetguid AS datasetguid,
  Dataset.crdate AS crdate,
  Dataset.datasetid AS datasetid,
  Status.text AS text,
  Dataset.status AS status,
  Dataset.crname AS crname,
  Dataset.description AS description,
  Dataset.chname AS chname,
  Dataset.emailsender AS emailsender,
  Dataset.sendcomment AS sendcomment,
  Dataset.transferdate AS transferdate,
  Dataset.transfertime AS transfertime,
  Dataset.transfertype AS transfertype,
  TransType.Transfertext AS Transfertext,
  SDCCN.Transferstatustext AS Transferstatustext,
  Dataset.crtime AS crtime,
  Dataset.chdate AS chdate,
  Dataset.chtime AS chtime
FROM LAW3_UI_DATASETS_I AS Dataset
LEFT OUTER JOIN LAW3_UI_DATASET_STATUSES_C ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN LAW3_UI_EXT_ATTR_STATUSES_C ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN LAW3_UI_TRANSFER_TYPE_C ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN LAW3_UI_TRANSFER_SDCCN_STAT_C ON /* join condition not captured in parsed metadata */
;