1. Home
  2. Resources
  3. SAP Tables
  4. SCY_AFKO - Subset structure of CAUFVD

SAP Table SCY_AFKO

Subset structure of CAUFVD

SCY_AFKO (Subset structure of CAUFVD) 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 SCY_AFKO to other SAP tables.

SCY_AFKO table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
AUFNR Order Number AUFNR CHAR 12 0
WERKS Plant WERKS_D CHAR 4 0
DISPO MRP controller for the order CO_DISPO CHAR 3 0
FEVOR Production Supervisor FEVOR CHAR 3 0
PVERW Task list usage PLN_VERWE CHAR 3 0
PLNBEZ Material Number MATNR CHAR 18 0
PLNAW Application of the task list PLNAW CHAR 1 0
PLNTY Task List Type PLNTY CHAR 1 0
PLNNR Key for Task List Group PLNNR CHAR 8 0
PLNAL Group Counter PLNAL CHAR 2 0
PLAUF Date for routing transfer CO_PLAUF DATS 8 0
PLGRP Responsible planner group/department VAGRP CHAR 3 0
PLSVB To lot size LOSGRBIS QUAN 13 3
PLSVN From Lot Size LOSGRVON QUAN 13 3
PLNME Task list unit of measure PLNME UNIT 3 0
PDATV Valid-From Date DATUV DATS 8 0
PAENR Change Number AENNR CHAR 12 0
STLTY BOM category STLTY CHAR 1 0
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
STLST BOM status STLST NUMC 2 0
STLNR Bill of material STNUM CHAR 8 0
STLAN BOM Usage STLAN CHAR 1 0
SDATV Valid-From Date DATUV DATS 8 0
SBMNG Base quantity BASMN QUAN 13 3
SBMEH Base Unit of Measure MEINS UNIT 3 0
SAENR Change Number AENNR CHAR 12 0
STLBEZ Material Number MATNR CHAR 18 0
STLAL Alternative BOM STALT CHAR 2 0
SLSVN From Lot Size LOSVN QUAN 13 3
SLSBS To Lot Size LOSBS QUAN 13 3
AUFLD Date of BOM Explosion/Routing Transfer CO_AUFLD DATS 8 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
FTRMS Scheduled release date CO_FTRMS DATS 8 0
FTRMI Actual release date CO_FTRMI DATS 8 0
FTRMP Planned release date CO_FTRMP DATS 8 0
GLTRP Basic finish date CO_GLTRP DATS 8 0
GSTRP Basic start date CO_GSTRP DATS 8 0
GLTRS Scheduled finish CO_GLTRS DATS 8 0
GSTRS Scheduled start CO_GSTRS DATS 8 0
GSTRI Actual start date CO_GSTRI DATS 8 0
GLTRI Actual finish date CO_GLTRI DATS 8 0
GETRI Confirmed Order Finish Date CO_GETRI DATS 8 0
GASMG Total scrap quantity in the order GASMG QUAN 13 3
GAMNG Total order quantity GAMNG QUAN 13 3
GMEIN Common unit of measure for all order items CO_GMEIN UNIT 3 0
TERKZ Scheduling type TERMKZ CHAR 1 0
REDKZ Reduction indicator for scheduling REDKZ CHAR 1 0
NULL No reduction carried out
1 Reduction level 1
2 Reduction level 2
3 Reduction level 3
4 Reduction level 4
5 Reduction level 5
6 Reduction level 6
FHORI Scheduling Margin Key for Floats FHORI CHAR 3 0
APRIO Order priority CO_APRIO CHAR 1 0
AUART Order Type AUFART 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
REFNR Reference order number AUFREFNR CHAR 12 0
ERNAM Entered by AUFERFNAM CHAR 12 0
ERDAT Created on AUFERFDAT DATS 8 0
AENAM Last changed by AUFAENAM CHAR 12 0
AEDAT Change date for Order Master AUFAEDAT DATS 8 0
KTEXT Description AUFTEXT CHAR 40 0
LTEXT Long Text Exists AUFLTEXT CHAR 1 0
X Yes
NULL No
BUKRS Company Code BUKRS CHAR 4 0
STATS Status Profile J_STSMA CHAR 8 0
OBJNR Object number J_OBJNR CHAR 22 0
LOEKZ Deletion flag AUFLOEKZ CHAR 1 0
X Yes
NULL No
GSBER Business Area GSBER CHAR 4 0
KOKRS Controlling Area KOKRS CHAR 4 0
CCKEY Cost collector key CCKEY CHAR 23 0
ASTKZ Identifier for statistical order AUFSTKZ CHAR 1 0
X Yes
NULL No
WAERS Order Currency AUFWAERS CUKY 5 0
OBJID Object ID CCOBJID CHAR 1 0
PLGKZ Identifier for planning with line items PLGKZ CHAR 1 0
X Yes
NULL No
KAPPL Application KAPPL CHAR 2 0
KALSM Costing Sheet AUFKALSM CHAR 6 0
ZSCHL Overhead key AUFZSCHL CHAR 6 0
ABKRS Processing group AUFABKRS NUMC 2 0
PROFID Network profile PROFIDNZPL CHAR 7 0
UPTER Indicator: Change to Scheduled Dates CO_UPTER CHAR 1 0
BEDID ID of the capacity requirements record BEDID NUMC 12 0
LODIV Lot size divisor LOSDIV QUAN 13 3
VORGZ Float before production (in days) VORGZ NUMC 3 0
SICHZ Float after production (in days) SICHZ NUMC 3 0
FREIZ Release period (in days) FREIZ NUMC 3 0
PRONR Project definition PS_PSP_PRO NUMC 8 0
PSPEL Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
ZAEHL Internal counter CIM_COUNT NUMC 8 0
MZAEHL Internal counter CIM_COUNT NUMC 8 0
ZKRIZ Counter for additional criteria DZKRIZ NUMC 7 0
PRUEFLOS Inspection Lot Number QPLOS NUMC 12 0
PLART Basis for scheduling PS_PLART CHAR 1 0
1 Basic dates
2 Forecast dates
RGEKZ Indicator: Backflush RGEKZ CHAR 1 0
X Yes
NULL No
KLVARP Costing variant for planned costs KALKVARPLN CHAR 4 0
KLVARI Costing variant for actual costs KALKVARIST CHAR 4 0
ABGSL Results Analysis Key ABGR_SCHL CHAR 6 0
AWSLS Variance Key AWSLS CHAR 6 0
VNAME Joint Venture JV_NAME CHAR 6 0
RECID Recovery Indicator JV_RECIND CHAR 2 0
FLG_AOB Indicator: relationships FLG_AOB CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
FLG_ARBEI Indicator: Default value work is relevant FLG_ARBEI CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
PRCTR Profit Center PRCTR CHAR 10 0
GLTPP Finish date (forecast) CO_GLTPP DATS 8 0
GSTPP Forecast start date CO_GSTPP DATS 8 0
GLTPS Scheduled forecast finish CO_GLTPS DATS 8 0
GSTPS Scheduled forecast start CO_GSTPS DATS 8 0
FTRPS Scheduled release date (forecast) CO_FTRPS DATS 8 0
RDKZP Reduction indicator for scheduling (forecast) REDKZP CHAR 1 0
NULL No reduction carried out
1 Reduction level 1
2 Reduction level 2
3 Reduction level 3
4 Reduction level 4
5 Reduction level 5
6 Reduction level 6
TRKZP Scheduling type (forecast) TERMKZP CHAR 1 0
RUECK Completion confirmation number for the operation CO_RUECK NUMC 10 0
RMZHL Internal counter CIM_COUNT NUMC 8 0
KVEWE Usage of the condition table KVEWE CHAR 1 0
IGMNG Yield confirmed from order confirmation CO_IGMNG QUAN 13 3
RATID ID of the capacity requirements record BEDID NUMC 12 0
GROID ID of the capacity requirements record BEDID NUMC 12 0
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
GLUZS Earliest scheduled finish: Execution (time) FSEDZ TIMS 6 0
GSUZS Earliest scheduled start: Execution (time) FSAVZ TIMS 6 0
REVLV Revision Level REVLV CHAR 2 0
RSHTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
RSHID Object ID of the resource CR_OBJID NUMC 8 0
RSNTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
RSNID Object ID of the resource CR_OBJID NUMC 8 0
AUTERM Indicator: Schedule automatically CO_AUTERM CHAR 1 0
X
NULL
AUCOST Indicator: Cost automatically CO_AUCOST CHAR 1 0
X
NULL
MATXT Material description CO_MATXT CHAR 40 0
KONTI Account assignment CO_KONTI CHAR 1 0
X
NULL
STTXT System Status CO_STTXT CHAR 40 0
ASTEX User status active CO_ASTEX CHAR 1 0
X
NULL
TXTKZ Long text exists CO_LTEXT CHAR 1 0
X Yes
NULL No
STDNR Number of standard networks to be copied PLNNR_REF CHAR 8 0
AVOUEB Indicator: Display operation overview AVOUEB CHAR 1 0
PRTRV Indicator: Project date definition PRTRV CHAR 1 0
X Yes
NULL No
SLDTV From selection date CO_SDATV DATS 8 0
SLDTB To selection date CO_SDATB DATS 8 0
FLG_TERM Indicator: Scheduling must take data changes into account FLG_TERM CHAR 1 0
X Yes
NULL No
FLG_TERDIA Indicator: Refill dialog table for scheduling FLG_TERDIA CHAR 1 0
FLG_DIRECT Indicator: Direct function call FLG_DIRECT CHAR 1 0
FLG_TRMV Indicator: Operation changes relevant to scheduling FLG_TRMV CHAR 1 0
X
NULL
FLG_TRME Indicator: Scheduling is carried out at least once FLG_TRME CHAR 1 0
X
NULL
GWEMG Delivered quantity CO_GWEMG QUAN 13 3
GIAMG Expected variance from planned qty to be delivered to stock CO_GIAMG QUAN 13 3
MIMEZ Expected yield variance CO_MIMEZ QUAN 13 3
APROZ Scrap percentage CO_APROZ DEC 5 2
IAPRZ Scrap percentage CO_APROZ DEC 5 2
VERAN Person/Group responsible for the network VANTW CHAR 3 0
NWART Type of network NWART CHAR 4 0
POSNR Order Item Number CO_POSNR NUMC 4 0
REDKZ_TX Description of reduction indicator REDKZ_TX CHAR 40 0
TERKZ_TX Description of scheduling type TERMKZ_TXT CHAR 30 0
PLART_TX Description of the basis for scheduling PLART_TX CHAR 40 0
TMBAS Set of dates for network PS_TERMBAS CHAR 1 0
1 Basic dates
2 Forecast dates
TMBAS_TX Description of the planning type TMBAS_TX CHAR 40 0
PROJN Work breakdown structure element (WBS element) PS_PSP_ELE NUMC 8 0
MATNR Material Number for Order CO_MATNR CHAR 18 0
FLG_PRINT Indicator: Order still to be printed (internal field) FLG_PRINT CHAR 1 0
X
NULL
ARTTEXT Text, 40 Characters Long TEXT40 CHAR 40 0
ASTTX Field displaying user status CO_ASTTX CHAR 40 0
KORRK Order conversion with the possibility of making corrections CO_KORRK CHAR 1 0
X Yes
NULL No
FREIKZ Indicator: Release order immediately CO_FREIKZ CHAR 1 0
X Yes
NULL No
PLAFKZ Indicator: Convert planned order with RSNUM CO_PLAFKZ CHAR 1 0
UMSKZ Indicator: Collective conversion of planned orders CO_UMSKZ CHAR 1 0
BMEINS Base Unit of Measure MEINS UNIT 3 0
BMENGE Base quantity BASMN QUAN 13 3
BAUMNG Base quantity BASMN QUAN 13 3
FLG_CALC Indicator: Order (network etc.) still to be calculated FLG_CALC CHAR 1 0
X
NULL
LOSGR Lot Size for Product Costing CK_LOSGR QUAN 13 3
TYPKZ Category of object causing the load (order category) TYPKZ CHAR 1 0
1 Work orders (detailed scheduling / routing...)
2 Planned orders (detailed scheduling / routing...)
3 SOP-Order (detailed scheduling / routing...)
4 Work order (prod. rate scheduling/rate routing)
5 Planned order (prod. rate scheduling/rate routing)
6 SOP-Order (prod. rate scheduling/rate routing)
7 Work order (rough-cut scheduling / profile)
8 Planned order (rough-cut scheduling / profile)
9 SOP-Order (rough-cut scheduling / profile)
A Maintenance task
B Maintenance messages
CREA_APL Application code, where the order/network was created CREA_APL CHAR 1 0
STUFE Level (in multi-level BOM explosions) HISTU DEC 2 0
WEGXX Path (for multi-level BOM explosions) WEGXX DEC 4 0
VWEGX Path (for multi-level BOM explosions) WEGXX DEC 4 0
INDBT Field defined as in SY-TABIX TABIX_D INT4 10 0
ARTPR Priority Type ARTPR CHAR 2 0
PRIOK Priority PRIOK CHAR 1 0
EQUNR Equipment Number EQUNR CHAR 18 0
BAUTL Assembly BAUTL CHAR 18 0
ILOAN Location and account assignment for technical object ILOAN CHAR 12 0
ILOAI ILOA Individual ILOAI CHAR 1 0
X Yes
NULL No
ANLZU Syst.Condition ANLZU CHAR 1 0
IWERK Maintenance Planning Plant IWERK CHAR 4 0
INGPR Planner Group for Customer Service and Plant Maintenance INGRP CHAR 3 0
APGRP Responsible planner group/department VAGRP CHAR 3 0
PM_OBJTY Object Type of CIM Resources for Work Center PM_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
GEWRK Object ID of the Work Center LGWID NUMC 8 0
KUNUM Customer Number KUNUM CHAR 10 0
ANING Name of Person Reponsible for System ANING CHAR 12 0
GAUZT Planned downtime in hours GAUZT FLTP 16 16
GAUEH Unit for Breakdown Duration MAUEH UNIT 3 0
ANLBD Date until which the system is available ANLBD DATS 8 0
ANLVD Date from which the system is available ANLVD DATS 8 0
ANLBZ Time until which the system is available ANLBZ TIMS 6 0
ANLVZ Time from Which System is Available ANLVZ TIMS 6 0
INSPK Name of Person Responsible for Technical Inspection INSPK CHAR 12 0
DATAN Date of Technical Inspection DATAN DATS 8 0
WARPL Maintenance Plan WARPL CHAR 12 0
ABNUM Maintenance Plan Call Number ABNUM INT4 10 0
WAPOS Maintenance item WAPOS CHAR 16 0
LAUFN Order number LAUFN CHAR 12 0
OBKNR Object list number OBJKNR INT4 10 0
REVNR Revision for Plant Maintenance and Customer Service REVNI CHAR 8 0
ADDAT PM Order: Reference Date ADDAT DATS 8 0
ADUHR Time of Reference Date ADUHR TIMS 6 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)
ILART Maintenance activity type ILA CHAR 3 0
QMNUM Notification No QMNUM CHAR 12 0
HISDA PM request: History date HISDA DATS 8 0
VAWRK Plant associated with main work center WERGW CHAR 4 0
VAPLZ Main work center for maintenance tasks GEWRK CHAR 8 0
VATXT Short text for the work center AP_KTEXT CHAR 40 0
INNAM Name of the Maintenance Planner Group INNAM CHAR 18 0
OL_AEKNZ Change indicator AEKNZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
PRINT_FLAG Indicator: Order Printing Requested PM_PRT_FLG CHAR 1 0
X Yes
NULL No
ABRUF_FLAG Flag: Maintenance plan call PM_ABR_FLG CHAR 1 0
X Yes
NULL No
WO_FLAG Indicator: Order Creation from PM Notification PM_WO_FLG CHAR 1 0
X Yes
NULL No
TPLNR Functional Location TPLNR CHAR 30 0
TPLNRI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ABCKZ ABC indicator for technical object ABCKZ CHAR 1 0
ABCKZI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
EQFNR Sort field EQFNR CHAR 30 0
EQFNRI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
SWERK Maintenance plant SWERK CHAR 4 0
SWERKI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
STORT Asset location STORT CHAR 10 0
STORTI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
MSGRP Room RAUMNR CHAR 8 0
MSGRPI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BEBER Plant section BEBER CHAR 3 0
BEBERI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
CR_OBJTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
PPSID Object ID of PP work center PPSID NUMC 8 0
PPSIDI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
PROID Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
PROIDI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
DAUFN Standing order number DAUFN CHAR 12 0
DAUFNI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
KOSTL Cost Center KOSTL CHAR 10 0
KOSTLI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ANLNR Main Asset Number ANLN1 CHAR 12 0
ANLNRI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ANLUN Asset Subnumber ANLN2 CHAR 4 0
ANLUNI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
IAUFNR Order Number AUFNR CHAR 12 0
AUFNRI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
IKOKRS Controlling Area KOKRS CHAR 4 0
KOKRSI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
IBUKRS Company Code BUKRS CHAR 4 0
BUKRSI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
IGSBER Business Area GSBER CHAR 4 0
GSBERI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
CREATE Ind.: Authorization exists CN_AUTH CHAR 1 0
X Yes
NULL No
CHANGE Ind.: Authorization exists CN_AUTH CHAR 1 0
X Yes
NULL No
DISPLAY Ind.: Authorization exists CN_AUTH CHAR 1 0
X Yes
NULL No
PSTEXT Ind.: Authorization exists CN_AUTH CHAR 1 0
X Yes
NULL No
MATERIAL Ind.: Authorization exists CN_AUTH CHAR 1 0
X Yes
NULL No
PRT Ind.: Authorization exists CN_AUTH CHAR 1 0
X Yes
NULL No
ACTELEM Ind.: Authorization exists CN_AUTH CHAR 1 0
X Yes
NULL No