SAP ABAP Table CYFI1 (Struct. containing all selectn. fields for capacity planning)

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	CYFI1	Table Relationship Diagram
Short Description	Struct. containing all selectn. fields for capacity 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	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
4	VERWE	☐	AP_VERWE	AP_VERWE	CHAR	4	0	Work Center Category	TC30
5	VERAN	☐	AP_VERAN	AP_VERAN	CHAR	3	0	Person responsible for the work center	TC24
6	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
7	LOART	☐	LOHNART	LOART	CHAR	4	0	Wage type
8	QUALF	☐	QUALF	QUALF	CHAR	2	0	Suitability	T423
9	TYPKZ	☐	CYFI1TYPKZ	CYFI1TYPKZ	CHAR	1	0	Category of object causing the load (order category)
10	PLANR	☐	KAPPLANER	KAPPLANER	CHAR	3	0	Capacity planner group	TC27
11	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
12	PLGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	T024A
13	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	T024D
14	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
15	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
16	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	*
17	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
18	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
19	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
20	CCKEY	☐	CY_CCKEY	CHAR23	CHAR	23	0	Cost collector key
21	KOSTV	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	*
22	ABKRS	☐	AUFABKRS	AKREIS	NUMC	2	0	Processing group	TKO08
23	KSTAR	☐	AUFKSTAR	KSTAR	CHAR	10	0	Settlement cost element	*
24	KOSTL	☐	AUFKOSTL	KOSTL	CHAR	10	0	Cost center for basic settlement	*
25	SAKNR	☐	AUFSAKNR	SAKNR	CHAR	10	0	G/L account for basic settlement	*
26	LOGRP	☐	LOHNGRP	LOHNGRP	CHAR	3	0	Wage group	T421
27	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	*
28	MATNR	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
29	PLWRK	☐	PLWRK	WERKS	CHAR	4	0	Planning Plant	T001W
30	PWWRK	☐	PWWRK	WERKS	CHAR	4	0	Production plant in planned order	T001W
31	PAART	☐	PAART	PAART	CHAR	4	0	Order type
32	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
33	PLSCN	☐	PLSCN	PLSCN	NUMC	3	0	Planning Scenario of Long-Term Planning	PLSC
34	AUFFX	☐	PLAFX	XFELD	CHAR	1	0	Firming indicator for planned order data
35	KAPFX	☐	KAPFX	XFELD	CHAR	1	0	Indicator: capacity for planned order dispatched
36	AUKOISTAT	☐	CY_IKSTAT	J_ISTAT	CHAR	5	0	Status / order header (internal)	TJ02
37	AUKOTXT03	☐	CY_TKSTAT	TEXT4	CHAR	4	0	Status / order header (text)
38	AFVGISTAT	☐	CY_IVSTAT	J_ISTAT	CHAR	5	0	Status / order operation or network activity (internal)	TJ02
39	AFVGTXT03	☐	CY_TVSTAT	TEXT4	CHAR	4	0	Status of an operation in an order (Text)
40	STAND	☐	AP_STAND	AP_STAND	CHAR	10	0	Work center location	T499S
41	NAME	☐	KAPNAME	KAPNAME	CHAR	8	0	Capacity name
42	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
43	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
44	PROJN	☐	PS_PSP_KPP	PS_PSP_KPP	CHAR	24	0	Name of WBS element for the selection
45	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
46	AFKOSELID	☐	SELID	SELID	CHAR	7	0	Selection ID	TJ48
47	AFVGSELID	☐	SELID	SELID	CHAR	7	0	Selection ID	TJ48
48	AFVGLOART	☐	LOHNART	LOART	CHAR	4	0	Wage type
49	AFVGLOGRP	☐	LOHNGRP	LOHNGRP	CHAR	3	0	Wage group	*
50	AFVGQUALF	☐	QUALF	QUALF	CHAR	2	0	Suitability	*
51	BSTKZ	☐	CY_BSTKZ	CY_BSTKZ	CHAR	1	0	Indicator rqmts.record is confirmed (cap.availability check)
52	APRIO	☐	CO_APRIO	CHAR1	CHAR	1	0	Order priority

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CYFI1	ABKRS	TKO08	ABKRS
2	CYFI1	AFKOSELID	TJ48	SELID
3	CYFI1	AFVGISTAT	TJ02	ISTAT
4	CYFI1	AFVGSELID	TJ48	SELID
5	CYFI1	AUART	T003O	AUART
6	CYFI1	AUFNR	AUFK	AUFNR
7	CYFI1	AUKOISTAT	TJ02	ISTAT
8	CYFI1	BUKRS	T001	BUKRS
9	CYFI1	DISPO	T024D	DISPO
10	CYFI1	GSBER	TGSB	GSBER
11	CYFI1	KAPAR	TC26	KAPAR
12	CYFI1	KDAUF	VBUK	VBELN
13	CYFI1	KOKRS	TKA01	KOKRS
14	CYFI1	LOGRP	T421	LOGRP
15	CYFI1	MATNR	MARA	MATNR
16	CYFI1	PLANR	TC27	PLANR
17	CYFI1	PLGRP	T024A	FEVOR
18	CYFI1	PLSCN	PLSC	PLSCN
19	CYFI1	PLWRK	T001W	WERKS
20	CYFI1	PWWRK	T001W	WERKS
21	CYFI1	QUALF	T423	QUALF
22	CYFI1	STAND	T499S	STAND
23	CYFI1	VERAN	TC24	VERAN
24	CYFI1	VERWE	TC30	VERWE
25	CYFI1	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in