CKIS

Transparent Table Application Table
144 Fields 2 CDS Views

Positionen Einzelkalkulation/Einzelnachweis Erz.kalkulatio

CKIS is an SAP database table in S/4HANA. Positionen Einzelkalkulation/Einzelnachweis Erz.kalkulatio. It contains 144 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FCO_COST_EST_KEKO_VBAP_SDM view left_outer PCC: Cost Estimate with Origin Sales Doc
P_CKIS view_entity from BASIC Private View - CKIS

Fields (144)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY lednr lednr Ledger
KEY bzobj ck_obj Reference Obj.
KEY kalnr ck_kalnr Cost EstimateNo
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
KEY posnr ck_posnr Item Number
statp statp_d Status
strgp strgp Control
typps typps Item Category
kstar kstar Cost Element
kstar_manual ck_cost_element_manual CElem Manual Chg
hrkft hrkft Origin Group
elemt ck_elemenths Component
elemtns ck_elementns Component
fvflg fvflg Fixed/Variable
opcod opcod Operation
frlnr forml_ek Formula Number
bukrs bukrs Company Code
werks werks_d Plant
matnr matnr Material
pschl pschl Pricing Key
kokrs_hrk kokrs_hrk CO Area
extnr extnr Base Object
gpreis ck_kpt Price/CAC
fpreis ck_kpf Fxd Price/CAC
peinh ck_kpeinh Price Unit/CACurr
pmeht pmeht Price Qty Unit
price_manual ck_price_manual Manual Price
wertb ck_kwt Value COCurr
wertn ck_kwt Value COCurr
wrtfx ck_kwf FixValue COCurr
wrtfw_kpf ck_owt Value ObjCurr
wrtfw_kfx ck_owf Fixed Value/OC
fwaer_kpf ck_owaer Object Currency
wrtfw_pos ck_twt Value TranCurr
wrtfw_pfx ck_twf Fixed Value/TC
fwaer ck_twaer Transaction Curr.
mkurs mkurs Average rate
fweht einht_cur Currency unit
menge menge_pos Quantity
meeht meins Base Unit
summ1 summe_mng QtyTotalItmCatS
summ2 summe_inv CapSpendTotCatS
summ3 summe_pos Items total
dpreis dpreis Average price
preis1 preis1 DeltaProf Legal
preis2 preis2 DeltaProf Legal
preis3 preis3 Delta Prof PCtr
preis4 preis4 Delta Prof PCtr
preis5 preis5 Price Comp. 5
pfkt1 pfktx Factor
pfkt2 pfktx Factor
pfkt3 pfktx Factor
pfkt4 pfktx Factor
pfkt5 pfktx Factor
zuabs dzuabs Abs. overhead
zufkt dzufkt Overhead factor
psknz psknz LotSzIndep.Ind.
sbdkz sbdkz Indiv./ Coll.
vtknz vtknz Distrib. Ind.
lstar lstar Activity Type
arbid objektid Object ID
kostl kostl Cost Center
infnr infnr Info Record
ekorg ekorg Purchasing Org.
esokz esokz Infotype
lifnr lifnr Supplier
ebeln ebeln Purchasing Doc.
ebelp ebelp Item
steus ck_steus Control Key
fxpru ck_fixprku Fixed-Price Co-Prod.
stpos ck_aequi4 Equivalence No.
afakt ck_splitfac Apportmt Factor
bwtar bwtar_d Valuation Type
mkalk ck_mkalk Mixed Costing
btyp ckml_btyp Process Cat.
kalnr_ba ckkalnrba Procurement Alt.
misch_verh ck_crossr Mixing Ratio
umrez umbsz Equal To
umren umbsn Denominator
ausmg ck_ausmg Scrap Quantity
ausmgko ck_ausmgko Comp. Scrap
ausproz ck_scrap Scrap (%)
aplzl ck_count Counter
vornr vornr Activity
uvorn uvorn Suboperation
steas ck_steas TgtStDate of Op
posnr_ext ck_posext Item Number
pointer1 ck_pos_poi Pointer 1
pointer2 ck_pos_poi Pointer 1
pointer3 ck_pos_poi Pointer 1
opreis ck_opt Price/Obj. Cur.
opreifx ck_opf Fxd Price/OC
tpreis ck_tpt Price/TCurrency
tpreifx ck_tpf Fxd Price/TC
patnr nkprtn Partner number
verws ck_verweis Reference of KALKTAB Items to a Context
prskz ck_prskz Price
rldnr fins_ledger Ledger
strat ck_strat Strategy
substrat ck_substrat Substr.InfoRec.
catergory fcom_category Plan Category
tkurs tkurs Item Exch. Rate
selkz ck_selkz CostingRelevncy
vrggrp ck_vrggrp Transac. Group
kkzmm kkzmm Additive Costs
ssedd ssedd Lat.finish date
fehlkz ck_fehlkz ErrInd
no_ccsplit ck_no_ccsplit No CostCompSplt
schkz ck_schkzhs Main CComp Splt
schkzns ck_schkzns Aux. Cost Split
ufield_mode ck_ufield_mode Specified Trans
ukaln ck_ukaln Cost Est Number
ukalka ck_ukalka Costing Type
ukadky ck_ukadky Costing Date
utvers ck_utvers Costing Version
ubwvar ck_ubwvar Val. Variant
hkmat hkmat Material origin
sposn sposn Item
ustrat ck_uebper1 Strategy 1
baugr ck_baugr Assembly
asnum asnum Activity number
peinh_2 peinh Price unit
peinh_3 peinh Price unit
prznr co_prznr Business Process
nlag ck_nlag NSM
prctr prctr Profit Center
tptyp fvc_tptyp Transfer Price Type
segunit fins_segmentation_unit Segmentation Unit
gsber gsber Business Area
pspnr wb_posnr WBS element
parob parob Partner Object
kzanw ck_kzanw Overhead Costs
kzlb ck_kzlb Subcontracted
subkey co_subkey CO subkey
kzwso kzwso Units meas. use
disst disst Low-Level Code
cuobj ck_cuobj Object Number
gentyp ck_gentyp Generation Type
component_id ck_component_id Pointer Itemiz.

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.

