SAP table KBED (Capacity Requirements Records)

SAP table KBED has 4 primary key fields being MANDT,BEDID,BEDZL,CANUM.

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
BEDID ID of the Capacity Requirements Record NUMC 12 0 KBKO BEDID
BEDZL Internal counter NUMC 8 0 CIM_COUNT
CANUM Counters for cap. rqmts. records (various caps. + indiv.caps NUMC 4 0 CY_COUNT
ARBID Work Center ID NUMC 8 0 ARBPLATZ
TYPKZ Category of object causing the load (order category) CHAR 1 0 TYPKZ
1 Work orders (detailed scheduling / routing...)
2 Planned orders (detailed scheduling / routing...)
3 SOP-Order (detailed scheduling / routing...)
A Maintenance task
B Maintenance messages
OBJKZ Indicator: Remaining split record CHAR 1 0 OBJKZ
X Remaining split record
KAPID Capacity ID NUMC 8 0 KAKO KAPID
BEDKZ Indicator: Remaining split record CHAR 1 0 BEDKZ
KRUESOLL Scheduled Capacity Requirements for Setup FLTP 16 16 CY_KRUESOL
KRUEREST Remaining Capacity Requirements for Setup FLTP 16 16 CY_KRUERES
KBEASOLL Scheduled Capacity Requirements for Processing FLTP 16 16 CY_KBEASOL
KBEAREST Remaining Capacity Requirements for Processing FLTP 16 16 CY_KBEARES
KABRSOLL Scheduled Capacity Requirements for the Teardown FLTP 16 16 CY_KABRSOL
KABRREST Remaining Capacity Requirements for Teardown FLTP 16 16 CY_KABRRES
KEINH Unit of Measure for Capacity Requirements UNIT 3 0 T006 CY_KEINH
FSTAD Earliest Start Date DATS 8 0 FSTAD
FSTAU Earliest Start Time TIMS 6 0 FSTAU
FENDD Earliest End Date DATS 8 0 FENDD
FENDU Earliest End Time TIMS 6 0 FENDU
SSTAD Latest Start Date DATS 8 0 SSTAD
SSTAU Latest Start Time TIMS 6 0 SSTAU
SENDD Latest End Date DATS 8 0 SENDD
SENDU Latest End Time TIMS 6 0 SENDU
ISTAD Actual Start Date DATS 8 0 ISTAD
ISTAU Actual Start Time TIMS 6 0 ISTAU
IENDD Actual End Date DATS 8 0 IENDD
IENDU Actual End Time TIMS 6 0 IENDU
PENDD Forecast End Date DATS 8 0 PENDD
PENDU Forecast End Time TIMS 6 0 PENDU
ISPLI Actual Number of Splits DEC 3 0 ISPLI
KPVER Distribution of Capacity Requirements (Planned/Prodn Order) CHAR 8 0 TC29 CR_VERTL
OBSTA Object status (order status) CHAR 22 0 ONR00 OBSTA
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL General counter for order NUMC 8 0 AFVC CO_APLZL
PLNUM Planned Order CHAR 10 0 PLAF PLNUM
PLNTY Task List Type CHAR 1 0 TCA01 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNAL Group Counter CHAR 2 0 PLNAL
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
PLNFL Sequence CHAR 6 0 PLNFOLGE
ZAEHF Internal counter NUMC 8 0 CIM_COUNT
PLNKN Number of the Task List Node NUMC 8 0 PLNKN
ZAEHP Internal counter NUMC 8 0 CIM_COUNT
SPLKN Number of the task list node of the sub-operation NUMC 8 0 SPLNKN
SZAEHL Internal counter NUMC 8 0 CIM_COUNT
SAFNR Sales Operations Planning Order CHAR 10 0 SAFNR
VORNR Operation/Activity Number CHAR 4 0 VORNR
OTYPE Object Type CHAR 2 0 T778O OTYPE
PERNR Personnel Number NUMC 8 0 PERNR_D
CANUMF Counter for the main capacity requirements record NUMC 4 0 CANUMF
SPLIT Split number INT1 3 0 CY_SPLIT
KBSTA Status of a Capacity Requirements (Object Number) CHAR 22 0 ONR00 CY_KBSTA
FSSBD Earliest scheduled start: Processing (date) DATS 8 0 FSSBD
FSSBZ Earliest Scheduled Start: Processing (Time) TIMS 6 0 FSSBZ
FSSAD Earliest scheduled start: Teardown (date) DATS 8 0 FSSAD
FSSAZ Earliest Scheduled Start: Teardown (Time) TIMS 6 0 FSSAZ
SSSBD Latest Scheduled Start: Processing (Date) DATS 8 0 SSSBD
SSSBZ Latest Scheduled Start: Processing (Time) TIMS 6 0 SSSBZ
SSSAD Latest Scheduled Start: Teardown (Date) DATS 8 0 SSSAD
SSSAZ Latest Scheduled Start: Teardown (Time) TIMS 6 0 SSSAZ
MGVRG Operation Total Quantity QUAN 13 3 MGVRG
MEINH Unit of measure for activity UNIT 3 0 T006 VORME
RSTUF Reduction Level Which Reduces Operation Lead Time NUMC 1 0 RSTUF
PLSCN Planning Scenario in Long-Term Planning NUMC 3 0 PLSC PLSCN
BSTKZ Capacity Requirement Availability Confirmation Code CHAR 1 0 CY_BSTKZ
Not yet checked or no capacity relevant to finite scheduling
1 Capacity available
2 Missing capacity
3 The requirements record belongs to a dispatched operation
BEDZLF BEDZL of Main Operation (for Phases and Their Main Ops) NUMC 8 0 BEDZLF
PHASE_KZ Indicator: Phase CHAR 1 0 PHASE_KZ
No information about phases exists
0 Operation is not a phase and has no phases
1 Operation has phases
2 Operation is a phase
MAXBD_KZ Indicator: Capacity fully committed CHAR 1 0 MAXBD_KZ
ANZMA Number of employees DEC 5 2 ANZMS

KBED foreign key relationships

Table Field Check Table Check Field
0 KBED APLZL AFVC Operation within an order AUFPL
0 KBED APLZL AFVC Operation within an order APLZL
1 KBED BEDID KBKO Header Record for Capacity Requirements MANDT
1 KBED BEDID KBKO Header Record for Capacity Requirements BEDID
0 KBED KAPID KAKO Capacity Header Segment MANDT
1 KBED KBSTA ONR00 General Object Number MANDT
0 KBED KEINH T006 Units of Measurement MANDT
0 KBED KEINH T006 Units of Measurement MSEHI
1 KBED KPVER TC29 Distribution key for capacity load MANDT
0 KBED MANDT T000 Clients MANDT
1 KBED MEINH T006 Units of Measurement MANDT
1 KBED MEINH T006 Units of Measurement MSEHI
0 KBED OBSTA ONR00 General Object Number MANDT
1 KBED OTYPE T778O Object Types MANDT
0 KBED PLNTY TCA01 Task list types MANDT
1 KBED PLNUM PLAF Planned Order MANDT
0 KBED PLSCN PLSC Planning scenarios in long-term planning MANDT