The AUFK table in SAP ERP or S/4HANA stores Order master data data. There are total 131 fields in AUFK table. The Order master data table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of AUFK table. It is in Cost Accounting, Orders (KAUF) ABAP package and is part of the Overhead Cost Orders (CO-OM-OPA) module.
SAP AUFK Table Fields
Following is the list of fields that are available in SAP AUFK table. The primary key fields of the table are MANDT (Client), AUFNR (Order Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| AUFNR | Order Number | AUFNR | CHAR (12) | |
| AUART | Order Type | AUFART | T003O | CHAR (4) |
| AUTYP | Order category | AUFTYP | NUMC (2) | |
| REFNR | Reference Order Number | AUFREFNR | AUFK | CHAR (12) |
| 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 | T001 | CHAR (4) |
| WERKS | Plant | WERKS_D | T001W | CHAR (4) |
| GSBER | Business Area | GSBER | TGSB | CHAR (4) |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR (4) |
| CCKEY | Cost Collector Key | CCKEY | CHAR (23) | |
| KOSTV | Responsible cost center | AUFKOSTV | CSKS | CHAR (10) |
| STORT | Location | AUFSTORT | T499S | CHAR (10) |
| SOWRK | Location Plant | AUFSOWRK | T001W | CHAR (4) |
| ASTKZ | Identifier for Statistical Order | AUFSTKZ | CHAR (1) | |
| WAERS | Order Currency | AUFWAERS | TCURC | CUKY (5) |
| ASTNR | Order Status | AUFASTNR | NUMC (2) | |
| STDAT | Date of Last Status Change | AUFSTDAT | DATS (8) | |
| ESTNR | Status Reached so Far | AUFESTNR | TKO03 | NUMC (2) |
| 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 | TKAVG | CHAR (4) |
| LOEKZ | Deletion Flag | AUFLOEKZ | CHAR (1) | |
| PLGKZ | Identifier for Planning with Line Items | PLGKZ | CHAR (1) | |
| KVEWE | Usage of the condition table | KVEWE | T681V | CHAR (1) |
| KAPPL | Application | KAPPL | T681A | CHAR (2) |
| KALSM | Costing Sheet | AUFKALSM | T683 | CHAR (6) |
| ZSCHL | Overhead key | AUFZSCHL | CHAR (6) | |
| ABKRS | Processing group | AUFABKRS | TKO08 | NUMC (2) |
| KSTAR | Settlement Cost Element | AUFKSTAR | CSKB | CHAR (10) |
| KOSTL | Cost Center for Basic Settlement | AUFKOSTL | CSKS | CHAR (10) |
| SAKNR | G/L Account for Basic Settlement | AUFSAKNR | SKB1 | CHAR (10) |
| SETNM | Allocation Set | AUFSETNM | CHAR (12) | |
| CYCLE | Cost center to which costs are actually posted | ST_KOSTL | CSKS | CHAR (10) |
| 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 | ONR00 | CHAR (22) |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR (10) |
| PSPEL | Work breakdown structure element (WBS element) | PS_PSP_ELE | PRPS | NUMC (8) |
| AWSLS | Variance Key | AWSLS | TKV01 | CHAR (6) |
| ABGSL | Results Analysis Key | ABGR_SCHL | TKKAA | CHAR (6) |
| EB_POST | Event-Based Posting | FCO_EB_POST | CHAR (1) | |
| TXJCD | Tax Jurisdiction | TXJCD | TTXJ | CHAR (15) |
| FUNC_AREA | Functional Area | FKBER | TFKB | CHAR (16) |
| SCOPE | Object Class | SCOPE_CV | CHAR (2) | |
| PLINT | Indicator for Integrated Planning | PLINT | CHAR (1) | |
| KDAUF | Sales Order Number | KDAUF | CHAR (10) | |
| KDPOS | Item number in Sales Order | KDPOS | NUMC (6) | |
| AUFEX | External order number | AUFEX | CHAR (20) | |
| IVPRO | Investment Measure Profile | IM_PROFIL | TAPRF | CHAR (6) |
| LOGSYSTEM | Logical System | LOGSYSTEM | TBDLS | CHAR (10) |
| FLG_MLTPS | Order Has Multiple Items | CO_MLTPS | CHAR (1) | |
| ABUKR | Requesting company code | IM_ABUKRS | T001 | CHAR (4) |
| AKSTL | Requesting cost center | PS_AKSTL | CSKS | CHAR (10) |
| SIZECL | Scale of investment objects | IM_SIZECL | TAIF5 | CHAR (2) |
| IZWEK | Reason for Investment | IZWEK | T087I | CHAR (2) |
| UMWKZ | Reason for Environmental Investment | AM_UMWKZ | T087K | CHAR (5) |
| KSTEMPF | Indicator: Direct cost collector | CO_KSTEMPF | CHAR (1) | |
| ZSCHM | Interest Profile for Project/Order Interest Calculation | PS_ZSCHM | TPI01 | CHAR (7) |
| PKOSA | Cost Collector for Production Process | PKOSA_D | CHAR (12) | |
| ANFAUFNR | Requesting order | AUFANFNR | AUFK | CHAR (12) |
| 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 | TBMOT | CHAR (2) |
| 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 | USR02 | CHAR (12) |
| EEW_AUFK_PS_DUMMY | Dummy function in length 1 | DUMMY | CHAR (1) | |
| VNAME | Joint venture | JV_NAME | T8JV | CHAR (6) |
| RECID | Recovery Indicator | JV_RECIND | T8JJ | CHAR (2) |
| ETYPE | Equity type | JV_ETYPE | T8JG | CHAR (3) |
| OTYPE | Joint Venture Object Type | JV_OTYPE | CHAR (4) | |
| JV_JIBCL | JIB/JIBE Class | JV_JIBCL | T8J6A | CHAR (3) |
| JV_JIBSA | JIB/JIBE Subclass A | JV_JIBSA | T8J6C | CHAR (5) |
| JV_OCO | JV original cost object | JV_OR_CO | CHAR (1) | |
| CPD_UPDAT | Time Stamp | /CPD/PFP_SC_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) |
| AD01PROFNR | Dynamic Item Processor Profile | AD01PROFNR | AD01C_PROF | CHAR (8) |
| 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 | FERC_C7 | CHAR (4) |
| AUFK_STATUS | Status Combination | ACTCMB_DELE | ACTCMB_TAB | INT1 (3) |
| CLAIM_CONTROL | Claim creation control indicator | WTYSC_CLAIM_CONTROL | WTYSCC_CLM_CONT | CHAR (1) |
| UPDATE_NEEDED | Claim inconsistency with order indicator | WTYSC_UPDATE_NEEDED | CHAR (1) | |
| UPDATE_CONTROL | Claim update trigger point from service order | WTYSC_UPDATE_CONTROL | WTYSCC_UPDT_CONT | CHAR (1) |
| CUSTOMERFLD1 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD2 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD3 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD4 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD5 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD6 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD7 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD8 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD9 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD10 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD11 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD12 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD13 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD14 | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| CUSTOMERFLD15 | Character Field with Length 10 | CHAR10 | CHAR (10) |
