I_TRANSPORTATIONORDERSTOP

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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

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,
    TRANSPORDSTOPCATEGORY,
    TRANSPORDSTOPDTETME,
    TRANSPORDSTOPHNDLGEXECSTATUS,
    TRANSPORDSTOPLOADINGPOINTID,
    TRANSPORDSTOPPLANTRANSPDTETME,
    TRANSPORDSTOPREQENDDTETME,
    TRANSPORDSTOPREQSTARTDTETME,
    TRANSPORDSTOPSEQUENCEPOSITION,
    TRANSPORDSTOPSTOPPARENTUUID,
    TRANSPORDSTOPWRHSCAT,
    TRANSPORDSTOPWRHSDOORID,
    TRANSPORDSTOPWRHSDOORSTATUS,
    TRANSPORDSTOPWRHSNMBR,
    TRANSPORTATIONORDERSTOP,
    TRANSPORTATIONORDERUUID,
    PRIMARY KEY (TRANSPORTATIONORDERSTOPUUID)
);