-- Positionen Einzelkalkulation/Einzelnachweis Erz.kalkulatio
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CKIS (
    MANDT,         -- Client [mandt]
    LEDNR,         -- Ledger [lednr]
    BZOBJ,         -- Reference Obj. [ck_obj]
    KALNR,         -- Cost EstimateNo [ck_kalnr]
    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]
    POSNR,         -- Item Number [ck_posnr]
    STATP,         -- Status [statp_d]
    STRGP,         -- Control [strgp]
    TYPPS,         -- Item Category [typps]
    KSTAR,         -- Cost Element [kstar]
    KSTAR_MANUAL,  -- CElem Manual Chg [ck_cost_element_manual]
    HRKFT,         -- Origin Group [hrkft]
    ELEMT,         -- Component [ck_elemenths]
    ELEMTNS,       -- Component [ck_elementns]
    FVFLG,         -- Fixed/Variable [fvflg]
    OPCOD,         -- Operation [opcod]
    FRLNR,         -- Formula Number [forml_ek]
    BUKRS,         -- Company Code [bukrs]
    WERKS,         -- Plant [werks_d]
    MATNR,         -- Material [matnr]
    PSCHL,         -- Pricing Key [pschl]
    KOKRS_HRK,     -- CO Area [kokrs_hrk]
    EXTNR,         -- Base Object [extnr]
    GPREIS,        -- Price/CAC [ck_kpt]
    FPREIS,        -- Fxd Price/CAC [ck_kpf]
    PEINH,         -- Price Unit/CACurr [ck_kpeinh]
    PMEHT,         -- Price Qty Unit [pmeht]
    PRICE_MANUAL,  -- Manual Price [ck_price_manual]
    WERTB,         -- Value COCurr [ck_kwt]
    WERTN,         -- Value COCurr [ck_kwt]
    WRTFX,         -- FixValue COCurr [ck_kwf]
    WRTFW_KPF,     -- Value ObjCurr [ck_owt]
    WRTFW_KFX,     -- Fixed Value/OC [ck_owf]
    FWAER_KPF,     -- Object Currency [ck_owaer]
    WRTFW_POS,     -- Value TranCurr [ck_twt]
    WRTFW_PFX,     -- Fixed Value/TC [ck_twf]
    FWAER,         -- Transaction Curr. [ck_twaer]
    MKURS,         -- Average rate [mkurs]
    FWEHT,         -- Currency unit [einht_cur]
    MENGE,         -- Quantity [menge_pos]
    MEEHT,         -- Base Unit [meins]
    SUMM1,         -- QtyTotalItmCatS [summe_mng]
    SUMM2,         -- CapSpendTotCatS [summe_inv]
    SUMM3,         -- Items total [summe_pos]
    DPREIS,        -- Average price [dpreis]
    PREIS1,        -- DeltaProf Legal [preis1]
    PREIS2,        -- DeltaProf Legal [preis2]
    PREIS3,        -- Delta Prof PCtr [preis3]
    PREIS4,        -- Delta Prof PCtr [preis4]
    PREIS5,        -- Price Comp. 5 [preis5]
    PFKT1,         -- Factor [pfktx]
    PFKT2,         -- Factor [pfktx]
    PFKT3,         -- Factor [pfktx]
    PFKT4,         -- Factor [pfktx]
    PFKT5,         -- Factor [pfktx]
    ZUABS,         -- Abs. overhead [dzuabs]
    ZUFKT,         -- Overhead factor [dzufkt]
    PSKNZ,         -- LotSzIndep.Ind. [psknz]
    SBDKZ,         -- Indiv./ Coll. [sbdkz]
    VTKNZ,         -- Distrib. Ind. [vtknz]
    LSTAR,         -- Activity Type [lstar]
    ARBID,         -- Object ID [objektid]
    KOSTL,         -- Cost Center [kostl]
    INFNR,         -- Info Record [infnr]
    EKORG,         -- Purchasing Org. [ekorg]
    ESOKZ,         -- Infotype [esokz]
    LIFNR,         -- Supplier [lifnr]
    EBELN,         -- Purchasing Doc. [ebeln]
    EBELP,         -- Item [ebelp]
    STEUS,         -- Control Key [ck_steus]
    FXPRU,         -- Fixed-Price Co-Prod. [ck_fixprku]
    STPOS,         -- Equivalence No. [ck_aequi4]
    AFAKT,         -- Apportmt Factor [ck_splitfac]
    BWTAR,         -- Valuation Type [bwtar_d]
    MKALK,         -- Mixed Costing [ck_mkalk]
    BTYP,          -- Process Cat. [ckml_btyp]
    KALNR_BA,      -- Procurement Alt. [ckkalnrba]
    MISCH_VERH,    -- Mixing Ratio [ck_crossr]
    UMREZ,         -- Equal To [umbsz]
    UMREN,         -- Denominator [umbsn]
    AUSMG,         -- Scrap Quantity [ck_ausmg]
    AUSMGKO,       -- Comp. Scrap [ck_ausmgko]
    AUSPROZ,       -- Scrap (%) [ck_scrap]
    APLZL,         -- Counter [ck_count]
    VORNR,         -- Activity [vornr]
    UVORN,         -- Suboperation [uvorn]
    STEAS,         -- TgtStDate of Op [ck_steas]
    POSNR_EXT,     -- Item Number [ck_posext]
    POINTER1,      -- Pointer 1 [ck_pos_poi]
    POINTER2,      -- Pointer 1 [ck_pos_poi]
    POINTER3,      -- Pointer 1 [ck_pos_poi]
    OPREIS,        -- Price/Obj. Cur. [ck_opt]
    OPREIFX,       -- Fxd Price/OC [ck_opf]
    TPREIS,        -- Price/TCurrency [ck_tpt]
    TPREIFX,       -- Fxd Price/TC [ck_tpf]
    PATNR,         -- Partner number [nkprtn]
    VERWS,         -- Reference of KALKTAB Items to a Context [ck_verweis]
    PRSKZ,         -- Price [ck_prskz]
    RLDNR,         -- Ledger [fins_ledger]
    STRAT,         -- Strategy [ck_strat]
    SUBSTRAT,      -- Substr.InfoRec. [ck_substrat]
    CATERGORY,     -- Plan Category [fcom_category]
    TKURS,         -- Item Exch. Rate [tkurs]
    SELKZ,         -- CostingRelevncy [ck_selkz]
    VRGGRP,        -- Transac. Group [ck_vrggrp]
    KKZMM,         -- Additive Costs [kkzmm]
    SSEDD,         -- Lat.finish date [ssedd]
    FEHLKZ,        -- ErrInd [ck_fehlkz]
    NO_CCSPLIT,    -- No CostCompSplt [ck_no_ccsplit]
    SCHKZ,         -- Main CComp Splt [ck_schkzhs]
    SCHKZNS,       -- Aux. Cost Split [ck_schkzns]
    UFIELD_MODE,   -- Specified Trans [ck_ufield_mode]
    UKALN,         -- Cost Est Number [ck_ukaln]
    UKALKA,        -- Costing Type [ck_ukalka]
    UKADKY,        -- Costing Date [ck_ukadky]
    UTVERS,        -- Costing Version [ck_utvers]
    UBWVAR,        -- Val. Variant [ck_ubwvar]
    HKMAT,         -- Material origin [hkmat]
    SPOSN,         -- Item [sposn]
    USTRAT,        -- Strategy 1 [ck_uebper1]
    BAUGR,         -- Assembly [ck_baugr]
    ASNUM,         -- Activity number [asnum]
    PEINH_2,       -- Price unit [peinh]
    PEINH_3,       -- Price unit [peinh]
    PRZNR,         -- Business Process [co_prznr]
    NLAG,          -- NSM [ck_nlag]
    PRCTR,         -- Profit Center [prctr]
    TPTYP,         -- Transfer Price Type [fvc_tptyp]
    SEGUNIT,       -- Segmentation Unit [fins_segmentation_unit]
    GSBER,         -- Business Area [gsber]
    PSPNR,         -- WBS element [wb_posnr]
    PAROB,         -- Partner Object [parob]
    KZANW,         -- Overhead Costs [ck_kzanw]
    KZLB,          -- Subcontracted [ck_kzlb]
    SUBKEY,        -- CO subkey [co_subkey]
    KZWSO,         -- Units meas. use [kzwso]
    DISST,         -- Low-Level Code [disst]
    CUOBJ,         -- Object Number [ck_cuobj]
    GENTYP,        -- Generation Type [ck_gentyp]
    COMPONENT_ID,  -- Pointer Itemiz. [ck_component_id]
    PRIMARY KEY (MANDT, LEDNR, BZOBJ, KALNR, KALKA, KADKY, TVERS, BWVAR, KKZMA, POSNR)
);

Learn More