I_TRANSPORTATIONORDERSTOP
Transportation Order: Stops
I_TRANSPORTATIONORDERSTOP is a CDS View in S/4HANA. Transportation Order: Stops. It contains 16 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_FreightOrderStopASR | view_entity | from | CONSUMPTION | ASR Cockpit Freight Order Stops |
| I_TranspOrdProcFlwBasicFacts | view_entity | inner | COMPOSITE | Transportation Order: Proc. Flow Basic Facts |
| I_TranspOrdStopAnalytics | view | from | COMPOSITE | Transportation Order Stop Analytics |
| P_RETURNSDELIVERYFREIGHTORDER | view | inner | CONSUMPTION | Freight Orders for Returns Delivery |
| P_SlsOrdProcFlow23_1 | view | inner | CONSUMPTION | Sales Order Process Flow: Level +2/3 Freight Orders Submodel |
| R_TrOrdStopLocAddrAddlRprstnTP | view_entity | from | TRANSACTIONAL | Transp Ord Stop Loc Addr Addl Rpn - TP |
| R_TrOrdStopLocAddrDfltRprstnTP | view_entity | from | TRANSACTIONAL | Transp Ord Stop Loc Addr Dflt Rpn - TP |
Fields (16)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | TransportationOrderStopUUID | TransportationOrderStopUUID | 4 |
| TranspOrdStopCategory | TranspOrdStopCategory | 2 | |
| TranspOrdStopDteTme | TranspOrdStopDteTme | 1 | |
| TranspOrdStopHndlgExecStatus | TranspOrdStopHndlgExecStatus | 1 | |
| TranspOrdStopLoadingPointID | TranspOrdStopLoadingPointID | 1 | |
| TranspOrdStopPlanTranspDteTme | DestStopPlndTranspDteTme,SourceStopPlndTranspDteTme,TranspOrdStopPlanTranspDteTme | 2 | |
| TranspOrdStopReqEndDteTme | DestStopReqdEndDteTme,SourceStopReqdEndDteTme | 1 | |
| TranspOrdStopReqStartDteTme | DestStopReqdStartDteTme,SourceStopReqdStartDteTme | 1 | |
| TranspOrdStopSequencePosition | TranspOrdStopSequencePosition | 1 | |
| TranspOrdStopStopParentUUID | TranspOrdStopStopParentUUID | 1 | |
| TranspOrdStopWrhsCat | TranspOrdStopWrhsCat | 1 | |
| TranspOrdStopWrhsDoorID | TranspOrdStopWrhsDoorID | 1 | |
| TranspOrdStopWrhsDoorStatus | TranspOrdStopWrhsDoorStatus | 1 | |
| TranspOrdStopWrhsNmbr | TranspOrdStopWrhsNmbr | 1 | |
| TransportationOrderStop | TransportationOrderStop | 1 | |
| TransportationOrderUUID | TransportationOrderUUID | 3 |
@EndUserText: {label: 'Transportation Order: Stops'}
@ObjectModel: {representativeKey: 'TransportationOrderStopUUID',
usageType: {serviceQuality: #C,
sizeCategory: #XL,
dataClass: #TRANSACTIONAL}}
@VDM: {viewType: #BASIC}
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
personalData.blocking:#('TRANSACTIONAL_DATA'),
privilegedAssociations: ['_TranspOrdExecution', '_CapaStop', '_TranspOrdExecTranspActyArr', '_TranspOrdExecTranspActyDep' ] }
@Metadata.ignorePropagatedAnnotations: true
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] } */
define view entity I_TransportationOrderStop
as select from /scmtms/d_torstp as stop
/* Business Object related Node Associations*/
association [1..1] to I_TransportationOrder as _TransportationOrder on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
association [0..*] to I_TranspOrdExecution as _TranspOrdExecution on $projection.TransportationOrderStopUUID = _TranspOrdExecution.TransportationOrderStopUUID
association [0..1] to I_TranspOrdExecTranspActy as _TranspOrdExecTranspActyDep on $projection.TransportationOrderStopUUID = _TranspOrdExecTranspActyDep.TransportationOrderStopUUID
and _TranspOrdExecTranspActyDep.TranspOrdActivity = '03'
association [0..1] to I_TranspOrdExecTranspActy as _TranspOrdExecTranspActyArr on $projection.TransportationOrderStopUUID = _TranspOrdExecTranspActyArr.TransportationOrderStopUUID
and _TranspOrdExecTranspActyArr.TranspOrdActivity = '04'
association [0..1] to I_TransportationOrderStop as _CapaStop on $projection.TranspOrdCapacityStopUUID = _CapaStop.TransportationOrderStopUUID
association [0..1] to I_TransportationOrderStop as _CapacityStop on $projection.TranspOrdCapacityStopUUID = _CapacityStop.TransportationOrderStopUUID
association [0..1] to I_LocationBasic as _LocationAdditional on $projection.LocationId is not initial
and $projection.LocationId = _LocationAdditional.Location
and $projection.LocationAdditionalUUID = _LocationAdditional.LocationAdditionalUUID
association [0..1] to I_TmLocationDescription as _Locationdescr on $projection.LocationId is not initial
and $projection.LocationId = _Locationdescr.Location
association [0..1] to I_TmLocationDescription as _LocationDescription on $projection.LocationId is not initial
and $projection.LocationId = _LocationDescription.Location
association [0..1] to I_TransportationLocationVH as _LocationVH on $projection.LocationId = _LocationVH.Location
association [0..1] to I_TranspOrdStopCategory as _TranspOrdStopCategory on $projection.TranspOrdStopCategory = _TranspOrdStopCategory.TranspOrdStopCategory
association [0..1] to I_TranspOrdStopRole as _TranspOrdStopRole on $projection.TranspOrdStopRole = _TranspOrdStopRole.TranspOrdStopRole
association [0..1] to I_TranspHndlgExecStatus as _TranspHndlgExecStatus on $projection.TranspOrdStopHndlgExecStatus = _TranspHndlgExecStatus.TranspOrdStopHndlgExecStatus
{
@ObjectModel.text.element: [ 'TransportationOrderStop' ]
key db_key as TransportationOrderStopUUID,
@ObjectModel.foreignKey.association: '_TransportationOrder'
cast(parent_key as /scmtms/vdm_tor_db_key preserving type) as TransportationOrderUUID,
@Semantics.text: true
stop_id as TransportationOrderStop,
@ObjectModel.foreignKey.association: '_TranspOrdStopCategory'
stop_cat as TranspOrdStopCategory,
@ObjectModel.foreignKey.association: '_LocationAdditional'
cast(log_loc_uuid as /scmtms/vdm_location_adtl_uuid preserving type) as LocationAdditionalUUID,
cast(_LocationAdditional.LocationUUID as /scmtms/vdm_location_uuid preserving type) as LocationUUID,
@Consumption.valueHelp: '_LocationVH'
log_locid as LocationId,
log_locun as TranspOrdStopLocUNCode,
log_lociata as TranspOrdStopLocIATACode,
stop_parent_key as TranspOrdStopStopParentUUID,
stop_seq_pos as TranspOrdStopSequencePosition,
cast(acc_start as log_created_on preserving type) as TranspOrdStopAccptblStrtDteTme,
cast(req_start as log_created_on preserving type) as TranspOrdStopReqStartDteTme,
cast(req_end as log_created_on preserving type) as TranspOrdStopReqEndDteTme,
cast(acc_end as log_created_on preserving type) as TranspOrdStopAccptblEndDteTme,
cast(plan_trans_time as log_created_on preserving type) as TranspOrdStopPlanTranspDteTme,
@ObjectModel.foreignKey.association: '_TranspOrdStopRole'
stop_role as TranspOrdStopRole,
cast(appointment_start as log_created_on preserving type) as TranspOrdStopApptStrtDteTme,
cast(appointment_end as log_created_on preserving type) as TranspOrdStopApptEndDteTme,
cast(carr_conf_start as log_created_on preserving type) as TranspStopCarrConfStrtDteTme,
cast(carr_conf_end as log_created_on preserving type) as TranspStopCarrConfEndDteTme,
cast(prepare_start as log_created_on preserving type) as TranspOrdStopPrepStrtDteTme,
cast(prepare_end as log_created_on preserving type) as TranspOrdStopPrepEndDteTme,
cast(finalize_start as log_created_on preserving type) as TranspStopFinalizeStrtDteTme,
cast(finalize_end as log_created_on preserving type) as TranspStopFinalizeEndDteTme,
cast(
case when _TranspOrdExecTranspActyArr.TranspOrdEvtActualDateTime > _TranspOrdExecTranspActyDep.TranspOrdEvtActualDateTime then _TranspOrdExecTranspActyArr.TranspOrdEvtActualDateTime
else _TranspOrdExecTranspActyDep.TranspOrdEvtActualDateTime
end as log_created_on preserving type) as TranspOrdStopPlanExecDteTme,
@ObjectModel.foreignKey.association: '_TranspHndlgExecStatus'
handling_exec as TranspOrdStopHndlgExecStatus,
cast(aggr_assgn_start_l as log_created_on preserving type) as TranspOrdStopLoadStartDateTime,
cast(aggr_assgn_end_l as log_created_on preserving type) as TranspOrdStopLoadEndDateTime,
cast(aggr_assgn_start_c as log_created_on preserving type) as TranspOrdStopCoupleStrtDteTme,
cast(aggr_assgn_end_c as log_created_on preserving type) as TranspOrdStopCoupleEndDteTme,
entry_port as TranspOrdStopIsEntryPort,
exit_port as TranspOrdStopIsExitPort,
assgn_stop_key as TranspOrdCapacityStopUUID,
assgn_item_key as TranspOrdStopCapacityItemUUID,
cast(assgn_start as log_created_on preserving type) as TranspOrdStopCapPlngStrtDteTme,
cast(assgn_end as log_created_on preserving type) as TranspOrdStopCapPlngEndDteTme,
cast(cutoff_doc as log_created_on preserving type ) as TranspOrdStopDocCutOffDateTime,
cast(cutoff_cargo as log_created_on preserving type ) as TranspOrdStopCrgoCutOffDteTme,
cast(cutoff_carr_vgm as log_created_on preserving type ) as TranspOrdStopVGMCutOffDateTime,
@Semantics.booleanIndicator: true
blk_exec as TranspOrdStopExecIsBlocked,
case // In case we have an actual date/time for departure, this is used as TranspOrdStopDteTme. otherwise the plan_trans_time is used as fallback
when stop_cat = 'O' and _TranspOrdExecTranspActyDep.TranspOrdEvtActualDateTime is not initial then _TranspOrdExecTranspActyDep.TranspOrdEvtActualDateTime
when stop_cat = 'I' and _TranspOrdExecTranspActyArr.TranspOrdEvtActualDateTime is not initial then _TranspOrdExecTranspActyArr.TranspOrdEvtActualDateTime
else cast(plan_trans_time as log_created_on preserving type)
end as TranspOrdStopDteTme,
// Warehouse Information for ASR Cockpit
wh_number as TranspOrdStopWrhsNmbr,
wh_cat as TranspOrdStopWrhsCat,
load_point_id as TranspOrdStopLoadingPointID,
wh_door as TranspOrdStopWrhsDoorID,
wh_door_status as TranspOrdStopWrhsDoorStatus,
asr_indicator as TranspOrdStopASRRelevance,
/* Associations */
@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
_TransportationOrder,
_CapaStop,
_CapacityStop,
_LocationAdditional,
_Locationdescr,
_LocationDescription,
_TranspOrdExecution,
_TranspOrdExecTranspActyDep,
_TranspOrdExecTranspActyArr,
_TranspOrdStopCategory,
_TranspOrdStopRole,
_TranspHndlgExecStatus,
_LocationVH
}