KBED
Capacity Requirements Records
KBED is an SAP database table in S/4HANA. Capacity Requirements Records. It contains 70 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CapacityRequirementItemCap | view | from | BASIC | Capacity Requirement Item Capacity |
| I_MaintOrderOpRqmtAssgmt | view_entity | inner | BASIC | Maint Order Op Requirement Assignment |
| I_RSHOperationAssignment | view | from | BASIC | Maintenance Order Operation Assignment |
| I_SchedCapacityRqmtItemCap | view | from | BASIC | Capacity Requirement Item Capacity |
| N_CapacityRequirementItemCap | view | from | Capacity Requirement Item Capacity Aux | |
| R_RSHPersonAssignmentTP | view_entity | from | TRANSACTIONAL | Maint Order Op assigned to Person TP |
Fields (70)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bedid | BEDID | Capacity Requirement | |||
| KEY | bedzl | CIM_COUNT | Counter | |||
| KEY | canum | CY_COUNT | Counter | |||
| arbid | ARBPLATZ | Work Center ID | ||||
| typkz | TYPKZ | Order category | ||||
| objkz | OBJKZ | Remaining split | ||||
| kapid | KAPID | Capacity ID | ||||
| bedkz | BEDKZ | Indicator: Remaining split record | ||||
| kruesoll | CY_KRUESOL | Scheduled Setup | ||||
| kruerest | CY_KRUERES | Remaining Setup | ||||
| kbeasoll | CY_KBEASOL | Sched. Process. | ||||
| kbearest | CY_KBEARES | Rem. Processing | ||||
| kabrsoll | CY_KABRSOL | Sched. Teardown | ||||
| kabrrest | CY_KABRRES | Remain.Teardown | ||||
| keinh | CY_KEINH | Capacity Unit | ||||
| fstad | FSTAD | Erlst Strt Date | ||||
| fstau | FSTAU | Erlst Strt Time | ||||
| fendd | FENDD | Erlst End Date | ||||
| fendu | FENDU | Erlst End Time | ||||
| sstad | SSTAD | Ltst Start Date | ||||
| sstau | SSTAU | Ltst Start Time | ||||
| sendd | SENDD | Ltst End Date | ||||
| sendu | SENDU | Ltst End Time | ||||
| istad | ISTAD | Actl Start Date | ||||
| istau | ISTAU | Actl Start Time | ||||
| iendd | IENDD | Actual End Date | ||||
| iendu | IENDU | Actl End Time | ||||
| pendd | PENDD | Fcst End Date | ||||
| pendu | PENDU | Fcst End Time | ||||
| ispli | ISPLI | Act. No. Splits | ||||
| kpver | CR_VERTL | Distribution | ||||
| obsta | OBSTA | Order status | ||||
| aufpl | CO_AUFPL | Plan No.f.Oper. | ||||
| aplzl | CO_APLZL | Counter | ||||
| plnum | PLNUM | Planned Order | ||||
| plnty | PLNTY | Task List Type | ||||
| plnnr | PLNNR | Group | ||||
| plnal | PLNAL | Group Counter | ||||
| zaehl | CIM_COUNT | Counter | ||||
| plnfl | PLNFOLGE | Sequence | ||||
| zaehf | CIM_COUNT | Counter | ||||
| plnkn | PLNKN | Node | ||||
| zaehp | CIM_COUNT | Counter | ||||
| splkn | SPLNKN | Nodes | ||||
| szaehl | CIM_COUNT | Counter | ||||
| safnr | SAFNR | SOP Order | ||||
| vornr | VORNR | Activity | ||||
| otype | OTYPE | Object type | ||||
| pernr | PERNR_D | Personnel No. | ||||
| canumf | CANUMF | Main reqmts | ||||
| split | CY_SPLIT | Split number | ||||
| kbsta | CY_KBSTA | Reqmts Status | ||||
| fssbd | FSSBD | Earl.start date | ||||
| fssbz | FSSBZ | Earl.start time | ||||
| fssad | FSSAD | Earl.start date | ||||
| fssaz | FSSAZ | Earl.start time | ||||
| sssbd | SSSBD | Lat.start date | ||||
| sssbz | SSSBZ | Lat. start time | ||||
| sssad | SSSAD | Lat.start date | ||||
| sssaz | SSSAZ | Lat. start time | ||||
| mgvrg | MGVRG | Operation Qty | ||||
| meinh | VORME | Act/op UoM | ||||
| rstuf | RSTUF | Reduction Level | ||||
| plscn | PLSCN | Planning Scenario | ||||
| bstkz | CY_BSTKZ | Capacity Conf. | ||||
| bedzlf | BEDZLF | BEDZL Operation | ||||
| phase_kz | PHASE_KZ | Phase | ||||
| maxbd_kz | MAXBD_KZ | Cap. committed | ||||
| anzma | ANZMS | No. employees |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Capacity Requirements Records
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KBED (
MANDT, -- Client [MANDT]
BEDID, -- Capacity Requirement [BEDID]
BEDZL, -- Counter [CIM_COUNT]
CANUM, -- Counter [CY_COUNT]
ARBID, -- Work Center ID [ARBPLATZ]
TYPKZ, -- Order category [TYPKZ]
OBJKZ, -- Remaining split [OBJKZ]
KAPID, -- Capacity ID [KAPID]
BEDKZ, -- Indicator: Remaining split record [BEDKZ]
KRUESOLL, -- Scheduled Setup [CY_KRUESOL]
KRUEREST, -- Remaining Setup [CY_KRUERES]
KBEASOLL, -- Sched. Process. [CY_KBEASOL]
KBEAREST, -- Rem. Processing [CY_KBEARES]
KABRSOLL, -- Sched. Teardown [CY_KABRSOL]
KABRREST, -- Remain.Teardown [CY_KABRRES]
KEINH, -- Capacity Unit [CY_KEINH]
FSTAD, -- Erlst Strt Date [FSTAD]
FSTAU, -- Erlst Strt Time [FSTAU]
FENDD, -- Erlst End Date [FENDD]
FENDU, -- Erlst End Time [FENDU]
SSTAD, -- Ltst Start Date [SSTAD]
SSTAU, -- Ltst Start Time [SSTAU]
SENDD, -- Ltst End Date [SENDD]
SENDU, -- Ltst End Time [SENDU]
ISTAD, -- Actl Start Date [ISTAD]
ISTAU, -- Actl Start Time [ISTAU]
IENDD, -- Actual End Date [IENDD]
IENDU, -- Actl End Time [IENDU]
PENDD, -- Fcst End Date [PENDD]
PENDU, -- Fcst End Time [PENDU]
ISPLI, -- Act. No. Splits [ISPLI]
KPVER, -- Distribution [CR_VERTL]
OBSTA, -- Order status [OBSTA]
AUFPL, -- Plan No.f.Oper. [CO_AUFPL]
APLZL, -- Counter [CO_APLZL]
PLNUM, -- Planned Order [PLNUM]
PLNTY, -- Task List Type [PLNTY]
PLNNR, -- Group [PLNNR]
PLNAL, -- Group Counter [PLNAL]
ZAEHL, -- Counter [CIM_COUNT]
PLNFL, -- Sequence [PLNFOLGE]
ZAEHF, -- Counter [CIM_COUNT]
PLNKN, -- Node [PLNKN]
ZAEHP, -- Counter [CIM_COUNT]
SPLKN, -- Nodes [SPLNKN]
SZAEHL, -- Counter [CIM_COUNT]
SAFNR, -- SOP Order [SAFNR]
VORNR, -- Activity [VORNR]
OTYPE, -- Object type [OTYPE]
PERNR, -- Personnel No. [PERNR_D]
CANUMF, -- Main reqmts [CANUMF]
SPLIT, -- Split number [CY_SPLIT]
KBSTA, -- Reqmts Status [CY_KBSTA]
FSSBD, -- Earl.start date [FSSBD]
FSSBZ, -- Earl.start time [FSSBZ]
FSSAD, -- Earl.start date [FSSAD]
FSSAZ, -- Earl.start time [FSSAZ]
SSSBD, -- Lat.start date [SSSBD]
SSSBZ, -- Lat. start time [SSSBZ]
SSSAD, -- Lat.start date [SSSAD]
SSSAZ, -- Lat. start time [SSSAZ]
MGVRG, -- Operation Qty [MGVRG]
MEINH, -- Act/op UoM [VORME]
RSTUF, -- Reduction Level [RSTUF]
PLSCN, -- Planning Scenario [PLSCN]
BSTKZ, -- Capacity Conf. [CY_BSTKZ]
BEDZLF, -- BEDZL Operation [BEDZLF]
PHASE_KZ, -- Phase [PHASE_KZ]
MAXBD_KZ, -- Cap. committed [MAXBD_KZ]
ANZMA, -- No. employees [ANZMS]
PRIMARY KEY (MANDT, BEDID, BEDZL, CANUM)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA