SAP Table AFKO - Order header data PP orders

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
AUFNR X AUFNR CHAR 3 12 0 AUFK Order Number
GLTRP CO_GLTRP DATS 15 8 0 Basic finish date
GSTRP PM_ORDGSTRP DATS 23 8 0 Basic Start Date
FTRMS CO_FTRMS DATS 31 8 0 Scheduled release date
GLTRS CO_GLTRS DATS 39 8 0 Scheduled finish
GSTRS CO_GSTRS DATS 47 8 0 Scheduled start
GSTRI CO_GSTRI DATS 55 8 0 Actual start date
GETRI CO_GETRI DATS 63 8 0 Confirmed Order Finish Date
GLTRI CO_GLTRI DATS 71 8 0 Actual finish date
FTRMI CO_FTRMI DATS 79 8 0 Actual release date
FTRMP CO_FTRMP DATS 87 8 0 Planned release date
RSNUM RSNUM NUMC 95 10 0 Number of Reservation/Dependent Requirement
GASMG GASMG QUAN 105 13 3 Total scrap quantity in the order
GAMNG GAMNG QUAN 112 13 3 Total order quantity
GMEIN MEINS UNIT 119 3 0 T006 Base Unit of Measure
PLNBEZ MATNR CHAR 122 18 0 MARA Material Number
PLNTY PLNTY CHAR 140 1 0 TCA01 Task List Type
PLNNR PLNNR CHAR 141 8 0 Key for Task List Group
PLNAW PLNAW CHAR 149 1 0 TCA09 Application of the task list
PLNAL PLNAL CHAR 150 2 0 Group Counter
PVERW PLN_VERWE CHAR 152 3 0 T411 Task list usage
PLAUF CO_PLAUF DATS 155 8 0 Date for routing transfer
PLSVB LOSGRBIS QUAN 163 13 3 To lot size
PLNME PLNME UNIT 170 3 0 T006 Task list unit of measure
PLSVN LOSGRVON QUAN 173 13 3 From Lot Size
PDATV DATUV DATS 180 8 0 Valid-From Date
PAENR AENNR CHAR 188 12 0 Change Number
PLGRP VAGRP CHAR 200 3 0 T024A Responsible planner group/department
LODIV LOSDIV QUAN 203 13 3 Lot size divisor
STLTY STLTY CHAR 210 1 0 BOM category
STLBEZ MATNR CHAR 211 18 0 MARA Material Number
STLST STLST NUMC 229 2 0 T415S BOM status
STLNR STNUM CHAR 231 8 0 Bill of material
SDATV DATUV DATS 239 8 0 Valid-From Date
SBMNG BASMN QUAN 247 13 3 Base quantity
SBMEH MEINS UNIT 254 3 0 T006 Base Unit of Measure
SAENR AENNR CHAR 257 12 0 Change Number
STLAL STALT CHAR 269 2 0 Alternative BOM
STLAN STLAN CHAR 271 1 0 T416 BOM Usage
SLSVN LOSVN QUAN 272 13 3 From Lot Size
SLSBS LOSBS QUAN 279 13 3 To Lot Size
AUFLD CO_AUFLD DATS 286 8 0 Date of BOM Explosion/Routing Transfer
DISPO CO_DISPO CHAR 294 3 0 T024D MRP controller for the order
AUFPL CO_AUFPL NUMC 297 10 0 Routing number of operations in the order
FEVOR FEVOR CHAR 307 3 0 T024F Production Supervisor
FHORI FHORI CHAR 310 3 0 T436A Scheduling Margin Key for Floats
TERKZ TERMKZ CHAR 313 1 0 T482 Scheduling type
REDKZ REDKZ CHAR 314 1 0 Reduction indicator for scheduling
APRIO CO_APRIO CHAR 315 1 0 Order priority
NTZUE NETZ_UEBER CHAR 316 12 0 AUFK Superior network number
VORUE VORG_UEBER CHAR 328 4 0 Superior activity
PROFID PROFIDNZPL CHAR 332 7 0 TCN41 Network profile
VORGZ VORGZ NUMC 339 3 0 Float before production (in days)
SICHZ SICHZ NUMC 342 3 0 Float after production (in days)
FREIZ FREIZ NUMC 345 3 0 Release period (in days)
UPTER CO_UPTER CHAR 348 1 0 Indicator: Change to Scheduled Dates
BEDID BEDID NUMC 349 12 0 ID of the capacity requirements record
PRONR PS_PSP_PRO NUMC 361 8 0 PROJ Project definition
ZAEHL CIM_COUNT NUMC 369 8 0 Internal counter
MZAEHL CIM_COUNT NUMC 377 8 0 Internal counter
ZKRIZ DZKRIZ NUMC 385 7 0 Counter for additional criteria
PRUEFLOS QPLOS NUMC 392 12 0 QALS Inspection Lot Number
KLVARP KALKVARPLN CHAR 404 4 0 TCK03 Costing variant for planned costs
KLVARI KALKVARIST CHAR 408 4 0 TCK03 Costing variant for actual costs
RGEKZ CO_RGEKZ CHAR 412 1 0 Indicator: Backflushing for order
PLART PS_PLART CHAR 413 1 0 Basis for scheduling
FLG_AOB FLG_AOB CHAR 414 1 0 Indicator: relationships
FLG_ARBEI FLG_ARBEI CHAR 415 1 0 Indicator: Default value work is relevant
GLTPP CO_GLTPP DATS 416 8 0 Finish date (forecast)
GSTPP CO_GSTPP DATS 424 8 0 Forecast start date
GLTPS CO_GLTPS DATS 432 8 0 Scheduled forecast finish
GSTPS CO_GSTPS DATS 440 8 0 Scheduled forecast start
FTRPS CO_FTRPS DATS 448 8 0 Scheduled release date (forecast)
RDKZP REDKZP CHAR 456 1 0 Reduction indicator for scheduling (forecast)
TRKZP TERMKZP CHAR 457 1 0 T482 Scheduling type (forecast)
RUECK CO_RUECK NUMC 458 10 0 Completion confirmation number for the operation
RMZHL CIM_COUNT NUMC 468 8 0 Internal counter
IGMNG CO_IGMNG QUAN 476 13 3 Yield confirmed from order confirmation
RATID BEDID NUMC 483 12 0 ID of the capacity requirements record
GROID BEDID NUMC 495 12 0 ID of the capacity requirements record
CUOBJ CUOBJ NUMC 507 18 0 Configuration (internal object number)
GLUZS CO_GLUZS TIMS 525 6 0 Scheduled finish time
GSUZS CO_GSUZS TIMS 531 6 0 Scheduled start time
REVLV REVLV CHAR 537 2 0 Revision Level
RSHTY CR_OBJTY CHAR 539 2 0 Object types of the CIM resource
RSHID CR_OBJID NUMC 541 8 0 CRID Object ID of the resource
RSNTY CR_OBJTY CHAR 549 2 0 Object types of the CIM resource
RSNID CR_OBJID NUMC 551 8 0 CRID Object ID of the resource
NAUTERM CO_NAUTERM CHAR 559 1 0 Indicator: Do not schedule automatically
NAUCOST CO_NAUCOST CHAR 560 1 0 Indicator: Do not cost automatically
STUFE HISTU DEC 561 2 0 Level (in multi-level BOM explosions)
WEGXX WEGXX DEC 563 4 0 Path (for multi-level BOM explosions)
VWEGX WEGXX DEC 566 4 0 Path (for multi-level BOM explosions)
ARSNR RSNUM NUMC 569 10 0 Number of Reservation/Dependent Requirement
ARSPS CO_POSNR NUMC 579 4 0 Order Item Number
MAUFNR MAUFNR CHAR 583 12 0 AUFK Number of superior order
LKNOT CO_LKNOT CHAR 595 12 0 AUFK Left node in collective order
RKNOT CO_RKNOT CHAR 607 12 0 AUFK Right node of a collective order
PRODNET CO_PRODNET CHAR 619 1 0 Indicator: Order is part of collective order
IASMG CO_IASMG QUAN 620 13 3 Scrap confirmed for order
ABARB CO_ABARB NUMC 627 3 0 Confirmation: Degree of processing
AUFNT CO_TEILNET CHAR 630 12 0 AUFK Number of superior network
AUFPT CO_AUFPL NUMC 642 10 0 Routing number of operations in the order
APLZT CO_APLZL NUMC 652 8 0 General counter for order
NO_DISP NO_DISP_PLUS CHAR 660 1 0 Effective for Materials Planning
CSPLIT CSPLIT CHAR 661 4 0 MAKV Apportionment Structure
AENNR AENNR CHAR 665 12 0 Change Number
CY_SEQNR CY_SEQNR NUMC 677 14 0 Seq. number order
BREAKS BREAKS CHAR 691 1 0 Indicator: Scheduling allowing for breaks
VORGZ_TRM VORGZ_TRM DEC 692 6 3 Scheduled float before production in days
SICHZ_TRM SICHZ_TRM DEC 696 6 3 Scheduled float after production in days
TRMDT TRMDT DATS 700 8 0 Date of the last scheduling
GLUZP CO_GLUZP TIMS 708 6 0 Basic finish (time)
GSUZP CO_GSUZP TIMS 714 6 0 Basic start time
GSUZI CO_GSUZI TIMS 720 6 0 Actual start time
GEUZI CO_GEUZI TIMS 726 6 0 Confirmed order finish (time)
GLUPP CO_GLUPP TIMS 732 6 0 Forecast finish (time)
GSUPP CO_GSUPP TIMS 738 6 0 Forecast start (time)
GLUPS CO_GLUPS TIMS 744 6 0 Scheduled forecast finish time
GSUPS CO_GSUPS TIMS 750 6 0 Scheduled start time (Forecast)
CHSCH KALSMA_CH CHAR 756 6 0 T683 Search procedure for batch determination
KAPT_VORGZ KAPT_VORGZ NUMC 762 3 0 Float (bef. production) remaining after finite scheduling
KAPT_SICHZ KAPT_SICHZ NUMC 765 3 0 Remaining float after finite scheduling
LEAD_AUFNR CO_LAUFNR CHAR 768 12 0 AUFK Leading order in current processing
PNETSTARTD CO_PSTARTD DATS 780 8 0 Outline start of collective network (date)
PNETSTARTT CO_PSTARTT TIMS 788 6 0 Start time of a collective order
PNETENDD CO_PENDD DATS 794 8 0 Outline finish of collective order (date)
PNETENDT CO_PENDT TIMS 802 6 0 Outline finish time
KBED KBED_D CHAR 808 1 0 Ind: do not create capacity requirements
KKALKR COMP_CALC CHAR 809 1 0 Indicator: Components will not be costed
SFCPF CO_PRODPRF CHAR 810 6 0 TCO43 Production Scheduling Profile
RMNGA RMNGA QUAN 816 13 3 Total confirmed rework quantity
GSBTR CO_GSBTR DATS 823 8 0 Overall commitment date
VFMNG CO_VFMNG QUAN 831 13 3 Committed quantity for order acc. to ATP check components
NOPCOST CO_NOPCOST CHAR 838 1 0 Do not calculate planned costs for order
NETZKONT NETZKONT CHAR 839 1 0 Indicator for the account assignment of a network(hdr/act.)
ATRKZ ATRKZ CHAR 840 1 0 Request ID
OBJTYPE OCM_OBJ_TYPE CHAR 841 1 0 Change indicator
CH_PROC OCM_CH_PROC CHAR 842 1 0 Process that has lead to the change of an object
KAPVERSA KAPVERSA NUMC 843 2 0 Version of Available Capacity
COLORDPROC CO_COLORDPRC CHAR 845 1 0 Collective order with/without automatic goods movement
KZERB PS_KZERB CHAR 846 1 0 Indicator: Project summarization via master data charact.
CONF_KEY CC_CONF_KEY NUMC 847 8 0 Identical object
ST_ARBID OBJEKTID NUMC 855 8 0 Object ID
VSNMR_V VSNMR_V CHAR 863 12 0 Sales document version number
TERHW TERHW CHAR 875 1 0 Scheduling note from order scheduling
SPLSTAT SPLIT_STAT CHAR 876 1 0 Status of an order in a split hierarchy
COSTUPD CN_COSTUPD CHAR 877 1 0 Costs are updated
ADPSP ADCOMPARE CHAR 878 40 0 PM/PS Reference Element
RMANR VBELN CHAR 918 10 0 Sales and Distribution Document Number
POSNR_RMA POSNR NUMC 928 6 0 Item number of the SD document
POSNV_RMA POSNR NUMC 934 6 0 Item number of the SD document
OIHANTYP OIH_HANTYP CHAR 940 2 0 OIH5 Excise Duty Handling Type

