I_TranspOrdStopAnalytics

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_TranspOrdStopAnalytics.
-- 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_TranspOrdStopAnalytics AS
SELECT
  cast(TransportationOrderStopUUID as /scmtms/vdm_tor_stop_db_key preserving type ) AS TransportationOrderStopUUID,
  TransportationOrderUUID,
  cast(TranspOrdStopStopParentUUID as /scmtms/vdm_tor_stp_stp_p_uuid preserving type) AS TranspOrdStopStopParentUUID,
  cast(TranspOrdCapacityStopUUID as /scmtms/vdm_tor_stp_cp_stp_key preserving type) AS TranspOrdCapacityStopUUID,
  cast(TranspOrdStopCapacityItemUUID as /scmtms/vdm_tor_stp_cp_itm_key preserving type) AS TranspOrdStopCapacityItemUUID,
  cast(TransportationOrderStop as /scmtms/vdm_tor_stop_id preserving type ) AS TransportationOrderStop,
  TranspOrdStopCategory,
  TranspOrdStopRole,
  TranspOrdStopSequencePosition,
  TranspOrdStopIsEntryPort,
  TranspOrdStopIsExitPort,
  cast(TranspOrdStopHndlgExecStatus as /scmtms/vdm_tor_stp_hdl_exe_st preserving type) AS TranspOrdStopHndlgExecStatus,
  cast(LocationUUID as /scmtms/vdm_tor_stp_loc_uuid preserving type) AS TranspOrdStopLocationUUID,
  cast(LocationAdditionalUUID as /scmtms/vdm_tor_stp_loc_a_uuid preserving type) AS TranspOrdStopLocationAddlUUID,
  cast(LocationId as /scmtms/vdm_tor_stp_loc_id preserving type) AS TranspOrdStopLocation,
  cast(TranspOrdStopLocUNCode as /scmtms/vdm_tor_stp_loc_un_cd preserving type) AS TranspOrdStopLocUNCode,
  cast(TranspOrdStopLocIATACode as /scmtms/vdm_tor_stp_loc_iata preserving type) AS TranspOrdStopLocIATACode,
  cast(TranspOrdStopAccptblStrtDteTme as /scmtms/vdm_tor_stp_acc_st_d_t preserving type) AS TranspOrdStopAccptblStrtDteTme,
  cast(TranspOrdStopAccptblEndDteTme as /scmtms/vdm_tor_stp_acc_en_d_t preserving type) AS TranspOrdStopAccptblEndDteTme,
  cast(TranspOrdStopReqStartDteTme as /scmtms/vdm_tor_stp_req_st_d_t preserving type) AS TranspOrdStopReqStartDteTme,
  cast(TranspOrdStopReqEndDteTme as /scmtms/vdm_tor_stp_req_en_d_t preserving type) AS TranspOrdStopReqEndDteTme,
  cast(TranspOrdStopPlanTranspDteTme as /scmtms/vdm_tor_stp_pln_tr_d_t preserving type) AS TranspOrdStopPlanTranspDteTme,
  cast(TranspOrdStopPlanExecDteTme as /scmtms/vdm_tor_stp_pln_ex_d_t preserving type) AS TranspOrdStopPlanExecDteTme,
  cast(TranspOrdStopLoadStartDateTime as /scmtms/vdm_tor_stp_load_s_dt preserving type) AS TranspOrdStopLoadStartDateTime,
  cast(TranspOrdStopLoadEndDateTime as /scmtms/vdm_tor_stp_load_e_dt preserving type) AS TranspOrdStopLoadEndDateTime,
  cast(TranspOrdStopCoupleStrtDteTme as /scmtms/vdm_tor_stp_coupl_s_dt preserving type) AS TranspOrdStopCoupleStrtDteTme,
  cast(TranspOrdStopCoupleEndDteTme as /scmtms/vdm_tor_stp_coupl_e_dt preserving type) AS TranspOrdStopCoupleEndDteTme,
  cast(TranspOrdStopCapPlngStrtDteTme as /scmtms/vdm_tor_stp_cp_pl_s_dt preserving type) AS TranspOrdStopCapPlngStrtDteTme,
  cast(TranspOrdStopCapPlngEndDteTme as /scmtms/vdm_tor_stp_cp_pl_e_dt preserving type) AS TranspOrdStopCapPlngEndDteTme,
  cast(TranspOrdStopApptStrtDteTme as /scmtms/vdm_tor_stp_appt_s_dt preserving type) AS TranspOrdStopApptStrtDteTme,
  cast(TranspOrdStopApptEndDteTme as /scmtms/vdm_tor_stp_appt_e_dt preserving type) AS TranspOrdStopApptEndDteTme,
  cast(TranspOrdStopPrepStrtDteTme as /scmtms/vdm_tor_stp_prep_s_dt preserving type) AS TranspOrdStopPrepStrtDteTme,
  cast(TranspOrdStopPrepEndDteTme as /scmtms/vdm_tor_stp_prep_e_dt preserving type) AS TranspOrdStopPrepEndDteTme,
  cast(TranspStopFinalizeStrtDteTme as /scmtms/vdm_tor_stp_final_s_dt preserving type) AS TranspStopFinalizeStrtDteTme,
  cast(TranspStopFinalizeEndDteTme as /scmtms/vdm_tor_stp_final_e_dt preserving type) AS TranspStopFinalizeEndDteTme,
  cast(TranspStopCarrConfStrtDteTme as /scmtms/vdm_tor_stp_ca_co_s_dt preserving type) AS TranspStopCarrConfStrtDteTme,
  cast(TranspStopCarrConfEndDteTme as /scmtms/vdm_tor_stp_ca_co_e_dt preserving type) AS TranspStopCarrConfEndDteTme,
  cast(TranspOrdStopDteTme as /scmtms/vdm_tor_stop_datetime preserving type) AS TranspOrdStopDteTme
FROM I_TransportationOrderStop
LEFT OUTER JOIN I_TransportationOrderAnalytics AS _TransportationOrderAnalytics ON TransportationOrderUUID = _TransportationOrderAnalytics.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_TranspOrdExecutionAnalytics AS _TranspOrdExecutionAnalytics ON TransportationOrderStopUUID = _TranspOrdExecutionAnalytics.TransportationOrderStopUUID  -- association [0..*]
LEFT OUTER JOIN I_LocationAnalytics AS _LocationAnalytics ON TranspOrdStopLocation = _LocationAnalytics.Location  -- association [0..1]
;