P_SavedSimulation

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.
-- 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: PSAVEDSIM

CREATE VIEW P_SavedSimulation AS
SELECT
  cast( SavedSimulation.id as vchclf_sim_conf_object ) AS ConfigurationObject,
  SavedSimulation.created_by AS CreatedByUser,
  SavedSimulation.created_on AS CreationDate,
  SavedSimulation.created_on_time AS CreationTime,
  SavedSimulation.changed_by AS LastChangedByUser,
  case when SavedSimulationDraft.lastchangedate is null then SavedSimulation.changed_on else SavedSimulationDraft.lastchangedate end as LastChangeDate AS lastchangedateendasLastChangeDate,
  case when SavedSimulationDraft.lastchangetime is null then SavedSimulation.changed_on_time else SavedSimulationDraft.lastchangetime end as LastChangeTime AS lastchangetimeendasLastChangeTime,
  SavedSimulation.product AS Product,
  SavedSimulation.plant AS Plant,
  SavedSimulation.cuobj AS ProductConfiguration,
  cast( '' as vchclf_sim_conf_object_item ) AS ConfigurationObjectItem,
  SavedSimulation.name AS VariantConfigurationSimlnName,
  SavedSimulation.configurationprofilecounter AS ConfigurationProfileNumber,
  SavedSimulation.simulation_date AS VariantConfigurationSimlnDate,
  SavedSimulationDraft.draftuuid AS DraftUUID,
  template_obj_id AS TemplateConfiguredObject,
  template_obj_item_id AS TemplateConfiguredObjectItem,
  template_obj_type AS TemplateConfiguredObjectType,
  application AS BOMExplosionApplication,
  SavedSimulationDraft.configurationstatus AS ConfigurationStatus,
  simulation_external_id AS VarConfignSimlnExternalID
FROM vch_simulation AS SavedSimulation
LEFT OUTER JOIN vch_sim_draft AS SavedSimulationDraft ON /* join condition not captured in parsed metadata */
;