I_TicketItemFld

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_TicketItemFld.
-- 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: ITICKETITEMFLDS

CREATE VIEW I_TicketItemFld AS
SELECT
  ticket_key AS NominationTicketKey,
  ticket_item AS NominationTicketItem,
  ticket_version AS NominationTicketVersion,
  ticket_purpose AS NominationTicketPurpose,
  ext_posnr AS NominationTicketExtNumber,
  status AS NominationItemStatus,
  substatus AS NominationItemSubStatus,
  sityp AS NominationScheduleType,
  tktsubrc AS NominationTicketStatus,
  mvscenario AS MaterialMovementType,
  nomnr AS NominationExtNumber,
  nomtk AS NominationDoc,
  nomit AS NominationDocItem,
  locid AS LocationId,
  tanknr AS TankSequenceNumber,
  vehicle AS VehicleId,
  menge AS ScheduledQuantity,
  meins AS BaseUnit,
  matnr AS ScheduledMaterial,
  erdat AS TicketCreationDate,
  erzeit AS TicketCreationTime,
  ernam AS TicketCreatedByUser,
  aedat AS TicketChangedDate,
  aenam AS TicketChangedByUser,
  budat AS TicketDocumentPostingDate,
  event_date AS NominationEventDate,
  gmmnr AS GeneralMeterNumber,
  o_itmstm AS OpenMeterDateTime,
  c_itmstm AS CloseMeterDateTime,
  stoprdg AS EndCounterMeterReading,
  stm_quantity AS StopMeterCalculationQuantity,
  stm_uom AS StopMeterUnitOfMeasure,
  socnr AS StorageObjectSegmentNumber,
  o_dip_read AS OpenDipReading,
  o_dip_read_uom AS OpenDipUnitOfMeasure,
  o_etmstm AS OpenTankDipDateTime,
  c_dip_read AS CloseDipReading,
  c_etmstm AS CloseTankDipDateTime,
  stp_gau_quan AS StopGaugeCalculationQuantity,
  stp_gau_uom AS StopGaugeUnitOfMeasure,
  gau_quantity AS CalculatedGaugeQuantity,
  gau_uom AS GaugeCalculationUoM,
  shtype AS BulkShipmentType,
  werks_o AS OriginPlant,
  lgort_o AS OriginStorageLocation,
  charg_d AS BatchDestinationLocation,
  werks_d AS DestinationPlant,
  lgort_d AS DestinationStorageLocation,
  time_st_load_sta AS QuantityStartDateTime,
  time_st_load_end AS QuantityEndDateTime,
  oib_bltime AS TicketDocumentPostingTime,
  cast( substring( time_st_load_sta, 1, 8 ) as abap.dats) AS TicketQuantityStartDate,
  cast( substring( time_st_load_sta, 9, 14 ) as abap.tims) AS TicketQuantityStartTime,
  cast( substring( time_st_load_end, 1, 8 ) as abap.dats) AS TicketQuantityEndDate,
  cast( substring( time_st_load_end, 9, 14 ) as abap.tims) AS TicketQuantityEndTime,
  cast(close_nomit as boolean) AS IsNominationItemClosed
FROM oij_el_ticket_i
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]
;