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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ CNVS (Package) R/3 Application development: Version Management

Basic Data

View Type	D	Database View
Database View	V_VSKBED
Short Description	Database View Using KBED and KBEZ
Root table	VSKBED_CN	Version: Capacity requirement records

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VSKBED_CN	VSKBED_CN
2	VSKBEZ_CN

Join Conditions

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

View Fields

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