I_TransportationOrder

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_TransportationOrder.
-- 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_TransportationOrder AS
SELECT
  cast(db_key as /scmtms/vdm_tor_db_key preserving type) AS TransportationOrderUUID,
  tor_id AS TransportationOrder,
  tor_cat AS TransportationOrderCategory,
  tor_type AS TransportationOrderType,
  dgo_indicator AS DangerousGoodsAreContained,
  transsrvlvl_code AS TransportationServiceLevel,
  resp_person AS TranspOrdResponsiblePerson,
  partner_ref_id AS TranspOrdPartnerReference,
  partner_mbl_id AS MasterBillOfLading,
  blk_plan AS TranspOrdPlanningBlock,
  blk_exec AS TranspOrdExecutionIsBlocked,
  inv_block AS InvoicingIsBlocked,
  cast(tsp as bu_partner_guid preserving type) AS CarrierUUID,
  cast(tspid as /scmtms/pty_carrier preserving type) AS Carrier,
  tsp_scac AS StandardCarrierAlphaCode,
  tsp_airlc AS TranspOrdAirlineIATACode,
  tsp_airlcawb AS TranspOrdAirWayBill,
  tsp_address_id AS CarrierAddressID,
  tsp_set_by_srvc AS CarrierOriginOfEntry,
  cast(shipper_key as bu_partner_guid preserving type) AS ShipperUUID,
  cast(shipperid as /scmtms/pty_shipper preserving type) AS Shipper,
  sp_address_id AS ShipperAddressID,
  cast(consignee_key as bu_partner_guid preserving type) AS ConsigneeUUID,
  cast(consigneeid as /scmtms/pty_consignee preserving type) AS Consignee,
  cp_address_id AS ConsigneeAddressID,
  shipping_type AS TranspOrdShippingType,
  movement_type AS MovementType,
  traffic_direct AS TranspOrdTrafficDirection,
  exec_org_id AS PlngAndExecOrganization,
  exec_grp_id AS PlngAndExecGroup,
  purch_org_id AS PurchasingOrganization,
  _PurchasingOrganization.OrganizationalUnitExternalID AS PurchasingOrgExternalID,
  purch_grp_id AS PurchasingGroup,
  _PurchasingGroup.OrganizationalUnitExternalID AS PurchasingGroupExternalID,
  purch_company_code AS PurgOrgCompanyCode,
  purch_org AS TranspPurgOrg,
  purch_grp AS TranspPurgGroup,
  lifecycle AS TranspOrdLifeCycleStatus,
  plan_status_root AS TranspOrdPlanningStatus,
  execution AS TransportationOrderExecSts,
  dg_status AS TranspOrderDngrsGdsSts,
  confirmation AS TransportationOrderConfSts,
  subcontracting AS TranspOrderSubcontrgSts,
  mtr AS MeansOfTransport,
  trmodcod AS TransportationMode,
  trmodcat AS TransportationModeCategory,
  max_util AS TranspOrdMaxUtilznRatio,
  trq_cat AS TransportationRequestCategory,
  invdisp_resolution AS FrtDsputCaseStatus,
  cast(max_util_mass as /scmtms/vdm_max_util_mass preserving type) AS TranspOrdMaxUtilznMassRatio,
  cast(max_util_volume as /scmtms/vdm_max_util_volume preserving type) AS TranspOrdMaxUtilznVolumeRatio,
  cast(max_util_length as /scmtms/vdm_max_util_length preserving type) AS TranspOrdMaxUtilznLengthRatio,
  cast(gro_wei_val as /scmtms/vdm_gro_wei_val preserving type ) AS TranspOrdGrossWeight,
  gro_wei_uni AS TranspOrdGrossWeightUnit,
  cast(gro_vol_val as /scmtms/vdm_gro_vol_val preserving type ) AS TranspOrdGrossVolume,
  gro_vol_uni AS TranspOrdGrossVolumeUnit,
  cast(net_wei_val as /scmtms/vdm_tor_net_wei_val preserving type ) AS TranspOrdNetWeight,
  net_wei_uni AS TranspOrdNetWeightUnit,
  cast(qua_pcs_val as /scmtms/vdm_tor_pcs_val preserving type ) AS TranspOrdQuantity,
  qua_pcs_uni AS TranspOrdQuantityUnit,
  cast(qua_pcs2_val as /scmtms/vdm_qty_alt_val preserving type ) AS TranspOrdAlternativeQty,
  qua_pcs2_uni AS TranspOrdAlternativeQtyUnit,
  cast(base_uom_val as /scmtms/vdm_qty_base_val preserving type ) AS TranspOrdBaseQuantity,
  base_uom_uni AS TranspOrdBaseQuantityUnit,
  cast(pkgun_wei_val as /scmtms/vdm_tor_pack_unl_wei_v preserving type ) AS TranspOrdTareWeight,
  pkgun_wei_uni AS TranspOrdTareWeightUnit,
  cast(normloadconsval as /scmtms/vdm_normloadconsval preserving type ) AS TranspOrdPalletSpacesQty,
  normloadconsuom AS TranspOrdPalletSpacesUnit,
  cast(addnormloadconsval as /scmtms/vdm_addnormloadconsval preserving type ) AS TranspOrdLoadMetersQty,
  addnormloadconsuom AS TranspOrdLoadMetersUnit,
  cast(cont_cnt_val as /scmtms/vdm_tor_cont_count_val preserving type ) AS TranspOrdNumberOfCtns,
  cont_cnt_uni AS TranspOrdNumberOfCtnsUnit,
  cast(dg_adr_pts_val as /scmtms/vdm_tor_dg_adr_pts_val preserving type ) AS TranspOrdDngrsGdsExmpPts,
  dg_adr_pts_uni AS TranspOrdDngrsGdsExmpPtsUnit,
  total_distance_km AS TranspOrdDistance,
  cast('KM' as /scmtms/vdm_dsp_length_unit) AS TranspOrdDistanceUnit,
  cast(total_duration_net as bapi11201trmdurat) AS TranspOrdNetDuration,
  cast('H' as /scmtms/vdm_dsp_time_unit) AS TranspOrdNetDurationUnit,
  created_by AS CreatedByUser,
  cast(created_on as log_created_on preserving type) AS CreationDateTime,
  changed_by AS LastChangedByUser,
  cast(changed_on as log_created_on preserving type) AS ChangedDateTime,
  cast(datetime_chlc as log_created_on preserving type) AS TranspOrdLfcycStsChgDteTime,
  cast(order_date as log_created_on preserving type) AS TranspOrdOrderDateTime,
  base_btd_id AS BusinessTransactionDocument,
  base_btd_tco AS BusinessTransactionDocType,
  dlv_goods_mvmnt AS TranspOrdGoodsMovementStatus,
  wh_processing_status AS TranspOrdWhseProcessingStatus,
  multi_exe_pty AS TranspOrdHasMltplExectgPties,
  pymt_ind AS TranspOrdInvoicingCarrierLevel,
  eikto AS TransOrdAcctNmbrWthExectgCarr,
  cast(tspexec_key as /scmtms/vdm_tspexec_uuid preserving type) AS TranspOrdExecutingCarrierUUID,
  tspexecid AS TranspOrdExecutingCarrier,
  tspexec_address_id AS ExecutingCarrierAddressID,
  creation_type AS TransportationOrderCrtnType,
  dlv_plan_goods_mvmnt_date AS TranspOrdPlannedGdsMvtDteTme,
  tu_cat AS TransportationUnitCategory
