P_SM_SelectionCriteria

DDL: P_SM_SELECTIONCRITERIA SQL: PSMSELCRITDATA Type: view
11 Fields 1 Data Sources

Schedule Manager selection criteria data

P_SM_SelectionCriteria is a CDS View that provides data about "Schedule Manager selection criteria data" in SAP S/4HANA. It reads from 1 data source (smselkrit) and exposes 11 fields with key field id.

Data Sources (1)

SourceAliasJoin Type
smselkrit smselkrit from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PSMSELCRITDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Schedule Manager selection criteria data view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
structure structure Structure ID
field field Logical Field
entry entry INT4
logsys logsys Source system
idtype idtype Type
sign sign Type of SIGN component in row type of a Ranges type
optio optio Option
low low Value from
high high Value up to
type type Worklist Type

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 P_SM_SelectionCriteria.
-- 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: PSMSELCRITDATA

CREATE VIEW P_SM_SelectionCriteria AS
SELECT
  id,
  structure,
  field,
  entry,
  logsys,
  idtype,
  sign,
  optio,
  low,
  high,
  type
FROM smselkrit
;

Learn More