SAP ABAP Table AFKO (Order Header Data PP Orders)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-CIC (Application Component) Interaction Center WinClient
⤷ CO (Package) R/3 Application development: PP Production orders
⤷ CRM-CIC (Application Component) Interaction Center WinClient
⤷ CO (Package) R/3 Application development: PP Production orders
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | AFKO | Table Relationship Diagram |
Short Description | Order Header Data PP Orders |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | T000 | |
2 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
3 | .INCLUDE | 0 | 0 | Order Header Data PP Orders | |||||
4 | GLTRP | CO_GLTRP | DATUM | DATS | 8 | 0 | Basic finish date | ||
5 | GSTRP | CO_GSTRP | DATUM | DATS | 8 | 0 | Basic start date | ||
6 | FTRMS | CO_FTRMS | DATUM | DATS | 8 | 0 | Scheduled release date | ||
7 | GLTRS | CO_GLTRS | DATUM | DATS | 8 | 0 | Scheduled finish | ||
8 | GSTRS | CO_GSTRS | DATUM | DATS | 8 | 0 | Scheduled start | ||
9 | GSTRI | CO_GSTRI | DATUM | DATS | 8 | 0 | Actual start date | ||
10 | GETRI | CO_GETRI | DATUM | DATS | 8 | 0 | Confirmed Order Finish Date | ||
11 | GLTRI | CO_GLTRI | DATUM | DATS | 8 | 0 | Actual finish date | ||
12 | FTRMI | CO_FTRMI | DATUM | DATS | 8 | 0 | Actual release date | ||
13 | FTRMP | CO_FTRMP | DATUM | DATS | 8 | 0 | Planned release date | ||
14 | RSNUM | RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | * | |
15 | GASMG | GASMG | MENG13 | QUAN | 13 | 3 | Total scrap quantity in the order | ||
16 | GAMNG | GAMNG | MENG13 | QUAN | 13 | 3 | Total order quantity | ||
17 | GMEIN | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
18 | PLNBEZ | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
19 | PLNTY | PLNTY | PLNTY | CHAR | 1 | 0 | Task List Type | * | |
20 | PLNNR | PLNNR | PLNNR | CHAR | 8 | 0 | Key for Task List Group | ||
21 | PLNAW | PLNAW | PLNAW | CHAR | 1 | 0 | Application of the task list | * | |
22 | PLNAL | PLNAL | ALTNR | CHAR | 2 | 0 | Group Counter | ||
23 | PVERW | PLN_VERWE | PLN_VERWE | CHAR | 3 | 0 | Task list usage | * | |
24 | PLAUF | CO_PLAUF | DATUM | DATS | 8 | 0 | Date for routing transfer | ||
25 | PLSVB | LOSGRBIS | MENG13 | QUAN | 13 | 3 | To lot size | ||
26 | PLNME | PLNME | MEINS | UNIT | 3 | 0 | Task list unit of measure | T006 | |
27 | PLSVN | LOSGRVON | MENG13 | QUAN | 13 | 3 | From Lot Size | ||
28 | PDATV | DATUV | DATUM | DATS | 8 | 0 | Valid-From Date | ||
29 | PAENR | AENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
30 | PLGRP | VAGRP | VAGRP | CHAR | 3 | 0 | Responsible planner group/department | * | |
31 | LODIV | LOSDIV | MENG13 | QUAN | 13 | 3 | Lot size divisor | ||
32 | STLTY | STLTY | STLTY | CHAR | 1 | 0 | BOM Category | ||
33 | STLBEZ | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
34 | STLST | STLST | STLST | NUMC | 2 | 0 | BOM Statuses | * | |
35 | STLNR | STNUM | STNUM | CHAR | 8 | 0 | Bill of Material | ||
36 | SDATV | DATUV | DATUM | DATS | 8 | 0 | Valid-From Date | ||
37 | SBMNG | BASMN | MENG13 | QUAN | 13 | 3 | Base quantity | ||
38 | SBMEH | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
39 | SAENR | AENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
40 | STLAL | STALT | ALTNR | CHAR | 2 | 0 | Alternative BOM | ||
41 | STLAN | STLAN | STLAN | CHAR | 1 | 0 | BOM Usage | * | |
42 | SLSVN | LOSVN | MENG13 | QUAN | 13 | 3 | From Lot Size | ||
43 | SLSBS | LOSBS | MENG13 | QUAN | 13 | 3 | To Lot Size | ||
44 | AUFLD | CO_AUFLD | DATUM | DATS | 8 | 0 | Date of BOM Explosion/Routing Transfer | ||
45 | DISPO | CO_DISPO | DISPO | CHAR | 3 | 0 | MRP controller for the order | * | |
46 | AUFPL | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
47 | FEVOR | FEVOR | FEVOR | CHAR | 3 | 0 | Production Supervisor | * | |
48 | FHORI | FHORI | FHORI | CHAR | 3 | 0 | Scheduling Margin Key for Floats | * | |
49 | TERKZ | TERMKZ | TERART | CHAR | 1 | 0 | Scheduling type | * | |
50 | REDKZ | REDKZ | REDKZ | CHAR | 1 | 0 | Reduction indicator for scheduling | ||
51 | APRIO | CO_APRIO | CHAR1 | CHAR | 1 | 0 | Order priority | ||
52 | NTZUE | NETZ_UEBER | AUFNR | CHAR | 12 | 0 | Superior network number | AUFK | |
53 | VORUE | VORG_UEBER | VORNR | CHAR | 4 | 0 | Superior activity | ||
54 | PROFID | PROFIDNZPL | PROFILID | CHAR | 7 | 0 | Network profile | * | |
55 | VORGZ | VORGZ | NUM3 | NUMC | 3 | 0 | Float before production (in days) | ||
56 | SICHZ | SICHZ | NUM3 | NUMC | 3 | 0 | Float after production (in days) | ||
57 | FREIZ | FREIZ | NUM3 | NUMC | 3 | 0 | Release period (in days) | ||
58 | UPTER | CO_UPTER | CHAR1 | CHAR | 1 | 0 | Indicator: Change to Scheduled Dates | ||
59 | BEDID | BEDID | BEDID | NUMC | 12 | 0 | ID of the capacity requirements record | * | |
60 | PRONR | PS_PSP_PRO | PS_PSPNR | NUMC | 8 | 0 | Project definition | PROJ | |
61 | ZAEHL | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
62 | MZAEHL | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
63 | ZKRIZ | DZKRIZ | ZKRIZ | NUMC | 7 | 0 | Counter for additional criteria | ||
64 | PRUEFLOS | QPLOS | QPLOS | NUMC | 12 | 0 | Inspection Lot Number | * | |
65 | KLVARP | KALKVARPLN | KLVAR | CHAR | 4 | 0 | Costing variant for planned costs | * | |
66 | KLVARI | KALKVARIST | KLVAR | CHAR | 4 | 0 | Costing variant for actual costs | * | |
67 | RGEKZ | CO_RGEKZ | CO_RGEKZ | CHAR | 1 | 0 | Indicator: Backflushing for order | ||
68 | PLART | PS_PLART | PS_PLART | CHAR | 1 | 0 | Basis for scheduling | ||
69 | FLG_AOB | FLG_AOB | FLAG | CHAR | 1 | 0 | Indicator: relationships | ||
70 | FLG_ARBEI | FLG_ARBEI | FLAG | CHAR | 1 | 0 | Indicator: Default value work is relevant | ||
71 | GLTPP | CO_GLTPP | DATUM | DATS | 8 | 0 | Finish date (forecast) | ||
72 | GSTPP | CO_GSTPP | DATUM | DATS | 8 | 0 | Forecast start date | ||
73 | GLTPS | CO_GLTPS | DATUM | DATS | 8 | 0 | Scheduled forecast finish | ||
74 | GSTPS | CO_GSTPS | DATUM | DATS | 8 | 0 | Scheduled forecast start | ||
75 | FTRPS | CO_FTRPS | DATUM | DATS | 8 | 0 | Scheduled release date (forecast) | ||
76 | RDKZP | REDKZP | REDKZ | CHAR | 1 | 0 | Reduction indicator for scheduling (forecast) | ||
77 | TRKZP | TERMKZP | TERART | CHAR | 1 | 0 | Scheduling type (forecast) | * | |
78 | RUECK | CO_RUECK | CO_RUECK | NUMC | 10 | 0 | Completion confirmation number for the operation | ||
79 | RMZHL | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
80 | IGMNG | CO_IGMNG | MENG13 | QUAN | 13 | 3 | Yield confirmed from order confirmation | ||
81 | RATID | BEDID | BEDID | NUMC | 12 | 0 | ID of the capacity requirements record | * | |
82 | GROID | BEDID | BEDID | NUMC | 12 | 0 | ID of the capacity requirements record | * | |
83 | CUOBJ | CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
84 | GLUZS | CO_GLUZS | UHRZT | TIMS | 6 | 0 | Scheduled finish time | ||
85 | GSUZS | CO_GSUZS | ATIME | TIMS | 6 | 0 | Scheduled Start (Time) | ||
86 | REVLV | REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
87 | RSHTY | CR_OBJTY | CR_OBJTY | CHAR | 2 | 0 | Object types of the CIM resource | ||
88 | RSHID | CR_OBJID | CR_OBJID | NUMC | 8 | 0 | Object ID of the resource | * | |
89 | RSNTY | CR_OBJTY | CR_OBJTY | CHAR | 2 | 0 | Object types of the CIM resource | ||
90 | RSNID | CR_OBJID | CR_OBJID | NUMC | 8 | 0 | Object ID of the resource | * | |
91 | NAUTERM | CO_NAUTERM | KREUZ | CHAR | 1 | 0 | Indicator: Do not schedule automatically | ||
92 | NAUCOST | CO_NAUCOST | KREUZ | CHAR | 1 | 0 | Indicator: Do not cost automatically | ||
93 | STUFE | HISTU | DEC2 | DEC | 2 | 0 | Level (in Multi-Level BOM Explosions) | ||
94 | WEGXX | WEGXX | DEC4 | DEC | 4 | 0 | Path (for Multi-Level BOM Explosions) | ||
95 | VWEGX | WEGXX | DEC4 | DEC | 4 | 0 | Path (for Multi-Level BOM Explosions) | ||
96 | ARSNR | RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | * | |
97 | ARSPS | CO_POSNR | CO_POSNR | NUMC | 4 | 0 | Order item number | ||
98 | MAUFNR | MAUFNR | AUFNR | CHAR | 12 | 0 | Number of superior order | * | |
99 | LKNOT | CO_LKNOT | AUFNR | CHAR | 12 | 0 | Left node in collective order | * | |
100 | RKNOT | CO_RKNOT | AUFNR | CHAR | 12 | 0 | Right node of a collective order | * | |
101 | PRODNET | CO_PRODNET | KREUZ | CHAR | 1 | 0 | Indicator: Order is part of collective order | ||
102 | IASMG | CO_IASMG | MENG13 | QUAN | 13 | 3 | Scrap confirmed for order | ||
103 | ABARB | CO_ABARB | CO_ABARB | NUMC | 3 | 0 | Confirmation: Degree of processing | ||
104 | AUFNT | CO_TEILNET | AUFNR | CHAR | 12 | 0 | Number of superior network | * | |
105 | AUFPT | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
106 | APLZT | CO_APLZL | CO_APLZL | NUMC | 8 | 0 | General counter for order | * | |
107 | NO_DISP | NO_DISP_PLUS | NO_DISP_PLUS | CHAR | 1 | 0 | Effective for Materials Planning | ||
108 | CSPLIT | CSPLIT | CSPLIT | CHAR | 4 | 0 | Apportionment structure | * | |
109 | AENNR | AENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
110 | CY_SEQNR | CY_SEQNR | CY_SEQNR | NUMC | 14 | 0 | Seq. number order | ||
111 | BREAKS | BREAKS | XFELD | CHAR | 1 | 0 | Indicator: Scheduling allowing for breaks | ||
112 | VORGZ_TRM | VORGZ_TRM | PUFFER_TRM | DEC | 6 | 3 | Scheduled float before production in days | ||
113 | SICHZ_TRM | SICHZ_TRM | PUFFER_TRM | DEC | 6 | 3 | Scheduled float after production in days | ||
114 | TRMDT | TRMDT | DATUM | DATS | 8 | 0 | Date of the last scheduling | ||
115 | GLUZP | CO_GLUZP | UHRZT | TIMS | 6 | 0 | Basic finish (time) | ||
116 | GSUZP | CO_GSUZP | UHRZT | TIMS | 6 | 0 | Basic start time | ||
117 | GSUZI | CO_GSUZI | UHRZT | TIMS | 6 | 0 | Actual start time | ||
118 | GEUZI | CO_GEUZI | UHRZT | TIMS | 6 | 0 | Confirmed order finish (time) | ||
119 | GLUPP | CO_GLUPP | UHRZT | TIMS | 6 | 0 | Forecast finish (time) | ||
120 | GSUPP | CO_GSUPP | UHRZT | TIMS | 6 | 0 | Forecast start (time) | ||
121 | GLUPS | CO_GLUPS | UHRZT | TIMS | 6 | 0 | Scheduled forecast finish time | ||
122 | GSUPS | CO_GSUPS | UHRZT | TIMS | 6 | 0 | Scheduled start time (Forecast) | ||
123 | CHSCH | KALSMA_CH | KALSM | CHAR | 6 | 0 | Search procedure for batch determination | T683 | |
124 | KAPT_VORGZ | KAPT_VORGZ | NUM3 | NUMC | 3 | 0 | Float (bef. production) remaining after finite scheduling | ||
125 | KAPT_SICHZ | KAPT_SICHZ | NUM3 | NUMC | 3 | 0 | Remaining float after finite scheduling | ||
126 | LEAD_AUFNR | CO_LAUFNR | AUFNR | CHAR | 12 | 0 | Leading order in current processing | AUFK | |
127 | PNETSTARTD | CO_PSTARTD | DATUM | DATS | 8 | 0 | Outline start of collective network (date) | ||
128 | PNETSTARTT | CO_PSTARTT | ATIME | TIMS | 6 | 0 | Start time of a collective order | ||
129 | PNETENDD | CO_PENDD | DATUM | DATS | 8 | 0 | Outline finish of collective order (date) | ||
130 | PNETENDT | CO_PENDT | ATIME | TIMS | 6 | 0 | Outline finish time | ||
131 | KBED | KBED_D | XFELD | CHAR | 1 | 0 | Ind: do not create capacity requirements | ||
132 | KKALKR | COMP_CALC | XFELD | CHAR | 1 | 0 | Indicator: Components will not be costed | ||
133 | SFCPF | CO_PRODPRF | CO_PRODPRF | CHAR | 6 | 0 | Production Scheduling Profile | * | |
134 | RMNGA | RMNGA | MENG13 | QUAN | 13 | 3 | Total confirmed rework quantity | ||
135 | GSBTR | CO_GSBTR | DATUM | DATS | 8 | 0 | Overall commitment date | ||
136 | VFMNG | CO_VFMNG | MENG13 | QUAN | 13 | 3 | Committed quantity for order acc. to ATP check components | ||
137 | NOPCOST | CO_NOPCOST | XFELD | CHAR | 1 | 0 | Do not calculate planned costs for order | ||
138 | NETZKONT | NETZKONT | NETZKONT | CHAR | 1 | 0 | Indicator for the account assignment of a network(hdr/act.) | ||
139 | ATRKZ | ATRKZ | ATRKZ | CHAR | 1 | 0 | Request ID | ||
140 | OBJTYPE | OCM_OBJ_TYPE | OCM_OBJ_TYPE | CHAR | 1 | 0 | Change indicator | ||
141 | CH_PROC | OCM_CH_PROC | OCM_CH_PROC | CHAR | 1 | 0 | Process that has lead to the change of an object | ||
142 | KAPVERSA | KAPVERSA | KAPVERSION | NUMC | 2 | 0 | Version of Available Capacity | * | |
143 | COLORDPROC | CO_COLORDPRC | CO_COLORDPRC | CHAR | 1 | 0 | Collective order with/without automatic goods movement | ||
144 | KZERB | PS_KZERB | XFELD | CHAR | 1 | 0 | Indicator: Project summarization | ||
145 | CONF_KEY | CC_CONF_KEY | CC_NUMC8 | NUMC | 8 | 0 | Identical object | ||
146 | ST_ARBID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
147 | VSNMR_V | VSNMR_V | VSNMR | CHAR | 12 | 0 | Sales document version number | ||
148 | TERHW | TERHW | TERHW | CHAR | 1 | 0 | Scheduling note from order scheduling | ||
149 | .INCLUDE | 0 | 0 | Include RMA for AUFK | |||||
150 | RMANR | VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | ||
151 | POSNR_RMA | POSNR | POSNR | NUMC | 6 | 0 | Item number of the SD document | ||
152 | POSNV_RMA | POSNR | POSNR | NUMC | 6 | 0 | Item number of the SD document |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | AFKO | AENNR | AENR | AENNR | |||
2 | AFKO | AUFNR | AUFK | AUFNR | KEY | 1 | 1 |
3 | AFKO | CHSCH | T683 | KALSM | |||
4 | AFKO | GMEIN | T006 | MSEHI | KEY | 1 | CN |
5 | AFKO | LEAD_AUFNR | AUFK | AUFNR | |||
6 | AFKO | MANDT | T000 | MANDT | KEY | 1 | CN |
7 | AFKO | NTZUE | AUFK | AUFNR | REF | C | C |
8 | AFKO | PAENR | AENR | AENNR | REF | 1 | CN |
9 | AFKO | PLNME | T006 | MSEHI | REF | 1 | CN |
10 | AFKO | PRONR | PROJ | PSPNR | REF | C | CN |
11 | AFKO | SAENR | AENR | AENNR | REF | C | CN |
12 | AFKO | SBMEH | T006 | MSEHI | REF | C | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |