I_TicketInfoFld

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_TicketInfoFld.
-- 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: ITICKETINFOFLD

CREATE VIEW I_TicketInfoFld AS
SELECT
  TicketItemFld.NominationTicketKey AS NominationTicketKey,
  TicketItemFld.NominationTicketItem AS NominationTicketItem,
  TicketItemFld.NominationTicketVersion AS NominationTicketVersion,
  TicketItemFld.NominationTicketPurpose AS NominationTicketPurpose,
  TicketItemFld.NominationDoc AS NominationDoc,
  TicketItemFld.NominationDocItem AS NominationDocItem,
  TicketItemFld.NominationExtNumber AS NominationExtNumber,
  NominationItemFld.NominationScheduleType AS NominationScheduleType,
  NominationItemFld.DemandMaterial AS DemandMaterial,
  NominationHeaderFld.NominationType AS NominationType,
  NominationHeaderFld.InTransitPlant AS InTransitPlant,
  NominationItemFld.LocationName AS LocationName,
  NominationItemFld.LocationId AS LocationId,
  NominationItemFld.ScheduledQuantity AS NominationSchedQuantity,
  ScheduledQuantityUnit,
  NominationItemFld.ActualScheduledQuantity AS ActualScheduledQuantity,
  NominationItemFld.ActualScheduledQuantityUnit AS ActualScheduledQuantityUnit,
  NominationHeaderFld.TransportSystem AS TransportSystem,
  TicketItemFld.ScheduledMaterial AS ScheduledMaterial,
  TicketItemFld.BaseUnit AS BaseUnit,
  TicketItemFld.TicketDocumentPostingDate AS TicketDocumentPostingDate,
  TicketErrorLogCheck.TicketMessageType AS TicketMessageType,
  TicketItemFld.ScheduledQuantity AS ScheduledQuantity,
  TicketItemFld.TicketQuantityStartDate AS TSWTicketStartDate,
  TicketItemFld.TicketQuantityStartTime AS TSWTicketStartTime,
  TicketItemFld.TicketQuantityEndDate AS TSWTicketEndDate,
  TicketItemFld.TicketQuantityEndTime AS TSWTicketEndTime,
  TicketItemFld.TicketDocumentPostingDate AS TSWTicketPostingDate,
  TicketItemFld.TicketDocumentPostingTime AS TSWTicketPostingTime,
  TicketItemFld.GeneralMeterNumber AS GeneralMeterNumber,
  cast('' as char12) AS MeterOpenQuantity,
  TicketItemFld.EndCounterMeterReading AS EndCounterMeterReading,
  TicketItemFld.OpenMeterDateTime AS OpenMeterDateTime,
  TicketItemFld.CloseMeterDateTime AS CloseMeterDateTime,
  TicketItemFld.StopMeterCalculationQuantity AS StopMeterCalculationQuantity,
  TicketItemFld.StopMeterUnitOfMeasure AS StopMeterUnitOfMeasure,
  TicketItemFld.TankSequenceNumber AS TankSequenceNumber,
  TicketItemFld.StorageObjectSegmentNumber AS StorageObjectSegmentNumber,
  TicketItemFld.OpenDipReading AS OpenDipReading,
  cast(TicketItemFld.OpenTankDipDateTime as timestamp ) AS OpenTankDipDateTime,
  TicketItemFld.CloseDipReading AS CloseDipReading,
  cast(TicketItemFld.CloseTankDipDateTime as timestamp ) AS CloseTankDipDateTime,
  TicketItemFld.CalculatedGaugeQuantity AS CalculatedGaugeQuantity,
  cast('' as char6) AS GaugeTimeZone,
  TicketItemFld.TicketCreatedByUser AS TicketCreatedByUser,
  TicketItemFld.TicketCreationDate AS TicketCreationDate,
  TicketItemFld.TicketCreationTime AS TicketCreationTime,
  TicketItemFld.TicketChangedByUser AS TicketChangedByUser,
  TicketItemFld.NominationItemStatus AS NominationItemStatus,
  TicketItemFld.NominationItemSubStatus AS NominationItemSubStatus,
  TicketItemFld.NominationTicketStatus AS NominationTicketStatus,
  TicketMovementType.TypeOfMovement AS TypeOfMovement,
  cast('' as boolean preserving type) AS QuantityIsMarked,
  cast('X' as boolean preserving type) AS MeterIsMarked,
  cast('' as boolean preserving type) AS GaugeIsMarked,
  TicketHeaderFld.TicketNumber AS TicketNumber,
  TicketHeaderFld.TicketExternalNumber AS TicketExternalNumber,
  TicketHeaderFld.NominationTicketType AS NominationTicketType,
  TicketItemFld.VehicleId AS VehicleId,
  TicketItemFld.TicketChangedDate AS TicketChangedDate,
  TicketItemFld.NominationEventDate AS NominationEventDate,
  TicketItemFld.StopGaugeUnitOfMeasure AS StopGaugeUnitOfMeasure,
  TicketItemFld.BulkShipmentType AS BulkShipmentType,
  TicketItemFld.OriginPlant AS OriginPlant,
  TicketItemFld.OriginStorageLocation AS OriginStorageLocation,
  TicketItemFld.DestinationPlant AS DestinationPlant,
  TicketItemFld.DestinationStorageLocation AS DestinationStorageLocation,
  case TicketLocationType.NominationLocationType when 'O' then TicketItemFld.OriginPlant when 'D' then TicketItemFld.DestinationPlant end as Plant AS DestinationPlantendasPlant,
  TicketItemFld.IsNominationItemClosed AS IsNominationItemClosed,
  NominationHeaderFld.NominationDocIsBlocked AS NominationDocIsBlocked,
  TicketHeaderFld.NominationTicketIsBlocked AS NominationTicketIsBlocked
INNER JOIN I_TicketHeaderFld AS TicketHeaderFld ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationItemFld AS NominationItemFld ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationHeaderFld AS NominationHeaderFld ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationLocationVH AS NominationLocationVH ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TicketErrorLogCheck AS TicketErrorLogCheck ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TicketMovementType AS TicketMovementType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_NominationTicketItem AS _TicketItemExtension ON NominationTicketKey = _TicketItemExtension.NominationTicketKey AND NominationTicketItem = _TicketItemExtension.NominationTicketItem AND NominationTicketVersion = _TicketItemExtension.NominationTicketVersion AND NominationTicketPurpose = _TicketItemExtension.NominationTicketPurpose  -- association [1..1]
LEFT OUTER JOIN I_TicketLocationType AS TicketLocationType ON TicketItemFld.NominationScheduleType = TicketLocationType.NominationScheduleType  -- association [1..1]
;