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 CreatedByUser,
  cast(created_on as log_created_on preserving type) AS CreationDateTime,
  changed_by AS LastChangedByUser,
  cast(changed_on as log_created_on preserving type) AS ChangedDateTime
FROM /scmtms/d_condde AS TransportationCondition
LEFT OUTER JOIN I_TransportationConditionType AS _TranspConditionType ON TransportationConditionType = _TranspConditionType.TransportationConditionType  -- association [1..1]
LEFT OUTER JOIN I_User AS _TranspConditionCreatedBy ON CreatedByUser = _TranspConditionCreatedBy.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _TranspConditionLastChangedBy ON LastChangedByUser = _TranspConditionLastChangedBy.UserID  -- association [0..1]
;