C_FreightOrderStopASR

DDL: C_FREIGHTORDERSTOPASR Type: view_entity CONSUMPTION
55 Fields 1 Data Sources 16 Associations

ASR Cockpit Freight Order Stops

C_FreightOrderStopASR is a Consumption CDS View that provides data about "ASR Cockpit Freight Order Stops" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrderStop) and exposes 55 fields with key field TransportationOrderStopUUID. It has 16 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrderStop Stop from

Associations (16)

CardinalityTargetAliasCondition
[1..1] I_TransportationOrder _TransportationOrder Stop.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
[1..1] I_TransportationOrderItem _ActvVehRsceItem Stop.TransportationOrderUUID = _ActvVehRsceItem.TransportationOrderUUID and _ActvVehRsceItem.TranspOrdItemCategory = 'AVR'
[1..1] I_EWM_WarehouseNumber_2 _WarehouseTimeZone Stop.TranspOrdStopWrhsNmbr = _WarehouseTimeZone.EWMWarehouse
[1..1] I_TransportationOrderStop _LogisticalStop Stop.TranspOrdStopStopParentUUID = _LogisticalStop.TransportationOrderStopUUID
[0..1] I_TranspOrdWarehouseText _TranspOrdWarehouseText Stop.TranspOrdStopWrhsNmbr = _TranspOrdWarehouseText.TranspOrdStopWrhsNmbr
[0..1] I_LocationBasic _LoadingPointText Stop.TranspOrdStopLoadingPointID = _LoadingPointText.Location
[0..1] I_TranspOrdStopWrhsCategory _TranspOrdStopWrhsCategory Stop.TranspOrdStopWrhsCat = _TranspOrdStopWrhsCategory.TranspOrdStopWrhsCat
[0..1] I_TranspOrdStopWrhsDoorStatus _TranspOrdStopWrhsDoorStatus Stop.TranspOrdStopWrhsDoorStatus = _TranspOrdStopWrhsDoorStatus.TranspOrdStopWrhsDoorStatus
[1..*] C_FrtOrdStopLoadRefFreightUnit _FreightUnit
[1..*] C_FrtOrdStopLoadRefCsgnmt _Consignment
[1..*] C_FrtOrdStopLoadRefERPOrder _ERPOrder
[1..*] C_FrtOrdStopLoadRefLogsExecDlv _LogsExecDelivery
[1..*] C_FrtOrdStopLoadRefWrhsRequest _WarehouseRequest
[1..*] C_FrtOrdStopLoadRefStagingArea _EWMStagingArea
[1..*] C_FrtOrdStopLoadRefStagingBay _EWMStagingBay
[1..*] C_FrtOrdStopLoadRefStggAreaGrp _EWMStagingAreaGroup

Annotations (8)

