I_TRANSPORDEXECUTION

CDS View
22 Fields 5 CDS Views

Transportation Order: Execution

I_TRANSPORDEXECUTION is a CDS View in S/4HANA. Transportation Order: Execution. It contains 22 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_FrtOrdExecutionEvent view from CONSUMPTION Freight Order Execution Event
I_TranspOrdExecutionAnalytics view from COMPOSITE Transportation Order Execution Analytics
I_TranspOrdExecutionEnrcd view from COMPOSITE Transportation Order Execution Enriched
I_TranspOrdStopLastRptdEvent view inner COMPOSITE Transp. Order: Last Rep. Event at Stop
R_TransportationOrderEventTP view_entity from TRANSACTIONAL Transportation Order Event - TP

Fields (22)

KeyField CDS FieldsUsed in Views
KEY TransportationOrderEventUUID TransportationOrderEventUUID 2
_TranspOrdEventCode _TranspOrdEventCode 1
_TranspOrdEventIsRecalled _TranspOrdEventIsRecalled 1
_TranspOrdEventStatus _TranspOrdEventStatus 1
_TransportationActivity _TransportationActivity 1
_TransportationOrderStop _TransportationOrderStop 1
ChangedDateTime ChangedDateTime 2
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 1
LastChangedByUser LastChangedByUser 2
LocationAdditionalUUID LocationAdditionalUUID 1
TranspOrdEventCode TranspOrdEventCode 2
TranspOrdEventIsRecalled TranspOrdEventIsRecalled 1
TranspOrdEventReasonCode TranspOrdEventReasonCode 1
TranspOrdEventReasonDesc TranspOrdEventReasonDesc 1
TranspOrdEventStatus TranspOrdEventStatus 1
TranspOrdEvtActualDateTime CreationDateTime,TranspOrdEvtActualDateTime 2
TranspOrdEvtActualDateTimeZone TranspOrdEvtActualDateTimeZone 1
TranspOrdExecution TransportationOrderEvent 1
TransportationActivity TransportationActivity 1
TransportationOrderStopUUID TransportationOrderStopUUID 1
TransportationOrderUUID TransportationOrderUUID 1

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: Execution
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRANSPORDEXECUTION (
    TRANSPORTATIONORDEREVENTUUID,
    _TRANSPORDEVENTCODE,
    _TRANSPORDEVENTISRECALLED,
    _TRANSPORDEVENTSTATUS,
    _TRANSPORTATIONACTIVITY,
    _TRANSPORTATIONORDERSTOP,
    CHANGEDDATETIME,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDBYUSER,
    LOCATIONADDITIONALUUID,
    TRANSPORDEVENTCODE,
    TRANSPORDEVENTISRECALLED,
    TRANSPORDEVENTREASONCODE,
    TRANSPORDEVENTREASONDESC,
    TRANSPORDEVENTSTATUS,
    TRANSPORDEVTACTUALDATETIME,
    TRANSPORDEVTACTUALDATETIMEZONE,
    TRANSPORDEXECUTION,
    TRANSPORTATIONACTIVITY,
    TRANSPORTATIONORDERSTOPUUID,
    TRANSPORTATIONORDERUUID,
    PRIMARY KEY (TRANSPORTATIONORDEREVENTUUID)
);

Learn More