SAP Reference
KE51
CreateS/4 · ActiveCreate Profit Center
Boilerplate SQL
Databricks SQLStarting 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;