SAP ABAP Table CYDETALL (Fields used for generating the detailed list)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	CYDETALL	Table Relationship Diagram
Short Description	Fields used for generating the detailed list

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
3	BEDZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
4	CANUM	☐	CR_CAPNUM	NUM4	NUMC	4	0	Capacity allocation number
5	HARBID	☐	ARBPLATZ	NUM08	NUMC	8	0	Work center ID
6	ARBID	☐	ARBPLATZ	NUM08	NUMC	8	0	Work center ID
7	TYPKZ	☐	TYPKZ	TYPKZ	CHAR	1	0	Type of object causing the load (order category)
8	HKAPID	☐	HKAPID	KAPID	NUMC	8	0	Superior capacity in a work center hierarchy	*
9	KAPID	☐	KAPID	KAPID	NUMC	8	0	Capacity ID	*
10	BEDKZ	☐	BEDKZ	X	CHAR	1	0	Indicator: Remaining split record
11	KRUESOLL	☐	CY_KRUESOL	KAPBED	FLTP	16	16	Scheduled cap. requirements for the op. segment "setup"
12	KRUEREST	☐	CY_KRUERES	KAPBED	FLTP	16	16	Remaining capacity rqmts. for operation segment "Setup"
13	KBEASOLL	☐	CY_KBEASOL	KAPBED	FLTP	16	16	Process target capacity requirements for operation segment
14	KBEAREST	☐	CY_KBEARES	KAPBED	FLTP	16	16	Remaining capacity rqmts.for operation segment "Processing"
15	KABRSOLL	☐	CY_KABRSOL	KAPBED	FLTP	16	16	Scheduled cap. requirements for the op. segment teardown
16	KABRREST	☐	CY_KABRRES	KAPBED	FLTP	16	16	Remaining capacity requirements for op. segment "tear down"
17	KEINH	☐	CY_KEINH	MEINS	UNIT	3	0	Unit of of measure for displaying capacity requirements	*
18	FSTAD	☐	FSTAD	DATUM	DATS	8	0	Earliest start / date
19	FSTAU	☐	FSTAU	T	TIMS	6	0	Earliest start / time
20	FENDD	☐	FENDD	DATUM	DATS	8	0	Earliest finish /date
21	FENDU	☐	FENDU	T	TIMS	6	0	Earliest finish /time
22	SSTAD	☐	SSTAD	DATUM	DATS	8	0	Latest start / date
23	SSTAU	☐	SSTAU	T	TIMS	6	0	Latest start / time
24	SENDD	☐	SENDD	DATUM	DATS	8	0	Latest finish / date
25	SENDU	☐	SENDU	T	TIMS	6	0	Latest finish / time
26	ISTAD	☐	ISTAD	DATUM	DATS	8	0	Actual start / date
27	ISTAU	☐	ISTAU	T	TIMS	6	0	Actual start / time
28	IENDD	☐	IENDD	DATUM	DATS	8	0	Actual finish / date
29	IENDU	☐	IENDU	T	TIMS	6	0	Actual finish / time
30	PENDD	☐	PENDD	DATUM	DATS	8	0	Forecast finish / date
31	PENDU	☐	PENDU	T	TIMS	6	0	Forecast finish / time
32	ISPLI	☐	ISPLI	SPLITTANZ	DEC	3	0	Actual number of splits
33	KPVER	☐	CR_VERTL	CR_VERTL	CHAR	8	0	Distribution of capacity requirements (Planned/prod.order)	*
34	OBSTA	☐	OBSTA	J_OBJNR	CHAR	22	0	Object status (order status)	*
35	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
36	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
37	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	*
38	PLSCN	☐	PLSCN	PLSCN	NUMC	3	0	Planning Scenario of Long-Term Planning	*
39	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
40	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
41	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
42	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
43	PLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
44	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
45	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
46	NAME1	☐	CY_NAME1	NAME	CHAR	35	0	Name of the customer for the customer order
47	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
48	UVORN	☐	UVORN	VORNR	CHAR	4	0	Suboperation
49	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	*
50	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
51	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
52	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
53	LOART	☐	LOHNART	LOART	CHAR	4	0	Wage type
54	MGVRG	☐	MGVRG	MENG13	QUAN	13	3	Operation Quantity
55	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	*
56	RFGRP	☐	RUEFAGRP	RUEFAGRP	CHAR	10	0	Setup group category	*
57	RFSCH	☐	RUEFASCHLU	RUEFASCHLU	CHAR	10	0	Setup group key	*
58	RASCH	☐	RUEARSCHLU	RUEARSCHLU	CHAR	2	0	Setup Type Key	*
59	ARBEI	☐	ARBEIT	ARBEIT	QUAN	7	1	Work involved in the activity
60	ARBEH	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	*
61	DAUNO	☐	DAUNOR	DAUER_4_1	QUAN	5	1	Normal duration of the activity
62	DAUNE	☐	DAUNORE	MEINS	UNIT	3	0	Normal duration/unit	*
63	EWDAN	☐	EWDAN	DAUER_4_1	QUAN	5	1	Normal duration (from forecast) of activity
64	EWDNE	☐	EWDNE	MEINS	UNIT	3	0	Unit for forecast normal duration	*
65	OFMNW	☐	OFMNW	ARBEIT	QUAN	7	1	Forecasted work (actual + remaining)
66	ASVRG	☐	ASVRG	MENG13	QUAN	13	3	Operation scrap
67	ISMNW	☐	ISMNW	ARBEIT	QUAN	7	1	Actual work
68	LMNGA	☐	LMNGA	MENG13	QUAN	13	3	Total Yield Confirmed
69	QUALF	☐	QUALF	QUALF	CHAR	2	0	Suitability	*
70	LOGRP	☐	LOHNGRP	LOHNGRP	CHAR	3	0	Wage group	*
71	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
72	NPRIO	☐	NW_PRIO	NW_PRIO	CHAR	1	0	Priority	*
73	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
74	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
75	FSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
76	FSAVZ	☐	FSAVZ	ATIME	TIMS	6	0	Earliest scheduled start: Execution (time)
77	FSSBD	☐	FSSBD	DATUM	DATS	8	0	Earliest scheduled start: Processing (date)
78	FSSBZ	☐	FSSBZ	ATIME	TIMS	6	0	Earliest scheduled start: Processing (time)
79	FSSAD	☐	FSSAD	DATUM	DATS	8	0	Earliest scheduled start: Teardown (date)
80	FSSAZ	☐	FSSAZ	ATIME	TIMS	6	0	Earliest scheduled start: Teardown (time)
81	FSEDD	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
82	FSEDZ	☐	FSEDZ	ATIME	TIMS	6	0	Earliest scheduled finish: Execution (time)
83	FSSLD	☐	FSSLD	DATUM	DATS	8	0	Earliest scheduled start: Wait (date)
84	FSSLZ	☐	FSSLZ	ATIME	TIMS	6	0	Earliest scheduled start: Wait (time)
85	FSELD	☐	FSELD	DATUM	DATS	8	0	Earliest scheduled finish: Wait (date)
86	FSELZ	☐	FSELZ	ATIME	TIMS	6	0	Earliest scheduled finish: Wait (time)
87	SSAVD	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
88	SSAVZ	☐	SSAVZ	ATIME	TIMS	6	0	Latest scheduled start: Execution (time)
89	SSSBD	☐	SSSBD	DATUM	DATS	8	0	Latest scheduled start: Processing (date)
90	SSSBZ	☐	SSSBZ	ATIME	TIMS	6	0	Latest scheduled start: Processing (time)
91	SSSAD	☐	SSSAD	DATUM	DATS	8	0	Latest scheduled start: Teardown (date)
92	SSSAZ	☐	SSSAZ	ATIME	TIMS	6	0	Latest scheduled start: Teardown (time)
93	SSEDD	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
94	SSEDZ	☐	SSEDZ	ATIME	TIMS	6	0	Latest scheduled finish: Execution (time)
95	SSSLD	☐	SSSLD	DATUM	DATS	8	0	Latest scheduled start: Wait time (date)
96	SSSLZ	☐	SSSLZ	ATIME	TIMS	6	0	Latest scheduled start: Wait time
97	SSELD	☐	SSELD	DATUM	DATS	8	0	Latest scheduled finish: Wait time (date)
98	SSELZ	☐	SSELZ	ATIME	TIMS	6	0	Latest scheduled finish: Wait time
99	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
100	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
101	IERD	☐	IERD	DATUM	DATS	8	0	Actual finish: Setup (date)
102	IERZ	☐	IERZ	ATIME	TIMS	6	0	Actual finish: Setup (time)
103	ISBD	☐	ISBD	DATUM	DATS	8	0	Actual start: Processing (date)
104	ISBZ	☐	ISBZ	ATIME	TIMS	6	0	Actual start: Processing (time)
105	IEBD	☐	IEBD	DATUM	DATS	8	0	Actual finish: Processing (date)
106	IEBZ	☐	IEBZ	ATIME	TIMS	6	0	Actual processing finish (time)
107	ISAD	☐	ISAD	DATUM	DATS	8	0	Actual start: Teardown (date)
108	ISAZ	☐	ISAZ	ATIME	TIMS	6	0	Actual start: Teardown (time)
109	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
110	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
111	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
112	PROJN	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
113	PRONR	☐	PS_PSP_PRO	PS_PSPNR	NUMC	8	0	Project definition	*
114	WARTZ	☐	WARTEZEIT	CX_ZEIT	FLTP	16	16	Queue time used for scheduling
115	WRTZE	☐	WTRZE	EINHEIT	UNIT	3	0	Unit of measure for queue time
116	RUEST	☐	RUEST	CX_ZEIT	FLTP	16	16	Setup time
117	RSTZE	☐	RSTZE	EINHEIT	UNIT	3	0	Unit of measure for setup time
118	BEARZ	☐	BEARZEIT	CX_ZEIT	FLTP	16	16	Processing time
119	BEAZE	☐	BEAZE	EINHEIT	UNIT	3	0	Unit of measure for processing time
120	ABRUE	☐	ABRUE	CX_ZEIT	FLTP	16	16	Teardown
121	ARUZE	☐	ARUZE	EINHEIT	UNIT	3	0	Unit of measure for teardown
122	LIEGZ	☐	LIEGEZEIT	CX_ZEIT	FLTP	16	16	Wait time used for scheduling
123	LIGZE	☐	LIGZE	EINHEIT	UNIT	3	0	Unit of measure for wait time
124	TRANZ	☐	TRANSZEIT	CX_ZEIT	FLTP	16	16	Move time used for scheduling
125	TRAZE	☐	TRAZE	EINHEIT	UNIT	3	0	Unit of measure for move time
126	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
127	POSNR	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
128	PLSVB	☐	LOSGRBIS	MENG13	QUAN	13	3	To lot size
129	PLSVN	☐	LOSGRVON	MENG13	QUAN	13	3	From Lot Size
130	PLNME	☐	PLNME	MEINS	UNIT	3	0	Task list unit of measure	*
131	AUF_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
132	GLTRP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
133	GSTRP	☐	CO_GSTRP	DATUM	DATS	8	0	Basic start date
134	FTRMS	☐	CO_FTRMS	DATUM	DATS	8	0	Scheduled release date
135	GLTRS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
136	GSTRS	☐	CO_GSTRS	DATUM	DATS	8	0	Scheduled start
137	GSTRI	☐	CO_GSTRI	DATUM	DATS	8	0	Actual start date
138	GLTRI	☐	CO_GLTRI	DATUM	DATS	8	0	Actual finish date
139	FTRMI	☐	CO_FTRMI	DATUM	DATS	8	0	Actual release date
140	FTRMP	☐	CO_FTRMP	DATUM	DATS	8	0	Planned release date
141	GAMNG	☐	GAMNG	MENG13	QUAN	13	3	Total order quantity
142	GMEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
143	APRIO	☐	CO_APRIO	CHAR1	CHAR	1	0	Order priority
144	REDKZ	☐	REDKZ	REDKZ	CHAR	1	0	Reduction indicator for scheduling
145	IGMNG	☐	CO_IGMNG	MENG13	QUAN	13	3	Yield confirmed from order confirmation
146	PLNBEZ	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
147	PLNAW	☐	PLNAW	PLNAW	CHAR	1	0	Application of the task list	*
148	PVERW	☐	PLN_VERWE	PLN_VERWE	CHAR	3	0	Task list usage	*
149	PLGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	*
150	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
151	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	*
152	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	*
153	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	*
154	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
155	KTEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
156	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
157	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
158	CCKEY	☐	CCKEY	CCKEY	CHAR	23	0	Cost collector key
159	KOSTV	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	*
160	PDAT1	☐	AUFPDAT1	DATUM	DATS	8	0	Planned release date
161	PDAT2	☐	AUFPDAT2	DATUM	DATS	8	0	Planned completion date
162	PDAT3	☐	AUFPDAT3	DATUM	DATS	8	0	Planned closing date
163	IDAT1	☐	AUFIDAT1	DATUM	DATS	8	0	Release date
164	IDAT2	☐	AUFIDAT2	DATUM	DATS	8	0	Technical completion date
165	IDAT3	☐	AUFIDAT3	DATUM	DATS	8	0	Close date
166	ABKRS	☐	AUFABKRS	AKREIS	NUMC	2	0	Processing group	*
167	KOSTL	☐	AUFKOSTL	KOSTL	CHAR	10	0	Cost center for basic settlement	*
168	PLWRK	☐	PLWRK	WERKS	CHAR	4	0	Planning Plant	*
169	PWWRK	☐	PWWRK	WERKS	CHAR	4	0	Production plant in planned order	*
170	PAART	☐	PAART	PAART	CHAR	4	0	Order type
171	AUFFX	☐	PLAFX	XFELD	CHAR	1	0	Firming indicator for planned order data
172	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
173	PSTTR	☐	PSTTR	DATUM	DATS	8	0	Order start date in planned order
174	PEDTR	☐	PEDTR	DATUM	DATS	8	0	Order finish date in the planned order
175	GSMNG	☐	GSMNG	MENG13	QUAN	13	3	Total planned order quantity
176	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
177	PALTR	☐	PALTR	DATUM	DATS	8	0	Explosion date
178	POOLK	☐	KAP_KZPOOL	XFELD	CHAR	1	0	Indicator for pooled capacity
179	PERIOD	☐	KAPER	CHAR10	CHAR	10	0	Planning period considered (capacity planning)
180	BEDARF	☐	KPSOL	KAPBED	FLTP	16	16	Scheduled capacity requirements
181	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
182	ARBPLTEXT	☐	ARBPLTEXT	TEXT40	CHAR	40	0	Text describing work center in more detail
183	VRG_ARBPL	☐	VRG_ARBPL	ARBPL	CHAR	8	0	Work center of the operation
184	VRG_ARBPLT	☐	VRG_ARBPLT	TEXT40	CHAR	40	0	Work center text of sub-operation
185	KAPAR	☐	KAPART	KAPART	CHAR	3	0	Capacity category	*
186	KAPARTEXT	☐	KAPTEXT	TEXT40	CHAR	40	0	Capacity short text
187	STATUS	☐	STATUS_TXT	STATUS_TXT	CHAR	4	0	Text of order status
188	STATUV	☐	STATUV_TXT	STATUV_TXT	CHAR	4	0	Text for the status of an operation or a network activity
189	MATTEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
190	MATNR	☐	CYMATNR	MATNR	CHAR	18	0	Material in planned order	*
191	MATNRALG	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
192	LIEINH	☐	CY_KEINH	MEINS	UNIT	3	0	Unit of of measure for displaying capacity requirements	*
193	ANGEB	☐	MENGEP	MENGEP	DEC	14	3	Quantity field
194	LIEINHA	☐	CY_KEINH	MEINS	UNIT	3	0	Unit of of measure for displaying capacity requirements	*
195	PERIODINT	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
196	BED_VERUR	☐	BED_VERUR	AUFNR	CHAR	12	0	Pegged requirements (work- or planned order) as type char.	*
197	BED_MENGE	☐	BED_GSMNG	MENG13	QUAN	13	3	Order quantity displayed in a list
198	BED_EINH	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
199	STTXT	☐	CO_STTXT	CHAR40	CHAR	40	0	System Status
200	AWTXT	☐	CY_AWTXT	CHAR40	CHAR	40	0	User status set at order level
201	AWVST	☐	CY_AWVTXT	CHAR40	CHAR	40	0	User status set at operation level
202	USR00	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
203	USR01	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
204	USR02	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
205	USR03	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
206	USR04	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
207	USE04	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	*
208	USR05	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
209	USE05	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	*
210	USR06	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
211	USE06	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	*
212	USR07	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
213	USE07	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	*
214	USR08	☐	USRDATE	USRDATE	DATS	8	0	User field for date
215	USR09	☐	USRDATE	USRDATE	DATS	8	0	User field for date
216	USR10	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
217	USR11	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
218	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
219	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
220	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number

History

Last changed by/on	SAP	20130529
SAP Release Created in