ESH_N_PROFIT_CENTER_CEPC

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_PROFIT_CENTER_CEPC.
-- 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_PROFI_CEPC

CREATE VIEW ESH_N_PROFIT_CENTER_CEPC 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,
  bukrs,
  vname,
  recid,
  etype,
  txjcd,
  regio,
  kvewe,
  kappl,
  kalsm,
  logsystem,
  lock_ind,
  pca_template,
  segment
FROM cepc
LEFT OUTER JOIN ESH_N_USER_USER AS _005056B254401E_90816669D010FE ON verak_user = _005056B254401E_90816669D010FE.bname  -- association [1..1]
LEFT OUTER JOIN cepct AS _TO_CEPCT ON prctr = _TO_CEPCT.prctr AND datbi = _TO_CEPCT.datbi AND kokrs = _TO_CEPCT.kokrs  -- association [0..*]
LEFT OUTER JOIN ESH_N_COMPANY_CODE_OMPANY_CODE AS _CEPC2COMPANY_CODE ON bukrs = _CEPC2COMPANY_CODE.BUKRS  -- association [1..1]
LEFT OUTER JOIN fagl_segmt AS _CEPC2FAGL_SEGMT ON segment = _CEPC2FAGL_SEGMT.segment  -- association [0..*]
LEFT OUTER JOIN tka01 AS _CEPC2TKA01 ON kokrs = _CEPC2TKA01.kokrs  -- association [1..1]
LEFT OUTER JOIN ESH_N_USER_USER AS _CEPC2USER ON usnam = _CEPC2USER.bname  -- association [1..1]
LEFT OUTER JOIN ESH_N_XFELD_3_XFELD AS _CEPC2XFELD ON lock_ind = _CEPC2XFELD.domvalue_l  -- association [0..*]
;