SE11 ABAP Dictionary SE11 AFKO

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

AFKO

Order header data PP orders
SAP PP Transparent Table 158 Fields
Primary Key:
MANDT AUFNR

Dictionary Fields Fields

(158 dari 158 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
AUFNR
KEY Order CHAR 12 - - Order Number
3
GLTRP
- Basic fin. DATS 8 - - Basic finish date
4
GSTRP
- Bas. Start DATS 8 - - Basic Start Date
5
FTRMS
- Release DATS 8 - - Scheduled release date
6
GLTRS
- Sched.Fin. DATS 8 - - Scheduled finish
7
GSTRS
- SchedStart DATS 8 - - Scheduled start
8
GSTRI
- Act. start DATS 8 - - Actual start date
9
GETRI
- Actual end DATS 8 - - Confirmed Order Finish Date
10
GLTRI
- Act.finish DATS 8 - - Actual finish date
11
FTRMI
- Release DATS 8 - - Actual release date
12
FTRMP
- Plan. rel. DATS 8 - - Planned release date
13
RSNUM
- Reserv.No. NUMC 10 - - Number of Reservation/Dependent Requirement
14
GASMG
- Scrap QUAN 13 3 - Total scrap quantity in the order
15
GAMNG
- Target qty QUAN 13 3 - Total order quantity
16
GMEIN
- Unit UNIT 3 - - Base Unit of Measure
17
PLNBEZ
- Material CHAR 18 - - Material Number
18
PLNTY
- Type CHAR 1 - - Task List Type
19
PLNNR
- Group CHAR 8 - - Key for Task List Group
20
PLNAW
- Applicatn CHAR 1 - - Application of the task list
21
PLNAL
- Grp.Countr CHAR 2 - - Group Counter
22
PVERW
- Usage CHAR 3 - - Task list usage
23
PLAUF
- RtgTransf. DATS 8 - - Date for routing transfer
24
PLSVB
- To LotSize QUAN 13 3 - To lot size
25
PLNME
- TskL unit UNIT 3 - - Task list unit of measure
26
PLSVN
- FrmLotSize QUAN 13 3 - From Lot Size
27
PDATV
- Valid From DATS 8 - - Valid-From Date
28
PAENR
- Change No. CHAR 12 - - Change Number
29
PLGRP
- PlannerGrp CHAR 3 - - Responsible planner group/department
30
LODIV
- LotSzeDiv QUAN 13 3 - Lot size divisor
31
STLTY
- BOM cat CHAR 1 - - BOM category
32
STLBEZ
- Material CHAR 18 - - Material Number
33
STLST
- BOM status NUMC 2 - - BOM status
34
STLNR
- BOM CHAR 8 - - Bill of material
35
SDATV
- Valid From DATS 8 - - Valid-From Date
36
SBMNG
- Base qty QUAN 13 3 - Base quantity
37
SBMEH
- Unit UNIT 3 - - Base Unit of Measure
38
SAENR
- Change No. CHAR 12 - - Change Number
39
STLAL
- Alt. BOM CHAR 2 - - Alternative BOM
40
STLAN
- BOM Usage CHAR 1 - - BOM Usage
41
SLSVN
- Frm Lot Sz QUAN 13 3 - From Lot Size
42
SLSBS
- To QUAN 13 3 - To Lot Size
43
AUFLD
- Expl. Date DATS 8 - - Date of BOM Explosion/Routing Transfer
44
DISPO
- MRP ctrlr CHAR 3 - - MRP controller for the order
45
AUFPL
- Plan no. NUMC 10 - - Routing number of operations in the order
46
FEVOR
- Pr.Superv. CHAR 3 - - Production Supervisor
47
FHORI
- SM key CHAR 3 - - Scheduling Margin Key for Floats
48
TERKZ
- SchedType CHAR 1 - - Scheduling type
49
REDKZ
- RedInd CHAR 1 - - Reduction indicator for scheduling
50
APRIO
- Priority CHAR 1 - - Order priority
51
NTZUE
- Network CHAR 12 - - Superior network number
52
VORUE
- Sup. act. CHAR 4 - - Superior activity
53
PROFID
- Profile CHAR 7 - - Network profile
54
VORGZ
- FlBefProd. NUMC 3 - - Float before production (in days)
55
SICHZ
- FlAftProd. NUMC 3 - - Float after production (in days)
56
FREIZ
- ReleasPer. NUMC 3 - - Release period (in days)
57
UPTER
- Dates Chgd CHAR 1 - - Indicator: Change to Scheduled Dates
58
BEDID
- ID no. NUMC 12 - - ID of the capacity requirements record
59
PRONR
- Proj.def. NUMC 8 - - Project definition
60
ZAEHL
- Counter NUMC 8 - - Internal counter
61
MZAEHL
- Counter NUMC 8 - - Internal counter
62
ZKRIZ
- AddCritCt NUMC 7 - - Counter for additional criteria
63
PRUEFLOS
- Insp. Lot NUMC 12 - - Inspection Lot Number
64
KLVARP
- CstgVarPln CHAR 4 - - Costing variant for planned costs
65
KLVARI
- CstgVarAct CHAR 4 - - Costing variant for actual costs
66
RGEKZ
- Backflush CHAR 1 - - Indicator: Backflushing for order
67
PLART
- SchedBasis CHAR 1 - - Basis for scheduling
68
FLG_AOB
- Ind:Relshp CHAR 1 - - Indicator: relationships
69
FLG_ARBEI
- Ind.work CHAR 1 - - Indicator: Default value work is relevant
70
GLTPP
- Finish DATS 8 - - Finish date (forecast)
71
GSTPP
- Start DATS 8 - - Forecast start date
72
GLTPS
- Finish DATS 8 - - Scheduled forecast finish
73
GSTPS
- Start DATS 8 - - Scheduled forecast start
74
FTRPS
- Release DATS 8 - - Scheduled release date (forecast)
75
RDKZP
- RedInd CHAR 1 - - Reduction indicator for scheduling (forecast)
76
TRKZP
- Sched.type CHAR 1 - - Scheduling type (forecast)
77
RUECK
- Confirm. NUMC 10 - - Completion confirmation number for the operation
78
RMZHL
- Counter NUMC 8 - - Internal counter
79
IGMNG
- Conf. qty QUAN 13 3 - Yield confirmed from order confirmation
80
RATID
- ID no. NUMC 12 - - ID of the capacity requirements record
81
GROID
- ID no. NUMC 12 - - ID of the capacity requirements record
82
CUOBJ
- Int.obj.no NUMC 18 - - Configuration (internal object number)
83
GLUZS
- Finish tme TIMS 6 - - Scheduled finish time
84
GSUZS
- BasicStart TIMS 6 - - Scheduled start time
85
REVLV
- Rev. Level CHAR 2 - - Revision Level
86
RSHTY
- Type CHAR 2 - - Object types of the CIM resource
87
RSHID
- ID NUMC 8 - - Object ID of the resource
88
RSNTY
- Type CHAR 2 - - Object types of the CIM resource
89
RSNID
- ID NUMC 8 - - Object ID of the resource
90
NAUTERM
- NoAutoSchd CHAR 1 - - Indicator: Do not schedule automatically
91
NAUCOST
- NoAutoCost CHAR 1 - - Indicator: Do not cost automatically
92
STUFE
- Level DEC 2 - - Level (in multi-level BOM explosions)
93
WEGXX
- Path DEC 4 - - Path (for multi-level BOM explosions)
94
VWEGX
- Path DEC 4 - - Path (for multi-level BOM explosions)
95
ARSNR
- Reserv.No. NUMC 10 - - Number of Reservation/Dependent Requirement
96
ARSPS
- Item No. NUMC 4 - - Order Item Number
97
MAUFNR
- SuperOrder CHAR 12 - - Number of superior order
98
LKNOT
- Left node CHAR 12 - - Left node in collective order
99
RKNOT
- Right node CHAR 12 - - Right node of a collective order
100
PRODNET
- CollectOrd CHAR 1 - - Indicator: Order is part of collective order
101
IASMG
- Scrap QUAN 13 3 - Scrap confirmed for order
102
ABARB
- Procssg. % NUMC 3 - - Confirmation: Degree of processing
103
AUFNT
- Subntwk of CHAR 12 - - Number of superior network
104
AUFPT
- Plan no. NUMC 10 - - Routing number of operations in the order
105
APLZT
- Counter NUMC 8 - - General counter for order
106
NO_DISP
- Eff.MatPlg CHAR 1 - - Effective for Materials Planning
107
CSPLIT
- Apportnmnt CHAR 4 - - Apportionment Structure
108
AENNR
- Change No. CHAR 12 - - Change Number
109
CY_SEQNR
- Seq. no. NUMC 14 - - Seq. number order
110
BREAKS
- Breaks CHAR 1 - - Indicator: Scheduling allowing for breaks
111
VORGZ_TRM
- FltBfProd DEC 6 3 - Scheduled float before production in days
112
SICHZ_TRM
- Float a. p DEC 6 3 - Scheduled float after production in days
113
TRMDT
- Sched. on DATS 8 - - Date of the last scheduling
114
GLUZP
- Basic fin. TIMS 6 - - Basic finish (time)
115
GSUZP
- BasicStart TIMS 6 - - Basic start time
116
GSUZI
- ActStart TIMS 6 - - Actual start time
117
GEUZI
- Act.finish TIMS 6 - - Confirmed order finish (time)
118
GLUPP
- FinishTime TIMS 6 - - Forecast finish (time)
119
GSUPP
- Start time TIMS 6 - - Forecast start (time)
120
GLUPS
- FinishTime TIMS 6 - - Scheduled forecast finish time
121
GSUPS
- Start time TIMS 6 - - Scheduled start time (Forecast)
122
CHSCH
- SearchProc CHAR 6 - - Search procedure for batch determination
123
KAPT_VORGZ
- RemPreFlt NUMC 3 - - Float (bef. production) remaining after finite scheduling
124
KAPT_SICHZ
- Rem. float NUMC 3 - - Remaining float after finite scheduling
125
LEAD_AUFNR
- LeadgOrder CHAR 12 - - Leading order in current processing
126
PNETSTARTD
- Start DATS 8 - - Outline start of collective network (date)
127
PNETSTARTT
- Start TIMS 6 - - Start time of a collective order
128
PNETENDD
- Finish DATS 8 - - Outline finish of collective order (date)
129
PNETENDT
- Finish TIMS 6 - - Outline finish time
130
KBED
- Cap.reqmts CHAR 1 - - Ind: do not create capacity requirements
131
KKALKR
- CostComp CHAR 1 - - Indicator: Components will not be costed
132
SFCPF
- ProdProf CHAR 6 - - Production Scheduling Profile
133
RMNGA
- Rework QUAN 13 3 - Total confirmed rework quantity
134
GSBTR
- Ov.commit. DATS 8 - - Overall commitment date
135
VFMNG
- Ord.qty QUAN 13 3 - Committed quantity for order acc. to ATP check components
136
NOPCOST
- No pl.cost CHAR 1 - - Do not calculate planned costs for order
137
NETZKONT
- Acct assnt CHAR 1 - - Indicator for the account assignment of a network(hdr/act.)
138
ATRKZ
- Request ID CHAR 1 - - Request ID
139
OBJTYPE
- ChD CHAR 1 - - Change indicator
140
CH_PROC
- ChgPrcType CHAR 1 - - Process that has lead to the change of an object
141
KAPVERSA
- Version NUMC 2 - - Version of Available Capacity
142
COLORDPROC
- CO process CHAR 1 - - Collective order with/without automatic goods movement
143
KZERB
- ProjS MsD CHAR 1 - - Indicator: Project summarization via master data charact.
144
CONF_KEY
- Ident.obj. NUMC 8 - - Identical object
145
ST_ARBID
- Object ID NUMC 8 - - Object ID
146
VSNMR_V
- Version CHAR 12 - - Sales document version number
147
TERHW
- SchedNote CHAR 1 - - Scheduling note from order scheduling
148
SPLSTAT
- SplitStat CHAR 1 - - Status of an order in a split hierarchy
149
COSTUPD
- UpdCosts CHAR 1 - - Costs are updated
150
ADPSP
- Ref. Elem. CHAR 40 - - PM/PS Reference Element
151
RMANR
- SD Doc. CHAR 10 - - Sales and Distribution Document Number
152
POSNR_RMA
- Item NUMC 6 - - Item number of the SD document
153
POSNV_RMA
- Item NUMC 6 - - Item number of the SD document
154
OIHANTYP
- Handl.Type CHAR 2 - - Excise Duty Handling Type
155
MILL_RATIO
- Factor INT4 10 - - Factor for Quantity-Based Settlement
156
BMEINS
- Unit UNIT 3 - - Base Unit of Measure
157
BMENGE
- Base qty QUAN 13 3 - Base quantity
158
MILL_OC_ZUSKZ
- Comb.Ind. CHAR 1 - - Combination Indicator

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk AFKO.

Standard T-Codes
ANSI SQL Query 
SELECT a.AUFNR,
       a.GLTRP,
       a.GSTRP,
       a.FTRMS,
       a.GLTRS,
       a.GSTRS
FROM AFKO AS a
WHERE a.AUFNR = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~aufnr,
       a~gltrp,
       a~gstrp,
       a~ftrms,
       a~gltrs,
       a~gstrs
  FROM afko AS a
  WHERE a~aufnr = '0001'
  INTO TABLE @DATA(lt_afko)
  UP TO 100 ROWS.
Mencari di seluruh SAP Knowledge Hub...
Tidak ditemukan hasil untuk ""
Cek "" langsung di Kamus SE11