ESH_N_ACTIVITY_TYPE_CSLA

DDL: ESH_N_ACTIVITY_TYPE_CSLA SQL: ESH_L_ACTIV_CSLA Type: view Package: BSESH_CO_OM

Activity master

ESH_N_ACTIVITY_TYPE_CSLA is a CDS View that provides data about "Activity master" in SAP S/4HANA. It reads from 1 data source (csla) and exposes 21 fields with key fields kokrs, lstar, datbi. It has 9 associations to related views. Part of development package BSESH_CO_OM.

Data Sources (1)

SourceAliasJoin Type
csla csla from

Associations (9)

CardinalityTargetAliasCondition
[0..*] ESH_N_ACTIVITY_TYPE_CSSL _TO_CSSL $projection.kokrs = _TO_CSSL.kokrs and $projection.lstar = _TO_CSSL.lstar
[0..*] cslt _TO_CSLT $projection.kokrs = _TO_CSLT.kokrs and $projection.lstar = _TO_CSLT.lstar and $projection.datbi = _TO_CSLT.datbi
[0..*] dd07t _CSLA2DD07T $projection.latyp = _CSLA2DD07T.domvalue_l and _CSLA2DD07T.domname = 'LATYP'
[0..*] ESH_N_UNIT_OF_MEASURE_T006A _CSLA2T006A $projection.leinh = _CSLA2T006A.msehi
[1..1] tka01 _CSLA2TKA01 $projection.kokrs = _CSLA2TKA01.kokrs
[1..1] ESH_N_TKA10_TKA10 _CSLA2TKA10 $projection.tarkz = _CSLA2TKA10.tarkz
[0..*] tkt05 _CSLA2TKT05 $projection.kstty = _CSLA2TKT05.kosar
[1..1] ESH_N_USER_USER _CSLA2USER $projection.usnam = _CSLA2USER.bname
[0..*] ESH_N_XFELD_3_XFELD _CSLA2XFELD $projection.sprkz = _CSLA2XFELD.domvalue_l

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ESH_L_ACTIV_CSLA view
EndUserText.label Activity master 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 (21)

KeyFieldSource TableSource FieldDescription
KEY kokrs kokrs
KEY lstar lstar
KEY datbi datbi
datab datab
leinh leinh
latyp latyp
ersda ersda
usnam usnam
kstty kstty
vksta vksta
sprkz sprkz
tarkz tarkz
_TO_CSSL _TO_CSSL
_TO_CSLT _TO_CSLT
_CSLA2DD07T _CSLA2DD07T
_CSLA2T006A _CSLA2T006A
_CSLA2TKA01 _CSLA2TKA01
_CSLA2TKA10 _CSLA2TKA10
_CSLA2TKT05 _CSLA2TKT05
_CSLA2USER _CSLA2USER
_CSLA2XFELD _CSLA2XFELD
-- Enterprise Search help view
-- This CDS view represents node CSLA of search model ACTIVITY_TYPE_H of search software component SAPAPPLH.
-- This CDS view represents: Activity master.
-- CSS component (relevant to Customer Incidents): CO-OM
-- Package: BSESH_CO_OM
-- Software Component: S4CORE
@AbapCatalog.sqlViewName: 'ESH_L_ACTIV_CSLA'
@EndUserText.label: 'Activity master'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #INHERITED
@AbapCatalog.compiler.compareFilter: true
define view ESH_N_ACTIVITY_TYPE_CSLA 
as select from csla

  association [0..*] to ESH_N_ACTIVITY_TYPE_CSSL    as _TO_CSSL    on $projection.kokrs   = _TO_CSSL.kokrs         and
                                                                      $projection.lstar   = _TO_CSSL.lstar
  association [0..*] to cslt                        as _TO_CSLT    on $projection.kokrs   = _TO_CSLT.kokrs         and
                                                                      $projection.lstar   = _TO_CSLT.lstar         and
                                                                      $projection.datbi   = _TO_CSLT.datbi
  association [0..*] to dd07t                       as _CSLA2DD07T on $projection.latyp   = _CSLA2DD07T.domvalue_l and
                                                                      _CSLA2DD07T.domname = 'LATYP'
  association [0..*] to ESH_N_UNIT_OF_MEASURE_T006A as _CSLA2T006A on $projection.leinh   = _CSLA2T006A.msehi
  association [1..1] to tka01                       as _CSLA2TKA01 on $projection.kokrs   = _CSLA2TKA01.kokrs
  association [1..1] to ESH_N_TKA10_TKA10           as _CSLA2TKA10 on $projection.tarkz   = _CSLA2TKA10.tarkz
  association [0..*] to tkt05                       as _CSLA2TKT05 on $projection.kstty   = _CSLA2TKT05.kosar
  association [1..1] to ESH_N_USER_USER             as _CSLA2USER  on $projection.usnam   = _CSLA2USER.bname
  association [0..*] to ESH_N_XFELD_3_XFELD         as _CSLA2XFELD on $projection.sprkz   = _CSLA2XFELD.domvalue_l

{
  key kokrs,
  key lstar,
  key datbi,
  datab,
  leinh,
  latyp,
  ersda,
  usnam,
  kstty,
  vksta,
  sprkz,
  tarkz,
  _TO_CSSL,
  _TO_CSLT,
  _CSLA2DD07T,
  _CSLA2T006A,
  _CSLA2TKA01,
  _CSLA2TKA10,
  _CSLA2TKT05,
  _CSLA2USER,
  _CSLA2XFELD
}