KEKO

Transparent Table Application Table
129 Fields 3 CDS Views

Erzeugniskalkulation - Kopfinformationen

KEKO is an SAP database table in S/4HANA. Erzeugniskalkulation - Kopfinformationen. It contains 129 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FCO_COST_EST_KEKO_VBAP_SDM view from PCC: Cost Estimate with Origin Sales Doc
P_KEKO view_entity from BASIC Private View - KEKO
P_Matval_Manage_Cost_Max_Pre view from BASIC Manage Material Valuations, table of cost estimates

Fields (129)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bzobj ck_obj Reference Obj.
KEY kalnr ck_kalnr1 ProdCostEst.No.
KEY kalka ck_kalka Costing Type
KEY kadky ck_kadky Costing Date
KEY tvers ck_tvers Costing Version
KEY bwvar ck_bwvar Valuation Variant
KEY kkzma ck_kkzma Additive Costs
matnr matnr Material
werks werks_d Plant
bwkey bwkey Valuation Area
bwtar bwtar_d Valuation Type
kokrs kokrs CO Area
kadat ck_abdat Cstg Date From
bidat ck_bidat Costing Date To
kadam ck_abdat Cstg Date From
bidam ck_bidat Costing Date To
bwdat ck_bwdat Valuation Date
aldat ck_brdat Qty Struc. Date
bedat ck_bedat Requiremts Date
verid verid Prod. Version
stnum stnum BOM
stlan stlan Usage
stalt stalt Alternative
stcnt cim_count Counter
plnnr plnnr Group
plnty plnty Task List Type
plnal plnal Group Counter
plnct cim_count Counter
loekz ck_loekz Deletion Indic.
losgr ck_losgr Cstg Lot Size
meins ck_meinh_bew Valuation Unit
erfnm ck_kalkusr Costed by
erfma ck_erfma Created By
cpudt ck_cpudt Created On
cpudm ck_cpudm Created On
cputime syuzeit Time
feh_anz ck_feh_anz Messgs Sel/QtyStrDet
feh_k_anz ck_feh_ank Costing Msgs
feh_sta ck_feh_sta Costing Status
maxmsg symsgty Message Type
freig ck_freig Release
mkalk ck_mkalk Mixed Costing
baltkz ck_balt_flag Cost Est for ProcAlt
kalnr_ba ckkalnrba Procurement Alt.
btyp ckml_btyp Process Cat.
misch_verh ck_mischverh Mixing Ratio
bwvar_ba ck_bwvar_ba ValVar of ProcAlt
plscn plscn Planning Scenario
plmng cki_plmng Plan Quantity
sobsl ck_sobsk SpecProcuremKey
sobes sobes Spec. procuremt
sowrk ck_sowrk SpclPrcmntPlant
sobwt ck_sobwt SpclPrcmntVltnT
sodir clcor Direct Prodn
sodum dumps Phantom item
kalsm ck_kalsm Costing Sheet
aufza aufza Overhead Type
bwsmr ck_bwsmr Material Vltn
substrat ck_substrat Substr.InfoRec.
rldnr fins_ledger Ledger
rldnr_ref ck_reference_to_ledger
klvar ck_klvar Costing Variant
kosgr ck_kosgr Overhead Group
zschl aufzschl Overhead key
poper poper Posting Period
bdatj bdatj Year
stkoz cim_count Counter
zaehl cim_count Counter
topka ck_topka Top Cost Est.
cmf_nr cmf_nr Number
ocs_count cmf_ocscnt No. of OCS Msgs
objnr j_objnr Object number
erzka ck_erzka Product Costing
losau ck_losau Lot Size
ausid ck_ausid Assembly/Oper. Scrap
ausss ausss Assembly scrap
saprl kk_saprl Release
kzroh ck_kzroh Material Comp.
aufpl ck_aufpl Routing No. Op.
cuobj ck_cuobj Object Number
cuobjid ck_cuobjid Config.Obj
techs techs StandardVariant
type ck_type Variant
wrklt ck_wrklt Plant (Variant)
vormdat ck_vormdat Marked On
vormusr ck_vormusr Marked By
freidat ck_freidat Released On
freiusr ck_freiusr Released By
uebid ck_uebid Transfer Control
prozess ck_prozess Process
pr_verid ck_verid Prod. Version
csplit csplit Apportionment
kzkup kzkupmat Co-Product
fxpru ck_fixprku Fixed-Price Co-Prod.
cfxpr ck_contfixprice Contains FxdPrcCP
ziffr ck_ziffr Equivalence No.
sumziffr ck_sumziffr Sum Equiv. Nos
afakt ck_splitfac Apportmt Factor
vbeln vbeln SD Document
posnr posnr Item
pspnr wb_posnr WBS element
sbdkz sbdkz Indiv./ Coll.
mlmaa ck_ml_maac ML Act.
beskz beskz Procurement
disst disst Low-Level Code
kalst ck_kalst Costing Level
template abc_templ Template
patnr nkprtn Partner number
part_vrsn ck_parvrsn Partner Version
elehk ck_elesmhk Cost Comp. Str.
elehkns ck_elesmns Cost Comp. Str.
vocnt ck_vocnt No. Markings
gsber gsber Business Area
prctr prctr Profit Center
segunit fins_segmentation_unit Segmentation Unit
hwaer hwaer Local Currency
fwaer_kpf waers Currency
refid ck_refid Reference Var.
meinh_ws lrmei_ws Bch-specific Un
kzwso kzwso Units meas. use
asl ck_asl OrderBOMCostEst
kalaid ck_kalaid Costing Run
kaladat ck_kaladat Cstg Run Date
otyp ckml_otyp Object Type
bvc_sobsl_use ck_bvc_sobsl_use Special Proc. P2P
bapi_created ck_bapi BAPI Cost Est.
sgt_scat sgt_scat Stock Segment
ucb_id fucb_id Breakdown ID

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.

