I_TransportationOrderAnalytics

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_TransportationOrderAnalytics.
-- 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_TransportationOrderAnalytics AS
SELECT
  TransportationOrderUUID,
  cast (TransportationOrder as /scmtms/vdm_tor_id preserving type) AS TransportationOrder,
  cast (TransportationOrderCategory as /scmtms/vdm_tor_category preserving type) AS TransportationOrderCategory,
  cast (TransportationOrderType as /scmtms/vdm_tor_type preserving type) AS TransportationOrderType,
  cast( cast(1 as abap.dec(10,0)) as /scmtms/vdm_num_tor preserving type) AS NumberOfTransportationOrders,
  CreatedByUser,
  cast(CreationDateTime as /scmtms/vdm_creation_datetme preserving type ) AS TranspOrdCreationDateTime,
  cast(cast(substring(cast(CreationDateTime as abap.char(17)), 1, 8) as abap.dats) as /scmtms/vdm_creation_date preserving type) AS TranspOrdCreationDate,
  LastChangedByUser,
  cast(ChangedDateTime as /scmtms/vdm_tm_tstmp_cht preserving type ) AS ChangedDateTime,
  cast(TranspOrdLfcycStsChgDteTime as /scmtms/vdm_lc_sts_chg_dttme_n preserving type ) AS TranspOrdLfcycStsChgDteTime,
  cast(TranspOrdOrderDateTime as /scmtms/vdm_tor_order_datetime preserving type) AS TranspOrdOrderDateTime,
  TranspOrdPartnerReference,
  cast (TranspOrdResponsiblePerson as /scmtms/vdm_tor_resp_person preserving type) AS TranspOrdResponsiblePerson,
  cast (DangerousGoodsAreContained as /scmtms/vdm_tor_dang_goods_ind preserving type) AS DangerousGoodsAreContained,
  TransportationServiceLevel,
  cast(TranspOrdPlanningBlock as /scmtms/vdm_block_planning preserving type) AS TranspOrdPlanningBlock,
  cast(TranspOrdExecutionIsBlocked as /scmtms/vdm_block_execution preserving type) AS TranspOrdExecutionIsBlocked,
  cast(InvoicingIsBlocked as /scmtms/vdm_block_invoicing preserving type) AS InvoicingIsBlocked,
  Carrier,
  cast(CarrierUUID as /scmtms/vdm_carrier_party_key preserving type ) AS CarrierUUID,
  cast(CarrierAddressID as /scmtms/vdm_carrier_address_id preserving type ) AS CarrierAddressID,
  cast(CarrierOriginOfEntry as /scmtms/vdm_carr_entry_origin preserving type ) AS CarrierOriginOfEntry,
  StandardCarrierAlphaCode,
  TranspOrdAirlineIATACode,
  cast(TranspOrdAirWayBill as /scmtms/vdm_airlcawb preserving type ) AS TranspOrdAirWayBill,
  cast(MasterBillOfLading as /scmtms/vdm_mbl_number preserving type ) AS MasterBillOfLading,
  Shipper,
  cast(ShipperUUID as /scmtms/vdm_shipper_party_key preserving type ) AS ShipperUUID,
  cast(ShipperAddressID as /scmtms/vdm_shipper_address_id preserving type ) AS ShipperAddressID,
  Consignee,
  cast(ConsigneeUUID as /scmtms/vdm_consignee_key preserving type ) AS ConsigneeUUID,
  cast(ConsigneeAddressID as /scmtms/vdm_consignee_addr_id preserving type ) AS ConsigneeAddressID,
  TranspOrdShippingType,
  MovementType,
  TranspOrdTrafficDirection,
  cast(_PlngAndExecOrganization.OrganizationalUnitExternalID as /scmtms/exec_org_ext_id preserving type) AS PlngAndExecOrgExternalID,
  cast(_PlngAndExecGroup.OrganizationalUnitExternalID as /scmtms/exec_grp_ext_id preserving type) AS PlngAndExecGroupExternalID,
  cast(PurchasingOrgExternalID as /scmb/pur_org_ext_id preserving type) AS PurchasingOrgExternalID,
  cast(PurchasingGroupExternalID as /scmb/egrp_org_ext_id preserving type) AS PurchasingGroupExternalID,
  cast(TranspOrdLifeCycleStatus as /scmtms/vdm_tor_lc_status preserving type) AS TranspOrdLifeCycleStatus,
  cast(TranspOrdPlanningStatus as /scmtms/vdm_tor_pln_status preserving type) AS TranspOrdPlanningStatus,
  cast(TransportationOrderExecSts as /scmtms/vdm_tor_exe_sts preserving type) AS TransportationOrderExecSts,
  cast(TranspOrderDngrsGdsSts as /scmtms/vdm_tor_dg_status preserving type) AS TranspOrderDngrsGdsSts,
  TranspOrderSubcontrgSts,
  TransportationOrderConfSts,
  cast(TranspOrdGoodsMovementStatus as /scmtms/vdm_dlv_goods_mvt_sts preserving type) AS TranspOrdGoodsMovementStatus,
  cast(TranspOrdWhseProcessingStatus as /scmtms/vdm_wh_procg_status preserving type) AS TranspOrdWhseProcessingStatus,
  BusinessTransactionDocument,
  BusinessTransactionDocType,
  TransportationRequestCategory,
  cast(MeansOfTransport as /scmtms/vdm_tor_mot preserving type) AS MeansOfTransport,
  cast(TransportationMode as /scmtms/vdm_tor_trmodcode preserving type) AS TransportationMode,
  cast(TransportationModeCategory as /scmtms/vdm_tor_trmod_cat preserving type) AS TransportationModeCategory,
  cast(FrtDsputCaseStatus as /scmtms/vdm_inv_disp_status preserving type) AS FrtDsputCaseStatus,
  TranspOrdMaxUtilznRatio,
  cast(TranspOrdMaxUtilznMassRatio as /scmtms/vdm_tor_max_util_mass preserving type) AS TranspOrdMaxUtilznMassRatio,
  cast(TranspOrdMaxUtilznVolumeRatio as /scmtms/vdm_max_util_volume preserving type) AS TranspOrdMaxUtilznVolumeRatio,
  cast(TranspOrdMaxUtilznLengthRatio as /scmtms/vdm_max_util_length preserving type) AS TranspOrdMaxUtilznLengthRatio,
  cast(cast('%' as abap.unit(3)) as /scmtms/vdm_util_percent_unit preserving type) AS TranspOrdUtilznUnit,
  cast(TranspOrdGrossWeight as /scmtms/vdm_tor_gro_wei_val preserving type ) AS TranspOrdGrossWeight,
  TranspOrdGrossWeightUnit,
  cast(TranspOrdGrossVolume as /scmtms/vdm_tor_gro_vol_val preserving type) AS TranspOrdGrossVolume,
  TranspOrdGrossVolumeUnit,
  cast(TranspOrdNetWeight as /scmtms/vdm_tor_net_wei_val preserving type) AS TranspOrdNetWeight,
  TranspOrdNetWeightUnit,
  cast(TranspOrdTareWeight as /scmtms/vdm_tor_pack_unl_wei_v preserving type) AS TranspOrdTareWeight,
  TranspOrdTareWeightUnit,
  cast(TranspOrdQuantity as /scmtms/vdm_tor_pcs_val preserving type) AS TranspOrdQuantity,
  TranspOrdQuantityUnit,
  cast(TranspOrdNumberOfCtns as /scmtms/vdm_tor_cont_count_val preserving type) AS TranspOrdNumberOfCtns,
  TranspOrdNumberOfCtnsUnit,
  cast(TranspOrdDngrsGdsExmpPts as /scmtms/vdm_tor_dg_adr_pts_val preserving type) AS TranspOrdDngrsGdsExmpPts,
  TranspOrdDngrsGdsExmpPtsUnit,
  cast(TranspOrdDistance as /scmtms/vdm_total_distance_km) AS TranspOrdDistance,
  cast(TranspOrdDistanceUnit as /scmtms/vdm_tor_dstnc_unit preserving type) AS TranspOrdDistanceUnit,
  cast (TranspOrdNetDuration as /scmtms/vdm_tor_net_duration preserving type) AS TranspOrdNetDuration
FROM I_TransportationOrder
LEFT OUTER JOIN I_TranspOrdItemAnalytics AS _TranspOrdItemAnalytics ON TransportationOrderUUID = _TranspOrdItemAnalytics.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_TranspOrdStopAnalytics AS _TranspOrdStopAnalytics ON TransportationOrderUUID = _TranspOrdStopAnalytics.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_TranspOrdStageAnalytics AS _TranspOrdStageAnalytics ON TransportationOrderUUID = _TranspOrdStageAnalytics.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_TranspOrdExecutionAnalytics AS _TranspOrdExecutionAnalytics ON TransportationOrderUUID = _TranspOrdExecutionAnalytics.TransportationOrderUUID  -- association [0..*]
;