GEN_RESULT_SET_W_O_MEM_COUNT

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 GEN_RESULT_SET_W_O_MEM_COUNT.
-- 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 GEN_RESULT_SET_W_O_MEM_COUNT AS
SELECT
  gres_d_rs_root.db_key AS DB_KEY,
  gres_d_rs_root.appl_id AS APPL_ID,
  gres_d_rs_root.rs_id AS RS_ID,
  gres_d_rs_root.ot_id AS OT_ID,
  gres_d_rs_root.category AS CATEGORY,
  gres_d_rs_root.name AS NAME,
  gres_d_rs_root.version AS VERSION,
  gres_d_rs_root.crea_date_time AS CREA_DATE_TIME,
  gres_d_rs_root.crea_uname AS CREA_UNAME,
  gres_d_rs_root.lchg_date_time AS LCHG_DATE_TIME,
  gres_d_rs_root.lchg_uname AS LCHG_UNAME,
  gres_d_rs_root.origin_root_guid AS ORIGIN_ROOT_GUID,
  gres_d_rs_root.origin_element_guid AS ORIGIN_ELEMENT_GUID,
  gseg_obj_type_t.ot_text AS OT_ID_T_INT,
  gres_d_rs_root.origin_type AS ORIGIN_TYPE,
  gseg_d_segment.id AS SEGMENT_ID,
  adrp.name_text AS CREA_ADRP_INT,
  adrp_2.name_text AS LCHG_ADRP_INT,
  gseg_nr_appl.nr_appl_id AS NR_APPL_ID,
  gseg_d_sm_root.name AS SEG_MODEL_NAME,
  gres_d_rs_root.member_count AS MEMBER_COUNT,
  gres_d_rs_root.foreign_member_type AS FOREIGN_MEMBER_TYPE,
  dd07t.ddtext AS CATEGORY_T,
  dd07t_2.ddtext AS ORIGIN_TYPE_T,
  case when gseg_obj_type_t.ot_text is null then gres_d_rs_root.ot_id else case when gseg_obj_type_t.ot_text = '' then gres_d_rs_root.ot_id else gseg_obj_type_t.ot_text end end as OT_ID_TEXT AS ot_textendendasOT_ID_TEXT,
  case when adrp.name_text is null then gres_d_rs_root.crea_uname else case when adrp.name_text = '' then gres_d_rs_root.crea_uname else adrp.name_text end end as CREA_UNAME_TEXT AS name_textendendasCREA_UNAME_TEXT,
  case when adrp_2.name_text is null then gres_d_rs_root.lchg_uname else case when adrp_2.name_text = '' then gres_d_rs_root.lchg_uname else adrp_2.name_text end end as LCHG_UNAME_TEXT AS name_textendendasLCHG_UNAME_TEXT,
  concat( 'M', concat(gseg_nr_appl.nr_appl_id, gres_d_rs_root.ot_id)) AS ENTITY_NAME_MEMBER,
  concat( 'O', concat(gseg_nr_appl.nr_appl_id, gres_d_rs_root.ot_id)) AS ENTITY_NAME_OBJECT
FROM gres_d_rs_root
LEFT OUTER JOIN gseg_obj_type_t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS dd07t_2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gseg_d_segment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gseg_nr_appl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gseg_d_sm_root ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr21 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr21 AS usr21_2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp AS adrp_2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS usr21 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS usr21_2 ON /* join condition not captured in parsed metadata */
;