-- Erzeugniskalkulation - Kopfinformationen
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KEKO (
    MANDT,          -- Client [mandt]
    BZOBJ,          -- Reference Obj. [ck_obj]
    KALNR,          -- ProdCostEst.No. [ck_kalnr1]
    KALKA,          -- Costing Type [ck_kalka]
    KADKY,          -- Costing Date [ck_kadky]
    TVERS,          -- Costing Version [ck_tvers]
    BWVAR,          -- Valuation Variant [ck_bwvar]
    KKZMA,          -- Additive Costs [ck_kkzma]
    MATNR,          -- Material [matnr]
    WERKS,          -- Plant [werks_d]
    BWKEY,          -- Valuation Area [bwkey]
    BWTAR,          -- Valuation Type [bwtar_d]
    KOKRS,          -- CO Area [kokrs]
    KADAT,          -- Cstg Date From [ck_abdat]
    BIDAT,          -- Costing Date To [ck_bidat]
    KADAM,          -- Cstg Date From [ck_abdat]
    BIDAM,          -- Costing Date To [ck_bidat]
    BWDAT,          -- Valuation Date [ck_bwdat]
    ALDAT,          -- Qty Struc. Date [ck_brdat]
    BEDAT,          -- Requiremts Date [ck_bedat]
    VERID,          -- Prod. Version [verid]
    STNUM,          -- BOM [stnum]
    STLAN,          -- Usage [stlan]
    STALT,          -- Alternative [stalt]
    STCNT,          -- Counter [cim_count]
    PLNNR,          -- Group [plnnr]
    PLNTY,          -- Task List Type [plnty]
    PLNAL,          -- Group Counter [plnal]
    PLNCT,          -- Counter [cim_count]
    LOEKZ,          -- Deletion Indic. [ck_loekz]
    LOSGR,          -- Cstg Lot Size [ck_losgr]
    MEINS,          -- Valuation Unit [ck_meinh_bew]
    ERFNM,          -- Costed by [ck_kalkusr]
    ERFMA,          -- Created By [ck_erfma]
    CPUDT,          -- Created On [ck_cpudt]
    CPUDM,          -- Created On [ck_cpudm]
    CPUTIME,        -- Time [syuzeit]
    FEH_ANZ,        -- Messgs Sel/QtyStrDet [ck_feh_anz]
    FEH_K_ANZ,      -- Costing Msgs [ck_feh_ank]
    FEH_STA,        -- Costing Status [ck_feh_sta]
    MAXMSG,         -- Message Type [symsgty]
    FREIG,          -- Release [ck_freig]
    MKALK,          -- Mixed Costing [ck_mkalk]
    BALTKZ,         -- Cost Est for ProcAlt [ck_balt_flag]
    KALNR_BA,       -- Procurement Alt. [ckkalnrba]
    BTYP,           -- Process Cat. [ckml_btyp]
    MISCH_VERH,     -- Mixing Ratio [ck_mischverh]
    BWVAR_BA,       -- ValVar of ProcAlt [ck_bwvar_ba]
    PLSCN,          -- Planning Scenario [plscn]
    PLMNG,          -- Plan Quantity [cki_plmng]
    SOBSL,          -- SpecProcuremKey [ck_sobsk]
    SOBES,          -- Spec. procuremt [sobes]
    SOWRK,          -- SpclPrcmntPlant [ck_sowrk]
    SOBWT,          -- SpclPrcmntVltnT [ck_sobwt]
    SODIR,          -- Direct Prodn [clcor]
    SODUM,          -- Phantom item [dumps]
    KALSM,          -- Costing Sheet [ck_kalsm]
    AUFZA,          -- Overhead Type [aufza]
    BWSMR,          -- Material Vltn [ck_bwsmr]
    SUBSTRAT,       -- Substr.InfoRec. [ck_substrat]
    RLDNR,          -- Ledger [fins_ledger]
    RLDNR_REF,      -- ck_reference_to_ledger
    KLVAR,          -- Costing Variant [ck_klvar]
    KOSGR,          -- Overhead Group [ck_kosgr]
    ZSCHL,          -- Overhead key [aufzschl]
    POPER,          -- Posting Period [poper]
    BDATJ,          -- Year [bdatj]
    STKOZ,          -- Counter [cim_count]
    ZAEHL,          -- Counter [cim_count]
    TOPKA,          -- Top Cost Est. [ck_topka]
    CMF_NR,         -- Number [cmf_nr]
    OCS_COUNT,      -- No. of OCS Msgs [cmf_ocscnt]
    OBJNR,          -- Object number [j_objnr]
    ERZKA,          -- Product Costing [ck_erzka]
    LOSAU,          -- Lot Size [ck_losau]
    AUSID,          -- Assembly/Oper. Scrap [ck_ausid]
    AUSSS,          -- Assembly scrap [ausss]
    SAPRL,          -- Release [kk_saprl]
    KZROH,          -- Material Comp. [ck_kzroh]
    AUFPL,          -- Routing No. Op. [ck_aufpl]
    CUOBJ,          -- Object Number [ck_cuobj]
    CUOBJID,        -- Config.Obj [ck_cuobjid]
    TECHS,          -- StandardVariant [techs]
    TYPE,           -- Variant [ck_type]
    WRKLT,          -- Plant (Variant) [ck_wrklt]
    VORMDAT,        -- Marked On [ck_vormdat]
    VORMUSR,        -- Marked By [ck_vormusr]
    FREIDAT,        -- Released On [ck_freidat]
    FREIUSR,        -- Released By [ck_freiusr]
    UEBID,          -- Transfer Control [ck_uebid]
    PROZESS,        -- Process [ck_prozess]
    PR_VERID,       -- Prod. Version [ck_verid]
    CSPLIT,         -- Apportionment [csplit]
    KZKUP,          -- Co-Product [kzkupmat]
    FXPRU,          -- Fixed-Price Co-Prod. [ck_fixprku]
    CFXPR,          -- Contains FxdPrcCP [ck_contfixprice]
    ZIFFR,          -- Equivalence No. [ck_ziffr]
    SUMZIFFR,       -- Sum Equiv. Nos [ck_sumziffr]
    AFAKT,          -- Apportmt Factor [ck_splitfac]
    VBELN,          -- SD Document [vbeln]
    POSNR,          -- Item [posnr]
    PSPNR,          -- WBS element [wb_posnr]
    SBDKZ,          -- Indiv./ Coll. [sbdkz]
    MLMAA,          -- ML Act. [ck_ml_maac]
    BESKZ,          -- Procurement [beskz]
    DISST,          -- Low-Level Code [disst]
    KALST,          -- Costing Level [ck_kalst]
    TEMPLATE,       -- Template [abc_templ]
    PATNR,          -- Partner number [nkprtn]
    PART_VRSN,      -- Partner Version [ck_parvrsn]
    ELEHK,          -- Cost Comp. Str. [ck_elesmhk]
    ELEHKNS,        -- Cost Comp. Str. [ck_elesmns]
    VOCNT,          -- No. Markings [ck_vocnt]
    GSBER,          -- Business Area [gsber]
    PRCTR,          -- Profit Center [prctr]
    SEGUNIT,        -- Segmentation Unit [fins_segmentation_unit]
    HWAER,          -- Local Currency [hwaer]
    FWAER_KPF,      -- Currency [waers]
    REFID,          -- Reference Var. [ck_refid]
    MEINH_WS,       -- Bch-specific Un [lrmei_ws]
    KZWSO,          -- Units meas. use [kzwso]
    ASL,            -- OrderBOMCostEst [ck_asl]
    KALAID,         -- Costing Run [ck_kalaid]
    KALADAT,        -- Cstg Run Date [ck_kaladat]
    OTYP,           -- Object Type [ckml_otyp]
    BVC_SOBSL_USE,  -- Special Proc. P2P [ck_bvc_sobsl_use]
    BAPI_CREATED,   -- BAPI Cost Est. [ck_bapi]
    SGT_SCAT,       -- Stock Segment [sgt_scat]
    UCB_ID,         -- Breakdown ID [fucb_id]
    PRIMARY KEY (MANDT, BZOBJ, KALNR, KALKA, KADKY, TVERS, BWVAR, KKZMA)
);

Learn More