1. Home
  2. Resources
  3. SAP Tables
  4. CYFI2 - Selection fields resource planning

SAP Table CYFI2

Selection fields resource planning

CYFI2 (Selection fields resource planning) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CYFI2 to other SAP tables.

Source: CYFI2 (Selection fields resource planning)

CYFI2 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
KAPAR Capacity category KAPART TC26 CHAR 3 0
KAKOKAPTER Indicator: Capacity relevant to finite scheduling KAP_KZTER CHAR 1 0
X Yes
NULL No
EINZKAPAR Category of individual capacity EKAPART CHAR 3 0
ARBPL Work center ARBPL CHAR 8 0
VERWE Work Center Category AP_VERWE TC30 CHAR 4 0
VERAN Person responsible for the work center AP_VERAN TC24 CHAR 3 0
AFVGWERKS Plant WERKS_D T001W CHAR 4 0
CRHDWERKS Plant WERKS_D T001W CHAR 4 0
KAKOWERKS Plant WERKS_D T001W CHAR 4 0
EINZWERKS Plant for individual capacity EWERKS CHAR 4 0
AFKOWERKS Plant WERKS_D T001W CHAR 4 0
AFVGLOART Wage Type LOHNART CHAR 4 0
AFVGQUALF Suitability QUALF T423 CHAR 2 0
TYPKZ Category of object causing the load (order category) CYFI2TYPKZ CHAR 1 0
1 Work order (detailed scheduling/task list...)
2 Planned order (detailed scheduling/task list...)
3 SOP-order (detailed planning/task list ...)
5 Planned order (production rate scheduling/rate routing)
6 SOP-order (production rate scheduling/rate routing)
8 Planned order (rough-cut scheduling/profile)
9 SOP order (rough-cut scheduling/profile)
PLANR Capacity planner group KAPPLANER TC27 CHAR 3 0
EINZPLANR Planner group for individual capacity EKAPPLANER CHAR 3 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
AFKOSEQNR Seq. number order CY_SEQNR NUMC 14 0
PLGRP Responsible planner group/department VAGRP T024A CHAR 3 0
DISPO MRP controller for the order CO_DISPO T024D CHAR 3 0
AUART Order Type AUFART T003O CHAR 4 0
AUTYP Order category AUFTYP NUMC 2 0
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
FEVOR Production Supervisor FEVOR CHAR 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
KOSTV Responsible cost center AUFKOSTV CHAR 10 0
KOSTL Cost center for basic settlement AUFKOSTL CHAR 10 0
AFVGLOGRP Wage group LOHNGRP T421 CHAR 3 0
PLNUM Planned order number PLNUM PLAF CHAR 10 0
AFPOMATNR Material Number for Order CO_MATNR MARA CHAR 18 0
PLAFMATNR Material Number for Order CO_MATNR MARA CHAR 18 0
PLWRK Planning Plant PLWRK T001W CHAR 4 0
PWWRK Production plant in planned order PWWRK T001W CHAR 4 0
PAART Order type PAART CHAR 4 0
NB Standard purchase order
LA Stock order
RS Reservation
KD Individual customer order
KB Consignment order
PE Run schedule quantity
VP Planned independent requirements
PR Project order
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
KAPFX Indicator: capacity for planned order dispatched KAPFX CHAR 1 0
X Yes
NULL No
NAME Capacity name KAPNAME CHAR 8 0
EINZNAME Name of individual capacity EKAPNAME CHAR 8 0
AFPOKDAUF Sales Order Number KDAUF VBUK CHAR 10 0
PLAFKDAUF Sales order number for planned order CY_KDAUF VBUK CHAR 10 0
SEQNR Seq. number order CY_SEQNR NUMC 14 0
AFPOKDPOS Item Number in Sales Order KDPOS NUMC 6 0
PLAFKDPOS Item Number in Sales Order KDPOS NUMC 6 0
AFPOPROJN Work breakdown structure element (WBS element) CY_POSID CHAR 24 0
AFVGPROJN Work breakdown structure element (WBS element) CY_POSID CHAR 24 0
PSPEL Work breakdown structure element (WBS element) CY_POSID CHAR 24 0
AFKOSELID Order Selection ID ORDSELID TJ48 CHAR 7 0
AFVGSELID Process Selection ID VRGSELID TJ48 CHAR 7 0
VORNR Operation/Activity Number VORNR CHAR 4 0
AFVGSEQNR Sequence number operation CY_SEQNRV NUMC 14 0
PLAFAUFNR Run schedule header number SA_AUFNR SAFK CHAR 12 0
EQUNR Equipment Number EQUNR EQUI CHAR 18 0
TPLNR Functional Location TPLNR IFLOT CHAR 30 0
OTYPE Object Type OTYPE T778O CHAR 2 0
PERNR Personnel Number PERNR_D NUMC 8 0
OBSTA Object status (order status) OBSTA CHAR 22 0
VRSIO Version number in the information structure VRSIO CHAR 3 0
KBSTA Status of a capacity requirements (object number) CY_KBSTA ONR00 CHAR 22 0
CANUMF Counter for the main capacity requirements record CANUMF NUMC 4 0
KBEDSELAV AFVG status in capacity requirements record (status profile) CYSELAV TJ48 CHAR 7 0
KBEDSELID Cap.reqmts status (selection profile) CYSELKB TJ48 CHAR 7 0
KBEDPLSCN Planning Scenario of Long-Term Planning PLSCN NUMC 3 0
KBEDBSTKZ Indicator rqmts.record is confirmed (cap.availability check) CY_BSTKZ CHAR 1 0
NULL 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 PHASE_KZ CHAR 1 0
0 Operation is not a phase and has no phases
1 Operation has phases
2 Operation is a phase
NULL No information about phases exists
KAPIE ID of main capacity EKAKOKAPID KAKO NUMC 8 0
PLSCN Planning Scenario of Long-Term Planning PLSCN NUMC 3 0
AUFFX Firming indicator for planned order data PLAFX CHAR 1 0
X Yes
NULL No
PHFLG Indicator: Phase PHFLG CHAR 1 0
X Yes
NULL No
ANLZU Syst.Condition ANLZU CHAR 1 0
APGRP Responsible planner group/department VAGRP CHAR 3 0
BAUTL Assembly BAUTL CHAR 18 0
GEWRK Main work center for maintenance tasks GEWRK CHAR 8 0
ILART Maintenance activity type ILA CHAR 3 0
INGPR Planner Group for Customer Service and Plant Maintenance INGRP CHAR 3 0
IPHAS Maintenance Processing Phase PM_PHASE CHAR 1 0
0 Outstanding
1 Postponed (currently not used)
2 Released
3 Technically completed
4 Manual deletion indicator set
5 Historical order
6 Completed for business (from 4.6)
IWERK Maintenance Planning Plant IWERK CHAR 4 0
PRIOK Priority PRIOK CHAR 1 0
REVNR Revision for Plant Maintenance and Customer Service REVNI CHAR 8 0
WAPOS Maintenance item WAPOS CHAR 16 0
WARPL Maintenance Plan WARPL CHAR 12 0
BEBER Plant section BEBER CHAR 3 0
EQFNR Sort field EQFNR CHAR 30 0
MSGRP Room RAUMNR CHAR 8 0
PPSID Object ID of PP work center PPSID NUMC 8 0
STORT Asset location STORT CHAR 10 0
SWERK Maintenance plant SWERK CHAR 4 0
MARAMATNR Material Number MATNR CHAR 18 0
SAFNR SOP order number SAFNR CHAR 10 0
AFKOVSNMR Number or description of a version VSNMR CHAR 12 0
AFVGVSNMR Number or description of a version VSNMR CHAR 12 0
KBEDVSNMR Number or description of a version VSNMR CHAR 12 0
AFKOLEAD Leading order in current processing CO_LAUFNR CHAR 12 0

