1. Home
  2. Resources
  3. SAP Tables
  4. CKBS - Base Planning Object - Unit Costing

SAP Table CKBS

Base Planning Object - Unit Costing

CKBS (Base Planning Object - Unit Costing) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CKBS to other SAP tables.

CKBS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
EXTNR Base Planning Object (External Number) EXTNR CHAR 18 0
OBJID Cost Estimate Number OBJID CHAR 10 0
KSTAR Cost Element KSTAR CHAR 10 0
BUKRS Company Code BUKRS T001 CHAR 4 0
WERKS Plant WERKS_D T001W CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
ESORT External Sort Field ESORT CHAR 4 0
BTGRP Base Planning Object Group BTGRP TCK40 CHAR 4 0
ERFNM Entered by ERFNM CHAR 12 0
ERFDT Created on ERFDT DATS 8 0
AENDT Date of last change AENDT DATS 8 0
AENNM Last changed by AENNM CHAR 12 0
DLFLG Deletion Flag for Unit Costing DLFLG CHAR 1 0
NULL no
X yes
FRFLG Release Flag FRFLG CHAR 1 0
NULL no
X yes
VERSA Current Costing Version Transferred VERS_AKT NUMC 2 0
VERSM Highest Costing Version Transferred VERS_MAX NUMC 2 0
HWGES Total Value of Cost Estimate in Local Currency HWGES CURR 15 2
HWAER Local Currency HWAER TCURC CUKY 5 0
LOSGR Lot Size MENGE_KPF QUAN 15 3
MEEHT Base Unit of Measure MEINS T006 UNIT 3 0
PREIS Price per Unit of Measure Calculated in Cost Estimate SPREIS CURR 15 2
ANRED Title ANRED CHAR 15 0
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
NAME3 Name 3 NAME3_GP CHAR 35 0
NAME4 Name 4 NAME4_GP CHAR 35 0
STRAS House number and street STRAS_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
LAND1 Country Key LAND1 T005 CHAR 3 0
PSTLZ Postal Code PSTLZ CHAR 10 0
ORT01 City ORT01_GP CHAR 35 0
ORT02 City ORT01_GP CHAR 35 0
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
INLND Country Key LAND1 T005 CHAR 3 0
ANZZL 3-figure data element KKEK_DEC3 DEC 3 0
WAREN Delivery address ID WAREN CHAR 1 0
LINE0 Address line LINES CHAR 80 0
LINE1 Address line LINES CHAR 80 0
LINE2 Address line LINES CHAR 80 0
LINE3 Address line LINES CHAR 80 0
LINE4 Address line LINES CHAR 80 0
LINE5 Address line LINES CHAR 80 0
LINE6 Address line LINES CHAR 80 0
LINE7 Address line LINES CHAR 80 0
LINE8 Address line LINES CHAR 80 0
LINE9 Address line LINES CHAR 80 0
LINEK Address line LINES CHAR 80 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
KLVAR Costing Variant CK_KLVAR TCK03 CHAR 4 0
KALSM Costing Sheet AUFKALSM CHAR 6 0
ZSCHL Overhead key AUFZSCHL CHAR 6 0
HWGFX Fixed Portion of Costing Value in Local Currency HWFIX CURR 15 2

CKBS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CKBS BTGRP SYST MANDT TCK40 Base Planning Object Group MANDT
CKBS BTGRP CKBS KOKRS TCK40 Base Planning Object Group KOKRS
CKBS BTGRP CKBS BTGRP TCK40 Base Planning Object Group BTGRP
CKBS BUKRS CKBS MANDT T001 Company Codes MANDT
CKBS BUKRS CKBS BUKRS T001 Company Codes BUKRS
CKBS HWAER CKBS HWAER TCURC Currency Codes WAERS
CKBS HWAER CKBS MANDT TCURC Currency Codes MANDT
CKBS INLND CKBS MANDT T005 Countries MANDT
CKBS INLND CKBS INLND T005 Countries LAND1
CKBS KLVAR CKBS KLVAR TCK03 Costing Variants KLVAR
CKBS KLVAR CKBS MANDT TCK03 Costing Variants MANDT
CKBS KOKRS CKBS MANDT TKA01 Controlling Areas MANDT
CKBS KOKRS CKBS KOKRS TKA01 Controlling Areas KOKRS
CKBS LAND1 CKBS MANDT T005 Countries MANDT
CKBS LAND1 CKBS LAND1 T005 Countries LAND1
CKBS MANDT CKBS MANDT T000 Clients MANDT
CKBS MEEHT CKBS MANDT T006 Units of Measurement MANDT
CKBS MEEHT CKBS MEEHT T006 Units of Measurement MSEHI
CKBS REGIO CKBS LAND1 T005S Taxes: Region (Province) Key LAND1
CKBS REGIO CKBS REGIO T005S Taxes: Region (Province) Key BLAND
CKBS REGIO CKBS MANDT T005S Taxes: Region (Province) Key MANDT
CKBS WERKS CKBS WERKS T001W Plants/Branches WERKS
CKBS WERKS CKBS MANDT T001W Plants/Branches MANDT