SAP Reference

KE51

CreateS/4HANA status: Active

Create Profit Center

Module: CO · Controlling

Boilerplate SQL

Databricks SQL

Starting point for querying the tables behind this transaction. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.

Query parameters
-- ============================================================
-- 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. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  h.MANDT AS "Client",
  h.PRCTR AS "Profit Center",
  h.DATBI AS "Valid To Date",
  h.KOKRS AS "Controlling Area"
FROM <catalog>.<schema>.cepc h
WHERE
  h.MANDT = '<MANDT>'
  AND h.PRCTR = '<PRCTR>'
  AND h.DATBI = '<DATBI>'
  AND h.KOKRS = '<KOKRS>'
ORDER BY h.PRCTR;

Tables Used by This Transaction