CSKS

Transparent Table Application Table
84 Fields 20 CDS Views

Cost Center Master Record

CSKS is an SAP database table in S/4HANA. Cost Center Master Record. It contains 84 fields. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
CTE_CDS_FIN_MON_CC view left_outer CDS View for Monitoring Cost Center export to Concur
E_CostCenter view from EXTENSION Include View for Cost Center Master Data
ESH_COSTCENTER view from Basis view for ESH CostCenter
ESH_N_COST_CENTER_CSKS view from Cost Center Master Data
FCO_COR_HSL_DER view left_outer HSL Corr. for Stat. Records in CO: Derivation of CurrKey
FCO_COST_RATE_MIG_CLASSIC view inner Activity prices from COST in ACCOSTRATE format
Fco_Mig_Check_Coep11_L2 view left_outer Check ACDOCA-records against COEP-records with WRTTP=11
fgl_lib_txt_kostl view from FI LIB: Cost center texts
FINOC_CHECK_REC_01_CCR_TO_REC view_entity inner Org. Change: From CostCtr to RE Contract
FINOC_CHECK_REC_01_PRCTRS view_entity left_outer Org. Change: PRCTRS of RE Contracts
FINOC_CHECK_REC_01_REC_TO_ALL view_entity left_outer Org. Change: From RE Contract to All
fins_prctr_of_object_acdoca view left_outer Derive PRCTR & PPRCTR for ACDOCA object
I_CostCenter view from BASIC Cost Center
P_ONRKL view left_outer BASIC
P_ONRKS view left_outer BASIC
SHSM_M_KOSTN view from Searchhelp View for Cost Center Name
v_coep_v2_l1a_view view left_outer LOCAL: Line Items COEP for statistical postings
VFCO_COST_CENTER_NAME_SHPV view from Cost Center Names
VFCO_CSKS_SHPV view from Cost Center Master Data
VFCO_CSKS_SHV_NO_AUTH view from Cost Center Master Data

Fields (84)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kokrs KOKRS CO Area
KEY kostl KOSTL Cost Center
KEY datbi DATBI Valid To
datab DATAB Valid From
bkzkp BKZKP Lock Act.PCosts
pkzkp PKZKP Plan pri. costs
bukrs BUKRS Company Code
gsber GSBER Business Area
kosar KOSAR CCtr Category
verak VERAK Person Resp.
verak_user VERAK_USER User Responsible
waers WAERS Currency
kalsm AUFKALSM Costing Sheet
txjcd TXJCD Tax Jur.
prctr PRCTR Profit Center
werks WERKS_D Plant
logsystem LOGSYSTEM Logical System
ersda ERFDT Entered On
usnam ERFNM Created By
bkzks BKZKS Actl Sec. Costs
bkzer BKZER Lock Act. Rev.
bkzob BKZOB Commitment
pkzks PKZKS Plan Secondary
pkzer PKZER Plan Revenues
vmeth VMETH Alloc. Methods
mgefl MGEFL Record Quantity
abtei ABTEI Department
nkost NKOST Subseq.CCtr
kvewe KVEWE Usage
kappl KAPPL Application
koszschl KOSZSCHL Overhead Key
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
regio REGIO Region
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 KDNAM Printer Name
khinr KHINR Std. Hierarchy
cckey CCKEY Cost Collector
kompl KSKOM Complete
stakz STAKZ Statistics Ind.
objnr J_OBJNR Object number
funkt FUNKT_DLK Function
afunk AFUNK_DLK Alt. Function
cpi_templ CCA_TEMPL_CPI Activity-Indep.Temp.
cpd_templ CCA_TEMPL_CPD Activity-Dep.Tmp
func_area FKBER Functional Area
sci_templ CCA_TEMPL_SCI Acty-IndepTemplAlloc
scd_templ CCA_TEMPL_SCD Acty-Dep Templ.Alloc
ski_templ CCA_TEMPL_SKI Templ.: Stat. KF
skd_templ CCA_TEMPL_SKD Templ.: Stat. KF
eew_csks_ps_dummy DUMMY Dummy function in length 1
vname JV_NAME Joint venture
recid JV_RECIND Recovery Ind.
etype JV_ETYPE Equity Type
jv_otype JV_OTYPE JV Object Type
jv_jibcl JV_JIBCL JIB/JIBE Class
jv_jibsa JV_JIBSA JIB/JIBE SbClsA
budget_carrying_cost_ctr FCO_BUDGET_CARRYING_COST_CTR Budget Cost Center
avc_profile FCO_AVC_PROFILE Availy Ctrl Prfl
avc_active FCO_AVC_FOR_COST_CENTER_ACTIVE AVC is Active
fund BP_GEBER Fund
grant_id GM_GRANT_NBR Grant
fund_fix_assigned PSM_FUND_FIX_ASSIGNED Fund Fixed Assignment
grant_fix_assigned PSM_GRANT_FIX_ASSIGNED Grant Fixed Assignment
func_area_fix_assigned PSM_FUNC_AREA_FIX_ASSIGNED Functional Area Fixed Assignment
ferc_ind FE_IND Reg. indicator

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.

