ESH_S_ACTIVITY_TYPE

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_ACTIVITY_TYPE.
-- 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_ACTIVITY_T
-- Parameters: P_Language : abap.lang, P_ReferenceDate : abap.dats

CREATE VIEW ESH_S_ACTIVITY_TYPE AS
SELECT
  kokrs,
  lstar,
  datbi,
  datab,
  leinh,
  latyp,
  ersda,
  usnam,
  kstty,
  vksta,
  sprkz,
  tarkz,
  _TO_CSLT[ 1: spras = $parameters.P_Language and datbi >= $parameters.P_ReferenceDate ].ktext AS ktext,
  _TO_CSLT[ 1: spras = $parameters.P_Language and datbi >= $parameters.P_ReferenceDate ].ltext AS ltext,
  _CSLA2TKA01.bezei AS bezei,
  _CSLA2TKA10._TO_TKT10_1[ 1: langu = $parameters.P_Language ].txt AS txt,
  _CSLA2T006A[ 1: spras = $parameters.P_Language ].mseh3 AS mseh3,
  _CSLA2T006A[ 1: spras = $parameters.P_Language ].msehl AS msehl,
  _CSLA2TKA01.ktopl AS ktopl,
  _CSLA2TKT05[ 1: spras = $parameters.P_Language ].ktext AS KTEXT1,
  _CSLA2DD07T[ 1: ddlanguage = $parameters.P_Language ].ddtext AS ddtext,
  _CSLA2XFELD[ 1: DOMALANGU = $parameters.P_Language ].VALUE_TEXT AS VALUE_TEXT,
  _CSLA2USER._TO_USER_NAME.name_text AS name_text,
  _TO_CSSL.kostl AS kostl,
  _TO_CSSL.objnr AS objnr
FROM ESH_N_ACTIVITY_TYPE_CSLA
;