I_TranspOrdExecution

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_TranspOrdExecution.
-- 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_TranspOrdExecution AS
SELECT
  db_key AS TransportationOrderEventUUID,
  cast(parent_key as /scmtms/vdm_tor_db_key preserving type) AS TransportationOrderUUID,
  cast(execution_id as /scmtms/vdm_execution_id preserving type) AS TranspOrdExecution,
  torstopuuid AS TransportationOrderStopUUID,
  toritmuuid AS TransportationOrderItemUUID,
  created_by AS CreatedByUser,
  cast(created_on as /scmtms/vdm_tm_tstmp_crt preserving type) AS CreationDateTime,
  changed_by AS LastChangedByUser,
  cast(changed_on as /scmtms/vdm_tm_tstmp_cht preserving type) AS ChangedDateTime,
  event_code AS TranspOrdEventCode,
  event_status AS TranspOrdEventStatus,
  trans_activity AS TransportationActivity,
  cast(event_revoked as /scmtms/event_revoked preserving type) AS TranspOrdEventIsRecalled,
  event_reason_code AS TranspOrdEventReasonCode,
  event_reason AS TranspOrdEventReasonDesc,
  cast(execinfo_source as /scmtms/execinfo_source preserving type) AS TranspOrdExecInfoSource,
  ref_event_code AS TranspOrdReferenceEventCode,
  cast(actual_date as /scmtms/vdm_event_actl_dtetme preserving type) AS TranspOrdEvtActualDateTime,
  cast(actual_tzone as /scmtms/vdm_actual_timezone preserving type) AS TranspOrdEvtActualDateTimeZone,
  cast(exp_end_date as /scmtms/vdm_expd_end_datetime preserving type) AS TranspOrdEvtExpdEndDateTime,
  cast(estimated_date as /scmtms/vdm_estimated_datetime preserving type) AS TranspOrdEvtEstimatedDateTime,
  cast (ext_loc_uuid as /scmtms/vdm_location_adtl_uuid preserving type) AS LocationAdditionalUUID,
  cast (_LocationAdditional.LocationUUID as /scmtms/vdm_location_uuid preserving type) AS LocationUUID,
  geolat AS GeographicalLocationLatitude,
  geolon AS GeographicalLocationLongitude,
  geoalt AS GeographicalLocationAltitude,
  qty_discrepancy AS TranspOrdHasQtyDiscrepancy,
  discrepancy AS TranspOrdIsDiscrepant,
  discr_type AS DiscrepancyType,
  discr_no_block AS TranspOrdIsDscrptWthoutBlk,
  discr_inside_tlr AS TranspOrdIsDiscrepantWithinTol,
  dsc_subcat AS TranspOrdExecDscrcySubCat,
  cast(gro_wei_val as /scmtms/vdm_exec_grss_wgt preserving type) AS TranspOrdExecGrossWeight,
  cast(gro_wei_uni as /scmtms/vdm_exec_grss_wgt_unit preserving type) AS TranspOrdExecGrossWeightUnit,
  cast(gro_vol_val as /scmtms/vdm_exec_grss_vol preserving type) AS TranspOrdExecGrossVolume,
  cast(gro_vol_uni as /scmtms/vdm_exec_grss_vol_unit preserving type) AS TranspOrdExecGrossVolumeUnit,
  cast(net_wei_val as /scmtms/vdm_exec_net_wgt preserving type) AS TranspOrdExecNetWeight,
  cast(net_wei_uni as /scmtms/vdm_exec_net_wgt_unit preserving type) AS TranspOrdExecNetWeightUnit,
  cast(qua_pcs_val as /scmtms/vdm_exec_qty preserving type) AS TranspOrdExecQuantity,
  cast(qua_pcs_uni as /scmtms/vdm_exec_qty_unit preserving type) AS TranspOrdExecQuantityUnit,
  cast(qua_pcs2_val as /scmtms/vdm_exec_qty_altv preserving type) AS TranspOrdExecAltvQty,
  cast(qua_pcs2_uni as /scmtms/vdm_exec_qty_altv_unit preserving type) AS TranspOrdExecAltvQtyUnit,
  cast(base_uom_val as /scmtms/vdm_exec_qty_base preserving type) AS TranspOrdExecBaseQty,
  cast(base_uom_uni as /scmtms/vdm_exec_qty_base_unit preserving type) AS TranspOrdExecBaseQtyUnit,
  cast(pkgun_wei_val as /scmtms/vdm_exec_tare_wgt preserving type) AS TranspOrdExecTareWeight,
  cast(pkgun_wei_uni as /scmtms/vdm_exec_tare_wgt_unit preserving type) AS TranspOrdExecTareWeightUnit,
  cast(cont_cnt_val as /scmtms/vdm_exec_ctn_nmbr preserving type) AS TranspOrdExecNumberOfCtns,
  cast(cont_cnt_uni as /scmtms/vdm_exec_ctn_nmbr_unit preserving type) AS TranspOrdExecNumberOfCtnsUnit,
  cast(dg_adr_pts_val as /scmtms/vdm_dngrsgd_exmpp preserving type) AS TranspOrdExecDngrsGdsExmpp,
  cast(dg_adr_pts_uni as /scmtms/vdm_dngrsgd_exmpp_unit preserving type) AS TranspOrdExecDngrsGdsExmppUnit,
  slac_val AS ShippersLoadAndCountQuantity,
  cast(length as /scmtms/vdm_exec_length preserving type) AS TranspOrdExecLength,
  cast(width as /scmtms/vdm_exec_width preserving type) AS TranspOrdExecWidth,
  cast(height as /scmtms/vdm_exec_height preserving type) AS TranspOrdExecHeight,
  cast(measuom as /scmtms/vdm_exec_length_unit preserving type) AS TranspOrdExecLengthUnit,
  cast (net_duration as /scmtms/vdm_net_duration) AS TranspOrdExecutionNetDuration,
  recording_method AS TranspOrdExecRecordingMethod,
  recording_person AS TranspOrdExecPersnRespRecg,
  cast(exec_role_cat as /scmtms/vdm_partner_function preserving type ) AS TranspOrdExecPartnerFunction
