CEPC
Stammdatentabelle von Profit Centern
CEPC is an SAP database table in S/4HANA. Stammdatentabelle von Profit Centern. It contains 48 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 (48)
| 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 |
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.
-- Stammdatentabelle von Profit Centern
-- 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]
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