SE11 ABAP Dictionary SE11 AUFK

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

AUFK

Order master data
SAP PP Transparent Table 170 Fields
Primary Key:
MANDT AUFNR

Dictionary Fields Fields

(170 dari 170 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
AUART
- Order Type CHAR 4 - - Order Type
4
AUTYP
- Order catg NUMC 2 - - Order category
5
REFNR
- Order CHAR 12 - - Reference order number
6
ERNAM
- Entered by CHAR 12 - - Entered by
7
ERDAT
- on DATS 8 - - Created on
8
AENAM
- Changed by CHAR 12 - - Last changed by
9
AEDAT
- Changed on DATS 8 - - Change date for Order Master
10
KTEXT
- Desc. CHAR 40 - - Description
11
LTEXT
- Long text CHAR 1 - - Long Text Exists
12
BUKRS
- CoCode CHAR 4 - T001 Company Code
13
WERKS
- Plant CHAR 4 - T001W Plant
14
GSBER
- Bus. Area CHAR 4 - - Business Area
15
KOKRS
- CO Area CHAR 4 - - Controlling Area
16
CCKEY
- Key CHAR 23 - - Cost collector key
17
KOSTV
- Resp. CCtr CHAR 10 - - Responsible cost center
18
STORT
- Location CHAR 10 - - Location
19
SOWRK
- Plant CHAR 4 - - Location plant
20
ASTKZ
- Statist. CHAR 1 - - Identifier for statistical order
21
WAERS
- Currency CUKY 5 - TCURC Order Currency
22
ASTNR
- Status NUMC 2 - - Order status
23
STDAT
- Status chg DATS 8 - - Date of last status change
24
ESTNR
- ReachdStat NUMC 2 - - Status reached so far
25
PHAS0
- Created CHAR 1 - - Phase "Order created"
26
PHAS1
- Released CHAR 1 - - Phase "Order released"
27
PHAS2
- Completed CHAR 1 - - Phase "order completed"
28
PHAS3
- Closed CHAR 1 - - Phase "order closed"
29
PDAT1
- PlnRelease DATS 8 - - Planned release date
30
PDAT2
- PlnCompltn DATS 8 - - Planned completion date
31
PDAT3
- Pl.clo.dat DATS 8 - - Planned closing date
32
IDAT1
- Release DATS 8 - - Release date
33
IDAT2
- TechCompl. DATS 8 - - Technical completion date
34
IDAT3
- Close DATS 8 - - Close date
35
OBJID
- Object ID CHAR 1 - - Object ID
36
VOGRP
- DisTranGrp CHAR 4 - - Group of disallowed transactions
37
LOEKZ
- Del. flag CHAR 1 - - Deletion flag
38
PLGKZ
- Plan LI CHAR 1 - - Identifier for planning with line items
39
KVEWE
- Usage CHAR 1 - - Usage of the condition table
40
KAPPL
- Applicat. CHAR 2 - - Application
41
KALSM
- Cstg Sheet CHAR 6 - - Costing Sheet
42
ZSCHL
- OH key CHAR 6 - - Overhead key
43
ABKRS
- Proc. grp NUMC 2 - - Processing group
44
KSTAR
- SettleCE CHAR 10 - - Settlement cost element
45
KOSTL
- Cost Ctrs CHAR 10 - - Cost center for basic settlement
46
SAKNR
- G/L acct CHAR 10 - - G/L account for basic settlement
47
SETNM
- AllocSet CHAR 12 - - Allocation set
48
CYCLE
- CCtr post. CHAR 10 - - Cost center to which costs are actually posted
49
SDATE
- From DATS 8 - - Start Date
50
SEQNR
- SequenceNo NUMC 4 - - Sequence number
51
USER0
- Applicant CHAR 20 - - Applicant
52
USER1
- Tel. CHAR 20 - - Applicant's telephone number
53
USER2
- Pers.resp. CHAR 20 - - Person responsible
54
USER3
- Tel. CHAR 20 - - Telephone number of person in charge
55
USER4
- Costs CURR 11 2 - Estimated total costs of order
56
USER5
- ApplicDate DATS 8 - - Application Date
57
USER6
- Department CHAR 15 - - Department
58
USER7
- Start work DATS 8 - - Work Start
59
USER8
- Work End DATS 8 - - End of Work
60
USER9
- WorkPermit CHAR 1 - - Identifier for work permit issued
61
OBJNR
- Obj. no. CHAR 22 - - Object number
62
PRCTR
- Profit Ctr CHAR 10 - - Profit Center
63
PSPEL
- WBS elem. NUMC 8 - - Work breakdown structure element (WBS element)
64
AWSLS
- Var. key CHAR 6 - - Variance Key
65
ABGSL
- RA Key CHAR 6 - - Results Analysis Key
66
TXJCD
- Tax Jur. CHAR 15 - - Tax Jurisdiction
67
FUNC_AREA
- Func. Area CHAR 16 - - Functional Area
68
SCOPE
- Obj. class CHAR 2 - - Object Class
69
PLINT
- Int.plan. CHAR 1 - - Indicator for Integrated Planning
70
KDAUF
- Sales Ord. CHAR 10 - - Sales Order Number
71
KDPOS
- SO Item NUMC 6 - - Item Number in Sales Order
72
AUFEX
- Ext.Ord.No CHAR 20 - - External order number
73
IVPRO
- InvProfile CHAR 6 - - Investment measure profile
74
LOGSYSTEM
- Log.System CHAR 10 - - Logical System
75
FLG_MLTPS
- MultItms CHAR 1 - - Order with multiple items
76
ABUKR
- CoCde CHAR 4 - - Requesting company code
77
AKSTL
- Request.CC CHAR 10 - - Requesting cost center
78
SIZECL
- Scale CHAR 2 - - Scale of investment objects
79
IZWEK
- Inv.reason CHAR 2 - - Reason for investment
80
UMWKZ
- Env. inv. CHAR 5 - - Reason for environmental investment
81
KSTEMPF
- Cost coll. CHAR 1 - - Indicator: Direct cost collector
82
ZSCHM
- Int. Prof. CHAR 7 - - Interest Profile for Project/Order Interest Calculation
83
PKOSA
- Cost coll. CHAR 12 - - Cost collector for production process PROCNR
84
ANFAUFNR
- Req. order CHAR 12 - - Requesting order
85
PROCNR
- ProdProcNo NUMC 12 - - Production Process
86
PROTY
- Proc. cat. CHAR 4 - - Process Category (Procurement/Consumption)
87
RSORD
- Refbshmnt CHAR 1 - - Refurbishment order indicator (PM)
88
BEMOT
- AcctIndic CHAR 2 - - Accounting Indicator
89
ADRNRA
- Addr. no. CHAR 10 - - Address number
90
ERFZEIT
- TimCreated TIMS 6 - - Time created
91
AEZEIT
- Changed at TIMS 6 - - Changed at
92
CSTG_VRNT
- Cstg Vrnt CHAR 4 - - Costing Variant
93
COSTESTNR
- CENo NUMC 12 - - Cost Estimate Number for Cost Est. w/o Qty Structure
94
VERAA_USER
- PersonResp CHAR 12 - - Person Responsible for CO Internal Order
95
DUMMY_CI_AUFK
- Single-Character Indicator CHAR 1 - - Single-Character Indicator
96
/MRSS/PL_STRU_ID
- RP node NUMC 8 - - Resource planning nodes
97
/MRSS/PL_MAN_TYP
- Manager CHAR 1 - - Assignment to resource planner or contact person
98
/MRSS/ORDER_PROB
- OP in % CHAR 3 - - Order probability in percent
99
/MRSS/ACT_TYPE
- Proc. var. CHAR 1 - - Process variant
100
/MRSS/INIT_DONE
- Initializ. CHAR 1 - - Internal initialization carried out once
101
/MRSS/DATACHANGE
- Changed: CHAR 1 - - Data was changed in the controls on the user screen
102
/MRSS/SALES_ORG
- Sales org. CHAR 4 - - Sales Organization
103
/MRSS/NW_BOOKED
- NW Booked CHAR 1 - - Network Set to "Booked"
104
/MRSS/REQ_TYPE
- Req. Type CHAR 2 - - Request Type
105
/MRSS/REQ_LOB
- LOB CHAR 2 - - Requester Line of Business
106
/MRSS/REQ_REGION
- Super reg. CHAR 8 - - Super region per country
107
/MRSS/REQ_CTRY
- Target CHAR 5 - - Broadcast Targets
108
/MRSS/REQ_OWNER
- Pers.No. NUMC 8 - - Personnel Number
109
/MRSS/REQUESTER
- Pers.No. NUMC 8 - - Personnel Number
110
/MRSS/CUSTOMER
- Customer CHAR 10 - - Customer Number 1
111
/MRSS/CEM
- Pers.No. NUMC 8 - - Personnel Number
112
/MRSS/CORP_COMP
- Corp Comp CHAR 2 - - Corporate Company
113
/MRSS/CORP_ORG
- Corp Org CHAR 2 - - Corporate Organization
114
/MRSS/PROJ_ID
- Text 24 CHAR 24 - - Character field length 24
115
/MRSS/PROJ_MGR
- Pers.No. NUMC 8 - - Personnel Number
116
/MRSS/ORIGIN
- Origin CHAR 2 - - Request Origin
117
/MRSS/RC_MGR
- Pers.No. NUMC 8 - - Personnel Number
118
/MRSS/CRM_PROB
- CRM Prob CHAR 3 - - CRM Probability
119
/MRSS/CE_DIR
- Pers.No. NUMC 8 - - Personnel Number
120
/MRSS/DLVRY_ORG
- Profit Ctr CHAR 10 - - Profit Center
121
/MRSS/MUST_WIN
- Ind CHAR 1 - - Indicator
122
/MRSS/AGS_ESC
- Escalation Header CHAR 2 - - Escalation Header
123
/MRSS/PRESALES
- Ind CHAR 1 - - Indicator
124
/MRSS/SYS_INFO
- Sys Info CHAR 120 - - System Info
125
/MRSS/LOCATION
- Proj Loc CHAR 40 - - Project Location
126
/MRSS/LANGUAGES
- Language CHAR 40 - - Language(s)
127
/MRSS/BILL_O_TYP
- Obj Type CHAR 2 - - Billing Object Type
128
/MRSS/CONTR_ID
- Cont. Type CHAR 2 - - Contract Type
129
/MRSS/RM_ORD_PRB
- Or. Prob CHAR 2 - - Order Probability
130
/MRSS/STATUS_IND
- STATUS Indicator CHAR 1 - - STATUS Indicator
131
/MRSS/PRIMED_BY
- Proj. Prim CHAR 1 - - Project Primed By
132
/MRSS/RM_FDTERMS
- Flow Down CHAR 2 - - Flow Down Terms
133
/MRSS/CREATEDBY
- Entered by CHAR 12 - - Entered by
134
/MRSS/RL_ASS_TYP
- Assign Ty CHAR 2 - - Assignment Types
135
/MRSS/SALES_ORGN
- Serv. SOrg CHAR 10 - - Sales Profit Center
136
/MRSS/DEAL_CURR
- Currency CUKY 5 - - Order Currency
137
/MRSS/INV_PART
- Inv Prtr CHAR 40 - - Involved Partner at project
138
/MRSS/REQ_PART
- Req. Part. CHAR 20 - - Requested Partner
139
/MRSS/CUST_NAME2
- Customer name 2 CHAR 20 - - Customer name 2
140
/MRSS/BILL_OBJ
- SO/IO/CC CHAR 20 - - SO/IO/CC Number
141
/MRSS/CUST_CONTR
- CContact CHAR 40 - - Customer Contact
142
/MRSS/CHCKS_REQD
- BC/S/DS Re CHAR 1 - - BC/S/DS Req'd
143
/MRSS/DEAL_VAL
- Deal Value NUMC 11 - - Deal Value
144
/MRSS/CHANGED_AT
- LclTmeStmp NUMC 21 - - Time Stamp - Long Format
145
/MRSS/VERSION
- Version CHAR 10 - - Version
146
/MRSS/PROJ_STATE
- State CHAR 3 - - State
147
/MRSS/PROJ_CTRY
- Project Country CHAR 3 - - Project Country
148
/MRSS/CREATEDON
- LclTmeStmp NUMC 21 - - Time Stamp - Long Format
149
/MRSS/PROJSERV
- Proj Ser NUMC 2 - - Project Service
150
/MRSS/CD_OPPOR
- Oppor Type NUMC 2 - - CD Opportunity
151
/MRSS/RES_RM_ORG
- Res RM Org NUMC 2 - - Responsible RM Org
152
/MRSS/SERV_PHASE
- Serv Phase CHAR 2 - - Resource Management Service Phase
153
VNAME
- Venture CHAR 6 - - Joint Venture
154
RECID
- Rec.Indic. CHAR 2 - - Recovery Indicator
155
ETYPE
- Equity Ty. CHAR 3 - - Equity type
156
OTYPE
- JV_ObjType CHAR 4 - - Joint Venture Object Type
157
JV_JIBCL
- Class CHAR 3 - - JIB/JIBE Class
158
JV_JIBSA
- Subclass A CHAR 5 - - JIB/JIBE Subclass A
159
JV_OCO
- Or CO CHAR 1 - - JV original cost object
160
/CUM/INDCU
- CU Order CHAR 1 - - CU: Order is Used for Compatible Units
161
/CUM/CMNUM
- CM Number CHAR 12 - - CU: Construction Measure Number
162
/CUM/AUEST
- Auto Est. CHAR 1 - - CU: Automatic Copy of Estimated Costs
163
/CUM/DESNUM
- CU Design CHAR 12 - - CU: Design Number
164
VAPLZ
- Mn.wk.ctr CHAR 8 - - Main work center for maintenance tasks
165
WAWRK
- Plant CHAR 4 - - Plant associated with main work center
166
FERC_IND
- Reg. ind. CHAR 4 - - Regulatory indicator
167
AUFK_STATUS
- Status Com INT1 3 - - Status Combination
168
CLAIM_CONTROL
- Clm Cntrl CHAR 1 - - Claim creation control indicator
169
UPDATE_NEEDED
- Inconsist CHAR 1 - - Claim inconsistency with order indicator
170
UPDATE_CONTROL
- Clm Update CHAR 1 - - Claim update trigger point from service order

Related References & SQL

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

Standard T-Codes
ANSI SQL Query 
SELECT a.AUFNR,
       a.AUART,
       a.AUTYP,
       a.REFNR,
       a.ERNAM,
       a.ERDAT
FROM AUFK AS a
WHERE a.AUFNR = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~aufnr,
       a~auart,
       a~autyp,
       a~refnr,
       a~ernam,
       a~erdat
  FROM aufk AS a
  WHERE a~aufnr = '0001'
  INTO TABLE @DATA(lt_aufk)
  UP TO 100 ROWS.
Mencari di seluruh SAP Knowledge Hub...
Tidak ditemukan hasil untuk ""
Cek "" langsung di Kamus SE11