I_TransportationOrderItem

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_TransportationOrderItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_TransportationOrderItem AS
SELECT
  cast(db_key as /scmtms/toritmuuid preserving type) AS TransportationOrderItemUUID,
  cast(parent_key as /scmtms/vdm_tor_db_key preserving type) AS TransportationOrderUUID,
  item_id AS TranspOrdItem,
  item_type AS TranspOrdItemType,
  multi_item AS IsMultiItem,
  item_parent_key AS TranspOrdItemParentItemUUID,
  src_stop_key AS SourceStopUUID,
  des_stop_key AS DestinationStopUUID,
  item_descr AS TranspOrdItemDesc,
  item_cat AS TranspOrdItemCategory,
  main_cargo_item AS IsMainCargoItem,
  ref_root_key AS PredecessorTransportationOrder,
  shipper_id AS Shipper,
  consignee_id AS Consignee,
  mot AS TransportationMode,
  mot_cat AS TransportationModeCategory,
  mtr AS MeansOfTransport,
  mtr AS TranspOrdMeansOfTransport,
  platenumber AS TranspOrdActvVehRscePltNmbr,
  cast(gro_wei_val as /scmtms/vdm_itm_grwgt_val preserving type) AS TranspOrdItemGrossWeight,
  cast(gro_wei_uni as /scmtms/vdm_itm_grwgt_unit preserving type) AS TranspOrdItemGrossWeightUnit,
  cast(gro_vol_val as /scmtms/vdm_itm_grvol_val preserving type) AS TranspOrdItemGrossVolume,
  cast(gro_vol_uni as /scmtms/vdm_itm_grvol_unit preserving type) AS TranspOrdItemGrossVolumeUnit,
  cast(net_wei_val as /scmtms/vdm_itm_netwgt_val preserving type) AS TranspOrdItemNetWeight,
  cast(net_wei_uni as /scmtms/vdm_itm_netwgt_unit preserving type) AS TranspOrdItemNetWeightUnit,
  cast(qua_pcs_val as /scmtms/vdm_itm_qty_val preserving type) AS TranspOrdItemQuantity,
  cast(qua_pcs_uni as /scmtms/vdm_itm_qty_unit preserving type) AS TranspOrdItemQuantityUnit,
  cast(qua_pcs2_val as /scmtms/vdm_itm_qty_alt_val preserving type) AS TranspOrdItemAltvQty,
  cast(qua_pcs2_uni as /scmtms/vdm_itm_qty_alt_unit preserving type) AS TranspOrdItemAltvQtyUnit,
  cast(base_uom_val as /scmtms/vdm_itm_base_val preserving type) AS TranspOrdItemBaseQty,
  cast(base_uom_uni as /scmtms/vdm_itm_base_unit preserving type) AS TranspOrdItemBaseQtyUnit,
  cast(pkgun_wei_val as /scmtms/vdm_itm_tare_wgt_val preserving type) AS TranspOrdItemTareWeight,
  cast(pkgun_wei_uni as /scmtms/vdm_itm_tare_wgt_unit preserving type) AS TranspOrdItemTareWeightUnit,
  cast(cont_cnt_val as /scmtms/vdm_itm_cont_val preserving type) AS TranspOrdItemNumberOfCtns,
  cast(cont_cnt_uni as /scmtms/vdm_itm_cont_unit preserving type) AS TranspOrdItemNumberOfCtnsUnit,
  length AS TranspOrdItemLength,
  width AS TranspOrdItemWidth,
  height AS TranspOrdItemHeight,
  measuom AS TranspOrdItemLengthUnit,
  cast( cast( amt_gdsv_val as abap.dec(31,6) ) * 10000 as abap.curr(31,2) ) AS TranspOrdItemGoodsValue,
  amt_gdsv_cur AS TranspOrdItemGoodsValueCrcy,
  dgo_indicator AS TranspOrdItemIsDangerousGood,
  dg_status AS TranspOrdItemDngrsGdsSts,
  prd_frght_grp AS MaterialFreightGroup,
  _MaterialFreightGroup._Text[1:Language = $session.system_language].MaterialFreightGroupName AS MaterialFreightGroupName,
  prd_transp_grp AS TransportationGroup,
  _TransportationGroup._Text[1:Language = $session.system_language].TransportationGroupName AS TransportationGroupName,
  product_id AS ProductID,
  _Product._Text[1:Language = $session.system_language].ProductName AS ProductName,
  base_btd_id AS TranspOrdDocReferenceID,
  base_btditem_id AS TranspOrdDocReferenceItmID,
  base_btd_tco AS TranspOrdDocReferenceType,
  base_btditem_tco AS TranspOrdDocReferenceItmType,
  orig_ref_root AS TranspOrdOrigRefRootUUID,
  shp_item_ref AS TranspOrdShptItemRefUUID,
  item_sort_id AS TranspOrdItemSorting,
  cast(shipper_key as /scmtms/vdm_shipper_key preserving type) AS ShipperUUID,
  sp_address_id AS ShipperAddressID,
  cast(consignee_key as /scmtms/vdm_consignee_key preserving type) AS ConsigneeUUID,
  cp_address_id AS ConsigneeAddressID,
  prd_key AS ProductUUID,
  inc_class_code AS IncotermsClassification,
  voyage_id AS TranspOrdItemVoyage,
  flight_code AS TranspOrdItemFlight,
  vessel_id AS TranspOrdItemVessel,
  imo_id AS TranspOrdItemIMOShip,
  flight_number AS TranspOrdFlightNumber,
  conf_status AS TranspOrdBookingConfSts,
  amt_hval_car_ind AS CargoIsHighValue,
  erp_plant_id AS Plant,
  wm_wh_number AS TranspOrdItmWhseNmbr,
  transsrvlvl_code AS TranspOrdShippingCondition,
  temp_uom AS TranspOrdItemTemperatureUnit,
  temp_ctrl_min AS TranspOrdItmMinTemp,
  temp_ctrl_max AS TranspOrdItmMaxTemp,
  tures_cat AS TranspOrdItmEquipmentGroup,
  tures_tco AS TranspOrdItmEquipmentType,
  shipper_own AS TranspOrdItmCtnIsShprOwnd,
  handling_exec AS TranspOrdItemHndlgExecStatus,
  country AS TranspOrdItmRegnCtryReg,
  package_id AS TranspOrdItemPackageID,
  measuomcam AS TranspOrdItemCapacityUnit,
  lengthcam AS TranspOrdItemCapacityLength,
  widthcam AS TranspOrdItemCapacityWidth,
  heightcam AS TranspOrdItemCapacityHeight,
  cast(gro_vol_valcap as /scmtms/vdm_itm_grvol_val preserving type) AS TranspOrdItmCapGrossVolume,
  gro_vol_unicap AS TranspOrdItmCapGrossVolumeUnit,
  cast(gro_wei_valcap as /scmtms/vdm_itm_grwgt_val preserving type ) AS TranspOrdItmCapGrossWeight,
  gro_wei_unicap AS TranspOrdItmCapGrossWeightUnit,
  cast (fu_root_key as /scmtms/vdm_freight_unit_uuid preserving type ) AS FreightUnitUUID,
  res_id AS TranspOrdItmResourceID
