I_TransportationOrderStage

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_TransportationOrderStage.
-- 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_TransportationOrderStage AS
SELECT
  db_key AS TransportationOrderStageUUID,
  cast(root_key as /scmtms/vdm_tor_db_key preserving type) AS TransportationOrderUUID,
  parent_key AS TranspOrdStageSrceStopUUID,
  succ_stop_key AS TranspOrdStageDestStopUUID,
  successor_id AS TransportationOrderStage,
  stop_succ_cat AS TranspOrdStageDestStopCategory,
  stage_type AS TranspOrdStageType,
  stage_cat AS TranspOrdStageCategory,
  cast(plan_status as char1 preserving type) AS TranspOrdStagePlnStatus,
  cast('KM' as /scmtms/vdm_stage_dstnc_unit) AS TranspOrdStageDistanceUnit,
  cast(distance_km as /scmtms/vdm_stage_dstnc preserving type) AS TranspOrdStageDistance,
  cast(duration_net as bapi11201trmdurat preserving type ) AS TranspOrdStageNetDuration,
  mtr_tco AS MeansOfTransport,
  mot AS TransportationMode,
  mot_cat AS TransportationModeCategory,
  cast(tsp_key as bu_partner_guid) AS CarrierUUID,
  tsp_id AS Carrier,
  tsp_scac AS TranspOrdStageSCACCode,
  tsp_airlc AS TranspOrdStageAirlineIATACode,
  tsp_airlcawb AS TranspOrdStageAirWayBill,
  voyage_id AS TranspOrdStageVoyage,
  flight_code AS TranspOrdStageFlight,
  vessel_id AS TranspOrdStageVessel,
  imo_id AS TranspOrdStageIMOShip,
  cast(_Carrier.IsBusinessPurposeCompleted as /scmtms/vdm_carrier_xpcpt preserving type) AS CarrierBusPurposeIsCompleted,
  cast(max_util as /scmtms/vdm_stage_util_max preserving type) AS TranspOrdStageMaxUtilznRatio,
  cast(util_mass as /scmtms/vdm_stage_util_mass preserving type) AS TranspOrdStageUtilznMassRatio,
  cast(util_volume as /scmtms/vdm_stage_util_volume preserving type) AS TranspOrdStageUtilznVolRatio,
  cast(util_length as /scmtms/vdm_stage_util_length preserving type) AS TranspOrdStageUtilznLenRatio,
  cast(util_dimless as /scmtms/vdm_stage_util_dimless preserving type) AS TranspOrdStageUtilznQtyRatio,
  payer_company_code AS RequestingCompanyCode,
  shipping_type AS TranspOrdStageShippingType,
  stg_pymt_ind AS TranspOrdStgeInvcgCarrLvl,
  tsp_pymt_id AS TranspOrdStageInvoicingCarrier,
  cast (tsp_pymt_key as /scmtms/vdm_inv_carr_uuid) AS TranspOrdStgeInvcgCarrUUID,
  tsp_pymt_scac AS TranspOrdStgeInvcgSCACCode
FROM /scmtms/d_torsts
LEFT OUTER JOIN I_TransportationOrder AS _TransportationOrder ON TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationOrderStop AS _TranspOrdStageSrceStop ON TranspOrdStageSrceStopUUID = _TranspOrdStageSrceStop.TransportationOrderStopUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationOrderStop AS _TranspOrdStageDestStop ON TranspOrdStageDestStopUUID = _TranspOrdStageDestStop.TransportationOrderStopUUID  -- association [1..1]
LEFT OUTER JOIN I_TranspOrdStageType AS _TranspOrdStageType ON TranspOrdStageType = _TranspOrdStageType.TranspOrdStageType  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdStageCategory AS _TranspOrdStageCategory ON TranspOrdStageCategory = _TranspOrdStageCategory.TranspOrdStageCategory  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Carrier ON Carrier = _Carrier.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _TranspOrdStageInvoicingCarr ON TranspOrdStageInvoicingCarrier = _TranspOrdStageInvoicingCarr.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_TranspSCACCode AS _TranspSCACCode ON TranspOrdStageSCACCode = _TranspSCACCode.TranspSCACCode  -- association [0..1]
LEFT OUTER JOIN I_TranspSCACCode AS _TranspOrdStgeInvcgSCACCode ON TranspOrdStgeInvcgSCACCode = _TranspOrdStgeInvcgSCACCode.TranspSCACCode  -- association [0..1]
LEFT OUTER JOIN I_TranspAirlineIATACode AS _TranspAirlineIATACode ON TranspOrdStageAirlineIATACode = _TranspAirlineIATACode.TranspAirlineIATACode  -- 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_TranspOrdStagePlnStatus AS _TranspOrdStagePlnStatus ON TranspOrdStagePlnStatus = _TranspOrdStagePlnStatus.TranspOrdStagePlnStatus  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _RequestingCompanyCode ON RequestingCompanyCode = _RequestingCompanyCode.CompanyCode  -- association [0..1]
;