I_TRANSPORTATIONORDERSTOP
Transportation Order: Stops
I_TRANSPORTATIONORDERSTOP is a CDS View in S/4HANA. Transportation Order: Stops. It contains 42 fields. 12 CDS views read from this table.
CDS Views using this table (12)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CollabnApplTranspOrderStop | view | from | CONSUMPTION | Transportation Order Stop |
| C_FreightOrderStopASR | view_entity | from | CONSUMPTION | ASR Cockpit Freight Order Stops |
| I_TranspOrdProcFlwBasicFacts | view | inner | COMPOSITE | Transportation Order: Proc. Flow Basic Facts |
| I_TranspOrdStopAnalytics | view | from | COMPOSITE | Transportation Order Stop Analytics |
| I_TransportationOrderStopEnrcd | view | from | COMPOSITE | Transportation Order Stop enriched |
| P_CollabnApplFrtOrdExecStop | view_entity | from | CONSUMPTION | Private View for FO Execution Stop |
| P_OUTBDELIVERY_FREIGHT_ORDER | view | inner | CONSUMPTION | |
| P_RETURNSDELIVERYFREIGHTORDER | view | inner | CONSUMPTION | |
| P_SlsOrdProcFlow23_1 | view | inner | CONSUMPTION | |
| R_TransportationOrderStopTP | view_entity | from | TRANSACTIONAL | Transportation Order Stop - TP |
| 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 (42)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | TransportationOrderStopUUID | TransportationOrderStopUUID | 7 |
| _CapacityStop | _CapacityStop | 1 | |
| _LocationAdditional | _LocationAdditional | 1 | |
| _LocationDescription | _LocationDescription | 1 | |
| _TranspHndlgExecStatus | _TranspHndlgExecStatus | 1 | |
| _TranspOrdExecTranspActyArr | _TranspOrdExecTranspActyArr | 1 | |
| _TranspOrdExecTranspActyDep | _TranspOrdExecTranspActyDep | 1 | |
| _TranspOrdExecution | _TranspOrdExecution | 1 | |
| _TranspOrdStopCategory | _TranspOrdStopCategory | 1 | |
| _TranspOrdStopRole | _TranspOrdStopRole | 1 | |
| LocationAdditionalUUID | LocationAdditionalUUID | 1 | |
| LocationId | LocationId | 3 | |
| TranspOrdCapacityStopUUID | TranspOrdCapacityStopUUID | 1 | |
| TranspOrdStopAccptblEndDteTme | TranspOrdStopAccptblEndDteTme | 3 | |
| TranspOrdStopAccptblStrtDteTme | TranspOrdStopAccptblStrtDteTme | 3 | |
| TranspOrdStopApptEndDteTme | TranspOrdStopApptEndDteTme | 1 | |
| TranspOrdStopApptStrtDteTme | TranspOrdStopApptStrtDteTme | 1 | |
| TranspOrdStopCapacityItemUUID | TranspOrdStopCapacityItemUUID | 1 | |
| TranspOrdStopCategory | TranspOrdStopCategory | 5 | |
| TranspOrdStopCrgoCutOffDteTme | TranspOrdStopCrgoCutOffDteTme | 1 | |
| TranspOrdStopDocCutOffDateTime | TranspOrdStopDocCutOffDateTime | 1 | |
| TranspOrdStopDteTme | TranspOrdStopDteTme | 2 | |
| TranspOrdStopExecIsBlocked | TranspOrdStopExecIsBlocked | 1 | |
| TranspOrdStopHndlgExecStatus | TranspOrdStopHndlgExecStatus | 2 | |
| TranspOrdStopLoadingPointID | TranspOrdStopLoadingPointID | 1 | |
| TranspOrdStopLocIATACode | LocationIATACode | 1 | |
| TranspOrdStopLocUNCode | LocationUNCode | 1 | |
| TranspOrdStopPlanTranspDteTme | DestStopPlndTranspDteTme,SourceStopPlndTranspDteTme,TranspOrdStopPlanTranspDteTme | 3 | |
| TranspOrdStopReqEndDteTme | DestStopReqdEndDteTme,SourceStopReqdEndDteTme,TranspOrdStopReqEndDteTme | 2 | |
| TranspOrdStopReqStartDteTme | DestStopReqdStartDteTme,SourceStopReqdStartDteTme,TranspOrdStopReqStartDteTme | 2 | |
| TranspOrdStopRole | TranspOrdStopRole | 1 | |
| TranspOrdStopSequencePosition | TranspOrdStopSequencePosition | 5 | |
| TranspOrdStopStopParentUUID | TranspOrdStopStopParentUUID | 2 | |
| TranspOrdStopVGMCutOffDateTime | TranspOrdStopVGMCutOffDateTime | 1 | |
| TranspOrdStopWrhsCat | TranspOrdStopWrhsCat | 1 | |
| TranspOrdStopWrhsDoorID | TranspOrdStopWrhsDoorID | 1 | |
| TranspOrdStopWrhsDoorStatus | TranspOrdStopWrhsDoorStatus | 1 | |
| TranspOrdStopWrhsNmbr | TranspOrdStopWrhsNmbr | 1 | |
| TransportationOrderStop | TransportationOrderStop | 4 | |
| TransportationOrderUUID | TransportationOrderUUID | 6 | |
| TranspStopCarrConfEndDteTme | TranspStopCarrConfEndDteTme | 2 | |
| TranspStopCarrConfStrtDteTme | TranspStopCarrConfStrtDteTme | 2 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Transportation Order: Stops
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRANSPORTATIONORDERSTOP (
TRANSPORTATIONORDERSTOPUUID,
_CAPACITYSTOP,
_LOCATIONADDITIONAL,
_LOCATIONDESCRIPTION,
_TRANSPHNDLGEXECSTATUS,
_TRANSPORDEXECTRANSPACTYARR,
_TRANSPORDEXECTRANSPACTYDEP,
_TRANSPORDEXECUTION,
_TRANSPORDSTOPCATEGORY,
_TRANSPORDSTOPROLE,
LOCATIONADDITIONALUUID,
LOCATIONID,
TRANSPORDCAPACITYSTOPUUID,
TRANSPORDSTOPACCPTBLENDDTETME,
TRANSPORDSTOPACCPTBLSTRTDTETME,
TRANSPORDSTOPAPPTENDDTETME,
TRANSPORDSTOPAPPTSTRTDTETME,
TRANSPORDSTOPCAPACITYITEMUUID,
TRANSPORDSTOPCATEGORY,
TRANSPORDSTOPCRGOCUTOFFDTETME,
TRANSPORDSTOPDOCCUTOFFDATETIME,
TRANSPORDSTOPDTETME,
TRANSPORDSTOPEXECISBLOCKED,
TRANSPORDSTOPHNDLGEXECSTATUS,
TRANSPORDSTOPLOADINGPOINTID,
TRANSPORDSTOPLOCIATACODE,
TRANSPORDSTOPLOCUNCODE,
TRANSPORDSTOPPLANTRANSPDTETME,
TRANSPORDSTOPREQENDDTETME,
TRANSPORDSTOPREQSTARTDTETME,
TRANSPORDSTOPROLE,
TRANSPORDSTOPSEQUENCEPOSITION,
TRANSPORDSTOPSTOPPARENTUUID,
TRANSPORDSTOPVGMCUTOFFDATETIME,
TRANSPORDSTOPWRHSCAT,
TRANSPORDSTOPWRHSDOORID,
TRANSPORDSTOPWRHSDOORSTATUS,
TRANSPORDSTOPWRHSNMBR,
TRANSPORTATIONORDERSTOP,
TRANSPORTATIONORDERUUID,
TRANSPSTOPCARRCONFENDDTETME,
TRANSPSTOPCARRCONFSTRTDTETME,
PRIMARY KEY (TRANSPORTATIONORDERSTOPUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA