SAP Table AUFK
Order master data
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
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 | |