I_NominationSimulation

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_NominationSimulation.
-- 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: INOMSIMULATION

CREATE VIEW I_NominationSimulation AS
SELECT
  sim_sched_id AS NominationSimlnID,
  sim_sched_ln AS NominationSimlnLineItm,
  sim_version AS NominationSimlnVersion,
  locid AS LocationId,
  sim_sched_typ AS NominationSimlnSchedCategory,
  idate AS ScheduledDate,
  s_matnr_i AS ScheduledMaterial,
  menge AS ScheduledQuantity,
  unit_i AS ScheduledQuantityUnit,
  tsyst AS TransportSystem,
  vktra AS ModeOfTransport,
  sityp AS NominationScheduleType,
  docind AS NominationReferenceDocType,
  docnr AS NominationReferenceDocument,
  docitm AS NominationReferenceDocItem,
  nomtk AS NominationDoc,
  nomit AS NominationDocItem,
  nomnr AS NominationExtNumber,
  nmvehicle AS TransportationVehicle,
  ernam AS CreatedByUser,
  erdat AS NominationScheduleCreationDate,
  erzeit AS NominationCreationTime,
  aedat AS NominationChangedDate,
  scenario_id AS NominationSimlnScenarioID,
  nmselect AS NominationDocIsBlocked
FROM oij_sched AS _Simulation
LEFT OUTER JOIN E_DemandNominationSchedule AS _DemandNomExtension ON NominationSimlnID = _DemandNomExtension.NominationSimlnID AND NominationSimlnLineItm = _DemandNomExtension.NominationSimlnLineItm AND NominationSimlnVersion = _DemandNomExtension.NominationSimlnVersion  -- association [1..1]
;