AUFK SAP table for – Order master data

Here we would like to draw your attention to AUFK table in SAP. As we know it is being mainly used with the SAP CO-OM (Overhead Cost Controlling in CO) component which is coming under CO module (Controlling). AUFK is a SAP standard transparent table used for storing Order master data related data in SAP. It comes under the package KAUF.

SAP AUFK table

Table AUFK technical data

TableAUFK
Data storingOrder master data
ModuleCO
ComponentCO-OM
SAP PackageKAUF
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP AUFK Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in AUFK table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • KTEXT
    Its data type is C (Character String) with field length 40
  • JV_OCO : JV original cost object
    Its data type is C (Character String) with field length 1
  • LTEXT
    Its data type is C (Character String) with field length 1
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • KOKRS : Controlling Area
    Its data type is C (Character String) with field length 4
  • CCKEY
    Its data type is C (Character String) with field length 23
  • KOSTV : Responsible cost center
    Its data type is C (Character String) with field length 10
  • STORT
    Its data type is C (Character String) with field length 10
  • SOWRK
    Its data type is C (Character String) with field length 4
  • AUFNR : Order Number
    Its a key field. Its data type is C (Character String) with field length 12
  • ASTKZ
    Its data type is C (Character String) with field length 1
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • ASTNR
    Its data type is N (Character String with Digits Only) with field length 2
  • STDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ESTNR
    Its data type is N (Character String with Digits Only) with field length 2
  • PHAS0
    Its data type is C (Character String) with field length 1
  • PHAS1
    Its data type is C (Character String) with field length 1
  • PHAS2
    Its data type is C (Character String) with field length 1
  • PHAS3
    Its data type is C (Character String) with field length 1
  • PDAT1
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AUART : Order Type
    Its data type is C (Character String) with field length 4
  • PDAT2
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PDAT3
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IDAT1
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IDAT2
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IDAT3
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • OBJID : Accrual Object (Internal Display in Form of a GUID)
    Its data type is C (Character String) with field length 1
  • VOGRP
    Its data type is C (Character String) with field length 4
  • LOEKZ : CHAR01 data element for SYST
    Its data type is C (Character String) with field length 1
  • PLGKZ
    Its data type is C (Character String) with field length 1
  • KVEWE
    Its data type is C (Character String) with field length 1
  • AUTYP : Order category
    Its data type is N (Character String with Digits Only) with field length 2
  • KAPPL : Application
    Its data type is C (Character String) with field length 2
  • KALSM : Costing Sheet
    Its data type is C (Character String) with field length 6
  • ZSCHL : Overhead key
    Its data type is C (Character String) with field length 6
  • ABKRS
    Its data type is N (Character String with Digits Only) with field length 2
  • KSTAR : Cost Element
    Its data type is C (Character String) with field length 10
  • KOSTL : Cost Center
    Its data type is C (Character String) with field length 10
  • SAKNR : G/L Account Number
    Its data type is C (Character String) with field length 10
  • SETNM
    Its data type is C (Character String) with field length 12
  • CYCLE
    Its data type is C (Character String) with field length 10
  • SDATE : Created on
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • REFNR
    Its data type is C (Character String) with field length 12
  • SEQNR : Flight Scheduling: Flight Sequence Number
    Its data type is N (Character String with Digits Only) with field length 4
  • USER0
    Its data type is C (Character String) with field length 20
  • USER1 : User Name in User Master Record
    Its data type is C (Character String) with field length 20
  • USER2
    Its data type is C (Character String) with field length 20
  • USER3
    Its data type is C (Character String) with field length 20
  • USER4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • USER5
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USER6
    Its data type is C (Character String) with field length 15
  • USER7
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USER8
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • USER9
    Its data type is C (Character String) with field length 1
  • OBJNR : Object number
    Its data type is C (Character String) with field length 22
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • PSPEL
    Its data type is N (Character String with Digits Only) with field length 8
  • AWSLS
    Its data type is C (Character String) with field length 6
  • ABGSL
    Its data type is C (Character String) with field length 6
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • SCOPE : Object Class
    Its data type is C (Character String) with field length 2
  • PLINT
    Its data type is C (Character String) with field length 1
  • KDAUF : Sales Order Number
    Its data type is C (Character String) with field length 10
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KDPOS : Item number in Sales Order
    Its data type is N (Character String with Digits Only) with field length 6
  • AUFEX
    Its data type is C (Character String) with field length 20
  • IVPRO
    Its data type is C (Character String) with field length 6
  • LOGSYSTEM
    Its data type is C (Character String) with field length 10
  • FLG_MLTPS
    Its data type is C (Character String) with field length 1
  • ABUKR : Company Code which will be Cleared Against
    Its data type is C (Character String) with field length 4
  • AKSTL
    Its data type is C (Character String) with field length 10
  • SIZECL
    Its data type is C (Character String) with field length 2
  • IZWEK
    Its data type is C (Character String) with field length 2
  • UMWKZ
    Its data type is C (Character String) with field length 5
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • KSTEMPF
    Its data type is C (Character String) with field length 1
  • ZSCHM
    Its data type is C (Character String) with field length 7
  • PKOSA
    Its data type is C (Character String) with field length 12
  • PROCNR
    Its data type is N (Character String with Digits Only) with field length 12
  • PROTY
    Its data type is C (Character String) with field length 4
  • RSORD
    Its data type is C (Character String) with field length 1
  • BEMOT : Accounting Indicator
    Its data type is C (Character String) with field length 2
  • ADRNRA
    Its data type is C (Character String) with field length 10
  • ERFZEIT
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • AEZEIT
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CI_AUFK
  • VNAME : Joint venture
    Its data type is C (Character String) with field length 6
  • RECID : Recovery Indicator
    Its data type is C (Character String) with field length 2
  • ETYPE : Equity type
    Its data type is C (Character String) with field length 3
  • OTYPE : Object Type
    Its data type is C (Character String) with field length 4
  • JV_JIBCL : JIB/JIBE Class
    Its data type is C (Character String) with field length 3
  • JV_JIBSA : JIB/JIBE Subclass A
    Its data type is C (Character String) with field length 5