Skip to content
SAP Reference

KE51

CreateS/4 · Active

Create Profit Center

Boilerplate SQL

Databricks SQL

Starting point for querying the tables behind this transaction. Adjust the WHERE clause for your scenario.

-- ============================================================
-- T-Code : KE51 Create Profit Center
-- Purpose: Create Profit Center — auto-generated boilerplate from tcode-table-map
-- Grain  : One row per CEPC
-- Tables : CEPC
-- Notes  : Auto-generated skeleton. Add MAKT/T001W/LFA1/KNA1 enrichment joins as needed for the business question. Replace placeholders (<...>) and MANDT with your tenant values.
-- ============================================================
SELECT
  h.MANDT AS "Client",
  h.PRCTR AS "Profit Center",
  h.DATBI AS "Valid To Date",
  h.KOKRS AS "Controlling Area"
FROM cepc h
WHERE
  h.MANDT = '100'
  AND h.PRCTR = '<PRCTR>'
  AND h.DATBI = '<DATBI>'
  AND h.KOKRS = '<KOKRS>'
ORDER BY h.PRCTR;

Tables Used by This Transaction