I_TransportationCondition

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_TransportationCondition.
-- 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_TransportationCondition AS
SELECT
  cast(db_key as /scmtms/vdm_cond_db_key preserving type ) AS TransportationConditionUUID,
  condition_id AS TransportationCondition,
  cond_descr AS TransportationConditionDesc,
  condition_type AS TransportationConditionType,
  condition_origin AS TransportationConditionOrigin,
  created_by AS TranspConditionCreatedByUser,
  cast(created_on as log_created_on preserving type) AS TranspConditionCrtedOnDateTime,
  changed_by AS TranspConditionLastChgdByUser,
  cast(changed_on as log_created_on preserving type) AS TranspConditionChangedDateTime
FROM /scmtms/d_condde AS TransportationCondition
LEFT OUTER JOIN I_TranspConditionDataObj AS _TransportationCondDataObj ON TransportationConditionUUID = _TransportationCondDataObj.TransportationConditionUUID  -- association [0..*]
LEFT OUTER JOIN I_TransportationConditionDocn AS _TransportationConditionDocn ON TransportationConditionUUID = _TransportationConditionDocn.TransportationConditionUUID  -- association [0..*]
LEFT OUTER JOIN I_TranspConditionTypeText AS _TranspConditionTypeText ON TransportationConditionType = _TranspConditionTypeText.TransportationConditionType  -- association [1..*]
LEFT OUTER JOIN I_TransportationConditionType AS _TranspConditionType ON TransportationConditionType = _TranspConditionType.TransportationConditionType  -- association [1..1]
LEFT OUTER JOIN I_User AS _TranspConditionCreatedBy ON TranspConditionCreatedByUser = _TranspConditionCreatedBy.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _TranspConditionLastChangedBy ON TranspConditionLastChgdByUser = _TranspConditionLastChangedBy.UserID  -- association [0..1]
;