1. SAP Tutorial
  2. CO Module

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

    • AUFK related tables

    • AUFLAY1 : Layouts for the Orders
    • TKO04 : Order Status Descriptions
    • TKO01 : Control parameters for order type
    • T003O : Order Types
    • TKLCO : Rules for taking over classification data
    • TKO03 : Order status
    • TKAVT : Transaction group names
    • TKOFA : Control table for field-selection group names
    • RKOCLMIG : Assign field names in CI_AUFK to characteristic names
    • TKAVG : Transaction groups
    • TKO08 : Processing groups for orders
    • TKOFA : Control table for field-selection group names
    • TKLCO : Rules for taking over classification data
    • TKAVT : Transaction group names
    • TKO01 : Control parameters for order type
    • AUFLAY3 : Assignment Subscreens: Screens for Order Master Data Maint.
    • T003O : Order Types
    • AUFLAY2 : Order Master Data Maintenance: Tab Names
    • T003P : Order Type Descriptions
    • TKAVG : Transaction groups

    AUFK related t.ransaction codes under SAP package KAUF

    • OKOU : Substitution Rules – Internal Orders
    • KOB1 : Orders: Actual Line Items
    • KORI : Job Selection
    • KO03 : Display Internal Order
    • KO25 : Display Order Supplement
    • KOC2 : Run Selected Reports
    • KOP2 : Change Orders for Plan Revaluation
    • KO26 : Change Order Return
    • KOA1 : Send Internal Order
    • KO32 : Deactivate Order Availability Cntrl
    • KO12 : Change Order Plan (Overall, Year)
    • KOK4 : Aut. Collect. Proc. Internal Orders
    • KOL1 : Order List (Master Data)
    • KO23 : Display Order Budget
    • KO27 : Display Order Return
    • KAFL : Delete All Costs Transferred w. KAFD
    • KO01 : Create Internal Order
    • KOH3 : Display Order Group
    • KOTZ : Costing Items for Order
    • KOWEB_EDIT_OR : Edit Order Master Data (Web)

    Related References

    Related Tutorials

    KO08 SAP tcode for – Data Transfer for Order Master Data

    KO08 tcode in SAP CO (Overhead Cost Controlling in CO) module. This transaction code is used for Data Transfer for...

    AUFLAY2 SAP table for – Order Master Data Maintenance: Tab Names

    AUFLAY2 table in SAP CO (Overhead Cost Controlling in CO) module. This tables is used for storing data of Order...

    KOWEB_CREATE_OR SAP tcode for – Create Order Master Data (Web)

    KOWEB_CREATE_OR tcode in SAP CO (Overhead Cost Controlling in CO) module. This transaction code is used for Create Order Master...

    AUFLAY3 SAP table for – Assignment Subscreens: Screens for Order Master Data Maint.

    AUFLAY3 table in SAP CO (Overhead Cost Controlling in CO) module. This tables is used for storing data of Assignment...

    KOWEB_EDIT_OR SAP tcode for – Edit Order Master Data (Web)

    KOWEB_EDIT_OR tcode in SAP CO (Overhead Cost Controlling in CO) module. This transaction code is used for Edit Order Master...

    KOL1 SAP tcode for – Order List (Master Data)

    KOL1 tcode in SAP CO (Overhead Cost Controlling in CO) module. This transaction code is used for Order List (Master...

    KOK5 SAP tcode for – Master Data List Internal Orders

    KOK5 tcode in SAP CO (Overhead Cost Controlling in CO) module. This transaction code is used for Master Data List...

    «
    »