Coll_Rsm_Attr

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 Coll_Rsm_Attr.
-- 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: V_COLL_RSM_ATTR
-- Parameters: language : abap.lang

CREATE VIEW Coll_Rsm_Attr AS
SELECT
  rsm_guid,
  customer,
  coll_segment,
  rsm_date,
  cast(rsm_time as tzntstmps) AS rsm_time,
  rsm_xbypass,
  rsm_reason,
  rsm_status,
  created_by,
  cast(created_at as tzntstmps) AS created_at,
  changed_by,
  cast(changed_at as tzntstmps) AS changed_at,
  substring(objkey, 1, 4) AS comp_code,
  cast(substring(objkey, 15, 4) as gjahr ) AS fiscal_year,
  cast(substring(objkey, 19, 3) as buzei ) AS doc_item
FROM udm_rsm_attr AS rsm
LEFT OUTER JOIN udm_rsm_reasont AS reasont ON /* join condition not captured in parsed metadata */
;