I_TRANSPORTATIONORDERITEM_2

CDS View
74 Fields 6 CDS Views

Transportation Order Item

I_TRANSPORTATIONORDERITEM_2 is a CDS View in S/4HANA. Transportation Order Item. It contains 74 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_TransportationOrderItemFDP view_entity from CONSUMPTION Transp Order Item Form Data Provider
I_TranspOrdItemBatch view_entity inner BASIC Transportation Order Item Batch
I_TranspOrdItmPrdcssrIntegDoc view_entity from COMPOSITE Transp Ord Item Prdcssr Integration Doc
P_OutbDelivByPrdcssrItm view_entity inner COMPOSITE Outbound Delivery by predecessor item
P_OutboundDeliveryByItem view_entity inner COMPOSITE Outbound Delivery by item
R_TransportationOrderItemTP view_entity from TRANSACTIONAL Transportation Order Item - TP

Fields (74)

KeyField CDS FieldsUsed in Views
KEY TransportationOrderItemUUID TransportationOrderItemUUID 3
_BusTransDocTypeCode _BusTransDocTypeCode 1
_Consignee _Consignee 1
_DestinationStop _DestinationStop 1
_PrdcssrTransportationOrder _PrdcssrTransportationOrder 1
_Product _Product 1
_Shipper _Shipper 1
_ShippingCondition _ShippingCondition 1
_SourceStop _SourceStop 1
_TranspOrdItemCategory _TranspOrdItemCategory 1
_TranspOrdItemGrossVolumeUnit _TranspOrdItemGrossVolumeUnit 1
_TranspOrdItemGrossWeightUnit _TranspOrdItemGrossWeightUnit 1
_TranspOrdItemNetWeightUnit _TranspOrdItemNetWeightUnit 1
_TranspOrdItemParentItem _TranspOrdItemParentItem 1
_TranspOrdItemQuantityUnit _TranspOrdItemQuantityUnit 1
_TranspOrdItemType _TranspOrdItemType 1
_TransportationGroup _TransportationGroup 1
_TransportationOrder _TransportationOrder 1
Consignee Consignee 1
ConsigneeAddressID ConsigneeAddressID 1
ConsigneeUUID ConsigneeUUID 1
DestinationStopUUID DestinationStopUUID 2
FreightUnitUUID FreightUnitUUID 1
IsMainCargoItem IsMainCargoItem 1
MaterialFreightGroup MaterialFreightGroup 1
PredecessorTransportationOrder PredecessorTransportationOrder 2
ProductID ProductID 3
ProductUUID ProductUUID 1
Shipper Shipper 1
ShipperAddressID ShipperAddressID 1
ShipperUUID ShipperUUID 1
SourceStopUUID SourceStopUUID 2
TranspBaseDocument TranspBaseDocument 2
TranspBaseDocumentItem TranspBaseDocumentItem 2
TranspBaseDocumentItemType TranspBaseDocumentItemType 2
TranspBaseDocumentType TranspBaseDocumentType 2
TranspEquipCapacityHeight TranspEquipCapacityHeight 1
TranspEquipCapacityLength TranspEquipCapacityLength 1
TranspEquipCapacityUnit TranspEquipCapacityUnit 1
TranspEquipCapacityVolume TranspEquipCapacityVolume 1
TranspEquipCapacityVolumeUnit TranspEquipCapacityVolumeUnit 1
TranspEquipCapacityWeight TranspEquipCapacityWeight 1
TranspEquipCapacityWeightUnit TranspEquipCapacityWeightUnit 1
TranspEquipCapacityWidth TranspEquipCapacityWidth 1
TranspEquipmentIsShipperOwned TranspEquipmentIsShipperOwned 1
TranspEquipmentPlateNumber TranspEquipmentPlateNumber 2
TranspEquipRegistrationCountry TranspEquipRegistrationCountry 2
TranspOrdItem TranspOrdItem 2
TranspOrdItemCategory TranspOrdItemCategory 2
TranspOrdItemDesc TranspOrdItemDesc 1
TranspOrdItemDngrsGdsSts TranspOrdItemDngrsGdsSts 2
TranspOrdItemGrossVolume TranspOrdItemGrossVolume 2
TranspOrdItemGrossVolumeUnit TranspOrdItemGrossVolumeUnit 2
TranspOrdItemGrossWeight TranspOrdItemGrossWeight 2
TranspOrdItemGrossWeightUnit TranspOrdItemGrossWeightUnit 2
TranspOrdItemNetWeight TranspOrdItemNetWeight 2
TranspOrdItemNetWeightUnit TranspOrdItemNetWeightUnit 2
TranspOrdItemPackageID TranspOrdItemPackageID 2
TranspOrdItemPalletSpacesQty TranspOrdItemPalletSpacesQty 1
TranspOrdItemPalletSpacesUnit TranspOrdItemPalletSpacesUnit 1
TranspOrdItemParentItemUUID TranspOrdItemParentItemUUID 2
TranspOrdItemQuantity TranspOrdItemQuantity 2
TranspOrdItemQuantityUnit TranspOrdItemQuantityUnit 2
TranspOrdItemShippingCondition TranspOrdItemShippingCondition 1
TranspOrdItemSorting TranspOrdItemSorting 1
TranspOrdItemTemperatureUnit TranspOrdItemTemperatureUnit 2
TranspOrdItemType TranspOrdItemType 1
TranspOrdItmMaxTemp TranspOrdItmMaxTemp 2
TranspOrdItmMinTemp TranspOrdItmMinTemp 2
TranspOrdShptItemRefUUID TranspOrdShptItemRefUUID 2
TransportationEquipmentGroup TransportationEquipmentGroup 2
TransportationEquipmentType TransportationEquipmentType 2
TransportationGroup TransportationGroup 1
TransportationOrderUUID TransportationOrderUUID 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 Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRANSPORTATIONORDERITEM_2 (
    TRANSPORTATIONORDERITEMUUID,
    _BUSTRANSDOCTYPECODE,
    _CONSIGNEE,
    _DESTINATIONSTOP,
    _PRDCSSRTRANSPORTATIONORDER,
    _PRODUCT,
    _SHIPPER,
    _SHIPPINGCONDITION,
    _SOURCESTOP,
    _TRANSPORDITEMCATEGORY,
    _TRANSPORDITEMGROSSVOLUMEUNIT,
    _TRANSPORDITEMGROSSWEIGHTUNIT,
    _TRANSPORDITEMNETWEIGHTUNIT,
    _TRANSPORDITEMPARENTITEM,
    _TRANSPORDITEMQUANTITYUNIT,
    _TRANSPORDITEMTYPE,
    _TRANSPORTATIONGROUP,
    _TRANSPORTATIONORDER,
    CONSIGNEE,
    CONSIGNEEADDRESSID,
    CONSIGNEEUUID,
    DESTINATIONSTOPUUID,
    FREIGHTUNITUUID,
    ISMAINCARGOITEM,
    MATERIALFREIGHTGROUP,
    PREDECESSORTRANSPORTATIONORDER,
    PRODUCTID,
    PRODUCTUUID,
    SHIPPER,
    SHIPPERADDRESSID,
    SHIPPERUUID,
    SOURCESTOPUUID,
    TRANSPBASEDOCUMENT,
    TRANSPBASEDOCUMENTITEM,
    TRANSPBASEDOCUMENTITEMTYPE,
    TRANSPBASEDOCUMENTTYPE,
    TRANSPEQUIPCAPACITYHEIGHT,
    TRANSPEQUIPCAPACITYLENGTH,
    TRANSPEQUIPCAPACITYUNIT,
    TRANSPEQUIPCAPACITYVOLUME,
    TRANSPEQUIPCAPACITYVOLUMEUNIT,
    TRANSPEQUIPCAPACITYWEIGHT,
    TRANSPEQUIPCAPACITYWEIGHTUNIT,
    TRANSPEQUIPCAPACITYWIDTH,
    TRANSPEQUIPMENTISSHIPPEROWNED,
    TRANSPEQUIPMENTPLATENUMBER,
    TRANSPEQUIPREGISTRATIONCOUNTRY,
    TRANSPORDITEM,
    TRANSPORDITEMCATEGORY,
    TRANSPORDITEMDESC,
    TRANSPORDITEMDNGRSGDSSTS,
    TRANSPORDITEMGROSSVOLUME,
    TRANSPORDITEMGROSSVOLUMEUNIT,
    TRANSPORDITEMGROSSWEIGHT,
    TRANSPORDITEMGROSSWEIGHTUNIT,
    TRANSPORDITEMNETWEIGHT,
    TRANSPORDITEMNETWEIGHTUNIT,
    TRANSPORDITEMPACKAGEID,
    TRANSPORDITEMPALLETSPACESQTY,
    TRANSPORDITEMPALLETSPACESUNIT,
    TRANSPORDITEMPARENTITEMUUID,
    TRANSPORDITEMQUANTITY,
    TRANSPORDITEMQUANTITYUNIT,
    TRANSPORDITEMSHIPPINGCONDITION,
    TRANSPORDITEMSORTING,
    TRANSPORDITEMTEMPERATUREUNIT,
    TRANSPORDITEMTYPE,
    TRANSPORDITMMAXTEMP,
    TRANSPORDITMMINTEMP,
    TRANSPORDSHPTITEMREFUUID,
    TRANSPORTATIONEQUIPMENTGROUP,
    TRANSPORTATIONEQUIPMENTTYPE,
    TRANSPORTATIONGROUP,
    TRANSPORTATIONORDERUUID,
    PRIMARY KEY (TRANSPORTATIONORDERITEMUUID)
);

Learn More