/trp/Cds_Ppe_Queue

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 /trp/Cds_Ppe_Queue.
-- 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.
-- SQL view name: /TRP/CDS_PPE_Q

CREATE VIEW /trp/Cds_Ppe_Queue AS
SELECT
  TU1.run_id AS RunId,
  TU1.tu_id AS TransportationUnit,
  mandt AS client,
  TU1.rule_id AS RuleId,
  TU1.start_time AS starttime,
  created_on AS createdon,
  created_by AS createdby,
  status,
  grp_exec_id AS GroupExecutionID,
  rule_name AS RuleName,
  user_id AS userId,
  before_loc_no AS BeforeLoc,
  new_loc_no AS NewLoc,
  trq_id AS TRQID,
  RP,
  before_time AS BeforeTime,
  new_time AS NewTime,
  TU_UUID,
  TR_TU_UUID,
  updated_on AS UPDATEDON,
  updated_by AS UPDATEDby
FROM /trp/tu_staging AS TU1
LEFT OUTER JOIN /trp/Cds_Ppe_Queue_Recent AS _TU2 ON TU1.tu_id = _TU2.tu_id AND TU1.rule_id = _TU2.rule_id AND TU1.start_time = _TU2.start_time  -- association [1]
LEFT OUTER JOIN /trp/Cds_Ppe_Res_Staging AS _Resource ON TU1.run_id = _Resource.run_id AND TU1.tu_id = _Resource.tu_id  -- association [1]
;