1020260Delivery of Oracle statistics (Oracle 10g, 11g)
545932Performance probl. in CO-PC-OBJ period-end closing: DB hints
1640636Confirmation counter: Correction programs
1079126Performance probl. in CO-PC-OBJ per-end closing: Oracle Hint
1428393Error during a regulation check in transation CBRC21
1413882Selection filter in substance volume tracking
501156DP90/DP95: Composite SAP Note for performance notes
445323CJ20N, CJ20, CJ2A, CJ2B: termination when opening a project.
423830Database profile of logical database PSJ
1248654Network search help times out in SRM
1097150DP90: Long runtime due to full table scan on AFKO table
125155No PReq generated for external operations
678522FAQ 2: Data inconsistencies in the Project System
587278Performance problems in overhead calculation and settlement
786476LDB PSJ: Long runtimes during selections on the AFKO table
160841Order data is incomplete (AFKO and AFPO are missing)
36326Enhancement of KKRAMERK (3.0/4.0 orders)
867952IAA on CO production order with incorrect valuation
799649Runtime IQ03 (history) long SELECT to VIAUFKST
711979Generating measure from approp.requ.:start/finish not transf
484428Additional selection conditions for PP_ORDER / PR_ORDER
712384Number of closed orders
369254RCJCLMIG: Long runtime (Oracle)
414213ORACLE:Performance problms with CAUFV select (CN24 + others)
502044CJ2B: Display/highlighting PM/SM order: TIME_OUT
322154Performance w/period close manufacturng orders/COC hierarchy
396892DEL-IS-OIL 4.6C: Deleted IS-OIL fields
365054Expensive statement on view CAUFV
372771PSBW: Date extraction PS using GETWA_NOT_ASSIGNED
364934COCM: optimize search for procurement elements
187906Performance: Customer developments in PP and PM
209904Performance/period-end closing for prod.orders & COH
322284Bad performance because of access to VALLC
135254Perfrmance problems in Projct System as of Rel. 4.0