Follow us on LinkedIn for your next SAP project

SAP Table ORDER_OUTPUT_TAB

Output Table for Orders

ORDER_OUTPUT_TAB (Output Table for Orders) 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 ORDER_OUTPUT_TAB to other SAP tables.

ORDER_OUTPUT_TAB table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT
CLNT
3 0
AUFNR
Order Number
AUFNR
CHAR
12 0
AUART
Order Type
AUFART
CHAR
4 0
AUTYP
Order category
AUFTYP
NUMC
2 0
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
BUKRS
Company Code
BUKRS
CHAR
4 0
WERKS
Plant
WERKS_D
CHAR
4 0
GSBER
Business Area
GSBER
CHAR
4 0
KOKRS
Controlling Area
KOKRS
CHAR
4 0
CCKEY
Cost collector key
CCKEY
CHAR
23 0
KOSTV
Responsible cost center
AUFKOSTV
CHAR
10 0
STORT
Location
AUFSTORT
CHAR
10 0
SOWRK
Location plant
AUFSOWRK
CHAR
4 0
ASTKZ
Identifier for statistical order
AUFSTKZ
CHAR
1 0
WAERS
Order Currency
AUFWAERS
CUKY
5 0
ASTNR
Order status
AUFASTNR
NUMC
2 0
STDAT
Date of last status change
AUFSTDAT
DATS
8 0
ESTNR
Status reached so far
AUFESTNR
NUMC
2 0
PHAS0
Phase "Order created"
AUFPHAS0
CHAR
1 0
PHAS1
Phase "Order released"
AUFPHAS1
CHAR
1 0
PHAS2
Phase "order completed"
AUFPHAS2
CHAR
1 0
PHAS3
Phase "order closed"
AUFPHAS3
CHAR
1 0
PDAT1
Planned release date
AUFPDAT1
DATS
8 0
PDAT2
Planned completion date
AUFPDAT2
DATS
8 0
PDAT3
Planned closing date
AUFPDAT3
DATS
8 0
IDAT1
Release date
AUFIDAT1
DATS
8 0
IDAT2
Technical completion date
AUFIDAT2
DATS
8 0
IDAT3
Close date
AUFIDAT3
DATS
8 0
OBJID
Object ID
CCOBJID
CHAR
1 0
VOGRP
Group of disallowed transactions
AUFSPSET
CHAR
4 0
LOEKZ
Deletion flag
AUFLOEKZ
CHAR
1 0
PLGKZ
Identifier for planning with line items
PLGKZ
CHAR
1 0
KVEWE
Usage of the condition table
KVEWE
CHAR
1 0
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
KSTAR
Settlement cost element
AUFKSTAR
CHAR
10 0
KOSTL
Cost center for basic settlement
AUFKOSTL
CHAR
10 0
SAKNR
G/L account for basic settlement
AUFSAKNR
CHAR
10 0
SETNM
Allocation set
AUFSETNM
CHAR
12 0
CYCLE
Cost center to which costs are actually posted
ST_KOSTL
CHAR
10 0
SDATE
Start Date
SDATE
DATS
8 0
SEQNR
Sequence number
AUFSEQNR
NUMC
4 0
USER0
Applicant
AUFUSER0
CHAR
20 0
USER1
Applicant's telephone number
AUFUSER1
CHAR
20 0
USER2
Person responsible
AUFUSER2
CHAR
20 0
USER3
Telephone number of person in charge
AUFUSER3
CHAR
20 0
USER4
Estimated total costs of order
AUFUSER4
CURR
11 2
USER5
Application Date
AUFUSER5
DATS
8 0
USER6
Department
AUFUSER6
CHAR
15 0
USER7
Work Start
AUFUSER7
DATS
8 0
USER8
End of Work
AUFUSER8
DATS
8 0
USER9
Identifier for work permit issued
AUFUSER9
CHAR
1 0
OBJNR
Object number
J_OBJNR
CHAR
22 0
PRCTR
Profit Center
PRCTR
CHAR
10 0
PSPEL
Work breakdown structure element (WBS element)
PS_PSP_ELE
NUMC
8 0
AWSLS
Variance Key
AWSLS
CHAR
6 0
ABGSL
Results Analysis Key
ABGR_SCHL
CHAR
6 0
TXJCD
Tax Jurisdiction
TXJCD
CHAR
15 0
FUNC_AREA
Functional Area
FKBER
CHAR
16 0
SCOPE
Object Class
SCOPE_CV
CHAR
2 0
PLINT
Indicator for Integrated Planning
PLINT
CHAR
1 0
KDAUF
Sales Order Number
KDAUF
CHAR
10 0
KDPOS
Item Number in Sales Order
KDPOS
NUMC
6 0
AUFEX
External order number
AUFEX
CHAR
20 0
IVPRO
Investment measure profile
IM_PROFIL
CHAR
6 0
LOGSYSTEM
Logical System
LOGSYSTEM
CHAR
10 0
FLG_MLTPS
Order with multiple items
CO_MLTPS
CHAR
1 0
ABUKR
Requesting company code
IM_ABUKRS
CHAR
4 0
AKSTL
Requesting cost center
PS_AKSTL
CHAR
10 0
SIZECL
Scale of investment objects
IM_SIZECL
CHAR
2 0
IZWEK
Reason for investment
IZWEK
CHAR
2 0
UMWKZ
Reason for environmental investment
AM_UMWKZ
CHAR
5 0
KSTEMPF
Indicator: Direct cost collector
CO_KSTEMPF
CHAR
1 0
ZSCHM
Interest Profile for Project/Order Interest Calculation
PS_ZSCHM
CHAR
7 0
PKOSA
Cost collector for production process PROCNR
PKOSA_D
CHAR
12 0
ANFAUFNR
Requesting order
AUFANFNR
CHAR
12 0
PROCNR
Production Process
CKML_F_PROCNR
NUMC
12 0
PROTY
Process Category (Procurement/Consumption)
CKML_PROZESS_TYP
CHAR
4 0
RSORD
Refurbishment order indicator (PM)
RSORD
CHAR
1 0
BEMOT
Accounting Indicator
BEMOT
CHAR
2 0
ADRNRA
Address number
AD_ADDRNUM
CHAR
10 0
ERFZEIT
Time created
CO_INS_TIME
TIMS
6 0
AEZEIT
Changed at
CO_CHG_TIME
TIMS
6 0
CSTG_VRNT
Costing Variant
CK_KLVAR
CHAR
4 0
COSTESTNR
Cost Estimate Number for Cost Est. w/o Qty Structure
CK_KALNR
NUMC
12 0
VERAA_USER
Person Responsible for CO Internal Order
VERAA_USER USR02
CHAR
12 0
DUMMY_CI_AUFK
Single-Character Indicator
CHAR1
CHAR
1 0
VNAME
Joint Venture
JV_NAME
CHAR
6 0
RECID
Recovery Indicator
JV_RECIND
CHAR
2 0
ETYPE
Equity type
JV_ETYPE
CHAR
3 0
OTYPE
Joint Venture Object Type
JV_OTYPE
CHAR
4 0
JV_JIBCL
JIB/JIBE Class
JV_JIBCL
CHAR
3 0
JV_JIBSA
JIB/JIBE Subclass A
JV_JIBSA
CHAR
5 0
JV_OCO
JV original cost object
JV_OR_CO
CHAR
1 0
CPD_UPDAT
Time Stamp
/CPD/PFP_TSTMP
DEC
15 0
/CUM/INDCU
CU: Order is Used for Compatible Units
/CUM/INDCU
CHAR
1 0
/CUM/CMNUM
CU: Construction Measure Number
/CUM/CMNUM
CHAR
12 0
/CUM/AUEST
CU: Automatic Copy of Estimated Costs
/CUM/AUEST
CHAR
1 0
/CUM/DESNUM
CU: Design Number
/CUM/DESNUM
CHAR
12 0
/MRSS/PL_STRU_ID
Resource planning nodes
/MRSS/T_PLAN_STRUCT_ID
NUMC
8 0
/MRSS/PL_MAN_TYP
Assignment to resource planner or contact person
/MRSS/T_MANAGER_TYPE
CHAR
1 0
/MRSS/ORDER_PROB
Order probability in percent
/MRSS/T_ORDER_PROB
CHAR
3 0
/MRSS/ACT_TYPE
Process variant
/MRSS/T_ACTIVITY_TYPE
CHAR
1 0
/MRSS/INIT_DONE
Internal initialization carried out once
/MRSS/T_INIT_DONE
CHAR
1 0
/MRSS/DATACHANGE
Data was changed in the controls on the user screen
/MRSS/T_USCREENCTL_DATACHANGED
CHAR
1 0
/MRSS/SALES_ORG
Sales Organization
VKORG
CHAR
4 0
/MRSS/NW_BOOKED
Network Set to "Booked"
/MRSS/T_NW_BOOKED
CHAR
1 0
VAPLZ
Main work center for maintenance tasks
GEWRK
CHAR
8 0
WAWRK
Plant associated with main work center
WERGW
CHAR
4 0
FERC_IND
Regulatory indicator
FE_IND FERC_C7
CHAR
4 0
AUFK_STATUS
Status Combination
ACTCMB_DELE ACTCMB_TAB
INT1
3 0
OIHANTYP
Excise Duty Handling Type
OIH_HANTYP OIH5
CHAR
2 0
CLAIM_CONTROL
Claim creation control indicator
WTYSC_CLAIM_CONTROL WTYSCC_CLM_CONT
CHAR
1 0
UPDATE_NEEDED
Claim inconsistency with order indicator
WTYSC_UPDATE_NEEDED
CHAR
1 0
UPDATE_CONTROL
Claim update trigger point from service order
WTYSC_UPDATE_CONTROL WTYSCC_UPDT_CONT
CHAR
1 0
AUF_INDEX
Index for the object in internal table
OBJ_INDEX
INT4
10 0
FLG_ABWEI
'Variances calculated' flag
FLG_ABWEI
CHAR
1 0
FLG_AFAEX
Checkbox
XFELD
CHAR
1 0
FLG_AIBEX
Flag 'Asset under construction exists'
FLG_AIBEX
CHAR
1 0
FLG_AIBOK
Checkbox
XFELD
CHAR
1 0
FLG_AUFKL
'Order will be classified' indicator
KZAUFKLA
CHAR
1 0
FLG_BUDGT
Flag 'Budget exists'
FLG_BUDGT
CHAR
1 0
FLG_COSTS
Flag 'Costs exist"
FLG_COSTS
CHAR
1 0
FLG_DATAC
Flag 'Data has been changed'
FLG_DATAC
CHAR
1 0
FLG_SAVEABR
Flag 'Saved From Settlement rule"
FLG_SAVEABR
CHAR
1 0
FLG_ENQUE
'Object is blocked' flag
FLG_ENQUE
CHAR
1 0
FLG_ERLOE
Identifier "Revenue posting allowed"
ERLOESE
CHAR
1 0
FLG_AANLE
Checkbox
XFELD
CHAR
1 0
FLG_IVPRG
Checkbox
XFELD
CHAR
1 0
FLG_NABPF
Indicator "Does not require settlement"
NABPF
CHAR
1 0
FLG_NKEXT
Internal (' ') or external ('X') number range flag
NRIND
CHAR
1 0
FLG_NOBWA
Flag 'No valuation type'
FLG_NOBWA
CHAR
1 0
FLG_OBLIGOX
Commitments Management Active
CO_OBLIGOX
CHAR
1 0
FLG_OLDST
Indicator 'Order status management active'
SVALT_D
CHAR
1 0
FLG_LOCKED
Checkbox
XFELD
CHAR
1 0
FLG_IMMO
Checkbox
XFELD
CHAR
1 0
OLD_ABGSL
Results Analysis Key
ABGR_SCHL
CHAR
6 0
OLD_ASTNR
Order status
AUFASTNR
NUMC
2 0
OLD_ESTNR
Status reached so far
AUFESTNR
NUMC
2 0
OLD_PLINT
Indicator for Integrated Planning
PLINT
CHAR
1 0
OLD_OBJNR
Object number
J_OBJNR
CHAR
22 0
PAR_ACTVT
Activity
ACTIV_AUTH
CHAR
2 0
PAR_APROF
Settlement profile
APROF
CHAR
6 0
PAR_DBMOD
Indicator for database change
DBMOD
CHAR
1 0
PAR_NUMKR
Number range
NUMKR
CHAR
2 0
PAR_OBTYP
Object Category
J_OBTYP
CHAR
3 0
PAR_BUSOBJ
Object type
OJ_NAME
CHAR
10 0
PAR_RESZ1
Residence Time 1 (Calendar Months)
RESZ1
NUMC
3 0
PAR_STSMA
Status Profile
J_STSMA
CHAR
8 0
PAR_TNAME
Text name for CO order
PAR_TNAME
CHAR
20 0
PAR_WAERS
Order Currency
AUFWAERS
CUKY
5 0
PAR_FORM
Form Name
TDFORM
CHAR
16 0
PAR_LAYOU
Layout for Master Data Maintenance Orders
AUFLAY
CHAR
4 0
PAR_TABSTR
Tab Page Number in the Order Layout
AUFBILD
CHAR
2 0
CHG_PRCTR
Profit Center
PRCTR
CHAR
10 0
CHG_BUKRS
Company Code
BUKRS
CHAR
4 0
CHG_WERKS
Plant
WERKS_D
CHAR
4 0
CHG_GSBER
Business Area
GSBER
CHAR
4 0
FLG_DRUCK
Indicator: "Print subarea order master"
FLG_DRUCK
CHAR
1 0
SYSST
System status line
J_STEXT
CHAR
40 0
ANWST
User Status Line
J_ATEXT
CHAR
40 0
MATNR
Material Number for Order
CO_MATNR
CHAR
18 0

