I_Oij06_My_Nominations

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_Oij06_My_Nominations.
-- 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: IOIJ06_MYNOM

CREATE VIEW I_Oij06_My_Nominations AS
SELECT
  h.NominationDoc AS NominationDoc,
  i.NominationDocItem AS NominationDocItem,
  h.NominationType AS NominationType,
  h.NominationExtNumber AS NominationExtNumber,
  h.NominationHeaderStatus AS NominationHeaderStatus,
  h.TransportSystem AS TransportSystem,
  h.NominationPipelineCycleID AS NominationPipelineCycleID,
  h.VehicleId AS VehicleId,
  h.NominationCarrier AS NominationCarrier,
  h.NominationShipper AS NominationShipper,
  h.BulkShipmentType AS BulkShipmentType,
  h.TransportationPlanningPoint AS TransportationPlanningPoint,
  h.InTransitPlant AS InTransitPlant,
  h.InTransitStorageLocation AS InTransitStorageLocation,
  h.NominationModeOfTransport AS NominationModeOfTransport,
  h.VehicleIdentifier AS VehicleIdentifier,
  h.NominationCreatedByUser AS NominationCreatedByUser,
  h.NominationCreationDate AS NominationCreationDate,
  i.NominationCreationTime AS NominationCreationTime,
  h.NominationChangedDate AS NominationChangedDate,
  h.BusinessType AS BusinessType,
  h.NominationDocIsBlocked AS NominationDocIsBlocked,
  i.NominationScheduleType AS NominationScheduleType,
  i.NominationItemStatus AS NominationItemStatus,
  i.NominationScheduleDate AS NominationScheduleDate,
  i.LocationId AS LocationId,
  i.ScheduledQuantity AS ScheduledQuantity,
  i.ActualScheduledQuantity AS ActualScheduledQuantity,
  i.ActualScheduledQuantityUnit AS ActualScheduledQuantityUnit,
  i.ScheduledQuantityUnit AS ScheduledQuantityUnit,
  i.DemandMaterial AS DemandMaterial,
  i.ScheduledMaterial AS ScheduledMaterial,
  i.ValuationTypeOrigin AS ValuationTypeOrigin,
  i.ValuationTypeDestination AS ValuationTypeDestination,
  i.LocationPartner AS LocationPartner,
  i.NominationReferenceDocument AS NominationReferenceDocument,
  i.NominationReferenceDocItem AS NominationReferenceDocItem,
  i.NominationInspector AS NominationInspector,
  i.IsNominationWorklistEntry AS IsNominationWorklistEntry,
  i.NominationIsIncomplete AS NominationIsIncomplete,
  i.ImportExportPartner AS ImportExportPartner,
  i.IsImportExportPartner AS IsImportExportPartner,
  i.ContractPartner AS ContractPartner,
  i.ConsigneePartner AS ConsigneePartner,
  i.NominationIsBlocked AS NominationIsBlocked,
  i.NominationIsMarkedForDeletion AS NominationIsMarkedForDeletion,
  i.NominationItemSubStatus AS NominationItemSubStatus,
  i.NominationRefDocCode AS NominationReferenceDocType,
  i.NominationItemIsComplete AS NominationItemIsComplete,
  i.BatchOriginLocation AS BatchOriginLocation,
  i.BatchDestinationLocation AS BatchDestinationLocation,
  h.ShippingRoute AS ShippingRoute,
  h.IsBookedTransportSystem AS IsBookedTransportSystem,
  i.NominationReferenceDocType AS IsReferenceDocument,
  h.NominationEventDefaultGroup AS NominationEventDefaultGroup,
  h.NominationHeaderUom AS NominationHeaderUom,
  i.ValuationType AS ValuationType,
  i.IsNominationActual AS IsNominationActual,
  h.NominationLastHeaderActionDate AS NominationLastHeaderActionDate,
  i.DestinationCityCode AS DestinationCityCode,
  i.OriginCityCode AS OriginCityCode,
  i.QuickConfirm AS QuickConfirmationCode,
  e.NominationEventType AS NominationEventType,
  cast('' as char200) AS NominationEventComments,
  cast('' as char200) AS NominationHeaderComment,
  cast('' as char200) AS NominationGeneralComments,
  cast (_NominationTicketStsCt.NumberOfTickets as abap.char( 20 )) AS NumberOfNominationTickets,
  (case when e.NominationEventNumber = '0000' then ' ' else e.NominationEventNumber end) AS NominationEventNumber,
  e.NominationEventChangedDate AS NominationEventChangedDate,
  e.NominationEventChangedTime AS NominationEventChangedTime,
  ' ' AS NominationEvents,
  ' ' AS NominationDocComments,
  ' ' AS NominationLoadIsToBeCopied,
  ' ' AS NominationIsUpdated,
  ' ' AS NominationIsToBeCopied,
  ' ' AS NominationItemIsToBeCopied,
  _NominationVehicleIdVH.VehicleIsBlocked AS VehicleIsBlocked,
  cast('' as boolean preserving type) AS NominationIsEditEnabled,
  cast('' as boolean preserving type) AS NominationIsCopyEnabled,
  cast('' as boolean preserving type) AS NominationIsAdvCopyEnabled,
  _ScheduledMaterialVH.MaterialDesc AS MaterialDesc,
  _LocationIdVH.LocationName AS LocationName,
  concat(i.NominationDoc , i.NominationDocItem) AS NominationExtDocItem,
  _DemandMaterialVH.MaterialDesc AS LoadDemandMaterialDesc,
  _NominationTransptSystVH.TransportSystemName AS TransportSystemDesc,
  _TicketShipperVH.ShipperName AS NominationShipperDesc,
  _TicketCarrierVH.CarrierName AS NominationCarrierDesc,
  case when i.NominationReferenceDocType = 'P' or i.NominationReferenceDocType = 'K' then _LocationPartnerVendor.SupplierName when i.NominationReferenceDocType = 'G' or i.NominationReferenceDocType = 'R' or i.NominationReferenceDocType = 'S' or i.NominationReferenceDocType = 'B' then _LocationPartnerCustomer.CustomerName end as PartnerDescription AS CustomerNameendasPartnerDescription,
  _NominationVehicleIdVH.VehicleDescription AS VehicleDescription,
  i.BatchLoad AS BatchLoad,
  i.IsNominationItmOriginBatCrted AS IsNominationItmOriginBatCrted,
  i.NominationItmDestBatIsCreated AS NominationItmDestBatIsCreated,
  i.NominationItmLoadBatIsCreated AS NominationItmLoadBatIsCreated,
  i.NominationScheduleEndDateTime AS NominationScheduleEndDateTime,
  _TSWLocationTimeZone.LocationTimeZone AS LocationTimeZone
