I_FrtUnitStage

DDL: I_FRTUNITSTAGE SQL: ITORFUSTG Type: view COMPOSITE
26 Fields 1 Data Sources 2 Associations

Freight Unit: Stages

I_FrtUnitStage is a Composite CDS View that provides data about "Freight Unit: Stages" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrderStage) and exposes 26 fields with key field TransportationOrderStageUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrderStage Stage from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_TransportationOrder _TransportationOrder $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
[1..1] P_TranspOrdStageSequence _StageSeq $projection.TransportationOrderUUID = _StageSeq.TransportationOrderUUID and $projection.TransportationOrderStageUUID = _StageSeq.TransportationOrderStageUUID

Annotations (13)

NameValueLevelField
EndUserText.label Freight Unit: Stages view
ObjectModel.representativeKey TransportationOrderStageUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ITORFUSTG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderStageUUID TransportationOrderStageUUID UUID
TransportationOrderUUID TransportationOrderUUID
TranspOrdStageSequence
SourceLocationLabel
TranspOrdDepartureDateTime
clientNULLasTranspOrdDepartureDate
clientNULLasTranspOrdDepartureTime
DestinationLocationLabel
TranspOrdArrivalDateTime
clientNULLasTranspOrdArrivalDate
clientNULLasTranspOrdArrivalTime
TranspErlstAccptblPkupDteTme
clientNULLasTranspErlstAccptblPkupDte
clientNULLasTranspErlstAccptblPkupTme
TranspErlstAccptblDelivDteTme
clientNULLasTranspErlstAccptblDelivDte
clientNULLasTranspErlstAccptblDelivTme
TranspLtstAccptblDelivDteTme
clientNULLasTranspLtstAccptblDelivDte
clientNULLasTranspLtstAccptblDelivTme
TranspOrdCapacityTranspOrd
TranspOrdStagePlnStatus I_TransportationOrderStage TranspOrdStagePlnStatus
TranspOrdStagePlnStatusDesc
RequestingCompanyCode I_TransportationOrderStage RequestingCompanyCode Req. co.code
_TransportationOrder _TransportationOrder
_RequestingCompanyCode _RequestingCompanyCode

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 I_FrtUnitStage.
-- 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: ITORFUSTG

CREATE VIEW I_FrtUnitStage AS
SELECT
  TransportationOrderStageUUID,
  TransportationOrderUUID,
  _StageSeq(i_clnt:$session.client, i_torcat:'FU').TranspOrdStageSequence AS TranspOrdStageSequence,
  _TranspOrdStageSrceStop._Locationdescr.AddressObjectDescription AS SourceLocationLabel,
  cast(_TranspOrdStageSrceStop.TranspOrdStopPlanTranspDteTme as log_created_on preserving type ) AS TranspOrdDepartureDateTime,
  tstmp_to_dats( _TranspOrdStageSrceStop.TranspOrdStopPlanTranspDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspOrdDepartureDate AS clientNULLasTranspOrdDepartureDate,
  tstmp_to_tims( _TranspOrdStageSrceStop.TranspOrdStopPlanTranspDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspOrdDepartureTime AS clientNULLasTranspOrdDepartureTime,
  _TranspOrdStageDestStop._Locationdescr.AddressObjectDescription AS DestinationLocationLabel,
  cast(_TranspOrdStageDestStop.TranspOrdStopPlanTranspDteTme as log_created_on preserving type ) AS TranspOrdArrivalDateTime,
  tstmp_to_dats( _TranspOrdStageDestStop.TranspOrdStopPlanTranspDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspOrdArrivalDate AS clientNULLasTranspOrdArrivalDate,
  tstmp_to_tims( _TranspOrdStageDestStop.TranspOrdStopPlanTranspDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspOrdArrivalTime AS clientNULLasTranspOrdArrivalTime,
  cast(_TranspOrdStageSrceStop.TranspOrdStopAccptblStrtDteTme as log_created_on preserving type ) AS TranspErlstAccptblPkupDteTme,
  tstmp_to_dats( _TranspOrdStageSrceStop.TranspOrdStopAccptblStrtDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspErlstAccptblPkupDte AS clientNULLasTranspErlstAccptblPkupDte,
  tstmp_to_tims( _TranspOrdStageSrceStop.TranspOrdStopAccptblStrtDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspErlstAccptblPkupTme AS clientNULLasTranspErlstAccptblPkupTme,
  cast(_TranspOrdStageDestStop.TranspOrdStopAccptblStrtDteTme as log_created_on preserving type ) AS TranspErlstAccptblDelivDteTme,
  tstmp_to_dats( _TranspOrdStageDestStop.TranspOrdStopAccptblStrtDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspErlstAccptblDelivDte AS clientNULLasTranspErlstAccptblDelivDte,
  tstmp_to_tims( _TranspOrdStageDestStop.TranspOrdStopAccptblStrtDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspErlstAccptblDelivTme AS clientNULLasTranspErlstAccptblDelivTme,
  cast(_TranspOrdStageDestStop.TranspOrdStopAccptblEndDteTme as log_created_on preserving type ) AS TranspLtstAccptblDelivDteTme,
  tstmp_to_dats( _TranspOrdStageDestStop.TranspOrdStopAccptblEndDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspLtstAccptblDelivDte AS clientNULLasTranspLtstAccptblDelivDte,
  tstmp_to_tims( _TranspOrdStageDestStop.TranspOrdStopAccptblEndDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspLtstAccptblDelivTme AS clientNULLasTranspLtstAccptblDelivTme,
  Stage._TranspOrdStageSrceStop._CapaStop._TransportationOrder.TransportationOrder AS TranspOrdCapacityTranspOrd,
  Stage.TranspOrdStagePlnStatus AS TranspOrdStagePlnStatus,
  Stage._TranspOrdStagePlnStatus._Text[1:Language = $session.system_language ].TranspOrdStagePlnStatusDesc AS TranspOrdStagePlnStatusDesc,
  Stage.RequestingCompanyCode AS RequestingCompanyCode
FROM I_TransportationOrderStage AS Stage
LEFT OUTER JOIN I_TransportationOrder AS _TransportationOrder ON TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN P_TranspOrdStageSequence AS _StageSeq ON TransportationOrderUUID = _StageSeq.TransportationOrderUUID AND TransportationOrderStageUUID = _StageSeq.TransportationOrderStageUUID  -- association [1..1]
;

Learn More