I_TRANSPORTATIONORDERSTAGE

CDS View
39 Fields 9 CDS Views

Transportation Order: Stages

I_TRANSPORTATIONORDERSTAGE is a CDS View in S/4HANA. Transportation Order: Stages. It contains 39 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_CollabnApplMngFrtOrdChrgStge view_entity from CONSUMPTION Freight Order Stage
C_FrtOrdAccrStage view from CONSUMPTION Freight Order Stages for Accruals
I_FrtOrderStage view from COMPOSITE Freight Order: Stages
I_FrtUnitStage view from COMPOSITE Freight Unit: Stages
I_TranspOrdStageAnalytics view from COMPOSITE Transportation Order Stage Analytics
I_TranspOrdStageEnrcd view from COMPOSITE Transportation Order Stage enriched
I_TranspOrdStgeBPAddrID view_entity from COMPOSITE Transp Order Stage Bus Prtn Address ID
I_TranspOrdStgeBPAddrID view_entity union_all COMPOSITE Transp Order Stage Bus Prtn Address ID
R_TransportationOrderStageTP view_entity from TRANSACTIONAL Transportation Order Stage - TP

Fields (39)

KeyField CDS FieldsUsed in Views
KEY TransportationOrderStageUUID TransportationOrderStageUUID 4
_Carrier _Carrier 1
_MeansOfTransport _MeansOfTransport 1
_TranspAirlineIATACode _TranspAirlineIATACode 1
_TranspOrdStageCategory _TranspOrdStageCategory 1
_TranspOrdStageDestStop _TranspOrdStageDestStop 1
_TranspOrdStageSrceStop _TranspOrdStageSrceStop 1
_TranspOrdStageType _TranspOrdStageType 1
_TransportationMode _TransportationMode 1
_TransportationModeCategory _TransportationModeCategory 1
Carrier Carrier 1
CarrierUUID CarrierUUID 1
MeansOfTransport TranspOrdStageMeansOfTransport 1
RequestingCompanyCode RequestingCompanyCode 1
TranspOrdStageAirlineIATACode TranspOrdStageAirlineIATACode 1
TranspOrdStageAirWayBill TranspOrdStageAirWayBill 1
TranspOrdStageCategory TranspOrdStageCategory 1
TranspOrdStageDestStopCategory TranspOrdStageDestStopCategory 1
TranspOrdStageDestStopUUID TranspOrdStageDestStopUUID 2
TranspOrdStageDistance TranspOrdStageDistance 2
TranspOrdStageDistanceUnit TranspOrdStageDistanceUnit 2
TranspOrdStageFlight TranspOrdStageFlight 1
TranspOrdStageIMOShip TranspOrdStageIMOShip 1
TranspOrdStageInvoicingCarrier TranspOrdStageInvoicingCarrier 1
TranspOrdStageNetDuration TranspOrdStageNetDuration 2
TranspOrdStagePlnStatus TranspOrdStagePlnStatus 1
TranspOrdStageSCACCode TranspOrdStageSCACCode 1
TranspOrdStageShippingType TranspOrdStageShippingType,TransportationShippingType 2
TranspOrdStageSrceStopUUID TranspOrdStageSrceStopUUID 2
TranspOrdStageType TranspOrdStageType 1
TranspOrdStageVessel TranspOrdStageVessel 1
TranspOrdStageVoyage TranspOrdStageVoyage 1
TranspOrdStgeInvcgCarrLvl TranspOrdStgeInvcgCarrLvl 1
TranspOrdStgeInvcgCarrUUID TranspOrdStgeInvcgCarrUUID 1
TranspOrdStgeInvcgSCACCode TranspOrdStgeInvcgSCACCode 1
TransportationMode TransportationMode 2
TransportationModeCategory TransportationModeCategory 1
TransportationOrderStage TransportationOrderStage 1
TransportationOrderUUID TransportationOrderUUID 4

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: Stages
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRANSPORTATIONORDERSTAGE (
    TRANSPORTATIONORDERSTAGEUUID,
    _CARRIER,
    _MEANSOFTRANSPORT,
    _TRANSPAIRLINEIATACODE,
    _TRANSPORDSTAGECATEGORY,
    _TRANSPORDSTAGEDESTSTOP,
    _TRANSPORDSTAGESRCESTOP,
    _TRANSPORDSTAGETYPE,
    _TRANSPORTATIONMODE,
    _TRANSPORTATIONMODECATEGORY,
    CARRIER,
    CARRIERUUID,
    MEANSOFTRANSPORT,
    REQUESTINGCOMPANYCODE,
    TRANSPORDSTAGEAIRLINEIATACODE,
    TRANSPORDSTAGEAIRWAYBILL,
    TRANSPORDSTAGECATEGORY,
    TRANSPORDSTAGEDESTSTOPCATEGORY,
    TRANSPORDSTAGEDESTSTOPUUID,
    TRANSPORDSTAGEDISTANCE,
    TRANSPORDSTAGEDISTANCEUNIT,
    TRANSPORDSTAGEFLIGHT,
    TRANSPORDSTAGEIMOSHIP,
    TRANSPORDSTAGEINVOICINGCARRIER,
    TRANSPORDSTAGENETDURATION,
    TRANSPORDSTAGEPLNSTATUS,
    TRANSPORDSTAGESCACCODE,
    TRANSPORDSTAGESHIPPINGTYPE,
    TRANSPORDSTAGESRCESTOPUUID,
    TRANSPORDSTAGETYPE,
    TRANSPORDSTAGEVESSEL,
    TRANSPORDSTAGEVOYAGE,
    TRANSPORDSTGEINVCGCARRLVL,
    TRANSPORDSTGEINVCGCARRUUID,
    TRANSPORDSTGEINVCGSCACCODE,
    TRANSPORTATIONMODE,
    TRANSPORTATIONMODECATEGORY,
    TRANSPORTATIONORDERSTAGE,
    TRANSPORTATIONORDERUUID,
    PRIMARY KEY (TRANSPORTATIONORDERSTAGEUUID)
);

Learn More