CYFI2 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CYFI2 AFKOSELID CYFI2 MANDT TJ48 Check Table for Selection IDs MANDT
CYFI2 AFKOSELID CYFI2 AFKOSELID TJ48 Check Table for Selection IDs SELID
CYFI2 AFKOWERKS CYFI2 MANDT T001W Plants/Branches MANDT
CYFI2 AFKOWERKS CYFI2 AFKOWERKS T001W Plants/Branches WERKS
CYFI2 AFPOKDAUF CYFI2 AFPOKDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
CYFI2 AFPOKDAUF CYFI2 MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
CYFI2 AFPOMATNR CYFI2 AFPOMATNR MARA General Material Data MATNR
CYFI2 AFPOMATNR CYFI2 MANDT MARA General Material Data MANDT
CYFI2 AFVGLOGRP CYFI2 AFVGLOGRP T421 Wage groups LOGRP
CYFI2 AFVGLOGRP CYFI2 AFKOWERKS T421 Wage groups WERKS
CYFI2 AFVGLOGRP CYFI2 MANDT T421 Wage groups MANDT
CYFI2 AFVGQUALF CYFI2 AFVGQUALF T423 Wage group qualification QUALF
CYFI2 AFVGQUALF CYFI2 AFKOWERKS T423 Wage group qualification WERKS
CYFI2 AFVGQUALF CYFI2 MANDT T423 Wage group qualification MANDT
CYFI2 AFVGSELID CYFI2 AFVGSELID TJ48 Check Table for Selection IDs SELID
CYFI2 AFVGSELID CYFI2 MANDT TJ48 Check Table for Selection IDs MANDT
CYFI2 AFVGWERKS CYFI2 AFVGWERKS T001W Plants/Branches WERKS
CYFI2 AFVGWERKS CYFI2 MANDT T001W Plants/Branches MANDT
CYFI2 AUART CYFI2 AUART T003O Order Types AUART
CYFI2 AUART CYFI2 MANDT T003O Order Types CLIENT
CYFI2 AUFNR CYFI2 AUFNR AUFK Order master data AUFNR
CYFI2 AUFNR CYFI2 MANDT AUFK Order master data MANDT
CYFI2 BUKRS CYFI2 MANDT T001 Company Codes MANDT
CYFI2 BUKRS CYFI2 BUKRS T001 Company Codes BUKRS
CYFI2 CRHDWERKS CYFI2 CRHDWERKS T001W Plants/Branches WERKS
CYFI2 CRHDWERKS CYFI2 MANDT T001W Plants/Branches MANDT
CYFI2 DISPO CYFI2 MANDT T024D MRP controllers MANDT
CYFI2 DISPO CYFI2 AFKOWERKS T024D MRP controllers WERKS
CYFI2 DISPO CYFI2 DISPO T024D MRP controllers DISPO
CYFI2 EQUNR CYFI2 EQUNR EQUI Equipment master data EQUNR
CYFI2 EQUNR CYFI2 MANDT EQUI Equipment master data MANDT
CYFI2 GSBER CYFI2 MANDT TGSB Business Areas MANDT
CYFI2 GSBER CYFI2 GSBER TGSB Business Areas GSBER
CYFI2 KAKOWERKS CYFI2 KAKOWERKS T001W Plants/Branches WERKS
CYFI2 KAKOWERKS CYFI2 MANDT T001W Plants/Branches MANDT
CYFI2 KAPAR CYFI2 MANDT TC26 Capacity category MANDT
CYFI2 KAPAR CYFI2 KAPAR TC26 Capacity category KAPAR
CYFI2 KAPIE CYFI2 KAPIE KAKO Capacity Header Segment KAPID
CYFI2 KAPIE CYFI2 MANDT KAKO Capacity Header Segment MANDT
CYFI2 KBEDSELAV CYFI2 KBEDSELAV TJ48 Check Table for Selection IDs SELID
CYFI2 KBEDSELAV CYFI2 MANDT TJ48 Check Table for Selection IDs MANDT
CYFI2 KBEDSELID CYFI2 KBEDSELID TJ48 Check Table for Selection IDs SELID
CYFI2 KBEDSELID CYFI2 MANDT TJ48 Check Table for Selection IDs MANDT
CYFI2 KBSTA CYFI2 KBSTA ONR00 General Object Number OBJNR
CYFI2 KBSTA CYFI2 MANDT ONR00 General Object Number MANDT
CYFI2 OTYPE CYFI2 OTYPE T778O Object Types OTYPE
CYFI2 OTYPE CYFI2 MANDT T778O Object Types MANDT
CYFI2 PLAFAUFNR CYFI2 MANDT SAFK Run Schedule Master Data MANDT
CYFI2 PLAFAUFNR CYFI2 PLAFAUFNR SAFK Run Schedule Master Data AUFNR
CYFI2 PLAFKDAUF CYFI2 MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
CYFI2 PLAFKDAUF CYFI2 PLAFKDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
CYFI2 PLAFMATNR CYFI2 PLAFMATNR MARA General Material Data MATNR
CYFI2 PLAFMATNR CYFI2 MANDT MARA General Material Data MANDT
CYFI2 PLANR CYFI2 PLANR TC27 Capacity planner groups PLANR
CYFI2 PLANR CYFI2 MANDT TC27 Capacity planner groups MANDT
CYFI2 PLGRP CYFI2 MANDT T024A Planner group MANDT
CYFI2 PLGRP CYFI2 AFKOWERKS T024A Planner group WERKS
CYFI2 PLGRP CYFI2 PLGRP T024A Planner group FEVOR
CYFI2 PLNUM CYFI2 MANDT PLAF Planned Order MANDT
CYFI2 PLNUM CYFI2 PLNUM PLAF Planned Order PLNUM
CYFI2 PLWRK CYFI2 PLWRK T001W Plants/Branches WERKS
CYFI2 PLWRK CYFI2 MANDT T001W Plants/Branches MANDT
CYFI2 PWWRK CYFI2 PWWRK T001W Plants/Branches WERKS
CYFI2 PWWRK CYFI2 MANDT T001W Plants/Branches MANDT
CYFI2 TPLNR CYFI2 TPLNR IFLOT Functional Location (Table) TPLNR
CYFI2 TPLNR CYFI2 MANDT IFLOT Functional Location (Table) MANDT
CYFI2 VERAN CYFI2 MANDT TC24 Person responsible for the work center MANDT
CYFI2 VERAN CYFI2 AFVGWERKS TC24 Person responsible for the work center WERKS
CYFI2 VERAN CYFI2 VERAN TC24 Person responsible for the work center VERAN
CYFI2 VERWE CYFI2 MANDT TC30 Work center category MANDT
CYFI2 VERWE CYFI2 VERWE TC30 Work center category VERWE