I_NominationTicketInfo

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_NominationTicketInfo.
-- 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: INOMTKTINFO

CREATE VIEW I_NominationTicketInfo AS
SELECT
  ticketitem.NominationTicketKey AS NominationTicketKey,
  ticketitem.NominationTicketItem AS NominationTicketItem,
  ticketitem.NominationTicketPurpose AS NominationTicketPurpose,
  ticketitem.NominationTicketVersion AS NominationTicketVersion,
  ticketitem.NominationDoc AS NominationDoc,
  ticketitem.NominationDocItem AS NominationDocItem,
  ticketitem.NominationExtNumber AS NominationExtNumber,
  nomitem.NominationScheduleType AS NominationScheduleType,
  nomitem.DemandMaterial AS DemandMaterial,
  nomhead.NominationType AS NominationType,
  nomitem.LocationName AS LocationName,
  nomitem.LocationId AS LocationId,
  nomhead.TransportSystem AS TransportSystem,
  ticketitem.ScheduledMaterial AS ScheduledMaterial,
  ticketitem.BaseUnit AS BaseUnit,
  ticketitem.TicketDocumentPostingDate AS TicketDocumentPostingDate,
  errorstat.TicketMessageType AS TicketMessageType,
  ticketitem.ScheduledQuantity AS ScheduledQuantity,
  cast(0 as timestamp ) AS QuantityStartDateTime,
  cast(0 as timestamp ) AS QuantityEndDateTime,
  cast(0 as timestamp ) AS QuantityPostingDateTime,
  ticketitem.GeneralMeterNumber AS GeneralMeterNumber,
  cast('' as char12) AS MeterOpenQuantity,
  ticketitem.EndCounterMeterReading AS EndCounterMeterReading,
  ticketitem.OpenMeterDateTime AS OpenMeterDateTime,
  ticketitem.CloseMeterDateTime AS CloseMeterDateTime,
  ticketitem.StopMeterCalculationQuantity AS StopMeterCalculationQuantity,
  ticketitem.StopMeterUnitOfMeasure AS StopMeterUnitOfMeasure,
  ticketitem.TankSequenceNumber AS TankSequenceNumber,
  ticketitem.StorageObjectSegmentNumber AS StorageObjectSegmentNumber,
  ticketitem.OpenDipReading AS OpenDipReading,
  cast(0 as timestamp ) AS OpenTankDipDateTime,
  ticketitem.CloseDipReading AS CloseDipReading,
  cast(0 as timestamp ) AS CloseTankDipDateTime,
  ticketitem.CalculatedGaugeQuantity AS CalculatedGaugeQuantity,
  cast('' as char6) AS GaugeTimeZone,
  ticketitem.TicketCreatedByUser AS TicketCreatedByUser,
  ticketitem.TicketCreationDate AS TicketCreationDate,
  ticketitem.TicketCreationTime AS TicketCreationTime,
  ticketitem.TicketChangedByUser AS TicketChangedByUser,
  ticketitem.NominationItemStatus AS NominationItemStatus,
  ticketitem.NominationItemSubStatus AS NominationItemSubStatus,
  ticketitem.NominationTicketStatus AS NominationTicketStatus,
  cast('Q' as abap.char(15)) AS TypeOfMovement,
  cast('' as boolean preserving type) AS QuantityIsMarked,
  cast('X' as boolean preserving type) AS MeterIsMarked,
  cast('' as boolean preserving type) AS GaugeIsMarked,
  tickethead.TicketNumber AS TicketNumber,
  tickethead.TicketExternalNumber AS TicketExternalNumber,
  tickethead.NominationTicketType AS NominationTicketType,
  ticketitem.VehicleId AS VehicleId,
  ticketitem.TicketChangedDate AS TicketChangedDate,
  ticketitem.NominationEventDate AS NominationEventDate,
  ticketitem.StopGaugeUnitOfMeasure AS StopGaugeUnitOfMeasure,
  ticketitem.BulkShipmentType AS BulkShipmentType,
  ticketitem.OriginPlant AS OriginPlant,
  ticketitem.OriginStorageLocation AS OriginStorageLocation,
  ticketitem.DestinationPlant AS DestinationPlant,
  ticketitem.DestinationStorageLocation AS DestinationStorageLocation
LEFT OUTER JOIN I_TicketHeaderFld AS tickethead ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationItemFld AS nomitem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationHeaderFld AS nomhead ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationTicketErrSts AS errorstat ON /* join condition not captured in parsed metadata */
;