P_SavedSimulation_Draft

DDL: P_SAVEDSIMULATION_DRAFT SQL: PSAVEDSIMDRFT Type: view BASIC
19 Fields 1 Data Sources

P_SavedSimulation_Draft is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (vch_sim_draft) and exposes 19 fields.

Data Sources (1)

SourceAliasJoin Type
vch_sim_draft SavedSimulationDraft from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSAVEDSIMDRFT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view

Fields (19)

KeyFieldSource TableSource FieldDescription
CreatedByUser createdbyuser User Name
CreationDate creationdate Time Stamp
LastChangedByUser lastchangedbyuser User Name
LastChangeDate lastchangedate Time Stamp
Product product Product Sold
ConfigurationObject UUID
Plant plant Valuation Area
ProductConfiguration configurationnumber Int. object no.
ConfigurationObjectItem
VariantConfigurationSimlnName name Zone name
DraftUUID draftuuid UUID
ConfigurationProfileNumber configurationprofilecounter Int. counter
VariantConfigurationSimlnDate configurationsimulationdate Date
CreationTime creationtime Time of Change
LastChangeTime lastchangetime Time changed
TemplateConfiguredObject templateconfiguredobject Simulation Environment: Simulation Configuration Object
TemplateConfiguredObjectItem templateconfiguredobjectitem Object Item
TemplateConfiguredObjectType templateconfiguredobjecttype Owner Type
ConfigurationStatus configurationstatus Status

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_SavedSimulation_Draft.
-- 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: PSAVEDSIMDRFT

CREATE VIEW P_SavedSimulation_Draft AS
SELECT
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  Product,
  cast(simulationuuid as vchclf_sim_conf_object) AS ConfigurationObject,
  Plant,
  configurationnumber AS ProductConfiguration,
  cast ( '' as vchclf_sim_conf_object_item ) AS ConfigurationObjectItem,
  name AS VariantConfigurationSimlnName,
  DraftUUID,
  configurationprofilecounter AS ConfigurationProfileNumber,
  configurationsimulationdate AS VariantConfigurationSimlnDate,
  CreationTime,
  LastChangeTime,
  TemplateConfiguredObject,
  TemplateConfiguredObjectItem,
  TemplateConfiguredObjectType,
  ConfigurationStatus
FROM vch_sim_draft AS SavedSimulationDraft
;

Learn More