I_AdvncdPlngSimulationVers

DDL: I_ADVNCDPLNGSIMULATIONVERS SQL: IAPSIMULATIONVRS Type: view BASIC
12 Fields 1 Data Sources

Simulation Version for Advanced Planning

I_AdvncdPlngSimulationVers is a Basic CDS View that provides data about "Simulation Version for Advanced Planning" in SAP S/4HANA. It reads from 1 data source (/sapapo/simsess) and exposes 12 fields with key field SimulationSessionUUID.

Data Sources (1)

SourceAliasJoin Type
/sapapo/simsess /sapapo/simsess from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IAPSIMULATIONVRS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Simulation Version for Advanced Planning view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SimulationSessionUUID simsessid Sim. Session
SimulationSessionName name Zone name
AdvncdPlngPlanningVersionUUID Plng Version
AdvncdPlngSimlnVersOwnerID create_user User Name
AdvncdPlngApplicationType application_type Application type
AdvncdPlngApplPrflID ovrprf Overall Profile
AdvncdPlngApplPlngBrdPrflID pltprf Plng Board Prfl
AdvncdPlngApplStrgyPrflID strprf Strategy Profile
AdvncdPlngPPStrgyPrflID pp_strprf PP Strategy Prof.
AdvncdPlngTimeProfileID timeprf Time Profile
AdvncdPlngApplOptmznPrflID optiprf Optimzn Profile
AdvncdPlngApplAlrtPrflID almprf PP/DS Alert Pr.

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 I_AdvncdPlngSimulationVers.
-- 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: IAPSIMULATIONVRS

CREATE VIEW I_AdvncdPlngSimulationVers AS
SELECT
  simsessid AS SimulationSessionUUID,
  name AS SimulationSessionName,
  cast(simverid as /sapapo/cres_guid ) AS AdvncdPlngPlanningVersionUUID,
  create_user AS AdvncdPlngSimlnVersOwnerID,
  application_type AS AdvncdPlngApplicationType,
  ovrprf AS AdvncdPlngApplPrflID,
  pltprf AS AdvncdPlngApplPlngBrdPrflID,
  strprf AS AdvncdPlngApplStrgyPrflID,
  pp_strprf AS AdvncdPlngPPStrgyPrflID,
  timeprf AS AdvncdPlngTimeProfileID,
  optiprf AS AdvncdPlngApplOptmznPrflID,
  almprf AS AdvncdPlngApplAlrtPrflID
FROM /sapapo/simsess
;

Learn More