C_VisualNominations

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 C_VisualNominations.
-- 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: CVISUALNOM

CREATE VIEW C_VisualNominations AS
SELECT
  a.NominationDoc AS NominationDoc,
  a.NominationDocItem AS NominationDocItem,
  a.NominationDocDischargeItem AS NominationDocDischargeItem,
  a.LocationId AS LocationId,
  a.LocationName AS LocationName,
  a.LocationDischargeId AS LocationDischargeId,
  a.DestinationLocationName AS DestinationLocationName,
  a.NominationModeOfTransport AS NominationModeOfTransport,
  a.VehicleId AS VehicleId,
  a.VehicleDescription AS VehicleDescription,
  a.TransportSystem AS TransportSystem,
  a.ModeOfTransportText AS ModeOfTransportText,
  a.NominationHeaderStatus AS NominationHeaderStatus,
  a.NominationExtNumber AS NominationExtNumber,
  a.NominationType AS NominationType,
  a.ScheduledMaterial AS ScheduledMaterial,
  a.MaterialDesc AS MaterialDesc,
  a.MaterialGroup AS MaterialGroup,
  a.MaterialGroupName AS MaterialGroupName,
  a.ProductHierarchy AS ProductHierarchy,
  a.ProductHierarchyName AS ProductHierarchyName,
  a.NominationCarrier AS NominationCarrier,
  a.CarrierName AS CarrierName,
  a.CompanyCode AS CompanyCode,
  a.ScheduledBatchStartDateTime AS ScheduledBatchStartDateTime,
  a.NominationScheduleDate AS NominationScheduleDate,
  a.NominationScheduledTime AS NominationScheduledTime,
  a.DischargeBatchStartDateTime AS DischargeBatchStartDateTime,
  a.PlannedDischargeDate AS PlannedDischargeDate,
  a.NominationDischargeTime AS NominationDischargeTime,
  a.ScheduledBatchEndDateTime AS ScheduledBatchEndDateTime,
  a.NominationEventChangedDate AS NominationEventChangedDate,
  a.NominationEventChangedTime AS NominationEventChangedTime,
  a.NominationEventChangedDateTime AS NominationEventChangedDateTime,
  a.ScheduledQuantity AS ScheduledQuantity,
  a.ScheduledQuantityUnit AS ScheduledQuantityUnit,
  a.ActualScheduledQuantity AS ActualScheduledQuantity,
  a.ActualScheduledQuantityUnit AS ActualScheduledQuantityUnit,
  a.DischargeSchedQuantity AS DischargeSchedQuantity,
  a.DischargeQuantityUnit AS DischargeQuantityUnit,
  a.ActualDischargeQuantity AS ActualDischargeQuantity,
  a.ActualDischargeQuantityUnit AS ActualDischargeQuantityUnit,
  a.IsReferenceDocument AS IsReferenceDocument,
  a.NominationScheduleType AS NominationScheduleType,
  a.NominationReferenceDocument AS NominationReferenceDocument,
  a.NominationReferenceDocItem AS NominationReferenceDocItem,
  a.NominationReferenceDocType AS NominationReferenceDocType,
  a.DischargeReferenceDocument AS DischargeReferenceDocument,
  a.NominationDischargeSchedType AS NominationDischargeSchedType,
  a.ContractPartner AS ContractPartner,
  a.LocationPartner AS LocationPartner,
  a.LocationPlant AS LocationPlant,
  a.DischargeContractPartner AS DischargeContractPartner,
  a.DischargeLocationPartner AS DischargeLocationPartner,
  a.DischargeLocationPlant AS DischargeLocationPlant,
  a.Customer AS Customer,
  a.CustomerName AS CustomerName,
  a.CustAddressNumber AS CustAddressNumber,
  a.CustomerCityName AS CustomerCityName,
  a.CustomerCountry AS CustomerCountry,
  a.AddressNumber AS AddressNumber,
  a.SupplierAccount AS SupplierAccount,
  a.SupplierName AS SupplierName,
  a.SupplierCityName AS SupplierCityName,
  a.SourceLocationCountry AS SourceLocationCountry,
  a.CityName AS CityName,
  a.CountryName AS CountryName,
  a.Region AS Region,
  a.FromLatitude AS FromLatitude,
  a.FromLongitude AS FromLongitude,
  a.ToLatitude AS ToLatitude,
  a.ToLongitude AS ToLongitude,
  a.ConnectionPoints AS ConnectionPoints,
  a.LocationPosition AS LocationPosition,
  a.ShippingRoute AS ShippingRoute,
  a.IsAlert AS IsAlert,
  a.AlertText AS AlertText,
  a.DischargeQtyAlertText AS DischargeQtyAlertText,
  a.IsLoadTimeAlert AS IsLoadTimeAlert,
  a.LoadTimeAlertText AS LoadTimeAlertText,
  a.IsDischargeTimeAlert AS IsDischargeTimeAlert,
  a.DischargeTimeAlertText AS DischargeTimeAlertText,
  a.IsLocationAlert AS IsLocationAlert,
  a.LocationAlertDesc AS LocationAlertDesc,
  a.IsDischargeLocAlert AS IsDischargeLocAlert,
  a.DischargeLocAlertDesc AS DischargeLocAlertDesc,
  a.SafetyStock AS SafetyStock,
  a.CapacityStock AS CapacityStock,
  a.NominationEventNumber AS NominationEventNumber,
  a.NominationEventType AS NominationEventType,
  a.NominationEventSequence AS NominationEventSequence,
  a.ActualStartDateFrom AS ActualStartDateFrom,
  a.ActualStartTimeFrom AS ActualStartTimeFrom,
  a.ActualStartFromDateTime AS ActualStartFromDateTime,
  a.DischargeEventNumber AS DischargeEventNumber,
  a.DischargeEventType AS DischargeEventType,
  a.DischargeDate AS DischargeDate,
  a.DischargeTime AS DischargeTime,
  a.DischargeStartDateTime AS DischargeStartDateTime,
  a.ActualEndDateTo AS ActualEndDateTo,
  a.ActualEndToDateTime AS ActualEndToDateTime,
  a.NominationTicketLoadStartDate AS NominationTicketLoadStartDate,
  a.NominationTicketLoadStartTime AS NominationTicketLoadStartTime,
  a.NomTicketLoadStartDateTime AS NomTicketLoadStartDateTime,
  a.NominationTicketDischargeDate AS NominationTicketDischargeDate,
  a.NominationTicketDischargeTime AS NominationTicketDischargeTime,
  a.NomTicketDischargeDateTime AS NomTicketDischargeDateTime,
  a.DestinationLocation AS DestinationLocation,
  a.RouteText AS RouteText,
  a.IsLoad AS IsLoad,
  a.IsNominationDocItem AS IsNominationDocItem,
  a.IsPegged AS IsPegged,
  a.IsVariant AS IsVariant,
  a.IsNominationLoad AS IsNominationLoad,
  a.IsNominationDischarge AS IsNominationDischarge,
  a.BusinessPartnerRoleType AS BusinessPartnerRoleType,
  a.ValuationType AS ValuationType,
  a.NominationPegID AS NominationPegID,
  a.NominationPeggingTypeUsage AS NominationPeggingTypeUsage,
  a.TransshipmentGroupID AS TransshipmentGroupID,
  a.IsNominationActual AS IsNominationActual,
  a.IsBookedTransportSystem AS IsBookedTransportSystem,
  a.NominationItemIsComplete AS NominationItemIsComplete,
  a.NominationItemStatus AS NominationItemStatus,
  a.NominationItemStatusDesc AS NominationItemStatusDesc,
  a.DischargeNominationItemStatus AS DischargeNominationItemStatus,
  a.ItemDischargeStatusText AS ItemDischargeStatusText,
  a.IndicatorValue AS IndicatorValue,
  a.NotificationStatusObject AS NotificationStatusObject,
  a.StatusObject AS StatusObject,
  a.NotificationDateTime AS NotificationDateTime,
  a.NotificationText AS NotificationText,
  MaintenanceNotificationText,
  a.IsCloudSystem AS IsCloudSystem,
  a.Simulation AS Simulation,
  a.Comments AS Comments,
  a.LoadDemandMaterialId AS LoadDemandMaterialId,
  a.DischargeDemandMaterialId AS DischargeDemandMaterialId,
  a.LoadDemandMaterialDesc AS LoadDemandMaterialDesc,
  a.DischargeDemandMaterialDesc AS DischargeDemandMaterialDesc,
  a.ShipmentLoadCost AS ShipmentLoadCost,
  a.ShipmentLoadCostCrcy AS ShipmentLoadCostCrcy,
  a.ShipmentDischargeCost AS ShipmentDischargeCost,
  a.ShipmentDischargeCostCrcy AS ShipmentDischargeCostCrcy,
  LocationTimeZone
