C_TripOutbDeliveryItemTP

DDL: C_TRIPOUTBDELIVERYITEMTP SQL: CTRIPOTBDLITEMTP Type: view CONSUMPTION
23 Fields 1 Data Sources 2 Associations

Trip Outbound Delivery Items

C_TripOutbDeliveryItemTP is a Consumption CDS View that provides data about "Trip Outbound Delivery Items" in SAP S/4HANA. It reads from 1 data source (I_TripOutbDeliveryItemTP) and exposes 23 fields with key fields TripDoc, TripDocItem, OutboundDelivery, OutboundDeliveryItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TripOutbDeliveryItemTP I_TripOutbDeliveryItemTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_TripItemTP _TripItemTP $projection.TripDoc = _TripItemTP.TripDoc and $projection.TripDocItem = _TripItemTP.TripDocItem
[1..1] C_TripHeadTP _TripHeadTP $projection.TripDoc = _TripHeadTP.TripDoc

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CTRIPOTBDLITEMTP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Trip Outbound Delivery Items view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY TripDoc TripDoc Trip ID
KEY TripDocItem TripDocItem Trip Item Number
KEY OutboundDelivery OutboundDelivery LE Delivery
KEY OutboundDeliveryItem OutboundDeliveryItem Logistics Execution Delivery Item
TripType TripType
OutboundDeliveryForEdit OutboundDeliveryForEdit Document
OutboundDeliveryItemForEdit OutboundDeliveryItemForEdit Item
DeliveryType DeliveryType Delivery Type
ScheduledMaterial ScheduledMaterial Material
ScheduledQuantity ScheduledQuantity Scheduled Quantity
ScheduledQuantityUnit ScheduledQuantityUnit UOM
DemurrageAmount DemurrageAmount Allocated Charges
DemurrageAmountCrcy DemurrageAmountCrcy Currency
ShipToParty ShipToParty Ship-To Party (obsolete)
SoldToParty SoldToParty Sold-to Party
VehicleId VehicleId Vehicle Number
ShippingPoint ShippingPoint Shipping Point
Plant Plant Valuation Area
_UnitOfMeasure _UnitOfMeasure
_TripHeadTP _TripHeadTP
_TripItemTP _TripItemTP
_TripOutboundDeliveryKeyVH _TripOutboundDeliveryKeyVH
_TripOutboundDeliveryVH _TripOutboundDeliveryVH

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_TripOutbDeliveryItemTP.
-- 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: CTRIPOTBDLITEMTP

CREATE VIEW C_TripOutbDeliveryItemTP AS
SELECT
  TripDoc,
  TripDocItem,
  OutboundDelivery,
  OutboundDeliveryItem,
  TripType,
  OutboundDeliveryForEdit,
  OutboundDeliveryItemForEdit,
  DeliveryType,
  ScheduledMaterial,
  ScheduledQuantity,
  ScheduledQuantityUnit,
  DemurrageAmount,
  DemurrageAmountCrcy,
  ShipToParty,
  SoldToParty,
  VehicleId,
  ShippingPoint,
  Plant
FROM I_TripOutbDeliveryItemTP
LEFT OUTER JOIN C_TripItemTP AS _TripItemTP ON TripDoc = _TripItemTP.TripDoc AND TripDocItem = _TripItemTP.TripDocItem  -- association [1..1]
LEFT OUTER JOIN C_TripHeadTP AS _TripHeadTP ON TripDoc = _TripHeadTP.TripDoc  -- association [1..1]
;

Learn More