C_TicketItemTP

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_TicketItemTP.
-- 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: CTICKETITEMTP

CREATE VIEW C_TicketItemTP AS
SELECT
  NominationTicketItem,
  NominationTicketKey,
  NominationTicketVersion,
  NominationTicketPurpose,
  TicketExternalNumber,
  TicketStatusColorCode,
  LatestTicketStatus,
  NominationTicketStatus,
  NominationDoc,
  NominationDocItem,
  NominationExtNumber,
  NominationScheduleType,
  NominationType,
  DemandMaterial,
  LocationName,
  TransportSystem,
  NominationTicketType,
  ScheduledMaterial,
  BaseUnit,
  ScheduledQuantity,
  LocationId,
  TicketDocumentPostingDate,
  TicketCorruptMode,
  TicketReverseMode,
  TicketCorrectionMode,
  TypeOfMovement,
  PlantTimeZone,
  QuantityStartDateTime,
  QuantityEndDateTime,
  QuantityPostingDateTime,
  GeneralMeterNumber,
  MeterOpenQuantity,
  EndCounterMeterReading,
  OpenMeterDateTime,
  CloseMeterDateTime,
  StopMeterCalculationQuantity,
  StopMeterUnitOfMeasure,
  TankSequenceNumber,
  StorageObjectSegmentNumber,
  GaugeTimeZone,
  OpenTankDipDateTime,
  CloseTankDipDateTime,
  GaugeOpenDipReading,
  GaugeCloseDipReading,
  CalculatedGaugeQuantity,
  IsNominationItemClosed,
  TicketCreatedByUser,
  TicketCreationTimeStmp,
  TSWTicketCreationDate,
  TSWTicketCreationTime,
  TicketChangedByUser,
  NominationItemStatus,
  NominationItemSubStatus,
  TicketChangedDate,
  NominationEventDate,
  StopGaugeUnitOfMeasure,
  BulkShipmentType,
  OriginPlant,
  OriginStorageLocation,
  DestinationPlant,
  ActualScheduledQuantity,
  NominationSchedQuantity,
  InTransitPlant,
  ScheduledQuantityUnit,
  ActualScheduledQuantityUnit,
  NominationTicketIsBlocked,
  NominationDocIsBlocked
