I_VisualAnalysis

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_VisualAnalysis.
-- 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: IVISUALANALYSIS

CREATE VIEW I_VisualAnalysis AS
SELECT
  nom.NominationDoc AS NominationDoc,
  nom.NominationDocItem AS NominationDocItem,
  cast('' as abap.char(10)) AS NominationDocDischargeItem,
  cast('' as char10) AS IsNominationDocItem,
  cast('' as char2) AS IsLoad,
  nom.ScheduledMaterial AS ScheduledMaterial,
  d.CompanyCode AS CompanyCode,
  nom.NominationCarrier AS NominationCarrier,
  nom.NominationModeOfTransport AS NominationModeOfTransport,
  e.ModeOfTransportDesc AS ModeOfTransportText,
  nom.LocationId AS LocationId,
  nom.VehicleId AS VehicleId,
  nom.ShippingRoute AS ShippingRoute,
  cast('' as abap.char(10) ) AS DestinationLocation,
  a.matkl AS MaterialGroup,
  nom.TransportSystem AS TransportSystem,
  nom.NominationScheduleType AS NominationScheduleType,
  nom.IsBookedTransportSystem AS IsBookedTransportSystem,
  nom.IsReferenceDocument AS IsReferenceDocument,
  nom.NominationReferenceDocument AS NominationReferenceDocument,
  nom.NominationItemStatus AS NominationItemStatus,
  nom.NominationScheduleDate AS NominationScheduleDate,
  calDate.YearWeek AS NominationCalendarWeek,
  calDate.YearMonth AS NominationCalendarMonth,
  calDate.CalendarYear AS NominationCalendarYear,
  nom.ScheduledBatchStartDateTime AS ScheduledBatchStartDateTime,
  cast(0 as abap.quan( 13, 3 )) AS ActualDischargeQuantity,
  cast( 0 as abap.dec( 13, 3 )) AS TransitTime,
  ev.ActualStartDateFrom AS ActualStartDateFrom,
  ev.ActualStartTimeFrom AS ActualStartTimeFrom,
  cast('' as abap.char(19) ) AS DischargeBatchStartDateTime,
  cast('00000000' as abap.dats) AS DischargeDate,
  cast('000000' as abap.tims) AS DischargeTime,
  cast( 0 as abap.dec( 13, 3 )) AS DeltaLoadDischargeTime,
  cast( 0 as abap.dec( 13, 3 )) AS NominationOverallLoad,
  cast( 0 as abap.dec( 13, 3 )) AS NominationOvrlDischarge,
  nom.ScheduledQuantity AS ScheduledQuantity,
  nom.ScheduledQuantityUnit AS ScheduledQuantityUnit,
  nom.ActualScheduledQuantity AS ActualScheduledQuantity,
  nom.ActualScheduledQuantityUnit AS ActualScheduledQuantityUnit,
  cast(0 as abap.quan( 13, 3 )) AS DeltaLoadQuantity,
  cast(0 as abap.quan( 13, 3 )) AS DeltaDischargeQuantity,
  cast('' as char2) AS NominationDocItmIndicator,
  cast('' as char15) AS DeltaText,
  cast('' as char15) AS DeltaDischargeText,
  nom.VehicleIsBlocked AS VehicleIsBlocked,
  nom.NominationShipper AS NominationShipper,
  nom.NominationInspector AS NominationInspector,
  nom.ImportExportPartner AS ImportExportPartner,
  nom.ConsigneePartner AS ConsigneePartner,
  nom.ContractPartner AS ContractPartner,
  nom.LocationPartner AS LocationPartner
LEFT OUTER JOIN mara AS a 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_OilPartnerRoles AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t001w AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Purreqvaluationarea AS d ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationModeOfTranspVH AS e ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalendarDate AS calDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS _Shipper ON NominationShipper = _Shipper.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Carrier ON NominationCarrier = _Carrier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Inspector ON NominationInspector = _Inspector.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _ImportExportPartner ON ImportExportPartner = _ImportExportPartner.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _ConsigneePartnerVendor ON ConsigneePartner = _ConsigneePartnerVendor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ConsigneePartnerCustomer ON ConsigneePartner = _ConsigneePartnerCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _ContractPartnerVendor ON ContractPartner = _ContractPartnerVendor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ContractPartnerCustomer ON ContractPartner = _ContractPartnerCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _LocationPartnerVendor ON LocationPartner = _LocationPartnerVendor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _LocationPartnerCustomer ON LocationPartner = _LocationPartnerCustomer.Customer  -- association [0..1]
;