P_CollabnApplFrtOrdInExecution

DDL: P_COLLABNAPPLFRTORDINEXECUTION Type: view_entity CONSUMPTION
35 Fields 2 Data Sources 2 Associations

Freight Orders in Execution

P_CollabnApplFrtOrdInExecution is a Consumption CDS View that provides data about "Freight Orders in Execution" in SAP S/4HANA. It reads from 2 data sources (P_CollabnApplCarrierUser, I_TransportationOrder) and exposes 35 fields with key field TransportationOrderUUID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_CollabnApplCarrierUser CollabnApplCarrierUser inner
I_TransportationOrder TransportationOrder from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_TranspOrdLastRptdEvent _LastReportedEvent $projection.TransportationOrderUUID = _LastReportedEvent.TransportationOrderUUID
[0..1] P_CollabnFrtOrdTypeAssgdEvt _FrtOrdTypeAssgdEvents $projection.TransportationOrderType = _FrtOrdTypeAssgdEvents.TransportationOrderType

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Freight Orders in Execution view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderUUID I_TransportationOrder TransportationOrderUUID
FreightOrder
TranspOrdExecutionIsBlocked I_TransportationOrder TranspOrdExecutionIsBlocked Execution Block
Carrier I_TransportationOrder Carrier Service Agent
MeansOfTransport I_TransportationOrder MeansOfTransport Means of Transport
MeansOfTransportDesc
TransportationOrderType I_TransportationOrder TransportationOrderType Document Type
TransportationOrderCategory I_TransportationOrder TransportationOrderCategory TO Category
TranspOrdDistanceUnit I_TransportationOrder TranspOrdDistanceUnit
TranspOrdDistance I_TransportationOrder TranspOrdDistance Total Distance
TranspOrdNetDurationUnit I_TransportationOrder TranspOrdNetDurationUnit
TranspOrdNetDuration
PurchasingOrgExternalID I_TransportationOrder PurchasingOrgExternalID
PurchasingOrganizationName
SourceLocation
DestinationLocation
SourceLocationDescription
DestinationLocationDescription
SourceLocationAddressDesc
DestinationLocationAddressDesc
TranspOrdDepartureDateTime
TranspOrdArrivalDateTime
TranspOrdResponsiblePerson I_TransportationOrder TranspOrdResponsiblePerson Person Resp.
CreationDateTime I_TransportationOrder CreationDateTime Timestamp
TranspOrdGrossWeightUnit I_TransportationOrder TranspOrdGrossWeightUnit Gr. Wt UoM
TranspOrdGrossWeight I_TransportationOrder TranspOrdGrossWeight
TranspOrdGrossVolumeUnit I_TransportationOrder TranspOrdGrossVolumeUnit Gross Vol. UoM
TranspOrdGrossVolume I_TransportationOrder TranspOrdGrossVolume
TranspOrdQuantityUnit I_TransportationOrder TranspOrdQuantityUnit Quantity UoM
TranspOrdQuantity I_TransportationOrder TranspOrdQuantity
TranspOrderDngrsGdsSts I_TransportationOrder TranspOrderDngrsGdsSts Dangerous Goods Sts
TranspOrderDngrsGdsStsDesc
LastReportedEventDateTime
LastReportedEventLocation
LocationDescription

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 P_CollabnApplFrtOrdInExecution.
-- 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.

