ESH_S_PROFIT_CENTER

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

CREATE VIEW ESH_S_PROFIT_CENTER AS
SELECT
  prctr,
  datbi,
  kokrs,
  datab,
  ersda,
  usnam,
  merkmal,
  abtei,
  verak,
  verak_user,
  waers,
  nprctr,
  land1,
  anred,
  name1,
  name2,
  name3,
  name4,
  ort01,
  ort02,
  stras,
  pfach,
  pstlz,
  pstl2,
  spras,
  telbx,
  telf1,
  telf2,
  telfx,
  teltx,
  telx1,
  datlt,
  drnam,
  khinr,
  vname,
  recid,
  etype,
  txjcd,
  regio,
  kvewe,
  kappl,
  kalsm,
  logsystem,
  lock_ind,
  pca_template,
  segment,
  _TO_CEPCT[ 1: spras = $parameters.P_Language and datbi >= $parameters.P_ReferenceDate ].ktext AS ktext,
  _TO_CEPCT[ 1: spras = $parameters.P_Language and datbi >= $parameters.P_ReferenceDate ].ltext AS ltext,
  _CEPC2TKA01.bezei AS bezei,
  _CEPC2FAGL_SEGMT[ 1: langu = $parameters.P_Language ].name AS name,
  _005056B254401E_90816669D010FE._TO_USER_NAME.name_text AS NAME_TEXT1,
  _CEPC2XFELD[ 1: DOMALANGU = $parameters.P_Language ].VALUE_TEXT AS LOCK_TEXT,
  _CEPC2XFELD[ 1: DOMALANGU = $parameters.P_Language ].domvalue_l AS domvalue_l
FROM ESH_N_PROFIT_CENTER_CEPC
;