CKBS SAP (Base Planning Object - Unit Costing) Table details

Dictionary Type: Table
Description: Base Planning Object - Unit Costing




ABAP Code to SELECT data from CKBS
Related tables to CKBS
Access table CKBS




Table field list including key, data, relationships and ABAP select examples

CKBS is a standard SAP Table which is used to store Base Planning Object - Unit Costing data and is available within R/3 SAP systems depending on the version and release level.

The CKBS table consists of various fields, each holding specific information or linking keys about Base Planning Object - Unit Costing data available in SAP. These include KOKRS (Controlling Area), EXTNR (Base Planning Object (External Number)), OBJID (Cost Estimate Number), KSTAR (Cost Element).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = CKBT


SAP CKBS table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
EXTNRBase Planning Object (External Number) EXTNRCHAR18ALPHAEXTNREBT
OBJIDCost Estimate Number OBJIDCHAR10OBJID
KSTARCost Element KSTARCHAR10Assigned to domainALPHAKSTARKAT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
ESORTExternal Sort Field ESORTCHAR4STATE
BTGRPBase Planning Object Group BTGRPCHAR4TCK40CHAR4
ERFNMEntered by ERFNMCHAR12USNAM
ERFDTCreated on ERFDTDATS8DATUM
AENDTDate of last change AENDTDATS8DATUM
AENNMLast changed by AENNMCHAR12USNAM
DLFLGDeletion Flag for Unit Costing DLFLGCHAR1YNFLG
FRFLGRelease Flag FRFLGCHAR1YNFLG
VERSACurrent Costing Version Transferred VERS_AKTNUMC2Assigned to domainVERS2
VERSMHighest Costing Version Transferred VERS_MAXNUMC2Assigned to domainVERS2
HWGESTotal Value of Cost Estimate in Local Currency HWGESCURR15(2) CVAL8
HWAERLocal Currency HWAERCUKY5TCURCWAERS
LOSGRLot Size MENGE_KPFQUAN15(3) CQUA8
MEEHTBase Unit of Measure MEINSUNIT3T006CUNITMEINS
PREISPrice per Unit of Measure Calculated in Cost Estimate SPREISCURR15(2) CVAL8
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
NAME3Name 3 NAME3_GPCHAR35NAME
NAME4Name 4 NAME4_GPCHAR35NAME
STRASHouse number and street STRAS_GPCHAR35TEXT35
PFACHPO Box PFACHCHAR10PFACH
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
LAND1Country Key LAND1CHAR3T005LAND1LND
PSTLZPostal Code PSTLZCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
ORT02City ORT01_GPCHAR35TEXT35
REGIOSTATE (State, Province, County) REGIOCHAR3T005SREGIO
INLNDCountry Key LAND1CHAR3T005LAND1LND
ANZZL3-figure data element KKEK_DEC3DEC3KKEK_DEC3
WARENDelivery address ID WARENCHAR1WAREN
LINE0Address line LINESCHAR80LINES
LINE1Address line LINESCHAR80LINES
LINE2Address line LINESCHAR80LINES
LINE3Address line LINESCHAR80LINES
LINE4Address line LINESCHAR80LINES
LINE5Address line LINESCHAR80LINES
LINE6Address line LINESCHAR80LINES
LINE7Address line LINESCHAR80LINES
LINE8Address line LINESCHAR80LINES
LINE9Address line LINESCHAR80LINES
LINEKAddress line LINESCHAR80LINES
KALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12Assigned to domainCK_KALNRKNR
KLVARCosting Variant CK_KLVARCHAR4TCK03KLVARKRT
KALSMCosting Sheet AUFKALSMCHAR6Assigned to domainKALSM
ZSCHLOverhead key AUFZSCHLCHAR6CHAR6
HWGFXFixed Portion of Costing Value in Local Currency HWFIXCURR15(2) CVAL8

Key field Non-key field



How do I retrieve data from SAP table CKBS using ABAP code

The following ABAP code Example will allow you to do a basic selection on CKBS to SELECT all data from the table
DATA: WA_CKBS TYPE CKBS.

SELECT SINGLE *
FROM CKBS
INTO CORRESPONDING FIELDS OF WA_CKBS
WHERE...

How to access SAP table CKBS

Within an ECC or HANA version of SAP you can also view further information about CKBS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!