FROM /scmtms/d_torite AS item
LEFT OUTER JOIN I_TransportationOrder AS _TransportationOrder ON TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationOrder AS _PrdcssrTransportationOrder ON PredecessorTransportationOrder = _PrdcssrTransportationOrder.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationOrderItem AS _TranspOrdItemParentItem ON TranspOrdItemParentItemUUID = _TranspOrdItemParentItem.TransportationOrderItemUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationOrderStop AS _SourceStop ON SourceStopUUID = _SourceStop.TransportationOrderStopUUID  -- association [0..1]
LEFT OUTER JOIN I_TransportationOrderStop AS _DestinationStop ON DestinationStopUUID = _DestinationStop.TransportationOrderStopUUID  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Consignee ON Consignee = _Consignee.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Shipper ON Shipper = _Shipper.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdItemSeal AS _TranspOrdItemSeal ON TransportationOrderItemUUID = _TranspOrdItemSeal.TransportationOrderItemUUID  -- association [0..*]
LEFT OUTER JOIN I_TranspOrdItemDocRef AS _TranspOrdItemDocRef ON TransportationOrderItemUUID = _TranspOrdItemDocRef.TransportationOrderItemUUID  -- association [0..*]
LEFT OUTER JOIN I_TranspOrdItemCommodityCode AS _TranspOrdItemCommodityCode ON TransportationOrderItemUUID = _TranspOrdItemCommodityCode.TransportationOrderItemUUID  -- association [0..*]
LEFT OUTER JOIN I_TranspOrdItemType AS _TranspOrdItemType ON TranspOrdItemType = _TranspOrdItemType.TranspOrdItemType  -- association [0..1]
LEFT OUTER JOIN I_IsMultiItem AS _IsMultiItem ON IsMultiItem = _IsMultiItem.IsMultiItem  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdItemCategory AS _TranspOrdItemCategory ON TranspOrdItemCategory = _TranspOrdItemCategory.TranspOrdItemCategory  -- association [0..1]
LEFT OUTER JOIN I_MeansOfTransport AS _MeansOfTransport ON MeansOfTransport = _MeansOfTransport.MeansOfTransport  -- association [0..1]
LEFT OUTER JOIN I_TransportationMode AS _TransportationMode ON TransportationMode = _TransportationMode.TransportationMode  -- association [0..1]
LEFT OUTER JOIN I_TransportationModeCategory AS _TransportationModeCategory ON TransportationModeCategory = _TransportationModeCategory.TransportationModeCategory  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItemGrossWeightUnit ON TranspOrdItemGrossWeightUnit = _TranspOrdItemGrossWeightUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItemGrossVolumeUnit ON TranspOrdItemGrossVolumeUnit = _TranspOrdItemGrossVolumeUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItemNetWeightUnit ON TranspOrdItemNetWeightUnit = _TranspOrdItemNetWeightUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItemQuantityUnit ON TranspOrdItemQuantityUnit = _TranspOrdItemQuantityUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItemAltvQtyUnit ON TranspOrdItemAltvQtyUnit = _TranspOrdItemAltvQtyUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItemBaseQtyUnit ON TranspOrdItemBaseQtyUnit = _TranspOrdItemBaseQtyUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItemTareWeightUnit ON TranspOrdItemTareWeightUnit = _TranspOrdItemTareWeightUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItemNumberOfCtnsUnit ON TranspOrdItemNumberOfCtnsUnit = _TranspOrdItemNumberOfCtnsUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItemLengthUnit ON TranspOrdItemLengthUnit = _TranspOrdItemLengthUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItemTemperatureUnit ON TranspOrdItemTemperatureUnit = _TranspOrdItemTemperatureUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItemCapacityUnit ON TranspOrdItemCapacityUnit = _TranspOrdItemCapacityUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItmCapGrossVolUnit ON TranspOrdItmCapGrossVolumeUnit = _TranspOrdItmCapGrossVolUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdItmCapGrossWeightUnt ON TranspOrdItmCapGrossWeightUnit = _TranspOrdItmCapGrossWeightUnt.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _GoodsValCurrency ON TranspOrdItemGoodsValueCrcy = _GoodsValCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_TransportationGroup AS _TransportationGroup ON TransportationGroup = _TransportationGroup.TransportationGroup  -- association [1..1]
LEFT OUTER JOIN I_MaterialFreightGroup AS _MaterialFreightGroup ON MaterialFreightGroup = _MaterialFreightGroup.MaterialFreightGroup  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON ProductID = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_BusTransDocTypeCode AS _BusTransDocTypeCode ON TranspOrdDocReferenceType = _BusTransDocTypeCode.BusinessTransactionDocType  -- association [1..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON TranspOrdShippingCondition = _ShippingCondition.ShippingCondition  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [1..1]
LEFT OUTER JOIN I_TranspOrdItemDngrsGdsStatus AS _TranspOrdItemDngrsGdsStatus ON TranspOrdItemDngrsGdsSts = _TranspOrdItemDngrsGdsStatus.TranspOrdItemDngrsGdsSts  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdBookingConfSts AS _TranspOrdBookingConfSts ON TranspOrdBookingConfSts = _TranspOrdBookingConfSts.TranspOrdBookingConfSts  -- association [0..1]
;