ESH_N_ACTIVITY_TYPE_CSSL

DDL: ESH_N_ACTIVITY_TYPE_CSSL SQL: ESH_L_ACTIV_CSSL Type: view
12 Fields 1 Data Sources 1 Associations

Cost Center/Activity Type

ESH_N_ACTIVITY_TYPE_CSSL is a CDS View that provides data about "Cost Center/Activity Type" in SAP S/4HANA. It reads from 1 data source (cssl) and exposes 12 fields with key fields kokrs, kostl, lstar, gjahr. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
cssl cssl from

Associations (1)

CardinalityTargetAliasCondition
[0..*] ESH_N_ACTIVITY_TYPE_CSLA _TO_CSSL $projection.kokrs = _TO_CSSL.kokrs and $projection.lstar = _TO_CSSL.lstar

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ESH_L_ACTIV_CSSL view
EndUserText.label Cost Center/Activity Type view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
AbapCatalog.compiler.compareFilter true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY kokrs kokrs Org. Value
KEY kostl kostl Substitute CC
KEY lstar lstar Activity Type
KEY gjahr gjahr Settlement Year
cckey cckey Cost Collector
latyp latyp ATyp category
leinh leinh Unit
ausfk ausfk Output factor
auseh auseh Output Unit
objnr objnr Val. Obj. No.
latypi latypi ATyp Cat. Act.
_TO_CSSL _TO_CSSL

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_ACTIVITY_TYPE_CSSL.
-- 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_ACTIV_CSSL

CREATE VIEW ESH_N_ACTIVITY_TYPE_CSSL AS
SELECT
  kokrs,
  kostl,
  lstar,
  gjahr,
  cckey,
  latyp,
  leinh,
  ausfk,
  auseh,
  objnr,
  latypi
FROM cssl
LEFT OUTER JOIN ESH_N_ACTIVITY_TYPE_CSLA AS _TO_CSSL ON kokrs = _TO_CSSL.kokrs AND lstar = _TO_CSSL.lstar  -- association [0..*]
;

Learn More