FROM /scmtms/d_torrot AS root
LEFT OUTER JOIN I_TransportationOrderItem AS _TransportationOrderItem ON TransportationOrderUUID = _TransportationOrderItem.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_TransportationOrderStop AS _TransportationOrderStop ON TransportationOrderUUID = _TransportationOrderStop.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_TransportationOrderStage AS _TransportationOrderStage ON TransportationOrderUUID = _TransportationOrderStage.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_TranspOrdExecution AS _TranspOrdExecution ON TransportationOrderUUID = _TranspOrdExecution.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_TransportationOrderBlock AS _TransportationOrderBlock ON TransportationOrderUUID = _TransportationOrderBlock.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_Tendering AS _Tendering ON TransportationOrderUUID = _Tendering.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_TranspOrdDocRef AS _DocRef ON TransportationOrderUUID = _DocRef.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_TransportationOrderStop AS _SourceStop ON TransportationOrderUUID = _SourceStop.TransportationOrderUUID AND _SourceStop.TranspOrdStopSequencePosition = 'F'  -- association [0..1]
LEFT OUTER JOIN I_TransportationOrderStop AS _DestinationStop ON TransportationOrderUUID = _DestinationStop.TransportationOrderUUID AND _DestinationStop.TranspOrdStopSequencePosition = 'L'  -- association [0..1]
LEFT OUTER JOIN I_TranspChargeItem AS _TranspChargeItem ON TransportationOrderUUID = _TranspChargeItem.RefTransportationOrderUUID  -- association [0..*]
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_BusinessPartner AS _Carrier ON Carrier = _Carrier.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ExectgCarrier ON TranspOrdExecutingCarrier = _ExectgCarrier.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_TranspOrganizationalUnit AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.OrganizationalUnit  -- association [0..1]
LEFT OUTER JOIN I_TranspOrganizationalUnit AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.OrganizationalUnit  -- association [0..1]
LEFT OUTER JOIN I_TranspOrganizationalUnit AS _PlngAndExecOrganization ON PlngAndExecOrganization = _PlngAndExecOrganization.OrganizationalUnit  -- association [0..1]
LEFT OUTER JOIN I_TranspOrganizationalUnit AS _PlngAndExecGroup ON PlngAndExecGroup = _PlngAndExecGroup.OrganizationalUnit  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PurchasingCompanyCode ON PurgOrgCompanyCode = _PurchasingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TransportationOrderType_2 AS _TransportationOrderType ON TransportationOrderType = _TransportationOrderType.TransportationOrderType  -- association [0..1]
LEFT OUTER JOIN I_TranspOrderCategory_2 AS _TransportationOrderCategory ON TransportationOrderCategory = _TransportationOrderCategory.TransportationOrderCategory  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdPlanningBlock AS _TranspOrdPlanningBlock ON TranspOrdPlanningBlock = _TranspOrdPlanningBlock.TranspOrdPlanningBlock  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdExecutionIsBlocked AS _TranspOrdExecutionIsBlocked ON TranspOrdExecutionIsBlocked = _TranspOrdExecutionIsBlocked.TranspOrdExecutionIsBlocked  -- association [0..1]
LEFT OUTER JOIN I_InvoicingIsBlocked AS _InvoicingIsBlocked ON InvoicingIsBlocked = _InvoicingIsBlocked.InvoicingIsBlocked  -- association [0..1]
LEFT OUTER JOIN I_TranspSCACCode AS _TranspSCACCode ON StandardCarrierAlphaCode = _TranspSCACCode.TranspSCACCode  -- association [0..1]
LEFT OUTER JOIN I_TranspAirlineIATACode AS _TranspAirlineIATACode ON TranspOrdAirlineIATACode = _TranspAirlineIATACode.TranspAirlineIATACode  -- association [0..1]
LEFT OUTER JOIN I_CarrierOriginOfEntry AS _CarrierOriginOfEntry ON CarrierOriginOfEntry = _CarrierOriginOfEntry.CarrierOriginOfEntry  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdShippingType AS _TranspOrdShippingType ON TranspOrdShippingType = _TranspOrdShippingType.TranspOrdShippingType  -- association [0..1]
LEFT OUTER JOIN I_TranspMovementType AS _MovementType ON MovementType = _MovementType.MovementType  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdLifeCycleStatus AS _TranspOrdLifeCycleStatus ON TranspOrdLifeCycleStatus = _TranspOrdLifeCycleStatus.TranspOrdLifeCycleStatus  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdPlanningStatus_2 AS _TranspOrdPlanningStatus ON TranspOrdPlanningStatus = _TranspOrdPlanningStatus.TranspOrdPlanningStatus  -- association [0..1]
LEFT OUTER JOIN I_TransportationOrderExecSts AS _TransportationOrderExecSts ON TransportationOrderExecSts = _TransportationOrderExecSts.TransportationOrderExecSts  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdDngrsGdsStatus AS _TranspOrdDngrsGdsStatus ON TranspOrderDngrsGdsSts = _TranspOrdDngrsGdsStatus.TranspOrderDngrsGdsSts  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdConfirmationStatus AS _TranspOrdConfirmationStatus ON TransportationOrderConfSts = _TranspOrdConfirmationStatus.TransportationOrderConfSts  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdSubcontractingSts AS _TranspOrdSubcontractingSts ON TranspOrderSubcontrgSts = _TranspOrdSubcontractingSts.TranspOrderSubcontrgSts  -- association [1..1]
LEFT OUTER JOIN I_TranspOrdWhseProcgStatus AS _TranspOrdWhseProcgStatus ON TranspOrdWhseProcessingStatus = _TranspOrdWhseProcgStatus.TranspOrdWhseProcessingStatus  -- association [1..1]
LEFT OUTER JOIN I_TranspOrdGoodsMvtStatus AS _TranspOrdGoodsMvtStatus ON TranspOrdGoodsMovementStatus = _TranspOrdGoodsMvtStatus.TranspOrdGoodsMovementStatus  -- association [1..1]
LEFT OUTER JOIN I_TranspOrdTrafficDirection AS _TranspOrdTrafficDirection ON TranspOrdTrafficDirection = _TranspOrdTrafficDirection.TranspOrdTrafficDirection  -- association [0..1]
LEFT OUTER JOIN I_MeansOfTransport AS _MeansOfTransport ON MeansOfTransport = _MeansOfTransport.MeansOfTransport  -- association [0..1]
LEFT OUTER JOIN I_TransportationMode_2 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_FrtDsputCaseStatus AS _FrtDsputCaseStatus ON FrtDsputCaseStatus = _FrtDsputCaseStatus.FrtDsputCaseStatus  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedBy ON CreatedByUser = _CreatedBy.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedBy ON LastChangedByUser = _LastChangedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _TranspOrdResponsiblePerson ON TranspOrdResponsiblePerson = _TranspOrdResponsiblePerson.UserID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdGrossWeightUnit ON TranspOrdGrossWeightUnit = _TranspOrdGrossWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdGrossVolumeUnit ON TranspOrdGrossVolumeUnit = _TranspOrdGrossVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdNetWeightUnit ON TranspOrdNetWeightUnit = _TranspOrdNetWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdQuantityUnit ON TranspOrdQuantityUnit = _TranspOrdQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdAlternativeQtyUnit ON TranspOrdAlternativeQtyUnit = _TranspOrdAlternativeQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdBaseQuantityUnit ON TranspOrdBaseQuantityUnit = _TranspOrdBaseQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdTareWeightUnit ON TranspOrdTareWeightUnit = _TranspOrdTareWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdNumberOfCtnsUnit ON TranspOrdNumberOfCtnsUnit = _TranspOrdNumberOfCtnsUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdDngrsGdsExmpPtsUnit ON TranspOrdDngrsGdsExmpPtsUnit = _TranspOrdDngrsGdsExmpPtsUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdPalletSpacesUnit ON TranspOrdPalletSpacesUnit = _TranspOrdPalletSpacesUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdLoadMetersUnit ON TranspOrdLoadMetersUnit = _TranspOrdLoadMetersUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_TransportationOrderSmmry AS _TranspOrdSummary ON TransportationOrderUUID = _TranspOrdSummary.TransportationOrderUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdErrHndlg AS _TranspOrdErrHndlg ON TransportationOrderUUID = _TranspOrdErrHndlg.TransportationOrderUUID  -- association [0..*]
;