ESH_N_ACTIVITY_TYPE_CSLA

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_CSLA.
-- 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_CSLA

CREATE VIEW ESH_N_ACTIVITY_TYPE_CSLA AS
SELECT
  kokrs,
  lstar,
  datbi,
  datab,
  leinh,
  latyp,
  ersda,
  usnam,
  kstty,
  vksta,
  sprkz,
  tarkz
FROM csla
LEFT OUTER JOIN ESH_N_ACTIVITY_TYPE_CSSL AS _TO_CSSL ON kokrs = _TO_CSSL.kokrs AND lstar = _TO_CSSL.lstar  -- association [0..*]
LEFT OUTER JOIN cslt AS _TO_CSLT ON kokrs = _TO_CSLT.kokrs AND lstar = _TO_CSLT.lstar AND datbi = _TO_CSLT.datbi  -- association [0..*]
LEFT OUTER JOIN dd07t AS _CSLA2DD07T ON latyp = _CSLA2DD07T.domvalue_l AND _CSLA2DD07T.domname = 'LATYP'  -- association [0..*]
LEFT OUTER JOIN ESH_N_UNIT_OF_MEASURE_T006A AS _CSLA2T006A ON leinh = _CSLA2T006A.msehi  -- association [0..*]
LEFT OUTER JOIN tka01 AS _CSLA2TKA01 ON kokrs = _CSLA2TKA01.kokrs  -- association [1..1]
LEFT OUTER JOIN ESH_N_TKA10_TKA10 AS _CSLA2TKA10 ON tarkz = _CSLA2TKA10.tarkz  -- association [1..1]
LEFT OUTER JOIN tkt05 AS _CSLA2TKT05 ON kstty = _CSLA2TKT05.kosar  -- association [0..*]
LEFT OUTER JOIN ESH_N_USER_USER AS _CSLA2USER ON usnam = _CSLA2USER.bname  -- association [1..1]
LEFT OUTER JOIN ESH_N_XFELD_3_XFELD AS _CSLA2XFELD ON sprkz = _CSLA2XFELD.domvalue_l  -- association [0..*]
;