CDS_prctr_v

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 CDS_prctr_v.
-- 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: CDS_V_PRCTR

CREATE VIEW CDS_prctr_v AS
SELECT
  prctrset.mandt AS Client,
  prctrset.khinr AS Profitcenterarea,
  prctrset.datab AS Validfromdate,
  prctrset.segment AS Segment,
  prctrset.datbi AS Validtodate,
  prctrset.verak AS Personresponsible,
  prctrset.prctr AS Profitcenter,
  prctrset.kokrs AS Controlarea,
  prctrset.spras AS OriginalLanguage,
  prctrtext.spras AS Language,
  prctrtext.ktext AS Generalname,
  prctrset.lock_ind AS Lockindicator
FROM cepc AS prctrset
LEFT OUTER JOIN cepct AS prctrtext ON /* join condition not captured in parsed metadata */
;