LEFT OUTER JOIN I_NominationItemFld AS i ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Oij06_Recent_Event AS e ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TSWLocationTimeZone AS _TSWLocationTimeZone ON LocationId = _TSWLocationTimeZone.TSWLocationID  -- association [1..1]
LEFT OUTER JOIN I_NominationTicketStsCt AS _NominationTicketStsCt ON NominationDoc = _NominationTicketStsCt.NominationDoc AND NominationDocItem = _NominationTicketStsCt.NominationDocItem  -- association [0..1]
LEFT OUTER JOIN I_TicketCarrierVH AS _TicketCarrierVH ON NominationCarrier = _TicketCarrierVH.NominationCarrier  -- association [0..1]
LEFT OUTER JOIN I_TicketShipperVH AS _TicketShipperVH ON NominationShipper = _TicketShipperVH.NominationShipper  -- association [0..1]
LEFT OUTER JOIN I_Supplier_VH AS _ImportExportPartner ON ImportExportPartner = _ImportExportPartner.Supplier  -- association [0..1]
LEFT OUTER JOIN I_TicketCreatedByVH AS _NominationCreatedByVH ON NominationCreatedByUser = _NominationCreatedByVH.UserID  -- association [0..1]
LEFT OUTER JOIN I_NominationLocPartnerVH AS _NominationLocPartnerVH ON LocationPartner = _NominationLocPartnerVH.LocationPartner AND TransportSystem = _NominationLocPartnerVH.TransportSystem AND LocationId = _NominationLocPartnerVH.LocationId  -- association [0..*]
LEFT OUTER JOIN I_NominationLocPartnerVH AS _NominationInspectorVH ON NominationInspector = _NominationInspectorVH.LocationPartner AND TransportSystem = _NominationInspectorVH.TransportSystem AND LocationId = _NominationInspectorVH.LocationId  -- association [0..*]
LEFT OUTER JOIN I_NominationLocPartnerVH AS _ContractPartnerVH ON ContractPartner = _ContractPartnerVH.LocationPartner AND TransportSystem = _ContractPartnerVH.TransportSystem AND LocationId = _ContractPartnerVH.LocationId  -- association [0..*]
LEFT OUTER JOIN I_NominationLocPartnerVH AS _ConsigneePartnerVH ON ConsigneePartner = _ConsigneePartnerVH.LocationPartner AND TransportSystem = _ConsigneePartnerVH.TransportSystem AND LocationId = _ConsigneePartnerVH.LocationId  -- association [0..*]
LEFT OUTER JOIN I_Oij06_Myeventss1_Object AS _Events ON NominationDoc = _Events.NominationDoc AND NominationDocItem = _Events.NominationDocItem  -- association [0..*]
LEFT OUTER JOIN I_LocationIdVH AS _LocationIdVH ON LocationId = _LocationIdVH.LocationId  -- association [0..1]
LEFT OUTER JOIN I_ScheduledMaterialVH AS _ScheduledMaterialVH ON ScheduledMaterial = _ScheduledMaterialVH.ScheduledMaterial  -- association [0..1]
LEFT OUTER JOIN I_ScheduledMaterialVH AS _DemandMaterialVH ON DemandMaterial = _DemandMaterialVH.ScheduledMaterial  -- association [0..1]
LEFT OUTER JOIN I_NominationKeyVH AS _NominationKeyVH ON NominationDoc = _NominationKeyVH.NominationDoc  -- association [0..*]
LEFT OUTER JOIN I_NominationKeyVH AS _NominationExtNumberVH ON NominationDoc = _NominationExtNumberVH.NominationDoc  -- association [0..*]
LEFT OUTER JOIN I_NominationItemVH AS _NominationItemVH ON NominationDoc = _NominationItemVH.NominationDoc AND NominationDocItem = _NominationItemVH.NominationDocItem  -- association [1..1]
LEFT OUTER JOIN I_NominationVehicleIdVH AS _NominationVehicleIdVH ON VehicleId = _NominationVehicleIdVH.VehicleId  -- association [0..1]
LEFT OUTER JOIN I_NominationTypeVH AS _NominationTypeVH ON NominationType = _NominationTypeVH.NominationType  -- association [0..1]
LEFT OUTER JOIN I_NominationBusinessTypeVH AS _NominationBusinessTypeVH ON BusinessType = _NominationBusinessTypeVH.BusinessType  -- association [0..1]
LEFT OUTER JOIN I_NominationDestValnTypeVH AS _NominationDestValnTypeVH ON ValuationTypeDestination = _NominationDestValnTypeVH.ValuationType  -- association [0..1]
LEFT OUTER JOIN I_NominationDestValnTypeVH AS _NominationOriginValnTypeVH ON ValuationTypeOrigin = _NominationOriginValnTypeVH.ValuationType  -- association [0..1]
LEFT OUTER JOIN I_NominationDocNumberVH AS _NominationDocNumberVH ON NominationReferenceDocument = _NominationDocNumberVH.NominationReferenceDocument  -- association [0..*]
LEFT OUTER JOIN I_NominationInTrnstPlantVH AS _NominationInTrnstPlantVH ON InTransitPlant = _NominationInTrnstPlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN I_NominationInTrnstStorLocVH AS _NominationInTrnstStorLocVH ON InTransitStorageLocation = _NominationInTrnstStorLocVH.InTransitStorageLocation AND InTransitPlant = _NominationInTrnstStorLocVH.Plant  -- association [0..1]
LEFT OUTER JOIN I_NominationItemStatusVH AS _NominationItemStatusVH ON NominationItemStatus = _NominationItemStatusVH.TicketItemStatus  -- association [0..*]
LEFT OUTER JOIN I_NominationHeaderStatusVH AS _NominationHeaderStatusVH ON NominationHeaderStatus = _NominationHeaderStatusVH.NominationHeaderStatus AND _NominationHeaderStatusVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_NominationItemSubStsVH AS _NominationItemSubStsVH ON NominationItemSubStatus = _NominationItemSubStsVH.NominationItemSubStatus  -- association [0..1]
LEFT OUTER JOIN I_NominationModeOfTranspVH AS _NominationModeOfTranspVH ON NominationModeOfTransport = _NominationModeOfTranspVH.ModeOfTransport  -- association [0..1]
LEFT OUTER JOIN I_NominationRefDocIndVH AS _NominationRefDocTypeIndVH ON NominationReferenceDocType = _NominationRefDocTypeIndVH.IsReferenceDocument  -- association [0..1]
LEFT OUTER JOIN I_NominationRefDocIndVH AS _NominationRefDocIndVH ON IsReferenceDocument = _NominationRefDocIndVH.IsReferenceDocument  -- association [0..1]
LEFT OUTER JOIN I_NominationScheduleTypeVH AS _NominationScheduledTypeVH ON NominationScheduleType = _NominationScheduledTypeVH.ScheduleType  -- association [0..1]
LEFT OUTER JOIN I_NominationTranspPlanPtVH AS _NominationTranspPlanPtVH ON TransportationPlanningPoint = _NominationTranspPlanPtVH.TransportationPlanningPoint  -- association [0..1]
LEFT OUTER JOIN I_NominationTransptSystVH AS _NominationTransptSystVH ON TransportSystem = _NominationTransptSystVH.TransportSystem  -- association [0..1]
LEFT OUTER JOIN I_NominationUoMVH AS _NominationUoMVH ON ScheduledQuantityUnit = _NominationUoMVH.TicketUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_NominationUoMVH AS _HeaderUoMVH ON NominationHeaderUom = _HeaderUoMVH.TicketUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_NominationUoMVH AS _ActualUoMVH ON ActualScheduledQuantityUnit = _ActualUoMVH.TicketUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_BulkShipmentType AS _BulkShipmentType ON BulkShipmentType = _BulkShipmentType.BulkShipmentType  -- association [0..1]
LEFT OUTER JOIN I_NominationImprtExprtIndVH AS _NominationImprtExprtIndVH ON IsImportExportPartner = _NominationImprtExprtIndVH.PartnerIndImportExport  -- association [0..*]
LEFT OUTER JOIN I_NominationIncompleteIndVH AS _NominationIncompleteIndVH ON NominationIsIncomplete = _NominationIncompleteIndVH.NominationIndIncomplete  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _ContractPartnerCustomer ON ContractPartner = _ContractPartnerCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _ContractPartnerVendor ON ContractPartner = _ContractPartnerVendor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ConsigneePartnerCustomer ON ConsigneePartner = _ConsigneePartnerCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _ConsigneePartnerVendor ON ConsigneePartner = _ConsigneePartnerVendor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _LocationPartnerCustomer ON LocationPartner = _LocationPartnerCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _LocationPartnerVendor ON LocationPartner = _LocationPartnerVendor.Supplier  -- association [0..1]
;