SAP table CYFI2 (Selection fields resource planning)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
KAPAR Capacity category CHAR 3 0 TC26 KAPART
KAKOKAPTER Indicator: Capacity Relevant to Finite Scheduling CHAR 1 0 KAP_KZTER
EINZKAPAR Category of individual capacity CHAR 3 0 EKAPART
ARBPL Work Center CHAR 8 0 ARBPL
VERWE Work Center Category CHAR 4 0 TC30 AP_VERWE
VERAN Person Responsible for the Work Center CHAR 3 0 TC24 AP_VERAN
AFVGWERKS Plant CHAR 4 0 T001W WERKS_D
CRHDWERKS Plant CHAR 4 0 T001W WERKS_D
KAKOWERKS Plant CHAR 4 0 T001W WERKS_D
EINZWERKS Plant for individual capacity CHAR 4 0 EWERKS
AFKOWERKS Plant CHAR 4 0 T001W WERKS_D
AFVGLOART Wage type CHAR 4 0 LOHNART
AFVGQUALF Suitability CHAR 2 0 T423 QUALF
TYPKZ Category of object causing the load (order category) CHAR 1 0 CYFI2TYPKZ
1 Work order (detailed scheduling/task list...)
2 Planned order (detailed scheduling/task list...)
3 SOP-order (detailed planning/task list ...)
PLANR Capacity Responsible Planner Group CHAR 3 0 TC27 KAPPLANER
EINZPLANR Planner group for individual capacity CHAR 3 0 EKAPPLANER
AUFNR Order Number CHAR 12 0 AUFK AUFNR
AFKOSEQNR Sequence Number Order NUMC 14 0 CY_SEQNR
PLGRP Responsible Planner Group or Department CHAR 3 0 T024A VAGRP
DISPO MRP controller for the order CHAR 3 0 T024D CO_DISPO
AUART Order Type CHAR 4 0 T003O AUFART
AUTYP Order category NUMC 2 0 AUFTYP
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
99 Master Planned order
FEVOR Production Supervisor CHAR 3 0 FEVOR
BUKRS Company Code CHAR 4 0 T001 BUKRS
GSBER Business Area CHAR 4 0 TGSB GSBER
KOSTV Responsible cost center CHAR 10 0 AUFKOSTV
KOSTL Cost Center for Basic Settlement CHAR 10 0 AUFKOSTL
AFVGLOGRP Wage Group CHAR 3 0 T421 LOHNGRP
PLNUM Planned Order CHAR 10 0 PLAF PLNUM
AFPOMATNR Material Number for Order CHAR 40 0 MARA CO_MATNR
PLAFMATNR Material Number for Order CHAR 40 0 MARA CO_MATNR
PLWRK Planning Plant CHAR 4 0 T001W PLWRK
PWWRK Production Plant CHAR 4 0 T001W PWWRK
PAART Planned Order Type CHAR 4 0 PAART
KB Consignment order
KD Individual customer order
LA Stock order
LX External planned order
NB Standard purchase order
PE Run schedule quantity
PR Project order
RS Reservation
VP Planned independent requirements
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
KAPFX Indicator: Capacity for Planned Order is Dispatched CHAR 1 0 KAPFX
NAME Capacity name CHAR 8 0 KAPNAME
EINZNAME Name of individual capacity CHAR 8 0 EKAPNAME
AFPOKDAUF Sales Order Number CHAR 10 0 KDAUF
PLAFKDAUF Sales order number for planned order CHAR 10 0 CY_KDAUF
SEQNR Sequence Number Order NUMC 14 0 CY_SEQNR
AFPOKDPOS Item number in Sales Order NUMC 6 0 KDPOS
PLAFKDPOS Item number in Sales Order NUMC 6 0 KDPOS
AFPOPROJN Work breakdown structure element (WBS element) CHAR 24 0 CY_POSID
AFVGPROJN Work breakdown structure element (WBS element) CHAR 24 0 CY_POSID
PSPEL Work breakdown structure element (WBS element) CHAR 24 0 CY_POSID
AFKOSELID Order Selection ID CHAR 7 0 TJ48 ORDSELID
AFVGSELID Process Selection ID CHAR 7 0 TJ48 VRGSELID
VORNR Operation/Activity Number CHAR 4 0 VORNR
AFVGSEQNR Sequence number operation NUMC 14 0 CY_SEQNRV
PLAFAUFNR Run schedule header number CHAR 12 0 SAFK SA_AUFNR
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
TPLNR Functional Location CHAR 30 0 IFLOT TPLNR
OTYPE Object Type CHAR 2 0 T778O OTYPE
PERNR Personnel Number NUMC 8 0 PERNR_D
OBSTA Object status (order status) CHAR 22 0 OBSTA
VRSIO Version number in the information structure CHAR 3 0 VRSIO
KBSTA Status of a Capacity Requirements (Object Number) CHAR 22 0 ONR00 CY_KBSTA
CANUMF Counter for the main capacity requirements record NUMC 4 0 CANUMF
KBEDSELAV AFVG status in capacity requirements record (status profile) CHAR 7 0 TJ48 CYSELAV
KBEDSELID Cap.reqmts status (selection profile) CHAR 7 0 TJ48 CYSELKB
KBEDPLSCN Planning Scenario in Long-Term Planning NUMC 3 0 PLSCN
KBEDBSTKZ Capacity Requirement Availability Confirmation Code CHAR 1 0 CY_BSTKZ
Not yet checked or no capacity relevant to finite scheduling
1 Capacity available
2 Missing capacity
3 The requirements record belongs to a dispatched operation
KBPHASE_KZ Indicator: Phase CHAR 1 0 PHASE_KZ
No information about phases exists
0 Operation is not a phase and has no phases
1 Operation has phases
2 Operation is a phase
KAPIE ID of main capacity NUMC 8 0 KAKO EKAKOKAPID
PLSCN Planning Scenario in Long-Term Planning NUMC 3 0 PLSCN
AUFFX Firming Indicator for Planned Order Data CHAR 1 0 PLAFX
PHFLG Indicator: Phase CHAR 1 0 PHFLG
ANLZU System Condition CHAR 1 0 ANLZU
APGRP Responsible Planner Group or Department CHAR 3 0 VAGRP
BAUTL Assembly CHAR 40 0 BAUTL
GEWRK Main work center for maintenance tasks CHAR 8 0 GEWRK
ILART Maintenance activity type CHAR 3 0 ILA
INGPR Planner Group for Customer Service and Plant Maintenance CHAR 3 0 INGRP
IPHAS Maintenance Processing Phase CHAR 1 0 PM_PHASE
0 Outstanding
1 Postponed (currently not used)
2 Released
3 Technically completed
4 Manual deletion indicator set
5 Historical order
6 Completed for business
IWERK Maintenance Planning Plant CHAR 4 0 IWERK
PRIOK Priority CHAR 1 0 PRIOK
REVNR Revision for Plant Maintenance and Customer Service CHAR 8 0 REVNI
WAPOS Maintenance item CHAR 16 0 WAPOS
WARPL Maintenance Plan CHAR 12 0 WARPL
BEBER Plant Section CHAR 3 0 BEBER
EQFNR Sort Field CHAR 30 0 EQFNR
MSGRP Room CHAR 8 0 RAUMNR
PPSID Object ID of PP work center NUMC 8 0 PPSID
STORT Asset location CHAR 10 0 STORT
SWERK Maintenance Plant CHAR 4 0 SWERK
MARAMATNR Material Number CHAR 40 0 MATNR
SAFNR Sales Operations Planning Order CHAR 10 0 SAFNR
AFKOVSNMR Number or description of a version CHAR 12 0 VSNMR
AFVGVSNMR Number or description of a version CHAR 12 0 VSNMR
KBEDVSNMR Number or description of a version CHAR 12 0 VSNMR
AFKOLEAD Leading Order in Current Processing CHAR 12 0 CO_LAUFNR