CREATE VIEW P_CollabnApplFrtOrdInExecution AS
SELECT
  TransportationOrder.TransportationOrderUUID AS TransportationOrderUUID,
  cast ( TransportationOrder.TransportationOrder as /scmtms/vdm_freight_order_id ) AS FreightOrder,
  TransportationOrder.TranspOrdExecutionIsBlocked AS TranspOrdExecutionIsBlocked,
  TransportationOrder.Carrier AS Carrier,
  TransportationOrder.MeansOfTransport AS MeansOfTransport,
  TransportationOrder._MeansOfTransport._Text[1: Language = $session.system_language].MeansOfTransportDesc AS MeansOfTransportDesc,
  TransportationOrder.TransportationOrderType AS TransportationOrderType,
  TransportationOrder.TransportationOrderCategory AS TransportationOrderCategory,
  TransportationOrder.TranspOrdDistanceUnit AS TranspOrdDistanceUnit,
  TransportationOrder.TranspOrdDistance AS TranspOrdDistance,
  TransportationOrder.TranspOrdNetDurationUnit AS TranspOrdNetDurationUnit,
  cast( (division(TransportationOrder.TranspOrdNetDuration, 10000,0)) as /scmtms/vdm_exec_net_duration ) AS TranspOrdNetDuration,
  TransportationOrder.PurchasingOrgExternalID AS PurchasingOrgExternalID,
  TransportationOrder._PurchasingOrganization._OrganizationalUnitText[1:Language = $session.system_language].OrganizationalUnitName AS PurchasingOrganizationName,
  TransportationOrder._SourceStop.LocationId AS SourceLocation,
  TransportationOrder._DestinationStop.LocationId AS DestinationLocation,
  TransportationOrder._SourceStop._Locationdescr.LocationDescription AS SourceLocationDescription,
  TransportationOrder._DestinationStop._Locationdescr.LocationDescription AS DestinationLocationDescription,
  TransportationOrder._SourceStop._Locationdescr.AddressObjectDescription AS SourceLocationAddressDesc,
  TransportationOrder._DestinationStop._Locationdescr.AddressObjectDescription AS DestinationLocationAddressDesc,
  TransportationOrder._SourceStop.TranspOrdStopPlanTranspDteTme AS TranspOrdDepartureDateTime,
  TransportationOrder._DestinationStop.TranspOrdStopPlanTranspDteTme AS TranspOrdArrivalDateTime,
  TransportationOrder.TranspOrdResponsiblePerson AS TranspOrdResponsiblePerson,
  TransportationOrder.CreationDateTime AS CreationDateTime,
  TransportationOrder.TranspOrdGrossWeightUnit AS TranspOrdGrossWeightUnit,
  TransportationOrder.TranspOrdGrossWeight AS TranspOrdGrossWeight,
  TransportationOrder.TranspOrdGrossVolumeUnit AS TranspOrdGrossVolumeUnit,
  TransportationOrder.TranspOrdGrossVolume AS TranspOrdGrossVolume,
  TransportationOrder.TranspOrdQuantityUnit AS TranspOrdQuantityUnit,
  TransportationOrder.TranspOrdQuantity AS TranspOrdQuantity,
  TransportationOrder.TranspOrderDngrsGdsSts AS TranspOrderDngrsGdsSts,
  TransportationOrder._TranspOrdDngrsGdsStatus._Text[1: Language = $session.system_language].TranspOrderDngrsGdsStsDesc AS TranspOrderDngrsGdsStsDesc,
  cast ( _LastReportedEvent.TranspOrdEvtActualDateTime as /scmtms/vdm_lastrptd_evt_dttme) AS LastReportedEventDateTime,
  cast (_LastReportedEvent._TransportationOrderStop.LocationId as /scmtms/vdm_lastrptd_evt_loc ) AS LastReportedEventLocation,
  _LastReportedEvent._TransportationOrderStop._Locationdescr.LocationDescription AS LocationDescription
FROM I_TransportationOrder AS TransportationOrder
INNER JOIN P_CollabnApplCarrierUser AS CollabnApplCarrierUser ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TranspOrdLastRptdEvent AS _LastReportedEvent ON TransportationOrderUUID = _LastReportedEvent.TransportationOrderUUID  -- association [0..1]
LEFT OUTER JOIN P_CollabnFrtOrdTypeAssgdEvt AS _FrtOrdTypeAssgdEvents ON TransportationOrderType = _FrtOrdTypeAssgdEvents.TransportationOrderType  -- association [0..1]
;

Learn More