I_TRANSPORTATIONORDER

CDS View
37 Fields 38 CDS Views

Transportation Orders

I_TRANSPORTATIONORDER is a CDS View in S/4HANA. Transportation Orders. It contains 37 fields. 38 CDS views read from this table.

CDS Views using this table (38)

ViewTypeJoinVDMDescription
C_FreightAgrmtFrtOrdRef view from CONSUMPTION Transportation Agreement Reference Doc
C_FrtOrdExecution view_entity from CONSUMPTION Freight Orders Execution
C_FrtOrdManagement view_entity from CONSUMPTION Freight Order Management
C_FrtOrdStopLoadRefCsgnmt view_entity inner CONSUMPTION Reference Stop to Consignment Order Item
C_FrtOrdStopLoadRefFreightUnit view_entity inner CONSUMPTION Reference Stop to Freight Unit
C_FrtUnitManagement view from CONSUMPTION Freight Unit Management
C_TranspOrdOutputParamDetn view from CONSUMPTION Transp Order Output Param Determin
I_TranspOrdCarrAddrID view_entity from COMPOSITE Transp Order Carrier Address ID
I_TranspOrdCarrAddrID view_entity union_all COMPOSITE Transp Order Carrier Address ID
I_TranspOrdCneeAddrID view_entity from COMPOSITE Transp Order Consignee Address ID
I_TranspOrdCneeAddrID view_entity union_all COMPOSITE Transp Order Consignee Address ID
I_TranspOrdExectgCarrAddrID view_entity from COMPOSITE Transp Order Exectg Carrier Address ID
I_TranspOrdExectgCarrAddrID view_entity union_all COMPOSITE Transp Order Exectg Carrier Address ID
I_TranspOrdProcFlwBasicFacts view from COMPOSITE Transportation Order: Proc. Flow Basic Facts
I_TranspOrdRootDelivDocRef view inner COMPOSITE Transportation Order: Root Delivery Document Reference
I_TranspOrdShprAddrID view_entity from COMPOSITE Transp Order Shipper Address ID
I_TranspOrdShprAddrID view_entity union_all COMPOSITE Transp Order Shipper Address ID
I_TransportationOrderAllBP view union_all COMPOSITE Transportation Order: All Business Partners
I_TransportationOrderAnalytics view from COMPOSITE Transportation Order Analytics
I_TransportationOrderEnrcd view from COMPOSITE Transportation Order Enriched
P_CollabnApplFreightOrdForConf view inner CONSUMPTION Private view for confirm freight order
P_CollabnApplFreightOrdForConf view from CONSUMPTION Private view for confirm freight order
P_CollabnApplFrtOrdInExecution view_entity from CONSUMPTION Freight Orders in Execution
P_CollabnApplFrtOrdInvoice view from CONSUMPTION Freight Orders for Invoicing
P_FrtOrdWthCalcError view from COMPOSITE
P_LogcDocFreightOrder view_entity from CONSUMPTION
P_TransportationCarrier view_entity from CONSUMPTION
R_FrtCostAllocRefFreightOrder view_entity inner COMPOSITE Frt Cost Alloc Ref Freight Order
R_FrtCostAllocRefFrtBooking view_entity inner COMPOSITE Frt Cost Alloc Ref Freight Booking
R_TranspOrdDocRefTP view_entity inner TRANSACTIONAL Transportation Order Doc Ref - TP
R_TranspOrdItemDocRefTP view_entity inner TRANSACTIONAL Transp Ord Item Document Reference - TP
R_TranspOrdItemSealTP view_entity inner TRANSACTIONAL Transportation Order Item Seal - TP
R_TransportationOrderBPTP view_entity inner TRANSACTIONAL Transportation Order Business Partner - TP
R_TransportationOrderEventTP view_entity inner TRANSACTIONAL Transportation Order Event - TP
R_TransportationOrderItemTP view_entity inner TRANSACTIONAL Transportation Order Item - TP
R_TransportationOrderStageTP view_entity inner TRANSACTIONAL Transportation Order Stage - TP
R_TransportationOrderStopTP view_entity inner TRANSACTIONAL Transportation Order Stop - TP
R_TransportationOrderTP view_entity from TRANSACTIONAL Transportation Order - TP

Fields (37)

