CEPC
Profit Center Master Data Table
CEPC is an SAP database table in S/4HANA. Profit Center Master Data Table. It contains 49 fields. 18 CDS views read from this table.
CDS Views using this table (18)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| CDS_prctr_v | view | from | ||
| CEPC_CMDT_PC_VIEW | view | left_outer | ||
| E_ProfitCenter | view | from | EXTENSION | Include View for Profit Center Master Data |
| ESH_N_PROFIT_CENTER_CEPC | view | from | Profit Center Master Data Table | |
| FAC_PROFIT_CENTER_VH | view | inner | value help view for profit center | |
| FAC_PROFIT_CENTER_VH | view | union_all | value help view for profit center | |
| FACRA_PROFITCENTERVH | view | from | Profit Center Value Help | |
| Fclm_Mm_Ebkn | view | left_outer | Account Assignment | |
| Fclm_Mm_Ekkn | view | left_outer | Account Assignment | |
| fgl_lib_txt_prctr | view | from | FI LIB: Profit center texts | |
| fiscds_gllit_04 | view | left_outer | GL Line Item (all Ledger) | |
| fiscds_gllit_05 | view | left_outer | GL Line Item (all Ledger) | |
| I_ProfitCenter | view | from | BASIC | Profit Center |
| I_ProfitCenterDetail | view | from | BASIC | Profit Center Detail |
| I_ProfitCenterWhereUsed | view | from | BASIC | Where Used Object List for Profit Center |
| ICA_PROFITCENTER | view | from | ||
| ICA_PROFITCENTER_C | view | from | ||
| SHSM_PROFITCENTER_VH | view | from | Profit Center Value Help |
Fields (49)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | prctr | PRCTR | Profit Center | |||
| KEY | datbi | DATBI | Valid To | |||
| KEY | kokrs | KOKRS | CO Area | |||
| datab | DATAB | Valid From | ||||
| ersda | ERFDT | Entered On | ||||
| usnam | ERFNM | Created By | ||||
| merkmal | FDMERKMAL | Characteristic | ||||
| abtei | ABTEIL | Department | ||||
| verak | VERAPC | Person Respons. | ||||
| verak_user | VERAPC_USER | User Responsible | ||||
| waers | WAERS | Currency | ||||
| nprctr | NPRCTR | Successor | ||||
| land1 | LAND1 | Country/Reg. | ||||
| anred | ANRED | Title | ||||
| name1 | NAME1_GP | Name | ||||
| name2 | NAME2_GP | Name 2 | ||||
| name3 | NAME3_GP | Name 3 | ||||
| name4 | NAME4_GP | Name 4 | ||||
| ort01 | ORT01_GP | City | ||||
| ort02 | ORT02_GP | District | ||||
| stras | STRAS_GP | Street | ||||
| pfach | PFACH | PO Box | ||||
| pstlz | PSTLZ | Postal Code | ||||
| pstl2 | PSTL2 | PO Box PCode | ||||
| spras | SPRAS | Language | ||||
| telbx | TELBX | Telebox | ||||
| telf1 | TELF1 | Telephone 1 | ||||
| telf2 | TELF2 | Telephone 2 | ||||
| telfx | TELFX | Fax Number | ||||
| teltx | TELTX | Teletex | ||||
| telx1 | TELX1 | Telex | ||||
| datlt | DATLT | Data line | ||||
| drnam | PCDNAM | Printer name | ||||
| khinr | PHINR | Area | ||||
| bukrs | BUKRS | Company Code | ||||
| vname | JV_NAME | Joint venture | ||||
| recid | JV_RECIND | Recovery Ind. | ||||
| etype | JV_ETYPE | Equity Type | ||||
| txjcd | TXJCD | Tax Jur. | ||||
| regio | REGIO | Region | ||||
| kvewe | KVEWE | Usage | ||||
| kappl | KAPPL | Application | ||||
| kalsm | KALSM_D | Procedure | ||||
| logsystem | LOGSYSTEM | Logical System | ||||
| lock_ind | LOCK_IND | Lock indicator | ||||
| pca_template | PCA_TEMPLATE | Form. Planning Temp. | ||||
| segment | FB_SEGMENT | Segment | ||||
| eew_cepc_ps_dummy | DUMMY | Dummy function in length 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Profit Center Master Data Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CEPC (
MANDT, -- Client [MANDT]
PRCTR, -- Profit Center [PRCTR]
DATBI, -- Valid To [DATBI]
KOKRS, -- CO Area [KOKRS]
DATAB, -- Valid From [DATAB]
ERSDA, -- Entered On [ERFDT]
USNAM, -- Created By [ERFNM]
MERKMAL, -- Characteristic [FDMERKMAL]
ABTEI, -- Department [ABTEIL]
VERAK, -- Person Respons. [VERAPC]
VERAK_USER, -- User Responsible [VERAPC_USER]
WAERS, -- Currency [WAERS]
NPRCTR, -- Successor [NPRCTR]
LAND1, -- Country/Reg. [LAND1]
ANRED, -- Title [ANRED]
NAME1, -- Name [NAME1_GP]
NAME2, -- Name 2 [NAME2_GP]
NAME3, -- Name 3 [NAME3_GP]
NAME4, -- Name 4 [NAME4_GP]
ORT01, -- City [ORT01_GP]
ORT02, -- District [ORT02_GP]
STRAS, -- Street [STRAS_GP]
PFACH, -- PO Box [PFACH]
PSTLZ, -- Postal Code [PSTLZ]
PSTL2, -- PO Box PCode [PSTL2]
SPRAS, -- Language [SPRAS]
TELBX, -- Telebox [TELBX]
TELF1, -- Telephone 1 [TELF1]
TELF2, -- Telephone 2 [TELF2]
TELFX, -- Fax Number [TELFX]
TELTX, -- Teletex [TELTX]
TELX1, -- Telex [TELX1]
DATLT, -- Data line [DATLT]
DRNAM, -- Printer name [PCDNAM]
KHINR, -- Area [PHINR]
BUKRS, -- Company Code [BUKRS]
VNAME, -- Joint venture [JV_NAME]
RECID, -- Recovery Ind. [JV_RECIND]
ETYPE, -- Equity Type [JV_ETYPE]
TXJCD, -- Tax Jur. [TXJCD]
REGIO, -- Region [REGIO]
KVEWE, -- Usage [KVEWE]
KAPPL, -- Application [KAPPL]
KALSM, -- Procedure [KALSM_D]
LOGSYSTEM, -- Logical System [LOGSYSTEM]
LOCK_IND, -- Lock indicator [LOCK_IND]
PCA_TEMPLATE, -- Form. Planning Temp. [PCA_TEMPLATE]
SEGMENT, -- Segment [FB_SEGMENT]
EEW_CEPC_PS_DUMMY, -- Dummy function in length 1 [DUMMY]
PRIMARY KEY (MANDT, PRCTR, DATBI, KOKRS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA