C_ScheduleHydrocarbonTrips

DDL: C_SCHEDULEHYDROCARBONTRIPS SQL: CSCHEDTRIP Type: view CONSUMPTION
55 Fields 1 Data Sources 1 Associations

Schedule Hydrocarbon Trips

C_ScheduleHydrocarbonTrips is a Consumption CDS View that provides data about "Schedule Hydrocarbon Trips" in SAP S/4HANA. It reads from 1 data source (I_ScheduleHydrocarbonTrips) and exposes 55 fields with key fields OutboundDelivery, OutboundDeliveryItem, ShipmentNumber, ShipmentItem, NominationDoc. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ScheduleHydrocarbonTrips I_ScheduleHydrocarbonTrips from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_TripHeadTP _TripHeadExtension $projection.TripDoc = _TripHeadExtension.TripDoc

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CSCHEDTRIP view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
UI.headerInfo.typeName Reference Document view
UI.headerInfo.typeNamePlural Reference Documents view
UI.headerInfo.title.value TripDoc view
UI.headerInfo.description.value TripExtNumber view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Schedule Hydrocarbon Trips view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery OutboundDelivery Outbound Delivery
KEY OutboundDeliveryItem OutboundDeliveryItem Outbound Delivery Item
KEY ShipmentNumber ShipmentNumber Shipment Number
KEY ShipmentItem ShipmentItem Shipment Item
KEY NominationDoc NominationDoc Nomination Key
KEY NominationDocItem NominationDocItem Nomination Item
KEY TripDoc TripDoc Trip ID
KEY TripDocItem TripDocItem
SchedRefDocType SchedRefDocType Schedule Reference Document Type
NominationExtNumber NominationExtNumber Nomination Number
TripVehicleID TripVehicleID Vehicle
TripExtNumber TripExtNumber Trip External Number
TripStatus TripStatus Trip Status
TripType TripType Trip Type
BulkShipmentVehicleType BulkShipmentVehicleType Vehicle Type
TripItemStatus TripItemStatus Trip Item Status
DemurrageAmount DemurrageAmount Total Demurrage
DemurrageAmountCrcy DemurrageAmountCrcy
TripDocType TripDocType Trip Reference
TripHeaderStsCriticality TripHeaderStsCriticality
TripItemStsCriticality TripItemStsCriticality
NominationType NominationType
TransportSystem TransportSystem Transport System
NominationShipper NominationShipper
NominationCarrier NominationCarrier
LocationId LocationId Location ID
ShippingPoint ShippingPoint Shipping Point
TransportationPlanningPoint TransportationPlanningPoint
BulkShipmentType BulkShipmentType
TripActionMode TripActionMode
TripIsBlocked TripIsBlocked
BulkShipmentIsBlocked BulkShipmentIsBlocked
NominationDocIsBlocked NominationDocIsBlocked
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
OutboundDeliveryVehicleID OutboundDeliveryVehicleID
_SoldToParty _SoldToParty
_ShipToParty _ShipToParty
_OutboundDeliveryVehicleID _OutboundDeliveryVehicleID
_NominationKey _NominationKey
_NominationExtNumber _NominationExtNumber
_NominationItem _NominationItem
_ShipmentNumber _ShipmentNumber
_ShipmentItem _ShipmentItem
_TripDoc _TripDoc
_TripDocItem _TripDocItem
_TripExtNumber _TripExtNumber
_TripStatus _TripStatus
_TripType _TripType
_TripItemStatus _TripItemStatus
_VehicleType _VehicleType
_TripVehicleId _TripVehicleId
_OutboundDelivery _OutboundDelivery
_OutboundDeliveryItm _OutboundDeliveryItm
_TripRefDocTypeT _TripRefDocTypeT

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_ScheduleHydrocarbonTrips.
-- 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: CSCHEDTRIP

CREATE VIEW C_ScheduleHydrocarbonTrips AS
SELECT
  OutboundDelivery,
  OutboundDeliveryItem,
  ShipmentNumber,
  ShipmentItem,
  NominationDoc,
  NominationDocItem,
  TripDoc,
  TripDocItem,
  SchedRefDocType,
  NominationExtNumber,
  TripVehicleID,
  TripExtNumber,
  TripStatus,
  TripType,
  BulkShipmentVehicleType,
  TripItemStatus,
  DemurrageAmount,
  DemurrageAmountCrcy,
  TripDocType,
  TripHeaderStsCriticality,
  TripItemStsCriticality,
  NominationType,
  TransportSystem,
  NominationShipper,
  NominationCarrier,
  LocationId,
  ShippingPoint,
  TransportationPlanningPoint,
  BulkShipmentType,
  TripActionMode,
  TripIsBlocked,
  BulkShipmentIsBlocked,
  NominationDocIsBlocked,
  SoldToParty,
  ShipToParty,
  OutboundDeliveryVehicleID
FROM I_ScheduleHydrocarbonTrips
LEFT OUTER JOIN E_TripHeadTP AS _TripHeadExtension ON TripDoc = _TripHeadExtension.TripDoc  -- association [1..1]
;

Learn More