CYFI2 foreign key relationships

Table Field Check Table Check Field
0 CYFI2 AFKOWERKS T001W Plants/Branches MANDT
0 CYFI2 AFKOWERKS T001W Plants/Branches WERKS
1 CYFI2 AFPOMATNR MARA General Material Data MANDT
1 CYFI2 AFPOMATNR MARA General Material Data MATNR
0 CYFI2 AFVGLOGRP T421 Wage groups MANDT
1 CYFI2 AFVGQUALF T423 Wage group qualification MANDT
1 CYFI2 AFVGQUALF T423 Wage group qualification QUALF
0 CYFI2 AFVGWERKS T001W Plants/Branches MANDT
0 CYFI2 AFVGWERKS T001W Plants/Branches WERKS
1 CYFI2 AUART T003O Order Types AUART
0 CYFI2 AUFNR AUFK Order master data AUFNR
1 CYFI2 BUKRS T001 Company Codes BUKRS
0 CYFI2 CRHDWERKS T001W Plants/Branches MANDT
0 CYFI2 CRHDWERKS T001W Plants/Branches WERKS
1 CYFI2 DISPO T024D MRP Controllers MANDT
1 CYFI2 DISPO T024D MRP Controllers WERKS
1 CYFI2 DISPO T024D MRP Controllers DISPO
0 CYFI2 EQUNR EQUI Equipment master data MANDT
1 CYFI2 GSBER TGSB Business Areas MANDT
1 CYFI2 GSBER TGSB Business Areas GSBER
0 CYFI2 KAKOWERKS T001W Plants/Branches MANDT
0 CYFI2 KAKOWERKS T001W Plants/Branches WERKS
1 CYFI2 KAPAR TC26 Capacity category MANDT
0 CYFI2 KAPIE KAKO Capacity Header Segment MANDT
1 CYFI2 KBSTA ONR00 General Object Number MANDT
0 CYFI2 OTYPE T778O Object Types MANDT
0 CYFI2 OTYPE T778O Object Types OTYPE
1 CYFI2 PLAFAUFNR SAFK Run Schedule Master Data MANDT
1 CYFI2 PLAFAUFNR SAFK Run Schedule Master Data AUFNR
0 CYFI2 PLAFMATNR MARA General Material Data MANDT
0 CYFI2 PLAFMATNR MARA General Material Data MATNR
1 CYFI2 PLANR TC27 Capacity planner groups MANDT
1 CYFI2 PLANR TC27 Capacity planner groups PLANR
0 CYFI2 PLGRP T024A Planner group WERKS
1 CYFI2 PLNUM PLAF Planned Order MANDT
0 CYFI2 PLWRK T001W Plants/Branches MANDT
0 CYFI2 PLWRK T001W Plants/Branches WERKS
1 CYFI2 PWWRK T001W Plants/Branches MANDT
1 CYFI2 PWWRK T001W Plants/Branches WERKS
0 CYFI2 VERAN TC24 Person responsible for the work center MANDT
0 CYFI2 VERAN TC24 Person responsible for the work center WERKS
1 CYFI2 VERWE TC30 Work center category MANDT