SAP ABAP Table IOSOSCAP (Database structure for ind. capacities order sub-operations)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-SFC (Application Component) Production Orders
     ⤷ COIS (Package) Order Information System

Basic Data

Table Category	INTTAB	Structure
Structure	IOSOSCAP	Table Relationship Diagram
Short Description	Database structure for ind. capacities order sub-operations

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Capacity requirements: dialog table for KBED
2	.INCLUDE	☐				0	0	Capacity Requirements Records
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	KBKO
5	BEDZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
6	CANUM	☐	CY_COUNT	CY_COUNT	NUMC	4	0	Counters for cap. rqmts. records (various caps. + indiv.caps	*
7	.INCLUDE	☐				0	0	KBED Include structure (cap. reqmnts records)
8	ARBID	☐	ARBPLATZ	NUM08	NUMC	8	0	Work center ID
9	TYPKZ	☐	TYPKZ	TYPKZ	CHAR	1	0	Type of object causing the load (order category)
10	OBJKZ	☐	OBJKZ	OBJKZ	CHAR	1	0	Indicator: Remaining split record
11	KAPID	☐	KAPID	KAPID	NUMC	8	0	Capacity ID	KAKO
12	BEDKZ	☐	BEDKZ	X	CHAR	1	0	Indicator: Remaining split record
13	KRUESOLL	☐	CY_KRUESOL	KAPBED	FLTP	16	16	Scheduled cap. requirements for the op. segment "setup"
14	KRUEREST	☐	CY_KRUERES	KAPBED	FLTP	16	16	Remaining capacity rqmts. for operation segment "Setup"
15	KBEASOLL	☐	CY_KBEASOL	KAPBED	FLTP	16	16	Process target capacity requirements for operation segment
16	KBEAREST	☐	CY_KBEARES	KAPBED	FLTP	16	16	Remaining capacity rqmts.for operation segment "Processing"
17	KABRSOLL	☐	CY_KABRSOL	KAPBED	FLTP	16	16	Scheduled cap. requirements for the op. segment teardown
18	KABRREST	☐	CY_KABRRES	KAPBED	FLTP	16	16	Remaining capacity requirements for op. segment "tear down"
19	KEINH	☐	CY_KEINH	MEINS	UNIT	3	0	Unit of of measure for displaying capacity requirements	T006
20	FSTAD	☐	FSTAD	DATUM	DATS	8	0	Earliest start / date
21	FSTAU	☐	FSTAU	T	TIMS	6	0	Earliest start / time
22	FENDD	☐	FENDD	DATUM	DATS	8	0	Earliest finish /date
23	FENDU	☐	FENDU	T	TIMS	6	0	Earliest finish /time
24	SSTAD	☐	SSTAD	DATUM	DATS	8	0	Latest start / date
25	SSTAU	☐	SSTAU	T	TIMS	6	0	Latest start / time
26	SENDD	☐	SENDD	DATUM	DATS	8	0	Latest finish / date
27	SENDU	☐	SENDU	T	TIMS	6	0	Latest finish / time
28	ISTAD	☐	ISTAD	DATUM	DATS	8	0	Actual start / date
29	ISTAU	☐	ISTAU	T	TIMS	6	0	Actual start / time
30	IENDD	☐	IENDD	DATUM	DATS	8	0	Actual finish / date
31	IENDU	☐	IENDU	T	TIMS	6	0	Actual finish / time
32	PENDD	☐	PENDD	DATUM	DATS	8	0	Forecast finish / date
33	PENDU	☐	PENDU	T	TIMS	6	0	Forecast finish / time
34	ISPLI	☐	ISPLI	SPLITTANZ	DEC	3	0	Actual number of splits
35	KPVER	☐	CR_VERTL	CR_VERTL	CHAR	8	0	Distribution of capacity requirements (Planned/prod.order)	TC29
36	OBSTA	☐	OBSTA	J_OBJNR	CHAR	22	0	Object status (order status)	ONR00
37	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
38	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	AFVC
39	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	PLAF
40	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
41	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
42	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
43	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
44	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
45	ZAEHF	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
46	PLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
47	ZAEHP	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
48	SPLKN	☐	SPLNKN	KNTNR	NUMC	8	0	Number of the task list node of the sub-operation
49	SZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
50	SAFNR	☐	SAFNR	SAFNR	CHAR	10	0	SOP order number
51	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
52	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
53	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
54	CANUMF	☐	CANUMF	NUM4	NUMC	4	0	Counter for the main capacity requirements record
55	SPLIT	☐	CY_SPLIT	INT1	INT1	3	0	Split number
56	KBSTA	☐	CY_KBSTA	J_OBJNR	CHAR	22	0	Status of a capacity requirements (object number)	ONR00
57	FSSBD	☐	FSSBD	DATUM	DATS	8	0	Earliest scheduled start: Processing (date)
58	FSSBZ	☐	FSSBZ	ATIME	TIMS	6	0	Earliest scheduled start: Processing (time)
59	FSSAD	☐	FSSAD	DATUM	DATS	8	0	Earliest scheduled start: Teardown (date)
60	FSSAZ	☐	FSSAZ	ATIME	TIMS	6	0	Earliest scheduled start: Teardown (time)
61	SSSBD	☐	SSSBD	DATUM	DATS	8	0	Latest scheduled start: Processing (date)
62	SSSBZ	☐	SSSBZ	ATIME	TIMS	6	0	Latest scheduled start: Processing (time)
63	SSSAD	☐	SSSAD	DATUM	DATS	8	0	Latest scheduled start: Teardown (date)
64	SSSAZ	☐	SSSAZ	ATIME	TIMS	6	0	Latest scheduled start: Teardown (time)
65	MGVRG	☐	MGVRG	MENG13	QUAN	13	3	Operation Quantity
66	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
67	RSTUF	☐	RSTUF	REDST	NUMC	1	0	Reduction level which reduces operation lead time
68	PLSCN	☐	PLSCN	PLSCN	NUMC	3	0	Planning Scenario of Long-Term Planning	PLSC
69	BSTKZ	☐	CY_BSTKZ	CY_BSTKZ	CHAR	1	0	Indicator rqmts.record is confirmed (cap.availability check)
70	BEDZLF	☐	BEDZLF	CIM_COUNT	NUMC	8	0	BEDZL of Main Operation (for Phases and Their Main Ops)
71	PHASE_KZ	☐	PHASE_KZ	PHASE_KZ	CHAR	1	0	Indicator: Phase
72	MAXBD_KZ	☐	MAXBD_KZ	XFELD	CHAR	1	0	Indicator: Capacity fully committed
73	ANZMA	☐	ANZMS	ANZMA	DEC	5	2	Number of employees
74	.INCLUDE	☐				0	0	Include structure KBEZ (additional data for KBED)
75	VGW01	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
76	VGE01	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
77	VGW02	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
78	VGE02	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
79	VGW03	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
80	VGE03	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
81	VGW04	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
82	VGE04	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
83	VGW05	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
84	VGE05	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
85	VGW06	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
86	VGE06	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
87	USR04	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
88	USE04	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
89	USR05	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
90	USE05	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
91	LEK01	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
92	LEK02	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
93	LEK03	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
94	LEK04	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
95	LEK05	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
96	LEK06	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
97	RSTZE	☐	RSTZE	EINHEIT	UNIT	3	0	Unit of measure for setup time
98	BEAZE	☐	BEAZE	EINHEIT	UNIT	3	0	Unit of measure for processing time
99	ARUZE	☐	ARUZE	EINHEIT	UNIT	3	0	Unit of measure for teardown
100	ARBEI	☐	ARBEIT	ARBEIT	QUAN	7	1	Work involved in the activity
101	ARBEH	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
102	LEKNW	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
103	ASVRG	☐	ASVRG	MENG13	QUAN	13	3	Operation scrap
104	UMREN	☐	CP_UMREN	UMBSN	DEC	5	0	Denominator for converting rtg and op units of measure
105	UMREZ	☐	CP_UMREZ	UMBSZ	DEC	5	0	Numerator for converting task list and oper. un. of measure
106	BMSCH	☐	BMSCH	BMSCH	QUAN	13	3	Base Quantity
107	LMNGA	☐	LMNGA	MENG13	QUAN	13	3	Total Yield Confirmed
108	XMNGA	☐	XMNGA	MENG13	QUAN	13	3	Total scrap quantity confirmed
109	ISMNW	☐	CO_ISMNW	MENG13	QUAN	13	3	Actual work
110	ISM01	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
111	ISM02	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
112	ISM03	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
113	ISM04	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
114	ISM05	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
115	ISM06	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
116	ISERH	☐	ISERH	VGWRT	QUAN	9	3	Confirmed break time
117	ZEIER	☐	DZEIER	MEINS	UNIT	3	0	Unit for the break time	T006
118	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
119	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
120	IERD	☐	IERD	DATUM	DATS	8	0	Actual finish: Setup (date)
121	IERZ	☐	IERZ	ATIME	TIMS	6	0	Actual finish: Setup (time)
122	ISBD	☐	ISBD	DATUM	DATS	8	0	Actual start: Processing (date)
123	ISBZ	☐	ISBZ	ATIME	TIMS	6	0	Actual start: Processing (time)
124	IEBD	☐	IEBD	DATUM	DATS	8	0	Actual finish: Processing (date)
125	IEBZ	☐	IEBZ	ATIME	TIMS	6	0	Actual processing finish (time)
126	ISAD	☐	ISAD	DATUM	DATS	8	0	Actual start: Teardown (date)
127	ISAZ	☐	ISAZ	ATIME	TIMS	6	0	Actual start: Teardown (time)
128	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
129	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
130	PEDD	☐	CO_PEDD	DATUM	DATS	8	0	Forecast finish date of operation from confirmation
131	PEDZ	☐	CO_PEDZ	ATIME	TIMS	6	0	Forecast finish time of operation from confirmation
132	OFM01	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
133	OFM02	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
134	OFM03	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
135	OFM04	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
136	OFM05	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
137	OFM06	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
138	OFMNW	☐	OFMNW	ARBEIT	QUAN	7	1	Forecasted work (actual + remaining)
139	PDAU	☐	PDAU	DAUER_4_1	QUAN	5	1	Forecasted duration of activity from confirmation
140	PDAE	☐	PDAE	MEINS	UNIT	3	0	Unit of the forecasted duration from the confirmation	T006
141	DAUNO	☐	DAUNOR	DAUER_4_1	QUAN	5	1	Normal duration of the activity
142	DAUNE	☐	DAUNORE	MEINS	UNIT	3	0	Normal duration/unit	T006
143	RMNGA	☐	RMNGA	MENGV13	QUAN	13	3	Total confirmed rework quantity
144	ILE01	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	T006
145	ILE02	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	T006
146	ILE03	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	T006
147	ILE04	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	T006
148	ILE05	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	T006
149	ILE06	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	T006
150	PER_EX	☐	CY_PEREX	KREUZ	CHAR	1	0	Entry in KPER exists for this split
151	DELTA_ST	☐	CY_DELTAST	MENGV13	QUAN	13	3	Time Difference Between Start Capacity and Individ. Capacity
152	DELTA_EN	☐	CY_DELTAEN	MENGV13	QUAN	13	3	Time Difference Between Fin. Capacity and Individ. Capacity
153	.INCLUDE	☐				0	0	Capacity requirements: Additional dialog fields for KBED
154	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
155	UVORN	☐	UVORN	VORNR	CHAR	4	0	Suboperation
156	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
157	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
158	LTXA2	☐	LTXA2	TEXT40	CHAR	40	0	Second line of the description
159	KAPAR	☐	KAPART	KAPART	CHAR	3	0	Capacity category	*
160	BEDSOLL	☐	CY_KBEDSOL	CY_KBED_P	QUAN	7	2	Capacity requirements scheduled for the operation/activity
161	KEHSOLL	☐	CY_KEINH	MEINS	UNIT	3	0	Unit of of measure for displaying capacity requirements	*
162	UELSOLL	☐	CY_UEBERL	XFELD	CHAR	1	0	Capacity requirements greater (field overflow)
163	BEDREST	☐	CY_KBEDRES	CY_KBED_P	QUAN	7	2	Remaining capacity requirements scheduled for operation
164	KEHREST	☐	CY_KEINH	MEINS	UNIT	3	0	Unit of of measure for displaying capacity requirements	*
165	UELREST	☐	CY_UEBERL	XFELD	CHAR	1	0	Capacity requirements greater (field overflow)
166	BREAKS	☐	BREAKS	XFELD	CHAR	1	0	Indicator: Scheduling allowing for breaks
167	ERR_MASK	☐	ERR_MASK	ERR_MASK	CHAR	5	0	Error mask
168	FLG_SEL	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
169	INDBT	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
170	.INCLUDE	☐				0	0	Version: PS version, version-related key fields
171	VSNMR	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
172	.INCLUDE	☐				0	0	Include for KBED (versions)
173	BEDIDORG	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
174	BEDZLORG	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
175	CANUMORG	☐	CY_COUNT	CY_COUNT	NUMC	4	0	Counters for cap. rqmts. records (various caps. + indiv.caps	*
176	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
177	KTEXT	☐	KAPTEXT	TEXT40	CHAR	40	0	Capacity short text
178	KZ_MARK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
179	INDEX_NODE	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
180	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IOSOSCAP	APLZL	AFVC	APLZL
2	IOSOSCAP	ARBEH	T006	MSEHI	KEY	1	CN
3	IOSOSCAP	BEDID	KBKO	BEDID
4	IOSOSCAP	DAUNE	T006	MSEHI	KEY	1	CN
5	IOSOSCAP	ILE01	T006	MSEHI	KEY	1	CN
6	IOSOSCAP	ILE02	T006	MSEHI	KEY	1	CN
7	IOSOSCAP	ILE03	T006	MSEHI	KEY	1	CN
8	IOSOSCAP	ILE04	T006	MSEHI	KEY	1	CN
9	IOSOSCAP	ILE05	T006	MSEHI	KEY	1	CN
10	IOSOSCAP	ILE06	T006	MSEHI	KEY	1	CN
11	IOSOSCAP	KAPID	KAKO	KAPID
12	IOSOSCAP	KBSTA	ONR00	OBJNR
13	IOSOSCAP	KEINH	T006	MSEHI
14	IOSOSCAP	KPVER	TC29	VERTL
15	IOSOSCAP	MANDT	T000	MANDT
16	IOSOSCAP	MEINH	T006	MSEHI
17	IOSOSCAP	OBSTA	ONR00	OBJNR
18	IOSOSCAP	OTYPE	T778O	OTYPE
19	IOSOSCAP	PDAE	T006	MSEHI	KEY	1	CN
20	IOSOSCAP	PLNTY	TCA01	PLNTY
21	IOSOSCAP	PLNUM	PLAF	PLNUM
22	IOSOSCAP	PLSCN	PLSC	PLSCN	REF	1	CN
23	IOSOSCAP	USE04	T006	MSEHI	KEY	1	CN
24	IOSOSCAP	USE05	T006	MSEHI	KEY	1	CN
25	IOSOSCAP	VGE01	T006	MSEHI	KEY	1	CN
26	IOSOSCAP	VGE02	T006	MSEHI	KEY	1	CN
27	IOSOSCAP	VGE03	T006	MSEHI	KEY	1	CN
28	IOSOSCAP	VGE04	T006	MSEHI	KEY	1	CN
29	IOSOSCAP	VGE05	T006	MSEHI	KEY	1	CN
30	IOSOSCAP	VGE06	T006	MSEHI	KEY	1	CN
31	IOSOSCAP	ZEIER	T006	MSEHI	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in