CMDT_CC

Transparent Table Application Table
36 Fields 1 CDS Views

Generic Master Data: Cost Center Enhancements

CMDT_CC is an SAP database table in S/4HANA. Generic Master Data: Cost Center Enhancements. It contains 36 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SHSM_V_CMDT_CC_SHLP view from Inactive Cost Center (Value help)

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objnr J_OBJNR Object number
KEY datbi DATBI Valid To
KEY status CMDT_STATUS Act.Status
datab DATAB Valid From
kokrs KOKRS CO Area
kostl KEO_COST_CENTER Cost Center
khinr CMDT_HIERAREA Area
verak RESP_PERS Person respons.
verak_user VERAK_USER User Responsible
waers WAERS Currency
bukrs BUKRS Company Code
gsber GSBER Business Area
kosar KOSAR CCtr Category
prctr PRCTR Profit Center
func_area FKBER Functional Area
abtei ABTEI Department
cpi_templ CCA_TEMPL_CPI Activity-Indep.Temp.
cpd_templ CCA_TEMPL_CPD Activity-Dep.Tmp
sci_templ CCA_TEMPL_SCI Acty-IndepTemplAlloc
scd_templ CCA_TEMPL_SCD Acty-Dep Templ.Alloc
kalsm AUFKALSM Costing Sheet
bkzkp BKZKP Lock Act.PCosts
pkzkp PKZKP Plan pri. costs
bkzks BKZKS Actl Sec. Costs
bkzer BKZER Lock Act. Rev.
bkzob BKZOB Commitment
pkzks PKZKS Plan Secondary
pkzer PKZER Plan Revenues
mgefl MGEFL Record Quantity
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

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.

-- Generic Master Data: Cost Center Enhancements
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMDT_CC (
    MANDT,       -- Client [MANDT]
    OBJNR,       -- Object number [J_OBJNR]
    DATBI,       -- Valid To [DATBI]
    STATUS,      -- Act.Status [CMDT_STATUS]
    DATAB,       -- Valid From [DATAB]
    KOKRS,       -- CO Area [KOKRS]
    KOSTL,       -- Cost Center [KEO_COST_CENTER]
    KHINR,       -- Area [CMDT_HIERAREA]
    VERAK,       -- Person respons. [RESP_PERS]
    VERAK_USER,  -- User Responsible [VERAK_USER]
    WAERS,       -- Currency [WAERS]
    BUKRS,       -- Company Code [BUKRS]
    GSBER,       -- Business Area [GSBER]
    KOSAR,       -- CCtr Category [KOSAR]
    PRCTR,       -- Profit Center [PRCTR]
    FUNC_AREA,   -- Functional Area [FKBER]
    ABTEI,       -- Department [ABTEI]
    CPI_TEMPL,   -- Activity-Indep.Temp. [CCA_TEMPL_CPI]
    CPD_TEMPL,   -- Activity-Dep.Tmp [CCA_TEMPL_CPD]
    SCI_TEMPL,   -- Acty-IndepTemplAlloc [CCA_TEMPL_SCI]
    SCD_TEMPL,   -- Acty-Dep Templ.Alloc [CCA_TEMPL_SCD]
    KALSM,       -- Costing Sheet [AUFKALSM]
    BKZKP,       -- Lock Act.PCosts [BKZKP]
    PKZKP,       -- Plan pri. costs [PKZKP]
    BKZKS,       -- Actl Sec. Costs [BKZKS]
    BKZER,       -- Lock Act. Rev. [BKZER]
    BKZOB,       -- Commitment [BKZOB]
    PKZKS,       -- Plan Secondary [PKZKS]
    PKZER,       -- Plan Revenues [PKZER]
    MGEFL,       -- Record Quantity [MGEFL]
    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]
    PRIMARY KEY (MANDT, OBJNR, DATBI, STATUS)
);

Learn More