-- Cost Center Master Record
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CSKS (
    MANDT,                     -- Client [MANDT]
    KOKRS,                     -- CO Area [KOKRS]
    KOSTL,                     -- Cost Center [KOSTL]
    DATBI,                     -- Valid To [DATBI]
    DATAB,                     -- Valid From [DATAB]
    BKZKP,                     -- Lock Act.PCosts [BKZKP]
    PKZKP,                     -- Plan pri. costs [PKZKP]
    BUKRS,                     -- Company Code [BUKRS]
    GSBER,                     -- Business Area [GSBER]
    KOSAR,                     -- CCtr Category [KOSAR]
    VERAK,                     -- Person Resp. [VERAK]
    VERAK_USER,                -- User Responsible [VERAK_USER]
    WAERS,                     -- Currency [WAERS]
    KALSM,                     -- Costing Sheet [AUFKALSM]
    TXJCD,                     -- Tax Jur. [TXJCD]
    PRCTR,                     -- Profit Center [PRCTR]
    WERKS,                     -- Plant [WERKS_D]
    LOGSYSTEM,                 -- Logical System [LOGSYSTEM]
    ERSDA,                     -- Entered On [ERFDT]
    USNAM,                     -- Created By [ERFNM]
    BKZKS,                     -- Actl Sec. Costs [BKZKS]
    BKZER,                     -- Lock Act. Rev. [BKZER]
    BKZOB,                     -- Commitment [BKZOB]
    PKZKS,                     -- Plan Secondary [PKZKS]
    PKZER,                     -- Plan Revenues [PKZER]
    VMETH,                     -- Alloc. Methods [VMETH]
    MGEFL,                     -- Record Quantity [MGEFL]
    ABTEI,                     -- Department [ABTEI]
    NKOST,                     -- Subseq.CCtr [NKOST]
    KVEWE,                     -- Usage [KVEWE]
    KAPPL,                     -- Application [KAPPL]
    KOSZSCHL,                  -- Overhead Key [KOSZSCHL]
    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]
    REGIO,                     -- Region [REGIO]
    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 [KDNAM]
    KHINR,                     -- Std. Hierarchy [KHINR]
    CCKEY,                     -- Cost Collector [CCKEY]
    KOMPL,                     -- Complete [KSKOM]
    STAKZ,                     -- Statistics Ind. [STAKZ]
    OBJNR,                     -- Object number [J_OBJNR]
    FUNKT,                     -- Function [FUNKT_DLK]
    AFUNK,                     -- Alt. Function [AFUNK_DLK]
    CPI_TEMPL,                 -- Activity-Indep.Temp. [CCA_TEMPL_CPI]
    CPD_TEMPL,                 -- Activity-Dep.Tmp [CCA_TEMPL_CPD]
    FUNC_AREA,                 -- Functional Area [FKBER]
    SCI_TEMPL,                 -- Acty-IndepTemplAlloc [CCA_TEMPL_SCI]
    SCD_TEMPL,                 -- Acty-Dep Templ.Alloc [CCA_TEMPL_SCD]
    SKI_TEMPL,                 -- Templ.: Stat. KF [CCA_TEMPL_SKI]
    SKD_TEMPL,                 -- Templ.: Stat. KF [CCA_TEMPL_SKD]
    EEW_CSKS_PS_DUMMY,         -- Dummy function in length 1 [DUMMY]
    VNAME,                     -- Joint venture [JV_NAME]
    RECID,                     -- Recovery Ind. [JV_RECIND]
    ETYPE,                     -- Equity Type [JV_ETYPE]
    JV_OTYPE,                  -- JV Object Type [JV_OTYPE]
    JV_JIBCL,                  -- JIB/JIBE Class [JV_JIBCL]
    JV_JIBSA,                  -- JIB/JIBE SbClsA [JV_JIBSA]
    BUDGET_CARRYING_COST_CTR,  -- Budget Cost Center [FCO_BUDGET_CARRYING_COST_CTR]
    AVC_PROFILE,               -- Availy Ctrl Prfl [FCO_AVC_PROFILE]
    AVC_ACTIVE,                -- AVC is Active [FCO_AVC_FOR_COST_CENTER_ACTIVE]
    FUND,                      -- Fund [BP_GEBER]
    GRANT_ID,                  -- Grant [GM_GRANT_NBR]
    FUND_FIX_ASSIGNED,         -- Fund Fixed Assignment [PSM_FUND_FIX_ASSIGNED]
    GRANT_FIX_ASSIGNED,        -- Grant Fixed Assignment [PSM_GRANT_FIX_ASSIGNED]
    FUNC_AREA_FIX_ASSIGNED,    -- Functional Area Fixed Assignment [PSM_FUNC_AREA_FIX_ASSIGNED]
    FERC_IND,                  -- Reg. indicator [FE_IND]
    PRIMARY KEY (MANDT, KOKRS, KOSTL, DATBI)
);

Learn More