FAC_PROFIT_CENTER_VH

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 FAC_PROFIT_CENTER_VH.
-- 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: FACPCVH

CREATE VIEW FAC_PROFIT_CENTER_VH AS
SELECT
  _ProfitCenterMasterData.prctr AS prctr,
  _ProfitCenterMasterData.datbi AS datbi,
  _ProfitCenterMasterData.kokrs AS kokrs,
  _CompanyCodeAssignment.bukrs AS bukrs,
  _ProfitCenterMasterData.verak AS verak,
  _ProfitCenterMasterData.verak_user AS verak_user,
  _ProfitCenterMasterDataText.spras AS spras,
  _ProfitCenterMasterDataText.ktext AS ktext,
  _ProfitCenterMasterDataText.ltext AS ltext
FROM cepc_bukrs AS _CompanyCodeAssignment
INNER JOIN tka02 AS _CoCd2CoAreaMap ON /* join condition not captured in parsed metadata */
INNER JOIN cepc AS _ProfitCenterMasterData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cepct AS _ProfitCenterMasterDataText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cepc_bukrs AS _CompanyCodeAssignment ON /* join condition not captured in parsed metadata */
INNER JOIN tka02 AS _CompanyCodeControllingAreaMap ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): cepc
;