I_TripOutboundDelivery

DDL: I_TRIPOUTBOUNDDELIVERY SQL: ITRIPOTBDL Type: view BASIC

Outbound Delivery details

I_TripOutboundDelivery is a Basic CDS View that provides data about "Outbound Delivery details" in SAP S/4HANA. It reads from 3 data sources (oij_el_cp_layt, likp, lips) and exposes 6 fields with key fields OutboundDelivery, OutboundDeliveryItem.

Data Sources (3)

SourceAliasJoin Type
oij_el_cp_layt oij_el_cp_layt left_outer
likp outbdelhdr from
lips outddelitm inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ITRIPOTBDL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
EndUserText.label Outbound Delivery details view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery likp vbeln SD Sched. Agmt
KEY OutboundDeliveryItem lips posnr WBS Element
ShipToParty likp kunnr Stock customer
SoldToParty likp kunag Sold-to Party
ShippingPoint likp vstel ShpPtDeparture
VehicleId oij_el_cp_layt vehicle Vehicle Number

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_TripOutboundDelivery.
-- 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: ITRIPOTBDL

CREATE VIEW I_TripOutboundDelivery AS
SELECT
  outbdelhdr.vbeln AS OutboundDelivery,
  outddelitm.posnr AS OutboundDeliveryItem,
  outbdelhdr.kunnr AS ShipToParty,
  outbdelhdr.kunag AS SoldToParty,
  outbdelhdr.vstel AS ShippingPoint,
  oij_el_cp_layt.vehicle AS VehicleId
FROM likp AS outbdelhdr
INNER JOIN lips AS outddelitm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oij_el_cp_layt ON /* join condition not captured in parsed metadata */
;