Menu

SAP Table AUFK

Order master data

The table AUFK (Order master data) is a standard table in SAP ERP. It belongs to the package KAUF.

Technical Information

Table AUFK
Short Text Order master data
Package KAUF
Table Type Transparent Table

Fields for Table AUFK

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 T000
AUFNR Order Number AUFNR CHAR 12
AUART Order Type AUFART CHAR 4 T003O
AUTYP Order category AUFTYP NUMC 2
REFNR Reference order number AUFREFNR CHAR 12 AUFK
ERNAM Entered by AUFERFNAM CHAR 12
ERDAT Created on AUFERFDAT DATS 8
AENAM Last changed by AUFAENAM CHAR 12
AEDAT Change date for Order Master AUFAEDAT DATS 8
KTEXT Description AUFTEXT CHAR 40
LTEXT Long Text Exists AUFLTEXT CHAR 1
BUKRS Company Code BUKRS CHAR 4 T001
WERKS Plant WERKS_D CHAR 4 T001W
GSBER Business Area GSBER CHAR 4 TGSB
KOKRS Controlling Area KOKRS CHAR 4 TKA01
CCKEY Cost collector key CCKEY CHAR 23
KOSTV Responsible cost center AUFKOSTV CHAR 10 CSKS
STORT Location AUFSTORT CHAR 10 T499S
SOWRK Location plant AUFSOWRK CHAR 4 T001W
ASTKZ Identifier for statistical order AUFSTKZ CHAR 1
WAERS Order Currency AUFWAERS CUKY 5 TCURC
ASTNR Order status AUFASTNR NUMC 2 *
STDAT Date of last status change AUFSTDAT DATS 8
ESTNR Status reached so far AUFESTNR NUMC 2 TKO03
PHAS0 Phase "Order created" AUFPHAS0 CHAR 1
PHAS1 Phase "Order released" AUFPHAS1 CHAR 1
PHAS2 Phase "order completed" AUFPHAS2 CHAR 1
PHAS3 Phase "order closed" AUFPHAS3 CHAR 1
PDAT1 Planned release date AUFPDAT1 DATS 8
PDAT2 Planned completion date AUFPDAT2 DATS 8
PDAT3 Planned closing date AUFPDAT3 DATS 8
IDAT1 Release date AUFIDAT1 DATS 8
IDAT2 Technical completion date AUFIDAT2 DATS 8
IDAT3 Close date AUFIDAT3 DATS 8
OBJID Object ID CCOBJID CHAR 1
VOGRP Group of disallowed transactions AUFSPSET CHAR 4 TKAVG
LOEKZ Deletion flag AUFLOEKZ CHAR 1
PLGKZ Identifier for planning with line items PLGKZ CHAR 1
KVEWE Usage of the condition table KVEWE CHAR 1 T681V
KAPPL Application KAPPL CHAR 2 T681A
KALSM Costing Sheet AUFKALSM CHAR 6 T683
ZSCHL Overhead key AUFZSCHL CHAR 6
ABKRS Processing group AUFABKRS NUMC 2 TKO08
KSTAR Settlement cost element AUFKSTAR CHAR 10 CSKB
KOSTL Cost center for basic settlement AUFKOSTL CHAR 10 CSKS
SAKNR G/L account for basic settlement AUFSAKNR CHAR 10 SKB1
SETNM Allocation set AUFSETNM CHAR 12
CYCLE Cost center to which costs are actually posted ST_KOSTL CHAR 10 CSKS
SDATE Start Date SDATE DATS 8 *
SEQNR Sequence number AUFSEQNR NUMC 4 *
USER0 Applicant AUFUSER0 CHAR 20
USER1 Applicant's telephone number AUFUSER1 CHAR 20
USER2 Person responsible AUFUSER2 CHAR 20
USER3 Telephone number of person in charge AUFUSER3 CHAR 20
USER4 Estimated total costs of order AUFUSER4 CURR 11
USER5 Application Date AUFUSER5 DATS 8
USER6 Department AUFUSER6 CHAR 15
USER7 Work Start AUFUSER7 DATS 8
USER8 End of Work AUFUSER8 DATS 8
USER9 Identifier for work permit issued AUFUSER9 CHAR 1
OBJNR Object number J_OBJNR CHAR 22 ONR00
PRCTR Profit Center PRCTR CHAR 10 CEPC
PSPEL Work breakdown structure element (WBS element) PS_PSP_ELE NUMC 8 PRPS
AWSLS Variance Key AWSLS CHAR 6 TKV01
ABGSL Results Analysis Key ABGR_SCHL CHAR 6 TKKAA
TXJCD Tax Jurisdiction TXJCD CHAR 15 TTXJ
FUNC_AREA Functional Area FKBER CHAR 16 TFKB
SCOPE Object Class SCOPE_CV CHAR 2
PLINT Indicator for Integrated Planning PLINT CHAR 1
KDAUF Sales Order Number KDAUF CHAR 10 VBUK
KDPOS Item Number in Sales Order KDPOS NUMC 6
AUFEX External order number AUFEX CHAR 20
IVPRO Investment measure profile IM_PROFIL CHAR 6 TAPRF
LOGSYSTEM Logical System LOGSYSTEM CHAR 10 TBDLS
FLG_MLTPS Order with multiple items CO_MLTPS CHAR 1
ABUKR Requesting company code IM_ABUKRS CHAR 4 T001
AKSTL Requesting cost center PS_AKSTL CHAR 10 CSKS
SIZECL Scale of investment objects IM_SIZECL CHAR 2 TAIF5
IZWEK Reason for investment IZWEK CHAR 2 T087I
UMWKZ Reason for environmental investment AM_UMWKZ CHAR 5 T087K
KSTEMPF Indicator: Direct cost collector CO_KSTEMPF CHAR 1
ZSCHM Interest Profile for Project/Order Interest Calculation PS_ZSCHM CHAR 7 TPI01
PKOSA Cost collector for production process PROCNR PKOSA_D CHAR 12 *
ANFAUFNR Requesting order AUFANFNR CHAR 12 AUFK
PROCNR Production Process CKML_F_PROCNR NUMC 12 *
PROTY Process Category (Procurement/Consumption) CKML_PROZESS_TYP CHAR 4 *
RSORD Refurbishment order indicator (PM) RSORD CHAR 1
BEMOT Accounting Indicator BEMOT CHAR 2 TBMOT
ADRNRA Address number AD_ADDRNUM CHAR 10 *
ERFZEIT Time created CO_INS_TIME TIMS 6
AEZEIT Changed at CO_CHG_TIME TIMS 6
CSTG_VRNT Costing Variant CK_KLVAR CHAR 4 *
COSTESTNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 *
VERAA_USER Person Responsible for CO Internal Order VERAA_USER CHAR 12 USR02
DUMMY_CI_AUFK Single-Character Indicator CHAR1 CHAR 1
ZFIELD97 Text, 40 Characters Long TEXT40 CHAR 40
VNAME Joint Venture JV_NAME CHAR 6 T8JV
RECID Recovery Indicator JV_RECIND CHAR 2 T8JJ
ETYPE Equity type JV_ETYPE CHAR 3 T8JG
OTYPE Joint Venture Object Type JV_OTYPE CHAR 4
JV_JIBCL JIB/JIBE Class JV_JIBCL CHAR 3 T8J6A
JV_JIBSA JIB/JIBE Subclass A JV_JIBSA CHAR 5 T8J6C
JV_OCO JV original cost object JV_OR_CO CHAR 1
CPD_UPDAT Time Stamp /CPD/PFP_TSTMP DEC 15
/CUM/INDCU CU: Order is Used for Compatible Units /CUM/INDCU CHAR 1
/CUM/CMNUM CU: Construction Measure Number /CUM/CMNUM CHAR 12
/CUM/AUEST CU: Automatic Copy of Estimated Costs /CUM/AUEST CHAR 1
/CUM/DESNUM CU: Design Number /CUM/DESNUM CHAR 12 *
/MRSS/PL_STRU_ID Resource planning nodes /MRSS/T_PLAN_STRUCT_ID NUMC 8 *
/MRSS/PL_MAN_TYP Assignment to resource planner or contact person /MRSS/T_MANAGER_TYPE CHAR 1
/MRSS/ORDER_PROB Order probability in percent /MRSS/T_ORDER_PROB CHAR 3
/MRSS/ACT_TYPE Process variant /MRSS/T_ACTIVITY_TYPE CHAR 1
/MRSS/INIT_DONE Internal initialization carried out once /MRSS/T_INIT_DONE CHAR 1
/MRSS/DATACHANGE Data was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGED CHAR 1
/MRSS/SALES_ORG Sales Organization VKORG CHAR 4 *
/MRSS/NW_BOOKED Network Set to "Booked" /MRSS/T_NW_BOOKED CHAR 1
AD01PROFNR Dynamic Item Processor Profile AD01PROFNR CHAR 8 AD01C_PROF
VAPLZ Main work center for maintenance tasks GEWRK CHAR 8
WAWRK Plant associated with main work center WERGW CHAR 4 *
FERC_IND Regulatory indicator FE_IND CHAR 4 FERC_C7
AUFK_STATUS Status Combination ACTCMB_DELE INT1 3 ACTCMB_TAB
Append Structure: WTYSC_HEAD_INDICATOR_AUFK_AS
CLAIM_CONTROL Claim creation control indicator WTYSC_CLAIM_CONTROL CHAR 1 WTYSCC_CLM_CONT
UPDATE_NEEDED Claim inconsistency with order indicator WTYSC_UPDATE_NEEDED CHAR 1
Include Structure: WTYSC_S_CLAIM_UPDATE_CONTROL
UPDATE_CONTROL Claim update trigger point from service order WTYSC_UPDATE_CONTROL CHAR 1 WTYSCC_UPDT_CONT