NameValueLevelField
EndUserText.label ASR Cockpit Freight Order Stops view
ObjectModel.representativeKey TransportationOrderStopUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderStopUUID I_TransportationOrderStop TransportationOrderStopUUID UUID
TransportationOrderUUID I_TransportationOrderStop TransportationOrderUUID
TransportationOrderStop I_TransportationOrderStop TransportationOrderStop Stop ID
TranspOrdStopStopParentUUID I_TransportationOrderStop TranspOrdStopStopParentUUID Stop Key
TranspOrdStopCategory I_TransportationOrderStop TranspOrdStopCategory Stop Category
TranspOrdStopCategoryDesc
TranspOrdStopHndlgExecStatus I_TransportationOrderStop TranspOrdStopHndlgExecStatus Handling Execution
TranspOrdStopHndlgExecStsDesc
TranspOrdStopPlanTranspDteTme I_TransportationOrderStop TranspOrdStopPlanTranspDteTme
TranspOrdStopDteTme I_TransportationOrderStop TranspOrdStopDteTme
TimeZoneID _WarehouseTimeZone TimeZoneID Time Zone
LocationId _LogisticalStop LocationId Location ID
TranspOrdLoglStopHndlgExecSts _LogisticalStop TranspOrdStopHndlgExecStatus Handling Execution
TrOrdLoglStopHndlgExecStsDesc
TranspOrdStopWrhsCat I_TransportationOrderStop TranspOrdStopWrhsCat Whse Category
TranspOrdStopWrhsCatDesc
TranspOrdStopWrhsNmbr I_TransportationOrderStop TranspOrdStopWrhsNmbr Warehouse Number
TranspOrdStopWrhsDesc
TranspOrdStopLoadingPointID I_TransportationOrderStop TranspOrdStopLoadingPointID Load./Unload. Pt
TranspOrdStopLoadingPointDesc
TranspOrdStopWrhsDoorID I_TransportationOrderStop TranspOrdStopWrhsDoorID Warehouse Door
TranspOrdStopWrhsDoorStatus I_TransportationOrderStop TranspOrdStopWrhsDoorStatus WH Door Status
TranspOrdStopWrhsDoorStsDesc
FreightOrder _TransportationOrder TransportationOrder
TransportationOrderType _TransportationOrder TransportationOrderType
TransportationOrderTypeDesc
CreationDateTime _TransportationOrder CreationDateTime Timestamp
TranspOrdLifeCycleStatus _TransportationOrder TranspOrdLifeCycleStatus
TranspOrdLifeCycleStatusDesc
TransportationOrderExecSts _TransportationOrder TransportationOrderExecSts
TransportationOrderExecStsDesc
TranspOrdGoodsMovementStatus _TransportationOrder TranspOrdGoodsMovementStatus
TranspOrdGoodsMvtStatusDesc
TranspOrderDngrsGdsSts _TransportationOrder TranspOrderDngrsGdsSts
TranspOrderDngrsGdsStsDesc
TranspOrdWhseProcessingStatus _TransportationOrder TranspOrdWhseProcessingStatus
TranspOrdWhseProcgStatusDesc
Shipper _TransportationOrder Shipper Shipper
Consignee _TransportationOrder Consignee Customer
Carrier _TransportationOrder Carrier Service Agent
TransportationMode _TransportationOrder TransportationMode
TransportationModeDesc
TranspOrdMeansOfTransport
MeansOfTransportDesc
TranspOrdItmEquipmentGroup _ActvVehRsceItem TranspOrdItmEquipmentGroup
TranspOrdItmEquipmentType _ActvVehRsceItem TranspOrdItmEquipmentType
TranspOrdItmResourceID _ActvVehRsceItem TranspOrdItmResourceID
_FreightUnit _FreightUnit
_Consignment _Consignment
_ERPOrder _ERPOrder
_LogsExecDelivery _LogsExecDelivery
_WarehouseRequest _WarehouseRequest
_EWMStagingArea _EWMStagingArea
_EWMStagingBay _EWMStagingBay
_EWMStagingAreaGroup _EWMStagingAreaGroup

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_FreightOrderStopASR.
-- 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 C_FreightOrderStopASR AS
SELECT
  Stop.TransportationOrderStopUUID AS TransportationOrderStopUUID,
  Stop.TransportationOrderUUID AS TransportationOrderUUID,
  Stop.TransportationOrderStop AS TransportationOrderStop,
  Stop.TranspOrdStopStopParentUUID AS TranspOrdStopStopParentUUID,
  Stop.TranspOrdStopCategory AS TranspOrdStopCategory,
  Stop._TranspOrdStopCategory._Text[1:Language = $session.system_language ].TranspOrdStopCategoryDesc AS TranspOrdStopCategoryDesc,
  Stop.TranspOrdStopHndlgExecStatus AS TranspOrdStopHndlgExecStatus,
  Stop._TranspHndlgExecStatus._Text[1:Language = $session.system_language ].TranspOrdStopHndlgExecStsDesc AS TranspOrdStopHndlgExecStsDesc,
  Stop.TranspOrdStopPlanTranspDteTme AS TranspOrdStopPlanTranspDteTme,
  Stop.TranspOrdStopDteTme AS TranspOrdStopDteTme,
  _WarehouseTimeZone.TimeZoneID AS TimeZoneID,
  _LogisticalStop.LocationId AS LocationId,
  _LogisticalStop.TranspOrdStopHndlgExecStatus AS TranspOrdLoglStopHndlgExecSts,
  _LogisticalStop._TranspHndlgExecStatus._Text[1:Language = $session.system_language ].TranspOrdStopHndlgExecStsDesc AS TrOrdLoglStopHndlgExecStsDesc,
  Stop.TranspOrdStopWrhsCat AS TranspOrdStopWrhsCat,
  _TranspOrdStopWrhsCategory._Text[1:Language=$session.system_language].TranspOrdStopWrhsCatDesc AS TranspOrdStopWrhsCatDesc,
  Stop.TranspOrdStopWrhsNmbr AS TranspOrdStopWrhsNmbr,
  _TranspOrdWarehouseText[1:Language=$session.system_language].TranspOrdStopWrhsDesc AS TranspOrdStopWrhsDesc,
  Stop.TranspOrdStopLoadingPointID AS TranspOrdStopLoadingPointID,
  _LoadingPointText._Text[1:Language=$session.system_language].LocationDescription AS TranspOrdStopLoadingPointDesc,
  Stop.TranspOrdStopWrhsDoorID AS TranspOrdStopWrhsDoorID,
  Stop.TranspOrdStopWrhsDoorStatus AS TranspOrdStopWrhsDoorStatus,
  _TranspOrdStopWrhsDoorStatus._Text[1:Language=$session.system_language].TranspOrdStopWrhsDoorStsDesc AS TranspOrdStopWrhsDoorStsDesc,
  _TransportationOrder.TransportationOrder AS FreightOrder,
  _TransportationOrder.TransportationOrderType AS TransportationOrderType,
  _TransportationOrder._TransportationOrderType._Text[1:Language = $session.system_language ].TransportationOrderTypeDesc AS TransportationOrderTypeDesc,
  _TransportationOrder.CreationDateTime AS CreationDateTime,
  _TransportationOrder.TranspOrdLifeCycleStatus AS TranspOrdLifeCycleStatus,
  _TransportationOrder._TranspOrdLifeCycleStatus._Text[1:Language = $session.system_language ].TranspOrdLifeCycleStatusDesc AS TranspOrdLifeCycleStatusDesc,
  _TransportationOrder.TransportationOrderExecSts AS TransportationOrderExecSts,
  _TransportationOrder._TransportationOrderExecSts._Text[1:Language = $session.system_language ].TransportationOrderExecStsDesc AS TransportationOrderExecStsDesc,
  _TransportationOrder.TranspOrdGoodsMovementStatus AS TranspOrdGoodsMovementStatus,
  _TransportationOrder._TranspOrdGoodsMvtStatus._Text[1:Language = $session.system_language ].TranspOrdGoodsMvtStatusDesc AS TranspOrdGoodsMvtStatusDesc,
  _TransportationOrder.TranspOrderDngrsGdsSts AS TranspOrderDngrsGdsSts,
  _TransportationOrder._TranspOrdDngrsGdsStatus._Text[1:Language = $session.system_language ].TranspOrderDngrsGdsStsDesc AS TranspOrderDngrsGdsStsDesc,
  _TransportationOrder.TranspOrdWhseProcessingStatus AS TranspOrdWhseProcessingStatus,
  _TransportationOrder._TranspOrdWhseProcgStatus._Text[1:Language = $session.system_language ].TranspOrdWhseProcgStatusDesc AS TranspOrdWhseProcgStatusDesc,
  _TransportationOrder.Shipper AS Shipper,
  _TransportationOrder.Consignee AS Consignee,
  _TransportationOrder.Carrier AS Carrier,
  _TransportationOrder.TransportationMode AS TransportationMode,
  _TransportationOrder._TransportationMode._Text[1:Language = $session.system_language ].TransportationModeDesc AS TransportationModeDesc,
  cast( _TransportationOrder.MeansOfTransport as /sapapo/tr_traty preserving type ) AS TranspOrdMeansOfTransport,
  _TransportationOrder._MeansOfTransport._Text[1:Language = $session.system_language ].MeansOfTransportDesc AS MeansOfTransportDesc,
  _ActvVehRsceItem.TranspOrdItmEquipmentGroup AS TranspOrdItmEquipmentGroup,
  _ActvVehRsceItem.TranspOrdItmEquipmentType AS TranspOrdItmEquipmentType,
  _ActvVehRsceItem.TranspOrdItmResourceID AS TranspOrdItmResourceID
