P_Simulation

DDL: P_SIMULATION SQL: PSIMULATION Type: view BASIC

P_Simulation is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (P_SavedSimulation, P_SavedSimulation_Draft, P_SimulationSearchSupport) and exposes 40 fields.

3 data source(s) 40 fields

Data Sources (3)

SourceAliasJoin Type
P_SavedSimulation P_SavedSimulation from
P_SavedSimulation_Draft P_SavedSimulation_Draft union
P_SimulationSearchSupport SearchSupport left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSIMULATION 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 (40)

KeyFieldSource TableSource FieldDescription
ConfigurationObject ConfigurationObject
ConfigurationObjectItem ConfigurationObjectItem
CreatedByUser CreatedByUser
CreationDate CreationDate
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
DraftUUID DraftUUID
Plant Plant
Product Product
ProductConfiguration ProductConfiguration
VariantConfigurationSimlnName VariantConfigurationSimlnName
CreationTime CreationTime
LastChangeTime LastChangeTime
HasActiveEntity
ConfigurationProfileNumber P_SavedSimulation ConfigurationProfileNumber
VariantConfigurationSimlnDate P_SavedSimulation VariantConfigurationSimlnDate
TemplateConfiguredObjectType TemplateConfiguredObjectType
TemplateConfiguredObject TemplateConfiguredObject
TemplateConfiguredObjectItem TemplateConfiguredObjectItem
ConfigurationStatus ConfigurationStatus
ConfigurationObjectItem ConfigurationObjectItem
CreatedByUser CreatedByUser
CreationDate CreationDate
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
DraftUUID DraftUUID
Plant Plant
Product Product
ProductConfiguration ProductConfiguration
VariantConfigurationSimlnName P_SavedSimulation_Draft VariantConfigurationSimlnName
CreationTime CreationTime
LastChangeTime LastChangeTime
HasActiveEntity
ConfigurationProfileNumber P_SavedSimulation_Draft ConfigurationProfileNumber
VariantConfigurationSimlnDate P_SavedSimulation_Draft VariantConfigurationSimlnDate
TemplateConfiguredObjectType TemplateConfiguredObjectType
TemplateConfiguredObject TemplateConfiguredObject
TemplateConfiguredObjectItem TemplateConfiguredObjectItem
ConfigurationStatus ConfigurationStatus
VarConfignSimlnExternalID P_SimulationSearchSupport VarConfignSimlnExternalID 
@AbapCatalog.sqlViewName: 'PSIMULATION'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC
@VDM.private: true

define view P_Simulation
  as select from P_SavedSimulation
{

  ConfigurationObject,
  ConfigurationObjectItem,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  DraftUUID,
  Plant,
  Product,
  ProductConfiguration,
  VariantConfigurationSimlnName,
  CreationTime,
  LastChangeTime,
  #CDSBOOLEAN.'true' as HasActiveEntity,

  P_SavedSimulation.ConfigurationProfileNumber,
  P_SavedSimulation.VariantConfigurationSimlnDate,
  TemplateConfiguredObjectType,
  TemplateConfiguredObject,
  TemplateConfiguredObjectItem,

  ConfigurationStatus,
  VarConfignSimlnExternalID

}

union select from P_SavedSimulation_Draft
  left outer join P_SimulationSearchSupport as SearchSupport on SearchSupport.VarConfignSimlnExternalID = ''
{
  ConfigurationObject,
  ConfigurationObjectItem,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  DraftUUID,
  Plant,
  Product,
  ProductConfiguration,
  P_SavedSimulation_Draft.VariantConfigurationSimlnName,
  CreationTime,
  LastChangeTime,
  #CDSBOOLEAN.'false' as HasActiveEntity,

  P_SavedSimulation_Draft.ConfigurationProfileNumber,
  P_SavedSimulation_Draft.VariantConfigurationSimlnDate,

  TemplateConfiguredObjectType,
  TemplateConfiguredObject,
  TemplateConfiguredObjectItem,

  ConfigurationStatus,
  SearchSupport.VarConfignSimlnExternalID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_SAVEDSIMULATION",
"P_SAVEDSIMULATION_DRAFT",
"P_SIMULATIONSEARCHSUPPORT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More