SAP ABAP View V_KBED (Database View Using KBED and KBEZ)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CX (Package) R/3 Application development: R/3 Scheduling

Basic Data

View Type	D	Database View
Database View	V_KBED
Short Description	Database View Using KBED and KBEZ
Root table	KBED	Capacity Requirements Records

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KBED	KBED
2	KBEZ

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KBED	MANDT	JL	EQ				0	0
2	KBEZ	MANDT	JR	EQ			AND	0	0
3	KBED	BEDID	JL	EQ				0	0
4	KBEZ	BEDID	JR	EQ			AND	0	0
5	KBED	BEDZL	JL	EQ				0	0
6	KBEZ	BEDZL	JR	EQ			AND	0	0
7	KBED	CANUM	JL	EQ				0	0
8	KBEZ	CANUM	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KBED	MANDT		☐	MANDT	☐	Client
2	BEDID	KBED	BEDID		☐	BEDID	☐	ID of the capacity requirements record
3	BEDZL	KBED	BEDZL		☐	CIM_COUNT	☐	Internal counter
4	CANUM	KBED	CANUM		☐	CY_COUNT	☐	Counters for cap. rqmts. records (various caps. + indiv.caps
5	ARBID	KBED	ARBID		☐	ARBPLATZ	☐	Work center ID
6	TYPKZ	KBED	TYPKZ		☐	TYPKZ	☐	Type of object causing the load (order category)
7	OBJKZ	KBED	OBJKZ		☐	OBJKZ	☐	Indicator: Remaining split record
8	KAPID	KBED	KAPID		☐	KAPID	☐	Capacity ID
9	BEDKZ	KBED	BEDKZ		☐	BEDKZ	☐	Indicator: Remaining split record
10	KRUESOLL	KBED	KRUESOLL		☐	CY_KRUESOL	☐	Scheduled cap. requirements for the op. segment "setup"
11	KRUEREST	KBED	KRUEREST		☐	CY_KRUERES	☐	Remaining capacity rqmts. for operation segment "Setup"
12	KBEASOLL	KBED	KBEASOLL		☐	CY_KBEASOL	☐	Process target capacity requirements for operation segment
13	KBEAREST	KBED	KBEAREST		☐	CY_KBEARES	☐	Remaining capacity rqmts.for operation segment "Processing"
14	KABRSOLL	KBED	KABRSOLL		☐	CY_KABRSOL	☐	Scheduled cap. requirements for the op. segment teardown
15	KABRREST	KBED	KABRREST		☐	CY_KABRRES	☐	Remaining capacity requirements for op. segment "tear down"
16	KEINH	KBED	KEINH		☐	CY_KEINH	☐	Unit of of measure for displaying capacity requirements
17	FSTAD	KBED	FSTAD		☐	FSTAD	☐	Earliest start / date
18	FSTAU	KBED	FSTAU		☐	FSTAU	☐	Earliest start / time
19	FENDD	KBED	FENDD		☐	FENDD	☐	Earliest finish /date
20	FENDU	KBED	FENDU		☐	FENDU	☐	Earliest finish /time
21	SSTAD	KBED	SSTAD		☐	SSTAD	☐	Latest start / date
22	SSTAU	KBED	SSTAU		☐	SSTAU	☐	Latest start / time
23	SENDD	KBED	SENDD		☐	SENDD	☐	Latest finish / date
24	SENDU	KBED	SENDU		☐	SENDU	☐	Latest finish / time
25	ISTAD	KBED	ISTAD		☐	ISTAD	☐	Actual start / date
26	ISTAU	KBED	ISTAU		☐	ISTAU	☐	Actual start / time
27	IENDD	KBED	IENDD		☐	IENDD	☐	Actual finish / date
28	IENDU	KBED	IENDU		☐	IENDU	☐	Actual finish / time
29	PENDD	KBED	PENDD		☐	PENDD	☐	Forecast finish / date
30	PENDU	KBED	PENDU		☐	PENDU	☐	Forecast finish / time
31	ISPLI	KBED	ISPLI		☐	ISPLI	☐	Actual number of splits
32	KPVER	KBED	KPVER		☐	CR_VERTL	☐	Distribution of capacity requirements (Planned/prod.order)
33	OBSTA	KBED	OBSTA		☐	OBSTA	☐	Object status (order status)
34	AUFPL	KBED	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
35	APLZL	KBED	APLZL		☐	CO_APLZL	☐	General counter for order
36	PLNUM	KBED	PLNUM		☐	PLNUM	☐	Planned order number
37	PLNTY	KBED	PLNTY		☐	PLNTY	☐	Task List Type
38	PLNNR	KBED	PLNNR		☐	PLNNR	☐	Key for Task List Group
39	PLNAL	KBED	PLNAL		☐	PLNAL	☐	Group Counter
40	ZAEHL	KBED	ZAEHL		☐	CIM_COUNT	☐	Internal counter
41	PLNFL	KBED	PLNFL		☐	PLNFOLGE	☐	Sequence
42	ZAEHF	KBED	ZAEHF		☐	CIM_COUNT	☐	Internal counter
43	PLNKN	KBED	PLNKN		☐	PLNKN	☐	Number of the task list node
44	ZAEHP	KBED	ZAEHP		☐	CIM_COUNT	☐	Internal counter
45	SPLKN	KBED	SPLKN		☐	SPLNKN	☐	Number of the task list node of the sub-operation
46	SZAEHL	KBED	SZAEHL		☐	CIM_COUNT	☐	Internal counter
47	SAFNR	KBED	SAFNR		☐	SAFNR	☐	SOP order number
48	VORNR	KBED	VORNR		☐	VORNR	☐	Operation/Activity Number
49	OTYPE	KBED	OTYPE		☐	OTYPE	☐	Object Type
50	PERNR	KBED	PERNR		☐	PERNR_D	☐	Personnel Number
51	CANUMF	KBED	CANUMF		☐	CANUMF	☐	Counter for the main capacity requirements record
52	SPLIT	KBED	SPLIT		☐	CY_SPLIT	☐	Split number
53	KBSTA	KBED	KBSTA		☐	CY_KBSTA	☐	Status of a capacity requirements (object number)
54	FSSBD	KBED	FSSBD		☐	FSSBD	☐	Earliest scheduled start: Processing (date)
55	FSSBZ	KBED	FSSBZ		☐	FSSBZ	☐	Earliest scheduled start: Processing (time)
56	FSSAD	KBED	FSSAD		☐	FSSAD	☐	Earliest scheduled start: Teardown (date)
57	FSSAZ	KBED	FSSAZ		☐	FSSAZ	☐	Earliest scheduled start: Teardown (time)
58	SSSBD	KBED	SSSBD		☐	SSSBD	☐	Latest scheduled start: Processing (date)
59	SSSBZ	KBED	SSSBZ		☐	SSSBZ	☐	Latest scheduled start: Processing (time)
60	SSSAD	KBED	SSSAD		☐	SSSAD	☐	Latest scheduled start: Teardown (date)
61	SSSAZ	KBED	SSSAZ		☐	SSSAZ	☐	Latest scheduled start: Teardown (time)
62	MGVRG	KBED	MGVRG		☐	MGVRG	☐	Operation Quantity
63	MEINH	KBED	MEINH		☐	VORME	☐	Unit of measure for activity
64	RSTUF	KBED	RSTUF		☐	RSTUF	☐	Reduction level which reduces operation lead time
65	PLSCN	KBED	PLSCN		☐	PLSCN	☐	Planning Scenario of Long-Term Planning
66	BSTKZ	KBED	BSTKZ		☐	CY_BSTKZ	☐	Indicator rqmts.record is confirmed (cap.availability check)
67	BEDZLF	KBED	BEDZLF		☐	BEDZLF	☐	BEDZL of Main Operation (for Phases and Their Main Ops)
68	PHASE_KZ	KBED	PHASE_KZ		☐	PHASE_KZ	☐	Indicator: Phase
69	ANZMA	KBED	ANZMA		☐	ANZMS	☐	Number of employees
70	VGW01	KBEZ	VGW01		☐	VGWRT	☐	Standard Value
71	VGE01	KBEZ	VGE01		☐	VGWRTEH	☐	Unit of measure for the standard value
72	VGW02	KBEZ	VGW02		☐	VGWRT	☐	Standard Value
73	VGE02	KBEZ	VGE02		☐	VGWRTEH	☐	Unit of measure for the standard value
74	VGW03	KBEZ	VGW03		☐	VGWRT	☐	Standard Value
75	VGE03	KBEZ	VGE03		☐	VGWRTEH	☐	Unit of measure for the standard value
76	VGW04	KBEZ	VGW04		☐	VGWRT	☐	Standard Value
77	VGE04	KBEZ	VGE04		☐	VGWRTEH	☐	Unit of measure for the standard value
78	VGW05	KBEZ	VGW05		☐	VGWRT	☐	Standard Value
79	VGE05	KBEZ	VGE05		☐	VGWRTEH	☐	Unit of measure for the standard value
80	VGW06	KBEZ	VGW06		☐	VGWRT	☐	Standard Value
81	VGE06	KBEZ	VGE06		☐	VGWRTEH	☐	Unit of measure for the standard value
82	USR04	KBEZ	USR04		☐	USRQUAN13	☐	User field for quantity (length 10.3)
83	USE04	KBEZ	USE04		☐	USRUNIT	☐	User field: Unit for quantity fields
84	USR05	KBEZ	USR05		☐	USRQUAN13	☐	User field for quantity (length 10.3)
85	USE05	KBEZ	USE05		☐	USRUNIT	☐	User field: Unit for quantity fields
86	LEK01	KBEZ	LEK01		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
87	LEK02	KBEZ	LEK02		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
88	LEK03	KBEZ	LEK03		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
89	LEK04	KBEZ	LEK04		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
90	LEK05	KBEZ	LEK05		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
91	LEK06	KBEZ	LEK06		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
92	RSTZE	KBEZ	RSTZE		☐	RSTZE	☐	Unit of measure for setup time
93	BEAZE	KBEZ	BEAZE		☐	BEAZE	☐	Unit of measure for processing time
94	ARUZE	KBEZ	ARUZE		☐	ARUZE	☐	Unit of measure for teardown
95	ARBEI	KBEZ	ARBEI		☐	ARBEIT	☐	Work involved in the activity
96	ARBEH	KBEZ	ARBEH		☐	ARBEITE	☐	Unit for work
97	LEKNW	KBEZ	LEKNW		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
98	ASVRG	KBEZ	ASVRG		☐	ASVRG	☐	Operation scrap
99	UMREN	KBEZ	UMREN		☐	CP_UMREN	☐	Denominator for converting rtg and op units of measure
100	UMREZ	KBEZ	UMREZ		☐	CP_UMREZ	☐	Numerator for converting task list and oper. un. of measure
101	BMSCH	KBEZ	BMSCH		☐	BMSCH	☐	Base Quantity
102	LMNGA	KBEZ	LMNGA		☐	LMNGA	☐	Total Yield Confirmed
103	XMNGA	KBEZ	XMNGA		☐	XMNGA	☐	Total scrap quantity confirmed
104	ISMNW	KBEZ	ISMNW		☐	CO_ISMNW	☐	Actual work
105	ISM01	KBEZ	ISM01		☐	CO_RUMNG	☐	Previously confirmed activity
106	ISM02	KBEZ	ISM02		☐	CO_RUMNG	☐	Previously confirmed activity
107	ISM03	KBEZ	ISM03		☐	CO_RUMNG	☐	Previously confirmed activity
108	ISM04	KBEZ	ISM04		☐	CO_RUMNG	☐	Previously confirmed activity
109	ISM05	KBEZ	ISM05		☐	CO_RUMNG	☐	Previously confirmed activity
110	ISM06	KBEZ	ISM06		☐	CO_RUMNG	☐	Previously confirmed activity
111	ISERH	KBEZ	ISERH		☐	ISERH	☐	Confirmed break time
112	ZEIER	KBEZ	ZEIER		☐	DZEIER	☐	Unit for the break time
113	ISDD	KBEZ	ISDD		☐	ISDD	☐	Actual start: Execution (date)
114	ISDZ	KBEZ	ISDZ		☐	ISDZ	☐	Actual start: Execution/setup (time)
115	IERD	KBEZ	IERD		☐	IERD	☐	Actual finish: Setup (date)
116	IERZ	KBEZ	IERZ		☐	IERZ	☐	Actual finish: Setup (time)
117	ISBD	KBEZ	ISBD		☐	ISBD	☐	Actual start: Processing (date)
118	ISBZ	KBEZ	ISBZ		☐	ISBZ	☐	Actual start: Processing (time)
119	IEBD	KBEZ	IEBD		☐	IEBD	☐	Actual finish: Processing (date)
120	IEBZ	KBEZ	IEBZ		☐	IEBZ	☐	Actual processing finish (time)
121	ISAD	KBEZ	ISAD		☐	ISAD	☐	Actual start: Teardown (date)
122	ISAZ	KBEZ	ISAZ		☐	ISAZ	☐	Actual start: Teardown (time)
123	IEDD	KBEZ	IEDD		☐	IEDD	☐	Actual finish: Execution (date)
124	IEDZ	KBEZ	IEDZ		☐	IEDZ	☐	Actual finish: Execution (time)
125	PEDD	KBEZ	PEDD		☐	CO_PEDD	☐	Forecast finish date of operation from confirmation
126	PEDZ	KBEZ	PEDZ		☐	CO_PEDZ	☐	Forecast finish time of operation from confirmation
127	OFM01	KBEZ	OFM01		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
128	OFM02	KBEZ	OFM02		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
129	OFM03	KBEZ	OFM03		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
130	OFM04	KBEZ	OFM04		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
131	OFM05	KBEZ	OFM05		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
132	OFM06	KBEZ	OFM06		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
133	OFMNW	KBEZ	OFMNW		☐	OFMNW	☐	Forecasted work (actual + remaining)
134	PDAU	KBEZ	PDAU		☐	PDAU	☐	Forecasted duration of activity from confirmation
135	PDAE	KBEZ	PDAE		☐	PDAE	☐	Unit of the forecasted duration from the confirmation
136	DAUNO	KBEZ	DAUNO		☐	DAUNOR	☐	Normal duration of the activity
137	DAUNE	KBEZ	DAUNE		☐	DAUNORE	☐	Normal duration/unit
138	PER_EX	KBEZ	PER_EX		☐	CY_PEREX	☐	Entry in KPER exists for this split

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in