I_TripItemTP

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_TripItemTP.
-- 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: ITRIPITEMTP

CREATE VIEW I_TripItemTP AS
SELECT
  trip_id AS TripDoc,
  trip_item AS TripDocItem,
  seqnr AS LocationSequenceNumber,
  locid AS LocationId,
  knote AS TripTransportConnectionPoint,
  bezei AS TransportationConnectionPoint,
  case when _TripHeadTP.TripDocType = 'N' then _TripNominationItmTP.Plant when _TripHeadTP.TripDocType = 'D' then _TripOutbDeliveryItemTP.Plant when _TripHeadTP.TripDocType = 'S' then _TripShptItmTP.Plant end as Plant AS PlantendasPlant,
  cast(0 as abap.char(4)) AS StorageLocation,
  cast(0 as abap.char(10)) AS CustomerReferenceNumber,
  cast(0 as abap.char(10)) AS SupplierAccountNumber,
  cast(0 as abap.char(4)) AS ShippingPoint,
  cast(0 as abap.char(4)) AS LoadingPoint
FROM oij08_tripitm
LEFT OUTER JOIN I_TripItemDemurrageCalc AS DemurrageCalc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TripItemLocationTimeZone AS _TripItemLocationTimeZone ON LocationId = _TripItemLocationTimeZone.TSWLocationID  -- association [1..1]
LEFT OUTER JOIN I_TripHeadTP AS _TripHeadTP ON TripDoc = _TripHeadTP.TripDoc  -- association [1..1]
LEFT OUTER JOIN I_TripNominationItmTP AS _TripNominationItmTP ON TripDoc = _TripNominationItmTP.TripDoc AND TripDocItem = _TripNominationItmTP.TripDocItem  -- association [0..*]
LEFT OUTER JOIN I_TripShptItmTP AS _TripShptItmTP ON TripDoc = _TripShptItmTP.TripDoc AND TripDocItem = _TripShptItmTP.TripDocItem  -- association [0..*]
LEFT OUTER JOIN I_TripOutbDeliveryItemTP AS _TripOutbDeliveryItemTP ON TripDoc = _TripOutbDeliveryItemTP.TripDoc AND TripDocItem = _TripOutbDeliveryItemTP.TripDocItem  -- association [0..*]
LEFT OUTER JOIN I_TripLayTimeEventsTP AS _TripLayTimeEventsTP ON TripDoc = _TripLayTimeEventsTP.TripDoc AND TripDocItem = _TripLayTimeEventsTP.TripDocItem  -- association [0..*]
LEFT OUTER JOIN I_TripInfluencingEventsTP AS _TripInfluencingEventsTP ON TripDoc = _TripInfluencingEventsTP.TripDoc AND TripDocItem = _TripInfluencingEventsTP.TripDocItem  -- association [0..*]
LEFT OUTER JOIN I_TripOtherEventsTP AS _TripOtherEventsTP ON TripDoc = _TripOtherEventsTP.TripDoc AND TripDocItem = _TripOtherEventsTP.TripDocItem  -- association [0..*]
LEFT OUTER JOIN I_TripStakeholdersTP AS _TripStakeholdersTP ON TripDoc = _TripStakeholdersTP.TripDoc AND TripDocItem = _TripStakeholdersTP.TripDocItem  -- association [0..*]
LEFT OUTER JOIN I_TripSchedOfChargesTP AS _TripSchedOfChargesTP ON TripDoc = _TripSchedOfChargesTP.TripDoc AND TripDocItem = _TripSchedOfChargesTP.TripDocItem  -- association [0..*]
LEFT OUTER JOIN I_TripItemStatusVH AS _TripItemStatusVH ON TripItemStatus = _TripItemStatusVH.TripItemStatus  -- association [0..*]
LEFT OUTER JOIN I_LocationIdVH AS _LocationIdVH ON LocationId = _LocationIdVH.LocationId  -- association [0..1]
LEFT OUTER JOIN I_NominationRefDocIndVH AS _NominationRefDocIndVH ON IsReferenceDocument = _NominationRefDocIndVH.IsReferenceDocument  -- association [0..1]
LEFT OUTER JOIN I_FreightContractVH AS _FreightContractVH ON FreightContract = _FreightContractVH.FreightContract AND LocationId = _FreightContractVH.LocationId  -- association [1..1]
LEFT OUTER JOIN I_FreightContractVH AS _FreightContractItemVH ON FreightContract = _FreightContractItemVH.FreightContract AND FreightContractItem = _FreightContractItemVH.FreightContractItem AND LocationId = _FreightContractItemVH.LocationId  -- association [0..1]
LEFT OUTER JOIN I_TripScheduleTypeVH AS _TripScheduleTypeVH ON NominationScheduleType = _TripScheduleTypeVH.NominationScheduleType  -- association [0..*]
LEFT OUTER JOIN E_TripItemTP AS _TripItemExtension ON TripDoc = _TripItemExtension.TripDoc AND TripDocItem = _TripItemExtension.TripDocItem  -- association [1..1]
;