P_UtilitiesScheduleSimulation

DDL: P_UTILITIESSCHEDULESIMULATION SQL: PSCHEADER Type: view BASIC

P_UtilitiesScheduleSimulation is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (tisu_sc_simhead) and exposes 11 fields.

Data Sources (1)

SourceAliasJoin Type
tisu_sc_simhead tisu_sc_simhead from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSCHEADER view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
check_id check_id Question Check ID
date_from date_from Validity Start Date
date_to date_to Validity End Date
created_on created_on Variant created on
created_by created_by Version Created By
changed_on changed_on Variant Changed on
changed_by changed_by User Name
approved_on approved_on Approved On
approved_by approved_by Step Completed By
rejected rejected Rejected
description description Well Code Des.

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_UtilitiesScheduleSimulation.
-- 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: PSCHEADER

CREATE VIEW P_UtilitiesScheduleSimulation AS
SELECT
  check_id,
  date_from,
  date_to,
  created_on,
  created_by,
  changed_on,
  changed_by,
  approved_on,
  approved_by,
  rejected,
  description
FROM tisu_sc_simhead
;