C_TripNominationItmTP

DDL: C_TRIPNOMINATIONITMTP SQL: CTRIPNOMINITEMTP Type: view CONSUMPTION
26 Fields 1 Data Sources 2 Associations

Trip Nomination Items

C_TripNominationItmTP is a Consumption CDS View that provides data about "Trip Nomination Items" in SAP S/4HANA. It reads from 1 data source (I_TripNominationItmTP) and exposes 26 fields with key fields TripDoc, TripDocItem, NominationDoc, NominationDocItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TripNominationItmTP I_TripNominationItmTP 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 CTRIPNOMINITEMTP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D 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 Nomination Items view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY TripDoc TripDoc Trip ID
KEY TripDocItem TripDocItem Trip Item Number
KEY NominationDoc NominationDoc Nomination key
KEY NominationDocItem NominationDocItem Nom. key item
NominationDocForEdit NominationDocForEdit Nomination Key
TripType _TripHeadTP TripType Trip Type
NominationDocItemForEdit NominationDocItemForEdit Nomination Item
NominationExtNumber NominationExtNumber Nomination Number
ScheduledMaterial ScheduledMaterial Material
ScheduledQuantity ScheduledQuantity Scheduled Quantity
ScheduledQuantityUnit ScheduledQuantityUnit UoM
DemurrageAmount DemurrageAmount Allocated Charges
DemurrageAmountCrcy DemurrageAmountCrcy Currency
NominationShipper NominationShipper
Carrier Carrier Service Agent
VehicleId _TripHeadTP VehicleId Vehicle
NominationType NominationType Nomination Type
TransportSystem TransportSystem Transport System
LocationId _TripItemTP LocationId Location
_NominationKeyVH _NominationKeyVH
_NominationItemVH _NominationItemVH
_UnitOfMeasure _UnitOfMeasure
_MaterialText _MaterialText
_NominationTypeText _NominationTypeText
_TripHeadTP _TripHeadTP
_TripItemTP _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 C_TripNominationItmTP.
-- 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: CTRIPNOMINITEMTP

CREATE VIEW C_TripNominationItmTP AS
SELECT
  TripDoc,
  TripDocItem,
  NominationDoc,
  NominationDocItem,
  NominationDocForEdit,
  _TripHeadTP.TripType AS TripType,
  NominationDocItemForEdit,
  NominationExtNumber,
  ScheduledMaterial,
  ScheduledQuantity,
  ScheduledQuantityUnit,
  DemurrageAmount,
  DemurrageAmountCrcy,
  NominationShipper,
  Carrier,
  _TripHeadTP.VehicleId AS VehicleId,
  NominationType,
  TransportSystem,
  _TripItemTP.LocationId AS LocationId
FROM I_TripNominationItmTP
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