FROM I_TicketItemTP AS _TicketItemTP
LEFT OUTER JOIN C_TicketHeadTP AS _TicketHeadTP ON NominationTicketKey = _TicketHeadTP.NominationTicketKey AND NominationTicketVersion = _TicketHeadTP.NominationTicketVersion  -- association [1..1]
LEFT OUTER JOIN C_NominationKeyVH AS _NominationKeyVH ON NominationDoc = _NominationKeyVH.NominationDoc AND NominationExtNumber = _NominationKeyVH.NominationExtNumber  -- association [0..1]
LEFT OUTER JOIN C_NominationItemVH AS _NominationDocItemVH ON NominationDoc = _NominationDocItemVH.NominationDoc AND NominationDocItem = _NominationDocItemVH.NominationDocItem  -- association [0..1]
LEFT OUTER JOIN C_TicketDocFlow AS _TicketDocFlow ON NominationTicketKey = _TicketDocFlow.NominationTicketKey AND NominationTicketItem = _TicketDocFlow.NominationTicketItem AND NominationTicketVersion = _TicketDocFlow.NominationTicketVersion AND NominationTicketPurpose = _TicketDocFlow.NominationTicketPurpose  -- association [0..*]
LEFT OUTER JOIN C_TicketErrorLog AS _TicketErrorLog ON NominationTicketKey = _TicketErrorLog.NominationTicketKey AND NominationTicketItem = _TicketErrorLog.NominationTicketItem AND NominationTicketPurpose = _TicketErrorLog.NominationTicketPurpose  -- association [0..*]
LEFT OUTER JOIN C_NominationLocationVH AS _NominationLocationVH ON LocationId = _NominationLocationVH.LocationId  -- association [0..1]
LEFT OUTER JOIN C_NominationUoMVH AS _NominationUoMVH ON BaseUnit = _NominationUoMVH.TicketUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN C_NominationMaterialVH AS _NominationMaterialVH ON DemandMaterial = _NominationMaterialVH.ScheduledMaterial AND LocationId = _NominationMaterialVH.TSWLocationID  -- association [0..1]
LEFT OUTER JOIN C_TicketTypeVH AS _TicketTypeVH ON NominationTicketType = _TicketTypeVH.NominationTicketType  -- association [0..1]
LEFT OUTER JOIN C_TicketAdditionalParamTP AS _TicketAdditionalParamTP ON NominationTicketKey = _TicketAdditionalParamTP.NominationTicketKey AND NominationTicketItem = _TicketAdditionalParamTP.NominationTicketItem AND NominationTicketVersion = _TicketAdditionalParamTP.NominationTicketVersion  -- association [0..*]
LEFT OUTER JOIN C_TicketAdditionalQtyTP AS _TicketAdditionalQtyTP ON NominationTicketKey = _TicketAdditionalQtyTP.NominationTicketKey AND NominationTicketItem = _TicketAdditionalQtyTP.NominationTicketItem AND NominationTicketVersion = _TicketAdditionalQtyTP.NominationTicketVersion  -- association [0..*]
LEFT OUTER JOIN C_TicketTankSqncNoVH AS _TicketTankSqncNoVH ON LocationId = _TicketTankSqncNoVH.LocationId AND ScheduledMaterial = _TicketTankSqncNoVH.ScheduledMaterial AND TankSequenceNumber = _TicketTankSqncNoVH.TankSequenceNumber AND QuantityEndDateTime = _TicketTankSqncNoVH.QuantityEndDateTime AND NominationDoc = _TicketTankSqncNoVH.NominationDoc AND NominationDocItem = _TicketTankSqncNoVH.NominationDocItem  -- association [0..*]
LEFT OUTER JOIN C_TicketGaugeOpnDipVH AS _TicketGaugeOpnDipVH ON TankSequenceNumber = _TicketGaugeOpnDipVH.GaugeTankSequenceNumber AND GaugeTimeZone = _TicketGaugeOpnDipVH.GaugeTimeZone AND LocationId = _TicketGaugeOpnDipVH.LocationId AND GaugeOpenDipReading = _TicketGaugeOpnDipVH.GaugeOpenDipReading AND OpenTankDipDateTime = _TicketGaugeOpnDipVH.OpenTankDipDateTime  -- association [0..*]
LEFT OUTER JOIN C_TicketGaugeClsDipVH AS _TicketGaugeClsDipVH ON TankSequenceNumber = _TicketGaugeClsDipVH.GaugeTankSequenceNumber AND GaugeTimeZone = _TicketGaugeClsDipVH.GaugeTimeZone AND LocationId = _TicketGaugeClsDipVH.LocationId AND GaugeCloseDipReading = _TicketGaugeClsDipVH.GaugeCloseDipReading AND CloseTankDipDateTime = _TicketGaugeClsDipVH.CloseTankDipDateTime  -- association [0..*]
LEFT OUTER JOIN C_NominationMeterNoVH AS _NominationMeterNoVH ON LocationId = _NominationMeterNoVH.LocationId AND GeneralMeterNumber = _NominationMeterNoVH.GeneralMeterNumber AND TransportSystem = _NominationMeterNoVH.TransportSystem  -- association [0..*]
LEFT OUTER JOIN C_TicketMvtTypeVH AS _TicketMvtTypeVH ON TypeOfMovement = _TicketMvtTypeVH.TypeOfMovement  -- association [0..1]
LEFT OUTER JOIN C_TicketPurposeVH AS _TicketPurposeVH ON NominationTicketPurpose = _TicketPurposeVH.NominationTicketPurpose  -- association [0..1]
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]
;