CKPH
Stammsatz Kostenträger-Identnummer
CKPH is an SAP database table in S/4HANA. Stammsatz Kostenträger-Identnummer. It contains 36 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FAC_COSTOBJECTVH | view | from | Data Source for Cost Object | |
| P_ONRHP | view_entity | inner | BASIC | View for P_ONRHP |
Fields (36)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | kstrg | kstrg | Cost Object | |||
| KEY | datbi | datbi | Valid To | |||
| datab | datab | Valid From | ||||
| kokrs | kokrs | CO Area | ||||
| bukrs | bukrs | Company Code | ||||
| werks | werks_d | Plant | ||||
| gsber | gsber | Business Area | ||||
| func_area | fkber | Functional Area | ||||
| objnr | j_objnr | Object number | ||||
| uektr | co_ukstr | HL cost object | ||||
| ktrty | kk_ktrtyp | Cost obj. type | ||||
| vaktr | kk_vaktr | Person resp. | ||||
| ltext | ktr_ltext | Text exists | ||||
| ernam | ktr_ernam | Created By | ||||
| erdat | ktr_erdat | Created on | ||||
| aenam | ktr_aenam | Last Changed By | ||||
| aedat | ktr_aedat | Changed On | ||||
| kstat | kk_kstat | Status | ||||
| stdat | kk_stdat | Status change | ||||
| loekz | ktr_loekz | Deletion Flag | ||||
| objwr | owaer | Object Currency | ||||
| kvewe | kvewe | Usage | ||||
| kappl | kappl | Application | ||||
| kalsm | ktr_kalsm | Costing sheet | ||||
| zschl | ktr_zschl | Overhead key | ||||
| awoba | awoba | Object Type | ||||
| awsls | awsls | Variance key | ||||
| fcpmg | spred | Distribution Key | ||||
| prctr | prctr | Profit Center | ||||
| saprl | kk_saprl | Release | ||||
| ktrat | kk_ktrart | Cost obj. cat. | ||||
| kalnr | ck_kalnr | Cost EstimateNo | ||||
| klvar | ck_klvar | Costing Variant | ||||
| loekennz | ktr_loeknz | Deletion Indic. | ||||
| ktrzb | kk_ktrzb | Time Base |
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.
-- Stammsatz Kostenträger-Identnummer
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CKPH (
MANDT, -- Client [mandt]
KSTRG, -- Cost Object [kstrg]
DATBI, -- Valid To [datbi]
DATAB, -- Valid From [datab]
KOKRS, -- CO Area [kokrs]
BUKRS, -- Company Code [bukrs]
WERKS, -- Plant [werks_d]
GSBER, -- Business Area [gsber]
FUNC_AREA, -- Functional Area [fkber]
OBJNR, -- Object number [j_objnr]
UEKTR, -- HL cost object [co_ukstr]
KTRTY, -- Cost obj. type [kk_ktrtyp]
VAKTR, -- Person resp. [kk_vaktr]
LTEXT, -- Text exists [ktr_ltext]
ERNAM, -- Created By [ktr_ernam]
ERDAT, -- Created on [ktr_erdat]
AENAM, -- Last Changed By [ktr_aenam]
AEDAT, -- Changed On [ktr_aedat]
KSTAT, -- Status [kk_kstat]
STDAT, -- Status change [kk_stdat]
LOEKZ, -- Deletion Flag [ktr_loekz]
OBJWR, -- Object Currency [owaer]
KVEWE, -- Usage [kvewe]
KAPPL, -- Application [kappl]
KALSM, -- Costing sheet [ktr_kalsm]
ZSCHL, -- Overhead key [ktr_zschl]
AWOBA, -- Object Type [awoba]
AWSLS, -- Variance key [awsls]
FCPMG, -- Distribution Key [spred]
PRCTR, -- Profit Center [prctr]
SAPRL, -- Release [kk_saprl]
KTRAT, -- Cost obj. cat. [kk_ktrart]
KALNR, -- Cost EstimateNo [ck_kalnr]
KLVAR, -- Costing Variant [ck_klvar]
LOEKENNZ, -- Deletion Indic. [ktr_loeknz]
KTRZB, -- Time Base [kk_ktrzb]
PRIMARY KEY (MANDT, KSTRG, DATBI)
);
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