FROM I_VisualNominations AS a
LEFT OUTER JOIN C_VisualMaterialGroupVH AS _MaterialGroupVH ON MaterialGroup = _MaterialGroupVH.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_VisualLocationVH AS _LocationVH ON LocationId = _LocationVH.LocationId  -- association [0..1]
LEFT OUTER JOIN C_VisualModeOfTransportVH AS _ModeofTranspVH ON NominationModeOfTransport = _ModeofTranspVH.ModeOfTransport  -- association [0..1]
LEFT OUTER JOIN C_VisualVehicleNumberVH AS _VehicleNumberVH ON VehicleId = _VehicleNumberVH.VehicleId  -- association [0..1]
LEFT OUTER JOIN C_VisualTransportSystemVH AS _TransportSystemVH ON TransportSystem = _TransportSystemVH.TransportSystem  -- association [0..1]
LEFT OUTER JOIN C_NominationTypeVH AS _NominationTypeVH ON NominationType = _NominationTypeVH.NominationType  -- association [0..1]
LEFT OUTER JOIN C_NominationNumberVH AS _NominationNumVH ON NominationExtNumber = _NominationNumVH.NominationExtNumber  -- association [0..*]
LEFT OUTER JOIN C_NominationStatusVH AS _NominationStatusVH ON NominationHeaderStatus = _NominationStatusVH.NominationHeaderStatus  -- association [0..1]
LEFT OUTER JOIN C_VisualProductIdVH AS _ProductIdVH ON ScheduledMaterial = _ProductIdVH.ProductID  -- association [0..*]
LEFT OUTER JOIN C_VisualProductHierarchyVH AS _ProductHierarchyVH ON ProductHierarchy = _ProductHierarchyVH.ProductHierarchy  -- association [0..1]
;