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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
FRFLG
Release Flag
|
FRFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
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 | MANDT |
TCURC
Currency Codes
|
MANDT |
| CKBS | HWAER | CKBS | HWAER |
TCURC
Currency Codes
|
WAERS |
| CKBS | INLND | CKBS | INLND |
T005
Countries
|
LAND1 |
| CKBS | INLND | CKBS | MANDT |
T005
Countries
|
MANDT |
| CKBS | KLVAR | CKBS | MANDT |
TCK03
Costing Variants
|
MANDT |
| CKBS | KLVAR | CKBS | KLVAR |
TCK03
Costing Variants
|
KLVAR |
| CKBS | KOKRS | CKBS | KOKRS |
TKA01
Controlling Areas
|
KOKRS |
| CKBS | KOKRS | CKBS | MANDT |
TKA01
Controlling Areas
|
MANDT |
| 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 | REGIO |
T005S
Taxes: Region (Province) Key
|
BLAND |
| CKBS | REGIO | CKBS | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| CKBS | REGIO | CKBS | LAND1 |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| CKBS | WERKS | CKBS | MANDT |
T001W
Plants/Branches
|
MANDT |
| CKBS | WERKS | CKBS | WERKS |
T001W
Plants/Branches
|
WERKS |