ESH_S_COST_CENTER_GRP

DDL: ESH_S_COST_CENTER_GRP SQL: ESH_U_COST_C_GRP Type: view

Cost Center Groups

ESH_S_COST_CENTER_GRP is a CDS View that provides data about "Cost Center Groups" in SAP S/4HANA. It reads from 1 data source (ESH_N_COST_CENTER_GRP_ER_GROUP) and exposes 34 fields.

Data Sources (1)

SourceAliasJoin Type
ESH_N_COST_CENTER_GRP_ER_GROUP ESH_N_COST_CENTER_GRP_ER_GROUP from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ESH_U_COST_C_GRP view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
AbapCatalog.compiler.compareFilter true view
Metadata.allowExtensions true view
EndUserText.label Cost Center Groups view
Consumption.semanticObject CostCenterGroup view
Search.searchable true view
EnterpriseSearch.enabled true view
UI.headerInfo.title.value DESCRIPT view

Fields (34)

KeyFieldSource TableSource FieldDescription
setclass setclass Set Class
subclass subclass Controllig Area
setname setname Cost Center Group
settype settype Set Type
xdynamic xdynamic Dynamic Set
authgr authgr Authorization Group
xuniq xuniq Specific Account?
rvalue rvalue Representative Cost Center
creuser creuser Author
credate credate Created on
cretime cretime Time
upduser upduser Changed By
upddate upddate Current Date
updtime updtime Updated At
saprl saprl SAP Release
tabname tabname Table/Constant Value
fieldname fieldname UI Group FieldName
rollname rollname Repr. Data Elem
set_olangu set_olangu Original Lang.
no_rwsheader no_rwsheader No Entries Exist in Table RWSHEADER for This Set
no_rwsline no_rwsline No Entries Exist in Table RWSLINE for This Set
no_setlinet no_setlinet No Entries Exist in Table SETLINET for This Set
descript Description
waers _SETHEADER2TKA01 waers Transaction Currency
bezei _SETHEADER2TKA01 bezei Controllig Area
ktext Representative Cost Center
name_text Created by
SETCLASS_PARENT _TO_PARENT_GROUP setclass Set Class
SETCLASS_CHILD _TO_CHILD_GROUP setclass Set Class
kostl
SUBCLASS_PARENT _TO_PARENT_GROUP subclass Subclass
SUBCLASS_CHILD _TO_CHILD_GROUP subclass Subclass
SETNAME_PARENT _TO_PARENT_GROUP setname Set Name
SETNAME_CHILD _TO_CHILD_GROUP setname Set Name

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_S_COST_CENTER_GRP.
-- 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_U_COST_C_GRP
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_COST_CENTER_GRP 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,
  _TO_COST_CENTER_GROUP_T[ 1: langu = $parameters.P_Language ].descript AS descript,
  _SETHEADER2TKA01.waers AS waers,
  _SETHEADER2TKA01.bezei AS bezei,
  _COST_CENTER_GROUP2CSKT[ 1: spras = $parameters.P_Language ].ktext AS ktext,
  _SETHEADER2USER._TO_USER_NAME.name_text AS name_text,
  _TO_PARENT_GROUP.setclass AS SETCLASS_PARENT,
  _TO_CHILD_GROUP.setclass AS SETCLASS_CHILD,
  _COST_CENTER_GROUP2CSKT[ 1: spras = $parameters.P_Language ].kostl AS kostl,
  _TO_PARENT_GROUP.subclass AS SUBCLASS_PARENT,
  _TO_CHILD_GROUP.subclass AS SUBCLASS_CHILD,
  _TO_PARENT_GROUP.setname AS SETNAME_PARENT,
  _TO_CHILD_GROUP.setname AS SETNAME_CHILD
FROM ESH_N_COST_CENTER_GRP_ER_GROUP
;