C_TripHeadTP

DDL: C_TRIPHEADTP SQL: CTRIPHEADTP Type: view CONSUMPTION
31 Fields 1 Data Sources 1 Associations

Trip Header

C_TripHeadTP is a Consumption CDS View that provides data about "Trip Header" in SAP S/4HANA. It reads from 1 data source (I_TripHeadTP) and exposes 31 fields with key field TripDoc. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_TripHeadTP I_TripHeadTP from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_TripItemTP _TripItemTP $projection.TripDoc = _TripItemTP.TripDoc

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName CTRIPHEADTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
UI.headerInfo.typeName Hydrocarbon Trip view
UI.headerInfo.typeNamePlural Trips view
UI.headerInfo.title.value TripDoc view
UI.headerInfo.description.value TripExtNumber view
EndUserText.label Trip Header view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY TripDoc TripDoc Trip ID
TripExtNumber TripExtNumber Trip External Number
TripType TripType Trip Type
VehicleId VehicleId Vehicle
TripHeaderStsCriticality TripHeaderStsCriticality
TripStatus TripStatus Status
BulkShipmentVehicleType BulkShipmentVehicleType Vehicle Type
DemurrageAmount DemurrageAmount Demurrage Amount
DemurrageAmountCrcy DemurrageAmountCrcy Currency
TripCurrency TripCurrency Trip Currency
TripCrcyExchangeRate TripCrcyExchangeRate Exchange Rate Type
TripCreationDate TripCreationDate Created On
TripCreationTime TripCreationTime Created At
TripCreationDateTime TripCreationDateTime Created On
CreatedByUser CreatedByUser Created By
TripChangedDate TripChangedDate Changed On
TripChangedTime TripChangedTime Changed At
TripChangedDateTime TripChangedDateTime Changed On
LastChangedByUser LastChangedByUser Changed By
TripDocType TripDocType Trip Reference
AccrualForDemurrageIsAllowed AccrualForDemurrageIsAllowed
TripIsBlocked TripIsBlocked Flag to Select Trp
TripDisplayMode TripDisplayMode
_TripItemTP _TripItemTP
_TripDocVH _TripDocVH
_TripExtNumberVH _TripExtNumberVH
_TripTypeVH _TripTypeVH
_TripRefDocTypeT _TripRefDocTypeT
_TripCreatedByVH _TripCreatedByVH
_TripStatusVH _TripStatusVH
_TripVehicleVH _TripVehicleVH

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_TripHeadTP.
-- 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: CTRIPHEADTP

CREATE VIEW C_TripHeadTP AS
SELECT
  TripDoc,
  TripExtNumber,
  TripType,
  VehicleId,
  TripHeaderStsCriticality,
  TripStatus,
  BulkShipmentVehicleType,
  DemurrageAmount,
  DemurrageAmountCrcy,
  TripCurrency,
  TripCrcyExchangeRate,
  TripCreationDate,
  TripCreationTime,
  TripCreationDateTime,
  CreatedByUser,
  TripChangedDate,
  TripChangedTime,
  TripChangedDateTime,
  LastChangedByUser,
  TripDocType,
  AccrualForDemurrageIsAllowed,
  TripIsBlocked,
  TripDisplayMode
FROM I_TripHeadTP
LEFT OUTER JOIN C_TripItemTP AS _TripItemTP ON TripDoc = _TripItemTP.TripDoc  -- association [0..*]
;

Learn More