SAP table KAKO (Capacity Header Segment)

SAP table KAKO has 2 primary key fields being MANDT,KAPID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KAPID Capacity ID NUMC 8 0 KAPID
AZMAX Number of Individual Capacities INT2 5 0 KAPANZAHL
AZNOR Number of Individual Capacities INT2 5 0 KAPANZAHL
BASNE Denominator of the base capacity DEC 5 0 KAPBASNEN
BASZL Numerator for base capacity DEC 5 0 KAPBASZHL
BEGZT Start time in seconds (internal) INT4 10 0 KAPBEGZT
BRGRU Authorization Group CHAR 4 0 BRGRU
ENDZT End Time in Seconds (internal) INT4 10 0 KAPENDZT
KALID Factory Calendar ID CHAR 2 0 TFACD CR_WFCID
KAPAR Capacity category CHAR 3 0 TC26 KAPART
MEINS Capacity Base Unit of Measure UNIT 3 0 T006 KAPBASIS
MOSID Grouping for Shift Definitions and Shift Sequences CHAR 2 0 TC39A SCHGRUP
NAME Capacity name CHAR 8 0 KAPNAME
NGRAD Capacity Utilization Ratio in Percent NUMC 3 0 NUTZGRAD
PAUSE Cumulative Break Duration in Seconds (internal) INT4 10 0 KAPPAUSE
PLANR Capacity Responsible Planner Group CHAR 3 0 TC27 KAPPLANER
POOLK Pooled Capacity Indicator CHAR 1 0 KAP_KZPOOL
REFAN Denominator relationship: No. of indiv. capacities reference INT1 3 0 KAPREFANZN
REFAZ Numerator relationships: No. of indiv. capacities reference INT1 3 0 KAPREFANZZ
REFID Capacity ID NUMC 8 0 KAKO KAPID
SUPPK Available capacity limits CHAR 1 0 KAP_SUPPLY
0 unlimited
1 limited
2 finally
VERSA Active Version of Available Capacity NUMC 2 0 TC36 KAPVERSAKT
WERKS Plant CHAR 4 0 T001W WERKS_D
KAPIE Capacity ID NUMC 8 0 KAKO KAPID
KAPTER Indicator: Capacity Relevant to Finite Scheduling CHAR 1 0 KAP_KZTER
KAPAVO Indicator: Several operations can use capacity CHAR 1 0 KAP_KZAVO
UEBERLAST Overload NUMC 3 0 UEBERLAST
KAPLPL Indicator: Capacity Excluded From Long-Term Planning CHAR 1 0 KAP_KZLPL
KAPEH Capacity Unit of Measure UNIT 3 0 T006 CR_KAPEH
MEHR Has Individual Capacities CHAR 1 0 KAP_MEHR
ANG_UNIT Unit for available capacity UNIT 3 0 KAPAZIT_VM_UNIT
ANG_MIN Minimum capacity in volume unit or unit of measure QUAN 13 3 KAPAZIT_VM_MIN
ANG_MAX Maximum capacity in volume unit or unit of measure QUAN 13 3 KAPAZIT_VM_MAX
LASTCHANGE_DATETIME Capacity Last Change Date Time DEC 21 7 KAP_LASTCHANGE_DATETIME
TYPE Resource Type NUMC 2 0 CRES_RESOURCETYPE
01 Multiactivity Resource
02 Single-Activity Resource
04 Single Mixed Resource
05 Multimixed Resource
06 Single Line Resource
07 Single Mixed Line Resource
10 Calendar Resource
11 Calendar Mixed Resource
RESTYPE Resource Category CHAR 1 0 CRES_RESOURCE_CATEGORY
CAPACITY_A Capacity of Bucket Resource QUAN 13 3 CRES_CAPACITYV1_DISP
CAPACITY_A_UNIT Unit of Measurement for the Capacity of a Bucket Resource UNIT 3 0 * CRES_CAPACITYV_UNIT
NUM_OF_PERIODS Number of Periods to Which the Capacity Refers NUMC 3 0 CRES_NUM_OF_PERIODS
PERIOD Period Type NUMC 2 0 CRES_PERIOD
01 No Period Reference
02 Day
BUFFERTIME Resource-Dependent Time Buffer INT4 10 0 CRES_BUFFERTIME
BUFFERTIME_UNIT Unit of Measurement for Time Buffer UNIT 3 0 * CRES_BUFFERTIME_UNIT
IS_BOTTLENECK This Resource is a Bottleneck Resource CHAR 1 0 CRES_BOTTLENECK
UNDERLOAD Minimum Capacity Load for the Resource NUMC 3 0 CRES_UNDERLOAD
OVERLAP_BUCKETS Activities can Overlap into Another Period CHAR 1 0 CRES_OVERLAP_BUCKETS
START_ON_GRID Activities can Only Begin at the Start of the Bucket CHAR 1 0 CRES_START_ON_GRID
MIN_OVERLAP Maximum Overlap of Activities INT4 10 0 CRES_MIN_OVERLAP
MIN_OVERLAP_UNIT Unit of Measurement for Maximum Overlap of Two Activities UNIT 3 0 * CRES_MIN_OVERLAP_UNIT
LOSS_FACTOR Loss Factor in Percent when Deriving Bucket Capacity NUMC 3 0 CRES_LOSS_FACTOR
SORT Freely Selectable Character Sequence for Sorting Resources CHAR 30 0 CRES_SORT
SYNC_START Synchronization of Activities when Overlapping Occurs NUMC 1 0 CRES_SYNC_START
0 No Synchronization
2 Synchronization
DEFINE_BUCKETS Definition of the Bucket Capacity of a Mixed Resource CHAR 1 0 CRES_DEFINE_BUCKETS
LC_DAYS_MINUS Validity of Available Capacity (In Past) NUMC 4 0 CRES_GEN_LC_BACKWARDS
LC_DAYS_PLUS Validity of Available Resource Capacity (In the Future) NUMC 4 0 CRES_GEN_LC_FORWARD
STORAGE_CAPABLE Resource has Storage Characteristics CHAR 1 0 CRES_STORAGE_CAPABLE
MIN_STORAGE Minimum Production Quantity QUAN 15 3 CRES_MIN_STORAGE
MAX_STORAGE Maximum Stock Level QUAN 15 3 CRES_MAX_STORAGE
STORAGE_UNIT Stock Unit UNIT 3 0 * CRES_STORAGE_UNIT
DIM_STORAGE Dimension of Storage Characteristic of a Resource CHAR 6 0 T006D CRES_DIMENSION_STORAGE
STORAGE_TO_ZERO Handling of Remaining Fill Level CHAR 1 0 CRES_STORAGE_TO_ZERO
SNPLC Resource is not Relevant to SNP CHAR 1 0 CRES_SNPLC
UTIL_BUCKET Utilization Rate for Bucket-Oriented Capacity [%] DEC 6 3 CRES_UTIL_BUCKET
CAMPAIGN_PPDS Resource is Campaign-Relevant CHAR 1 0 CRES_CAMPAIGN_PPDS
CAMPAIGN_SNP Cross-Period Lot Sizes CHAR 1 0 CRES_CAMPAIGN_SNP
No Cross-Period Lot-Size Planning
S Sequence-Dependent Lot-Size Planning
X Cross-Period Lot Size Planning
TSTREAM_EXTERNAL Capacity Data for Time Stream Originates in External System CHAR 1 0 CRES_TSTREAM_EXTERNAL
FINITY_LEVEL Finiteness Level of Resource NUMC 4 0 CRES_FINITY_LEVEL
BR_QUANT Number of Units of Measure for Base Rate QUAN 13 3 CRES_BASE_RATE
BR_QUNIT Unit of Measure for Production Rate UNIT 3 0 * CRES_RATE_QUNIT
BR_TIME Number of Time Units for Production Rate QUAN 5 2 CRES_RATE_TIME
BR_TUNIT Time Unit of Production Rate UNIT 3 0 * CRES_RATE_TUNIT
RITT_FLG /SAPAPO/RITT_FLG CHAR 1 0 CRES_RITT_FLG
MDRMODEL Defintion Name for the Product-Dependent Rate CHAR 40 0 CRES_MDR_NAME
PP_DEF_BUCKETS Definition of PP/DS Bucket Capacity CHAR 1 0 CRES_PP_DEFINE_BUCKETS
No PP/DS Available Bucket Capacity
B From Block Planning
T From Time-Continuous Capacity
PP_BUCKET_SCHEMA PP/DS Bucket Schema NUMC 2 0 CRES_PP_BUCKET_SCHEMA
01 Shift
02 Day (Shift Start)
03 Day (Start 00:00)
04 Week (from Monday)
05 Week (from Tuesday)
06 Week (from Wednesday)
07 Week (from Thursday)
08 Week (from Friday)
09 Week (from Saturday)
10 Week (from Sunday)
11 Japanese Ten Days
12 Month
PP_BUCKET_FACT Factor: Relation. of Avl. Bucket Cap. to Avl. Time-Cont Cap. NUMC 3 0 CRES_PP_BUCKET_FACTOR
MIX_PLAN_TYPE Finite Capacity of a Mixed Resource NUMC 1 0 CRES_MIX_PLAN_TYPE
0 Time-Continuous Capacity
1 Bucket Capacity

KAKO foreign key relationships

Table Field Check Table Check Field
0 KAKO DIM_STORAGE T006D Dimensions DIMID
1 KAKO KAPAR TC26 Capacity category MANDT
0 KAKO KAPEH T006 Units of Measurement MANDT
1 KAKO KAPIE KAKO Capacity Header Segment MANDT
0 KAKO MANDT T000 Clients MANDT
1 KAKO MEINS T006 Units of Measurement MANDT
1 KAKO MEINS T006 Units of Measurement MSEHI
0 KAKO MOSID TC39A Grouping shift definitions and shift sequences MANDT
0 KAKO MOSID TC39A Grouping shift definitions and shift sequences SCHGRUP
1 KAKO PLANR TC27 Capacity planner groups MANDT
1 KAKO PLANR TC27 Capacity planner groups PLANR
0 KAKO REFID KAKO Capacity Header Segment MANDT
1 KAKO VERSA TC36 Available capacity version MANDT
1 KAKO VERSA TC36 Available capacity version VERSN
0 KAKO WERKS T001W Plants/Branches MANDT
0 KAKO WERKS T001W Plants/Branches WERKS