ESH_N_ACTIVITY_TYPE_CSLA
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)
| Source | Alias | Join Type |
|---|---|---|
| csla | csla | from |
Associations (9)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA