I_NominationTicketDetail

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_NominationTicketDetail.
-- 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: INOMTICKETDET

CREATE VIEW I_NominationTicketDetail AS
SELECT
  NominationItem.NominationDoc AS NominationDoc,
  NominationItem.NominationDocItem AS NominationDocItem,
  NominationSchedldMvtPegging.NominationPegID AS NominationPegID,
  NominationHeader.NominationExtNumber AS NominationExtNumber,
  NominationItem.ScheduledMaterial AS ScheduledMaterial,
  NominationItem.OilLocationPartnerPlant AS OilLocationPartnerPlant,
  NominationItem.OilLocationPartnerStorageLoc AS OilLocationPartnerStorageLoc,
  NominationItem.ScheduledQuantity AS ScheduledQuantity,
  NominationItem.ScheduledQuantityUnit AS ScheduledQuantityUnit,
  NominationItem.NominationScheduleType AS NominationScheduleType,
  NominationItem.LocationId AS LocationId,
  _OilBusinessLocation.TimeZoneID AS TimeZoneID,
  NominationItem.NominationScheduleDate AS NominationScheduleDate,
  NominationHeader.VehicleId AS VehicleId,
  NominationHeader.NominationCarrier AS NominationCarrier,
  NominationHeader.NominationShipper AS NominationShipper,
  NominationItem.NominationInspector AS NominationInspector,
  NominationHeader.TransportSystem AS TransportSystem,
  NominationHeader.NominationModeOfTransport AS NominationModeOfTransport,
  NominationHeader.BulkShipmentType AS BulkShipmentType,
  TicketItem.ScheduledQuantity AS NominationTicketActualQuantity,
  TicketItem.BaseUnit AS NominationTicketActualQtyUoM,
  TicketItem.NominationIsClosed AS NominationIsClosed,
  NominationItem.NominationItemIsComplete AS NominationItemIsComplete,
  tstmp_to_dats( cast(cast(NominationTicketLoadEndDteTme as abap.numc(15)) as timestamp), _OilBusinessLocation.TimeZoneID, $session.client, 'NULL' ) as NominationTicketLoadEndDate AS clientNULLasNominationTicketLoadEndDate,
  tstmp_to_tims( cast(cast(NominationTicketLoadEndDteTme as abap.numc(15)) as timestamp), _OilBusinessLocation.TimeZoneID, $session.client, 'NULL' ) as NominationTicketLoadEndTime AS clientNULLasNominationTicketLoadEndTime,
  cast(cast(NominationTicketLoadStrtDteTme as abap.numc(15)) as timestamp) AS NominationTicketLoadStrtDteTme,
  cast(cast(NominationTicketLoadEndDteTme as abap.numc(15)) as timestamp) AS NominationTicketLoadEndDteTme,
  NominationLastTicketStatus.NominationTicketStatus AS NominationTicketStatus,
  OilMovementScenario,
  NominationLastTicketStatus.NominationTicketKey AS NominationTicketKey,
  NominationLastTicketStatus.NominationTicketItem AS NominationTicketItem,
  NominationLastTicketStatus.NominationTicketPurpose AS NominationTicketPurpose,
  NominationLastTicketStatus.NominationTicketVersion AS NominationTicketVersion,
  NominationLastTicketStatus.NominationLastTicketStatus AS NominationLastTicketStatus,
  NominationLastTicketStatus.NominationInProcessQuantity AS NominationInProcessQuantity,
  NominationItem.ActualScheduledQuantity AS ActualScheduledQuantity,
  NominationItem.ActualScheduledQuantityUnit AS ActualScheduledQuantityUnit,
  TicketItem.TicketCreationDate AS TicketCreationDate,
  TicketItem.TicketCreationTime AS TicketCreationTime,
  cast('' as abap.char(40)) AS LocationIDDesc,
  cast('' as abap.char(40)) AS NominationOriginLocationDesc,
  cast('' as abap.char(40)) AS NominationDestLocationDesc,
  cast('' as abap.char(40)) AS NominationModeOfTransportDesc,
  cast('' as abap.char(40)) AS NominationScheduleTypeDesc,
  cast('' as abap.char(40)) AS TransportSystemDesc,
  cast('' as abap.char(40)) AS VehicleIdDesc,
  cast('' as abap.char(40)) AS NominationTicketActlQtyUoMDesc,
  cast('' as abap.char(40)) AS ScheduledQuantityUnitDesc,
  cast('' as abap.char(40)) AS NominationInProcessUoMDesc,
  cast('' as abap.char(40)) AS ActualSchedldQuantityUnitDesc,
  NominationDocIsBlocked
FROM I_NominationItemFld AS NominationItem
INNER JOIN I_NominationHeaderFld AS NominationHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_OilTransportSystem AS OilTransportSystem ON /* join condition not captured in parsed metadata */
INNER JOIN I_NominationMovementScenario AS MovementScenario ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationTicketStatus AS NominationLastTicketStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationTicketItemFld AS TicketItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationSchedldMvtPegging AS NominationSchedldMvtPegging ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationMblTicketConfign AS NominationConfiguration ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationItemLocationDetail AS NominationItemLocationDetail ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OilBusinessLocation AS _OilBusinessLocation ON NominationItem.LocationId = _OilBusinessLocation.LocationId  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _NominationShipper ON NominationShipper = _NominationShipper.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _NominationCarrier ON NominationCarrier = _NominationCarrier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _NominationInspector ON NominationInspector = _NominationInspector.Supplier  -- association [1..1]
;