ESH_N_COST_CENTER_GRP_ER_GROUP

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 ESH_N_COST_CENTER_GRP_ER_GROUP.
-- 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: ESH_L_COST_CGRU

CREATE VIEW ESH_N_COST_CENTER_GRP_ER_GROUP AS
SELECT
  setclass,
  subclass,
  setname,
  settype,
  xdynamic,
  authgr,
  xuniq,
  rvalue,
  creuser,
  credate,
  cretime,
  upduser,
  upddate,
  updtime,
  saprl,
  tabname,
  fieldname,
  rollname,
  set_olangu,
  no_rwsheader,
  no_rwsline,
  no_setlinet
FROM setheader
LEFT OUTER JOIN setnode AS _TO_CHILD_GROUP ON setclass = _TO_CHILD_GROUP.setclass AND subclass = _TO_CHILD_GROUP.subclass AND setname = _TO_CHILD_GROUP.setname  -- association [0..*]
LEFT OUTER JOIN setnode AS _TO_PARENT_GROUP ON setclass = _TO_PARENT_GROUP.subsetcls AND subclass = _TO_PARENT_GROUP.subsetscls AND setname = _TO_PARENT_GROUP.subsetname  -- association [0..*]
LEFT OUTER JOIN setheadert AS _TO_COST_CENTER_GROUP_T ON setclass = _TO_COST_CENTER_GROUP_T.setclass AND subclass = _TO_COST_CENTER_GROUP_T.subclass AND setname = _TO_COST_CENTER_GROUP_T.setname  -- association [0..*]
LEFT OUTER JOIN cskt AS _COST_CENTER_GROUP2CSKT ON subclass = _COST_CENTER_GROUP2CSKT.kokrs AND rvalue = _COST_CENTER_GROUP2CSKT.kostl  -- association [0..*]
LEFT OUTER JOIN tka01 AS _SETHEADER2TKA01 ON subclass = _SETHEADER2TKA01.kokrs  -- association [1..1]
LEFT OUTER JOIN ESH_N_USER_USER AS _SETHEADER2USER ON creuser = _SETHEADER2USER.bname  -- association [1..1]
;