KeyField CDS FieldsUsed in Views
KEY TransportationOrder FreightOrder,FreightUnit,TranspOrdInternalCsgnmtOrdID,TransportationOrder 6
KEY TransportationOrderUUID TransportationOrderUUID 6
_TranspOrdExecutionIsBlocked _TranspOrdExecutionIsBlocked 1
_TranspOrdLifeCycleStatus _TranspOrdLifeCycleStatus 1
_TranspOrdPlanningBlock _TranspOrdPlanningBlock 1
_TranspOrdPlanningStatus _TranspOrdPlanningStatus 1
_TransportationMode _TransportationMode 2
_TransportationOrderCategory _TransportationOrderCategory 2
_TransportationOrderExecSts _TransportationOrderExecSts 1
_TransportationOrderType _TransportationOrderType 2
Carrier Carrier 3
CreationDateTime CreationDateTime 1
MasterBillOfLading MasterBillOfLading 1
MeansOfTransport MeansOfTransport 3
PurchasingOrganization PurchasingOrganization 1
PurchasingOrgExternalID PurchasingOrgExternalID 3
TranspOrdDistance TranspOrdDistance 3
TranspOrdDistanceUnit TranspOrdDistanceUnit 3
TranspOrderDngrsGdsSts TranspOrderDngrsGdsSts 2
TranspOrdExecutionIsBlocked TranspOrdExecutionIsBlocked 2
TranspOrdGrossVolume TranspOrdGrossVolume 3
TranspOrdGrossVolumeUnit TranspOrdGrossVolumeUnit 3
TranspOrdGrossWeight TranspOrdGrossWeight 3
TranspOrdGrossWeightUnit TranspOrdGrossWeightUnit 3
TranspOrdLifeCycleStatus TranspOrdLifeCycleStatus 1
TranspOrdNetDurationUnit TranspOrdNetDurationUnit 1
TranspOrdPartnerReference TranspOrdExternalCsgnmtOrdID,TranspOrdPartnerReference 2
TranspOrdPlannedGdsMvtDteTme TranspOrdPlannedGdsMvtDteTme 1
TranspOrdPlanningBlock TranspOrdPlanningBlock 1
TranspOrdPlanningStatus TranspOrdPlanningStatus 1
TranspOrdQuantity TranspOrdQuantity 2
TranspOrdQuantityUnit TranspOrdQuantityUnit 2
TranspOrdResponsiblePerson TranspOrdResponsiblePerson 4
TransportationMode TransportationMode 2
TransportationOrderCategory TransportationOrderCategory 14
TransportationOrderExecSts TransportationOrderExecSts 1
TransportationOrderType TransportationOrderType 5

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 Orders
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRANSPORTATIONORDER (
    TRANSPORTATIONORDER,
    TRANSPORTATIONORDERUUID,
    _TRANSPORDEXECUTIONISBLOCKED,
    _TRANSPORDLIFECYCLESTATUS,
    _TRANSPORDPLANNINGBLOCK,
    _TRANSPORDPLANNINGSTATUS,
    _TRANSPORTATIONMODE,
    _TRANSPORTATIONORDERCATEGORY,
    _TRANSPORTATIONORDEREXECSTS,
    _TRANSPORTATIONORDERTYPE,
    CARRIER,
    CREATIONDATETIME,
    MASTERBILLOFLADING,
    MEANSOFTRANSPORT,
    PURCHASINGORGANIZATION,
    PURCHASINGORGEXTERNALID,
    TRANSPORDDISTANCE,
    TRANSPORDDISTANCEUNIT,
    TRANSPORDERDNGRSGDSSTS,
    TRANSPORDEXECUTIONISBLOCKED,
    TRANSPORDGROSSVOLUME,
    TRANSPORDGROSSVOLUMEUNIT,
    TRANSPORDGROSSWEIGHT,
    TRANSPORDGROSSWEIGHTUNIT,
    TRANSPORDLIFECYCLESTATUS,
    TRANSPORDNETDURATIONUNIT,
    TRANSPORDPARTNERREFERENCE,
    TRANSPORDPLANNEDGDSMVTDTETME,
    TRANSPORDPLANNINGBLOCK,
    TRANSPORDPLANNINGSTATUS,
    TRANSPORDQUANTITY,
    TRANSPORDQUANTITYUNIT,
    TRANSPORDRESPONSIBLEPERSON,
    TRANSPORTATIONMODE,
    TRANSPORTATIONORDERCATEGORY,
    TRANSPORTATIONORDEREXECSTS,
    TRANSPORTATIONORDERTYPE,
    PRIMARY KEY (TRANSPORTATIONORDER, TRANSPORTATIONORDERUUID)
);

Learn More