SAP ABAP Table CYFI2 (Selection fields resource planning)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	CYFI2	Table Relationship Diagram
Short Description	Selection fields resource planning

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	KAPAR	☐	KAPART	KAPART	CHAR	3	0	Capacity category	TC26
3	KAKOKAPTER	☐	KAP_KZTER	XFELD	CHAR	1	0	Indicator: Capacity relevant to finite scheduling
4	EINZKAPAR	☐	EKAPART	KAPART	CHAR	3	0	Category of individual capacity	*
5	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
6	VERWE	☐	AP_VERWE	AP_VERWE	CHAR	4	0	Work Center Category	TC30
7	VERAN	☐	AP_VERAN	AP_VERAN	CHAR	3	0	Person responsible for the work center	TC24
8	AFVGWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	CRHDWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	KAKOWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
11	EINZWERKS	☐	EWERKS	WERKS	CHAR	4	0	Plant for individual capacity	*
12	AFKOWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
13	AFVGLOART	☐	LOHNART	LOART	CHAR	4	0	Wage type
14	AFVGQUALF	☐	QUALF	QUALF	CHAR	2	0	Suitability	T423
15	TYPKZ	☐	CYFI2TYPKZ	CYFI2TYPKZ	CHAR	1	0	Category of object causing the load (order category)
16	PLANR	☐	KAPPLANER	KAPPLANER	CHAR	3	0	Capacity planner group	TC27
17	EINZPLANR	☐	EKAPPLANER	KAPPLANER	CHAR	3	0	Planner group for individual capacity	*
18	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
19	AFKOSEQNR	☐	CY_SEQNR	CY_SEQNR	NUMC	14	0	Seq. number order
20	PLGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	T024A
21	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	T024D
22	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
23	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
24	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	*
25	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
26	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
27	KOSTV	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	*
28	KOSTL	☐	AUFKOSTL	KOSTL	CHAR	10	0	Cost center for basic settlement	*
29	AFVGLOGRP	☐	LOHNGRP	LOHNGRP	CHAR	3	0	Wage group	T421
30	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	PLAF
31	AFPOMATNR	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
32	PLAFMATNR	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
33	PLWRK	☐	PLWRK	WERKS	CHAR	4	0	Planning Plant	T001W
34	PWWRK	☐	PWWRK	WERKS	CHAR	4	0	Production plant in planned order	T001W
35	PAART	☐	PAART	PAART	CHAR	4	0	Order type
36	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
37	KAPFX	☐	KAPFX	XFELD	CHAR	1	0	Indicator: capacity for planned order dispatched
38	NAME	☐	KAPNAME	KAPNAME	CHAR	8	0	Capacity name
39	EINZNAME	☐	EKAPNAME	KAPNAME	CHAR	8	0	Name of individual capacity
40	AFPOKDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
41	PLAFKDAUF	☐	CY_KDAUF	VBELN	CHAR	10	0	Sales order number for planned order	VBUK
42	SEQNR	☐	CY_SEQNR	CY_SEQNR	NUMC	14	0	Seq. number order
43	AFPOKDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
44	PLAFKDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
45	AFPOPROJN	☐	CY_POSID	PS_POSID	CHAR	24	0	Work breakdown structure element (WBS element)
46	AFVGPROJN	☐	CY_POSID	PS_POSID	CHAR	24	0	Work breakdown structure element (WBS element)
47	PSPEL	☐	CY_POSID	PS_POSID	CHAR	24	0	Work breakdown structure element (WBS element)
48	AFKOSELID	☐	ORDSELID	SELID	CHAR	7	0	Order Selection ID	TJ48
49	AFVGSELID	☐	VRGSELID	SELID	CHAR	7	0	Process Selection ID	TJ48
50	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
51	AFVGSEQNR	☐	CY_SEQNRV	CY_SEQNR	NUMC	14	0	Sequence number operation
52	PLAFAUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
53	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
54	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
55	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
56	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
57	OBSTA	☐	OBSTA	J_OBJNR	CHAR	22	0	Object status (order status)	*
58	VRSIO	☐	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
59	KBSTA	☐	CY_KBSTA	J_OBJNR	CHAR	22	0	Status of a capacity requirements (object number)	ONR00
60	CANUMF	☐	CANUMF	NUM4	NUMC	4	0	Counter for the main capacity requirements record
61	KBEDSELAV	☐	CYSELAV	SELID	CHAR	7	0	AFVG status in capacity requirements record (status profile)	TJ48
62	KBEDSELID	☐	CYSELKB	SELID	CHAR	7	0	Cap.reqmts status (selection profile)	TJ48
63	KBEDPLSCN	☐	PLSCN	PLSCN	NUMC	3	0	Planning Scenario of Long-Term Planning	*
64	KBEDBSTKZ	☐	CY_BSTKZ	CY_BSTKZ	CHAR	1	0	Indicator rqmts.record is confirmed (cap.availability check)
65	KBPHASE_KZ	☐	PHASE_KZ	PHASE_KZ	CHAR	1	0	Indicator: Phase
66	KAPIE	☐	EKAKOKAPID	KAPID	NUMC	8	0	ID of main capacity	KAKO
67	PLSCN	☐	PLSCN	PLSCN	NUMC	3	0	Planning Scenario of Long-Term Planning	*
68	AUFFX	☐	PLAFX	XFELD	CHAR	1	0	Firming indicator for planned order data
69	PHFLG	☐	PHFLG	XFELD	CHAR	1	0	Indicator: Phase
70	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	*
71	APGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	*
72	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	*
73	GEWRK	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
74	ILART	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	*
75	INGPR	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	*
76	IPHAS	☐	PM_PHASE	PM_PHASE	CHAR	1	0	Maintenance Processing Phase
77	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	*
78	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	*
79	REVNR	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	*
80	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
81	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	*
82	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	*
83	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
84	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
85	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	*
86	STORT	☐	STORT	AP_STAND	CHAR	10	0	Asset location	*
87	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	*
88	MARAMATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
89	SAFNR	☐	SAFNR	SAFNR	CHAR	10	0	SOP order number
90	AFKOVSNMR	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
91	AFVGVSNMR	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
92	KBEDVSNMR	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
93	AFKOLEAD	☐	CO_LAUFNR	AUFNR	CHAR	12	0	Leading order in current processing	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CYFI2	AFKOSELID	TJ48	SELID
2	CYFI2	AFKOWERKS	T001W	WERKS
3	CYFI2	AFPOKDAUF	VBUK	VBELN
4	CYFI2	AFPOMATNR	MARA	MATNR
5	CYFI2	AFVGLOGRP	T421	LOGRP
6	CYFI2	AFVGQUALF	T423	QUALF
7	CYFI2	AFVGSELID	TJ48	SELID
8	CYFI2	AFVGWERKS	T001W	WERKS
9	CYFI2	AUART	T003O	AUART
10	CYFI2	AUFNR	AUFK	AUFNR
11	CYFI2	BUKRS	T001	BUKRS
12	CYFI2	CRHDWERKS	T001W	WERKS
13	CYFI2	DISPO	T024D	DISPO
14	CYFI2	EQUNR	EQUI	EQUNR
15	CYFI2	GSBER	TGSB	GSBER
16	CYFI2	KAKOWERKS	T001W	WERKS
17	CYFI2	KAPAR	TC26	KAPAR
18	CYFI2	KAPIE	KAKO	KAPID
19	CYFI2	KBEDSELAV	TJ48	SELID
20	CYFI2	KBEDSELID	TJ48	SELID
21	CYFI2	KBSTA	ONR00	OBJNR
22	CYFI2	OTYPE	T778O	OTYPE
23	CYFI2	PLAFAUFNR	SAFK	AUFNR
24	CYFI2	PLAFKDAUF	VBUK	VBELN
25	CYFI2	PLAFMATNR	MARA	MATNR
26	CYFI2	PLANR	TC27	PLANR
27	CYFI2	PLGRP	T024A	FEVOR
28	CYFI2	PLNUM	PLAF	PLNUM
29	CYFI2	PLWRK	T001W	WERKS
30	CYFI2	PWWRK	T001W	WERKS
31	CYFI2	TPLNR	IFLOT	TPLNR
32	CYFI2	VERAN	TC24	VERAN
33	CYFI2	VERWE	TC30	VERWE

History

Last changed by/on	SAP	20130529
SAP Release Created in