I_VisualSimulation

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_VisualSimulation.
-- 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: IVISUSIM

CREATE VIEW I_VisualSimulation AS
SELECT
  sim.nomtk AS NominationDoc,
  sim.nomit AS NominationDocItem,
  cast ( '' as abap.char(10) ) AS NominationDocDischargeItem,
  sim.nomnr AS NominationExtNumber,
  sim.nomtyp AS NominationType,
  sim.nomst AS NominationHeaderStatus,
  sim.locid AS LocationId,
  loc.BusinessEntityLocationName AS LocationName,
  cast('' as abap.char(10)) AS LocationDischargeId,
  cast('' as abap.char(35)) AS DestinationLocationName,
  loc.CompanyCode AS CompanyCode,
  sim.s_matnr_i AS ScheduledMaterial,
  sim.menge AS ScheduledQuantity,
  sim.unit_i AS ScheduledQuantityUnit,
  cast(0 as abap.quan( 13, 3 )) AS DischargeSchedQuantity,
  cast('' as abap.char(3 )) AS DischargeQuantityUnit,
  sim.docind AS IsReferenceDocument,
  sim.docnr AS NominationReferenceDocument,
  sim.cycle AS NominationPipelineCycleID,
  sim.nmshipper AS NominationShipper,
  sim.nmcarrier AS NominationCarrier,
  cast('' as abap.char(35) ) AS CarrierName,
  sim.nmwerk AS InTransitPlant,
  sim.nmlgort AS InTransitStorageLocation,
  sim.nmvehicle AS VehicleId,
  cast('' as abap.char(40) ) AS VehicleDescription,
  sim.tsyst AS TransportSystem,
  sim.sentdat AS NominationLastHeaderActionDate,
  sim.nmtplst AS TransportationPlanningPoint,
  sim.route AS ShippingRoute,
  sim.bookts AS IsBookedTransportSystem,
  sim.ev_group AS NominationEventDefaultGroup,
  sim.unit AS NominationHeaderUom,
  sim.nmshtype AS BulkShipmentType,
  sim.vktra AS NominationModeOfTransport,
  nh.ModeOfTransportDesc AS ModeOfTransportText,
  sim.bustyp AS BusinessType,
  sim.nmvessel AS VehicleIdentifier,
  sim.aedat AS NominationChangedDate,
  sim.erdat AS NominationCreationDate,
  sim.erzeit AS NominationCreationTime,
  sim.ernam AS NominationCreatedByUser,
  sim.bloind AS NominationIsBlocked,
  sim.conpat AS ContractPartner,
  sim.cons AS ConsigneePartner,
  sim.delind AS NominationIsMarkedForDeletion,
  sim.docitm AS NominationReferenceDocItem,
  sim.doctyp AS NominationReferenceDocType,
  sim.flag_imex AS IsImportExportPartner,
  sim.charg_o AS BatchOriginLocation,
  sim.charg_d AS BatchDestinationLocation,
  sim.idate AS NominationScheduleDate,
  sim.impoexpo AS ImportExportPartner,
  sim.incomplete_flag AS NominationIsIncomplete,
  sim.inspe AS NominationInspector,
  sim.istat AS NominationItemStatus,
  sim.isubstat AS NominationItemSubStatus,
  sim.matnr_i AS LoadDemandMaterialId,
  sim.matnr_i AS DischargeDemandMaterialId,
  sim.partnr AS LocationPartner,
  cast( '' as abap.char(4)) AS LocationPlant,
  sim.sityp AS NominationScheduleType,
  sim.owner AS ValuationType,
  sim.valuationtype_d AS ValuationTypeDestination,
  sim.valuationtype_o AS ValuationTypeOrigin,
  sim.worklist_i AS IsNominationWorklistEntry,
  sim.actualqty AS ActualScheduledQuantity,
  sim.actualuom AS ActualScheduledQuantityUnit,
  cast(0 as abap.quan( 13, 3 )) AS ActualDischargeQuantity,
  cast('' as abap.char(3 )) AS ActualDischargeQuantityUnit,
  sim.ilock AS NominationItemIsComplete,
  sim.sched_tst_from AS ScheduledBatchStartDateTime,
  sim.sched_tst_to AS ScheduledBatchEndDateTime,
  sim.actuals AS IsNominationActual,
  m.MaterialDescription AS MaterialDesc,
  cast('' as char1) AS DischargeNominationItemStatus,
  cast('' as char50) AS NominationItemStatusDesc,
  cast('' as char50) AS ItemDischargeStatusText,
  a.matkl AS MaterialGroup,
  cast('' as char50) AS MaterialGroupName,
  a.prdha AS ProductHierarchy,
  cast('' as char50) AS ProductHierarchyName,
  b.Customer AS Customer,
  cast('' as abap.char(35) ) AS CustomerName,
  d.Supplier AS SupplierAccount,
  cast('' as abap.char(35) ) AS SupplierName,
  c.addrnumber AS CustAddressNumber,
  c.city1 AS CustomerCityName,
  c.country AS CustomerCountry,
  e.addrnumber AS AddressNumber,
  e.city1 AS SupplierCityName,
  e.country AS SourceLocationCountry,
  loc.CityName AS CityName,
  loc.CountryName AS CountryName,
  loc.Region AS Region,
  rt.rpart AS BusinessPartnerRoleType,
  cast('' as char20 ) AS FromLatitude,
  cast('' as char20 ) AS FromLongitude,
  cast('' as char20 ) AS ToLatitude,
  cast('' as char20 ) AS ToLongitude,
  uv.variant AS ConnectionPoints,
  uv.variant AS LocationPosition,
  cast('' as char30 ) AS RouteText,
  cast('' as char2 ) AS IsAlert,
  cast('' as char255) AS AlertText,
  cast('' as char255) AS DischargeQtyAlertText,
  cast('' as char2 ) AS IsLoadTimeAlert,
  cast('' as char255) AS LoadTimeAlertText,
  cast('' as char2 ) AS IsDischargeTimeAlert,
  cast('' as char255) AS DischargeTimeAlertText,
  cast('' as char1 ) AS IsLocationAlert,
  cast('' as char255) AS LocationAlertDesc,
  cast('' as char1 ) AS IsDischargeLocAlert,
  cast('' as char255) AS DischargeLocAlertDesc,
  cast('' as char2 ) AS IsLoad,
  cast('' as char10 ) AS IsNominationDocItem,
  cast('' as char1 ) AS IsPegged,
  f.SafetyStock AS SafetyStock,
  f.CapacityStock AS CapacityStock,
  ev.NominationEventNumber AS NominationEventNumber,
  ev.NominationEventType AS NominationEventType,
  ev.NominationEventSequence AS NominationEventSequence,
  ev.ActualStartDateFrom AS ActualStartDateFrom,
  ev.ActualStartTimeFrom AS ActualStartTimeFrom,
  re.NominationEventChangedDate AS NominationEventChangedDate,
  re.NominationEventChangedTime AS NominationEventChangedTime,
  cast('' as char4 ) AS DischargeEventNumber,
  cast('' as char4 ) AS DischargeEventType,
  cast('00000000' as abap.dats) AS DischargeDate,
  cast('000000' as abap.tims) AS DischargeTime,
  ev.ActualStartDateTo AS ActualStartDateTo,
  ev.ActualStartTimeTo AS ActualStartTimeTo,
  ev.ActualEndDateFrom AS ActualEndDateFrom,
  ev.ActualEndTimeFrom AS ActualEndTimeFrom,
  ev.ActualEndDateTo AS ActualEndDateTo,
  ev.ActualEndTimeTo AS ActualEndTimeTo,
  cast('00000000' as abap.dats) AS NominationTicketLoadStartDate,
  cast('000000' as abap.tims) AS NominationTicketLoadStartTime,
  cast('00000000' as abap.dats) AS NominationTicketDischargeDate,
  cast('000000' as abap.tims) AS NominationTicketDischargeTime,
  cast('000000' as abap.tims) AS NominationScheduledTime,
  cast('00000000' as abap.dats) AS PlannedDischargeDate,
  cast('000000' as abap.tims) AS NominationDischargeTime,
  cast('' as abap.char(10) ) AS DestinationLocation,
  cast('' as char1) AS IsVariant,
  cast('' as char1) AS IsNominationLoad,
  cast('' as char1) AS IsNominationDischarge,
  o.pegid AS NominationPegID,
  p.peg_type_usage AS NominationPeggingTypeUsage,
  cast('0' as abap.int1) AS TransshipmentGroupID,
  cast(' ' as char1 ) AS DischargeReferenceDocument,
  cast(' ' as char2 ) AS NominationDischargeSchedType,
  cast(' ' as char10) AS DischargeContractPartner,
  cast(' ' as char10) AS DischargeLocationPartner,
  cast(' ' as char4 ) AS DischargeLocationPlant,
  sp.mstus AS NotificationStatusObject,
  cast(' ' as char2 ) AS StatusObject,
  sp.mtims AS NotificationDateTime,
  cast(' ' as char10) AS NotificationText,
  cast(' ' as char10) AS MaintenanceNotificationText,
  cast(' ' as char2 ) AS IndicatorValue,
  cast(' ' as char2 ) AS IsCloudSystem,
  sim.sim_sched_typ AS Simulation,
  cast('' as abap.char( 256 ) ) AS Comments,
  m_l.MaterialDescription AS LoadDemandMaterialDesc,
  m_d.MaterialDescription AS DischargeDemandMaterialDesc,
  cast( 0 as oij09_cost ) AS ShipmentLoadCost,
  cast(' ' as oij09_waers ) AS ShipmentLoadCostCrcy,
  cast( 0 as oij09_cost ) AS ShipmentDischargeCost,
  cast(' ' as oij09_waers ) AS ShipmentDischargeCostCrcy,
  _VisualLocationTimeZone.LocationTimeZone AS LocationTimeZone
FROM voij_sched AS sim
LEFT OUTER JOIN v_oijpeg AS o ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_oij_pegtyp AS p ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mara AS a ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialDescription AS m ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialDescription AS m_l ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialDescription AS m_d ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrc AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS d ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrc AS e ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_VisualLocations AS loc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oij07_mot_eve_v AS k ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Oij06_Recent_Event AS re ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Oij06_Myeventss1_Main AS ev ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OilLocMatlPlanning AS f ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationModeOfTranspVH AS nh ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_oigvt AS j ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_oijtsloc AS ts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_oijrra AS rt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_oij_shipments AS sp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_visu_usrva AS uv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_VisualLocationTimeZone AS _VisualLocationTimeZone ON LocationId = _VisualLocationTimeZone.TSWLocationID  -- association [1..1]
;