CEPC

Transparent Table Application Table

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)

ViewTypeJoinVDMDescription
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)

KeyField Data ElementDescription DomainTypeLength
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)
);