FROM I_TransportationOrderStop AS Stop
LEFT OUTER JOIN I_TransportationOrder AS _TransportationOrder ON Stop.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationOrderItem AS _ActvVehRsceItem ON Stop.TransportationOrderUUID = _ActvVehRsceItem.TransportationOrderUUID AND _ActvVehRsceItem.TranspOrdItemCategory = 'AVR'  -- association [1..1]
LEFT OUTER JOIN I_EWM_WarehouseNumber_2 AS _WarehouseTimeZone ON Stop.TranspOrdStopWrhsNmbr = _WarehouseTimeZone.EWMWarehouse  -- association [1..1]
LEFT OUTER JOIN I_TransportationOrderStop AS _LogisticalStop ON Stop.TranspOrdStopStopParentUUID = _LogisticalStop.TransportationOrderStopUUID  -- association [1..1]
LEFT OUTER JOIN I_TranspOrdWarehouseText AS _TranspOrdWarehouseText ON Stop.TranspOrdStopWrhsNmbr = _TranspOrdWarehouseText.TranspOrdStopWrhsNmbr  -- association [0..1]
LEFT OUTER JOIN I_LocationBasic AS _LoadingPointText ON Stop.TranspOrdStopLoadingPointID = _LoadingPointText.Location  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdStopWrhsCategory AS _TranspOrdStopWrhsCategory ON Stop.TranspOrdStopWrhsCat = _TranspOrdStopWrhsCategory.TranspOrdStopWrhsCat  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdStopWrhsDoorStatus AS _TranspOrdStopWrhsDoorStatus ON Stop.TranspOrdStopWrhsDoorStatus = _TranspOrdStopWrhsDoorStatus.TranspOrdStopWrhsDoorStatus  -- association [0..1]
LEFT OUTER JOIN C_FrtOrdStopLoadRefFreightUnit AS _FreightUnit ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN C_FrtOrdStopLoadRefCsgnmt AS _Consignment ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN C_FrtOrdStopLoadRefERPOrder AS _ERPOrder ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN C_FrtOrdStopLoadRefLogsExecDlv AS _LogsExecDelivery ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN C_FrtOrdStopLoadRefWrhsRequest AS _WarehouseRequest ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN C_FrtOrdStopLoadRefStagingArea AS _EWMStagingArea ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN C_FrtOrdStopLoadRefStagingBay AS _EWMStagingBay ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN C_FrtOrdStopLoadRefStggAreaGrp AS _EWMStagingAreaGroup ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More