Profit Center Table in SAP
If you’re searching for the Profit Center Table in SAP, you’ve come to the right place.
Profit Centers play a major role in SAP Controlling (CO) and Financial Accounting (FI) by helping organizations analyze profits and losses for different business units.
Whether you’re working in SAP ECC or SAP S/4HANA, knowing the correct profit center tables can save significant development and reporting time.
In this guide, you’ll learn:
- Main Profit Center Tables
- Profit Center Master Data Table
- Company Code Assignment Table
- Cost Center to Profit Center Table
- Material Master Profit Center Table
- SAP Profit Center TCodes
- SAP S/4HANA Profit Center Tables
- Real examples
- Frequently Asked Questions
Let’s begin.
What is a Profit Center in SAP?
A Profit Center is an organizational unit in SAP used to measure the profitability of a specific business area, department, product line, branch, or region.
Companies use Profit Centers to:
- Track revenues
- Monitor expenses
- Measure profitability
- Prepare management reports
- Analyze internal performance
Each Profit Center belongs to a Controlling Area and can also be assigned to one or more Company Codes depending on system configuration.
Main Profit Center Table in SAP
The primary Profit Center master table is:
| Table | Description |
|---|---|
| CEPC | Profit Center Master Data |
The CEPC table stores:
- Profit Center
- Controlling Area
- Name
- Valid From
- Valid To
- Person Responsible
- Currency
- Department
- Address Information
This is the most commonly used Profit Center table in SAP.
CEPC Table in SAP
The CEPC table contains the master records for Profit Centers.
Some important fields include:
| Field | Description |
|---|---|
| PRCTR | Profit Center |
| KOKRS | Controlling Area |
| DATBI | Valid To Date |
| DATAB | Valid From Date |
| NAME1 | Profit Center Name |
| KHINR | Hierarchy Area |
| VERAK | Person Responsible |
Aslo Read: SAP S/4HANA Migration Cockpit step by step process
Developers frequently use CEPC for:
- ALV Reports
- Custom Reports
- CDS Views
- SAP ABAP Development
- Data Extraction
Company Code Assignment Table
Many SAP beginners assume CEPC stores company code information.
Actually, the Company Code assignment is maintained in another table.
| Table | Description |
|---|---|
| CEPC_BUKRS | Profit Center Assignment to Company Code |
This table links:
- Profit Center
- Company Code
- Validity Dates
Important fields include:
- PRCTR
- BUKRS
- DATAB
- DATBI
Profit Center Hierarchy Table
SAP stores Profit Center hierarchy information using:
| Table | Purpose |
|---|---|
| SETHEADER | Hierarchy Header |
| SETNODE | Hierarchy Nodes |
| SETLEAF | Hierarchy Values |
These tables are commonly used when generating hierarchy reports.
Also Read: Substring in SAP HANA Calculated Column – Example and Syntax
Profit Center Table in SAP S/4HANA
In SAP S/4HANA, Profit Centers continue to exist, but Universal Journal (ACDOCA) becomes the primary source for financial postings.
Important tables include:
| Table | Description |
|---|---|
| CEPC | Profit Center Master |
| CEPC_BUKRS | Company Code Assignment |
| ACDOCA | Universal Journal |
| CSKS | Cost Center Master |
| MARC | Material Plant Data |
| MARA | Material Master |
Profit Center information is available in Universal Journal through field:
PRCTR
This makes reporting much easier compared to SAP ECC.
Profit Center Field in SAP Tables
Profit Center field name is:
PRCTR
You will commonly find this field in:
- ACDOCA
- BSEG
- COEP
- CSKS
- MARC
- MBEW
- COBK
- COSS
- COSP
Whenever you need Profit Center information, search for field PRCTR.
Material Master Profit Center Table
Profit Center assignment for materials is generally maintained in:
| Table | Description |
|---|---|
| MARC | Plant Data for Material |
| MBEW | Material Valuation |
Important field:
PRCTR
Example:
Material
↓
Plant
↓
Profit Center
Cost Center to Profit Center Table
Cost Centers are stored in:
| Table | Description |
|---|---|
| CSKS | Cost Center Master |
Important field:
PRCTR
Every Cost Center can be assigned to a Profit Center.
Universal Journal Profit Center
SAP S/4HANA stores financial transactions inside:
ACDOCA
Profit Center field:
PRCTR
Example query:
SELECT PRCTR,
RBUKRS,
GJAHR,
HSL
FROM ACDOCA
WHERE PRCTR='PC1000';
SAP Profit Center Transaction Codes (TCodes)
Here are the most commonly used Profit Center transaction codes.
| TCode | Description |
|---|---|
| KE51 | Create Profit Center |
| KE52 | Change Profit Center |
| KE53 | Display Profit Center |
| KE55 | Profit Center List |
| KCH1 | Create Profit Center Group |
| KCH2 | Change Group |
| KCH3 | Display Group |
| 0KE5 | Profit Center Settings |
These are frequently used by SAP FICO consultants.
Example: Retrieve Profit Center Master Data
Example ABAP SQL:
SELECT *
FROM CEPC
INTO TABLE lt_cepc
WHERE KOKRS = '1000'.
Retrieve Company Code:
SELECT *
FROM CEPC_BUKRS
INTO TABLE lt_bukrs.
Relationship Between Profit Center Tables
Company Code
│
│
CEPC_BUKRS
│
│
Profit Center (CEPC)
│
│
Cost Center (CSKS)
│
│
Material (MARC)
│
│
Universal Journal (ACDOCA)
Difference Between CEPC and CEPC_BUKRS
| CEPC | CEPC_BUKRS |
|---|---|
| Master Data | Company Code Assignment |
| Profit Center Details | Company Code Mapping |
| Name | Company Code |
| Responsible Person | Validity |
| Hierarchy | Assignment |
Frequently Used SAP Tables Related to Profit Center
| Table | Description |
|---|---|
| CEPC | Profit Center Master |
| CEPC_BUKRS | Company Code Assignment |
| ACDOCA | Universal Journal |
| CSKS | Cost Center Master |
| COEP | CO Line Items |
| COBK | CO Documents |
| COSS | Cost Totals |
| COSP | Cost Planning |
| MARC | Material Plant Data |
| MBEW | Material Valuation |
Common Interview Questions
Which table stores Profit Center Master Data?
Answer: CEPC.
Which table links Company Code and Profit Center?
Answer: CEPC_BUKRS.
What is the Profit Center field name?
Answer:
PRCTR
Which transaction creates a Profit Center?
KE51
Which transaction displays a Profit Center?
KE53
Which SAP S/4HANA table stores Profit Center postings?
ACDOCA
Best Practices
When working with Profit Centers in SAP:
- Always use CEPC for master data.
- Use CEPC_BUKRS to identify company code assignments.
- In SAP S/4HANA, use ACDOCA for financial reporting.
- Use the PRCTR field consistently across reporting and custom developments.
- Apply validity dates (
DATABandDATBI) when joining master data to avoid inaccurate historical results. - Optimize SQL queries by filtering on Controlling Area (KOKRS) and relevant date ranges.
Conclusion
Understanding the Profit Center Table in SAP is essential for SAP FICO consultants, ABAP developers, SAP HANA developers, and SAP S/4HANA professionals. While CEPC remains the primary table for Profit Center master data, related tables like CEPC_BUKRS, CSKS, MARC, and ACDOCA provide the full picture for assignments and transactional reporting.
Whether you’re building custom reports, writing SQL queries, developing ABAP programs, or preparing for interviews, knowing these tables and their relationships will make your work more efficient and accurate.
FAQ
What is the main Profit Center table in SAP?
The primary Profit Center master data table is CEPC.
Which table assigns a Profit Center to a Company Code?
CEPC_BUKRS stores the relationship between Profit Centers and Company Codes.
What is the Profit Center field in SAP?
The field name is PRCTR, and it appears in many SAP tables including ACDOCA, COEP, CSKS, MARC, and MBEW.
Which TCode is used to create a Profit Center?
Use KE51 to create, KE52 to change, and KE53 to display a Profit Center.
Which table stores Profit Center postings in SAP S/4HANA?
Financial postings that include Profit Centers are stored in the ACDOCA Universal Journal table.
Know this:
- profit center table in SAP
- profit center table in SAP S/4HANA
- CEPC table in SAP
- CEPC_BUKRS table
- SAP profit center master table
- SAP profit center TCode
- SAP profit center hierarchy
- SAP PRCTR field
- SAP cost center to profit center table
- material master profit center table
- ACDOCA profit center
- SAP ECC profit center tables