FROM /scmtms/d_torexe
LEFT OUTER JOIN I_TransportationOrder AS _TransportationOrder ON TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationOrderItem AS _TransportationOrderItem ON TransportationOrderItemUUID = _TransportationOrderItem.TransportationOrderItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TransportationOrderStop AS _TransportationOrderStop ON TransportationOrderStopUUID = _TransportationOrderStop.TransportationOrderStopUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdEventCode AS _TranspOrdEventCode ON TranspOrdEventCode = _TranspOrdEventCode.TranspOrdEventCode  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdEventCode AS _TranspOrdReferenceEventCode ON TranspOrdReferenceEventCode = _TranspOrdReferenceEventCode.TranspOrdEventCode  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdEventStatus AS _TranspOrdEventStatus ON TranspOrdEventStatus = _TranspOrdEventStatus.TranspOrdEventStatus  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdHasQtyDiscrepancy AS _TranspOrdHasQtyDiscrepancy ON TranspOrdHasQtyDiscrepancy = _TranspOrdHasQtyDiscrepancy.TranspOrdHasQtyDiscrepancy  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdIsDiscrepant AS _TranspOrdIsDiscrepant ON TranspOrdIsDiscrepant = _TranspOrdIsDiscrepant.TranspOrdIsDiscrepant  -- association [0..1]
LEFT OUTER JOIN I_DiscrepancyType AS _DiscrepancyType ON DiscrepancyType = _DiscrepancyType.DiscrepancyType  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdIsDscrptWthoutBlk AS _TranspOrdIsDscrptWthoutBlk ON TranspOrdIsDscrptWthoutBlk = _TranspOrdIsDscrptWthoutBlk.TranspOrdIsDscrptWthoutBlk  -- association [0..1]
LEFT OUTER JOIN I_TranspExecDscrcySubCat AS _TranspExecDscrcySubCat ON TranspOrdExecDscrcySubCat = _TranspExecDscrcySubCat.TranspOrdExecDscrcySubCat  -- association [0..1]
LEFT OUTER JOIN I_TransportationActivity AS _TransportationActivity ON TransportationActivity = _TransportationActivity.TransportationActivity  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdEventIsRecalled AS _TranspOrdEventIsRecalled ON TranspOrdEventIsRecalled = _TranspOrdEventIsRecalled.TranspOrdEventIsRecalled  -- association [0..1]
LEFT OUTER JOIN I_LocationBasic AS _LocationAdditional ON LocationAdditionalUUID = _LocationAdditional.LocationAdditionalUUID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdExecGrossWeightUnit ON TranspOrdExecGrossWeightUnit = _TranspOrdExecGrossWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdExecGrossVolumeUnit ON TranspOrdExecGrossVolumeUnit = _TranspOrdExecGrossVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdExecNetWeightUnit ON TranspOrdExecNetWeightUnit = _TranspOrdExecNetWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdExecQuantityUnit ON TranspOrdExecQuantityUnit = _TranspOrdExecQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdExecAltvQtyUnit ON TranspOrdExecAltvQtyUnit = _TranspOrdExecAltvQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdExecBaseQtyUnit ON TranspOrdExecBaseQtyUnit = _TranspOrdExecBaseQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdExecTareWeightUnit ON TranspOrdExecTareWeightUnit = _TranspOrdExecTareWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdExecNumberOfCtnsUnit ON TranspOrdExecNumberOfCtnsUnit = _TranspOrdExecNumberOfCtnsUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdExecDngrsGdsExmppUoM ON TranspOrdExecDngrsGdsExmppUnit = _TranspOrdExecDngrsGdsExmppUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdExecLengthUnit ON TranspOrdExecLengthUnit = _TranspOrdExecLengthUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdExecInfoSource AS _TranspOrdExecInfoSource ON TranspOrdExecInfoSource = _TranspOrdExecInfoSource.TranspOrdExecInfoSource  -- association [0..1]
;