ORDER_OUTPUT_TAB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ORDER_OUTPUT_TAB AUFK_STATUS ORDER_OUTPUT_TAB MANDT ACTCMB_TAB
table for status combination
MANDT
ORDER_OUTPUT_TAB AUFK_STATUS ORDER_OUTPUT_TAB AUFK_STATUS ACTCMB_TAB
table for status combination
ACTCMB
ORDER_OUTPUT_TAB CLAIM_CONTROL SYST MANDT WTYSCC_CLM_CONT
Instance when the Claim can be created from the Order
MANDT
ORDER_OUTPUT_TAB CLAIM_CONTROL ORDER_OUTPUT_TAB CLAIM_CONTROL WTYSCC_CLM_CONT
Instance when the Claim can be created from the Order
CLAIM_CONTROL
ORDER_OUTPUT_TAB FERC_IND ORDER_OUTPUT_TAB MANDT FERC_C7
Regulatory indicators
MANDT
ORDER_OUTPUT_TAB FERC_IND ORDER_OUTPUT_TAB FERC_IND FERC_C7
Regulatory indicators
IND
ORDER_OUTPUT_TAB OIHANTYP SYST MANDT OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
MANDT
ORDER_OUTPUT_TAB OIHANTYP ORDER_OUTPUT_TAB OIHANTYP OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
HANTYP
ORDER_OUTPUT_TAB UPDATE_CONTROL ORDER_OUTPUT_TAB UPDATE_CONTROL WTYSCC_UPDT_CONT
Update control points for claim update from service order
UPDATE_CONTROL
ORDER_OUTPUT_TAB UPDATE_CONTROL SYST MANDT WTYSCC_UPDT_CONT
Update control points for claim update from service order
MANDT
ORDER_OUTPUT_TAB VERAA_USER * USR02
Logon Data (Kernel-Side Use)
MANDT
ORDER_OUTPUT_TAB VERAA_USER ORDER_OUTPUT_TAB VERAA_USER USR02
Logon Data (Kernel-Side Use)
BNAME