1. Home
  2. Resources
  3. SAP Tables
  4. ORDER_OUTPUT_TAB - Output Table for Orders

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
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
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
PHAS1 Phase "Order released" AUFPHAS1 CHAR 1 0
X Yes
NULL No
PHAS2 Phase "order completed" AUFPHAS2 CHAR 1 0
X Yes
NULL No
PHAS3 Phase "order closed" AUFPHAS3 CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
PLGKZ Identifier for planning with line items PLGKZ CHAR 1 0
X Yes
NULL No
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
X Work permit issued
NULL
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
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
PLINT Indicator for Integrated Planning PLINT CHAR 1 0
X Yes
NULL No
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
X
NULL
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
E Sales order
P Project
K Cost center
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
X Yes
NULL No
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
P object type for projects
O object type for orders
C object type for costcenters
NULL object type for current object
CPD_UPDAT Time Stamp /CPD/PFP_TSTMP DEC 15 0
/CUM/INDCU CU: Order is Used for Compatible Units /CUM/INDCU CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
/CUM/CMNUM CU: Construction Measure Number /CUM/CMNUM CHAR 12 0
/CUM/AUEST CU: Automatic Copy of Estimated Costs /CUM/AUEST CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
/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
C Contact Person
R Resource Manager
/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
NULL Not Relevant to Resource Planning
1 Contact person process
2 Resource planner process
3 Background Resource Planning Process
/MRSS/INIT_DONE Internal initialization carried out once /MRSS/T_INIT_DONE CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
/MRSS/DATACHANGE Data was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGED CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
/MRSS/SALES_ORG Sales Organization VKORG CHAR 4 0
/MRSS/NW_BOOKED Network Set to "Booked" /MRSS/T_NW_BOOKED CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
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
X Update needed
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
X Yes
NULL No
FLG_AFAEX Checkbox XFELD CHAR 1 0
X Yes
NULL No
FLG_AIBEX Flag 'Asset under construction exists' FLG_AIBEX CHAR 1 0
X Yes
NULL No
FLG_AIBOK Checkbox XFELD CHAR 1 0
X Yes
NULL No
FLG_AUFKL 'Order will be classified' indicator KZAUFKLA CHAR 1 0
X Yes
NULL No
FLG_BUDGT Flag 'Budget exists' FLG_BUDGT CHAR 1 0
X Yes
NULL No
FLG_COSTS Flag 'Costs exist" FLG_COSTS CHAR 1 0
X Yes
NULL No
FLG_DATAC Flag 'Data has been changed' FLG_DATAC CHAR 1 0
X Yes
NULL No
FLG_SAVEABR Flag 'Saved From Settlement rule" FLG_SAVEABR CHAR 1 0
X Yes
NULL No
FLG_ENQUE 'Object is blocked' flag FLG_ENQUE CHAR 1 0
X Yes
NULL No
FLG_ERLOE Identifier "Revenue posting allowed" ERLOESE CHAR 1 0
NULL not allowed
X allowed
FLG_AANLE Checkbox XFELD CHAR 1 0
X Yes
NULL No
FLG_IVPRG Checkbox XFELD CHAR 1 0
X Yes
NULL No
FLG_NABPF Indicator "Does not require settlement" NABPF CHAR 1 0
X Yes
NULL No
FLG_NKEXT Internal (' ') or external ('X') number range flag NRIND CHAR 1 0
X Yes
NULL No
FLG_NOBWA Flag 'No valuation type' FLG_NOBWA CHAR 1 0
X Yes
NULL No
FLG_OBLIGOX Commitments Management Active CO_OBLIGOX CHAR 1 0
X Yes
NULL No
FLG_OLDST Indicator 'Order status management active' SVALT_D CHAR 1 0
X Yes
NULL No
FLG_LOCKED Checkbox XFELD CHAR 1 0
X Yes
NULL No
FLG_IMMO Checkbox XFELD CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
01 1st screen (displayed after intial access)
02 2nd screen
03 3rd screen
04 4th screen
05 5th screen
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
X Yes
NULL No
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 SYST MANDT WTYSCC_UPDT_CONT Update control points for claim update from service order MANDT
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 VERAA_USER ORDER_OUTPUT_TAB VERAA_USER USR02 Logon Data (Kernel-Side Use) BNAME
ORDER_OUTPUT_TAB VERAA_USER * USR02 Logon Data (Kernel-Side Use) MANDT