SAP TABLES | Controlling | Overhead Cost Controlling | Overhead Cost Orders(CO-OM-OPA) SAP CO

AUFK SAP Order master data Table and data







AUFK is a standard SAP Table which is used to store Order master data data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP AUFK Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP AUFK Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
AUFNRAUFNRCHAR12 Order NumberALPHA
AUARTAUFARTCHAR4 T003OOrder Type
AUTYPAUFTYPNUMC2 Order category
REFNRAUFREFNRCHAR12 AUFKReference order numberALPHA
ERNAMAUFERFNAMCHAR12 Entered by
ERDATAUFERFDATDATS8 Created on
AENAMAUFAENAMCHAR12 Last changed by
AEDATAUFAEDATDATS8 Change date for Order Master
KTEXTAUFTEXTCHAR40 Description
LTEXTAUFLTEXTCHAR1 Long Text Exists
BUKRSBUKRSCHAR4 T001Company Code
WERKSWERKS_DCHAR4 T001WPlant
GSBERGSBERCHAR4 TGSBBusiness Area
KOKRSKOKRSCHAR4 TKA01Controlling Area
CCKEYCCKEYCHAR23 Cost collector key
KOSTVAUFKOSTVCHAR10 CSKSResponsible cost centerALPHA
STORTAUFSTORTCHAR10 T499SLocation
SOWRKAUFSOWRKCHAR4 T001WLocation plant
ASTKZAUFSTKZCHAR1 Identifier for statistical order
WAERSAUFWAERSCUKY5 TCURCOrder Currency
ASTNRAUFASTNRNUMC2
*
Order status
STDATAUFSTDATDATS8 Date of last status change
ESTNRAUFESTNRNUMC2 TKO03Status reached so far
PHAS0AUFPHAS0CHAR1 Phase "Order created"
PHAS1AUFPHAS1CHAR1 Phase "Order released"
PHAS2AUFPHAS2CHAR1 Phase "order completed"
PHAS3AUFPHAS3CHAR1 Phase "order closed"
PDAT1AUFPDAT1DATS8 Planned release date
PDAT2AUFPDAT2DATS8 Planned completion date
PDAT3AUFPDAT3DATS8 Planned closing date
IDAT1AUFIDAT1DATS8 Release date
IDAT2AUFIDAT2DATS8 Technical completion date
IDAT3AUFIDAT3DATS8 Close date
OBJIDCCOBJIDCHAR1 Object ID
VOGRPAUFSPSETCHAR4 TKAVGGroup of disallowed transactions
LOEKZAUFLOEKZCHAR1 Deletion flag
PLGKZPLGKZCHAR1 Identifier for planning with line items
KVEWEKVEWECHAR1 T681VUsage of the condition table


KAPPLKAPPLCHAR2 T681AApplication
KALSMAUFKALSMCHAR6 T683Costing Sheet
ZSCHLAUFZSCHLCHAR6 Overhead key
ABKRSAUFABKRSNUMC2 TKO08Processing group
KSTARAUFKSTARCHAR10 CSKBSettlement cost elementALPHA
KOSTLAUFKOSTLCHAR10 CSKSCost center for basic settlementALPHA
SAKNRAUFSAKNRCHAR10 SKB1G/L account for basic settlementALPHA
SETNMAUFSETNMCHAR12 Allocation set
CYCLEST_KOSTLCHAR10 CSKSCost center to which costs are actually postedALPHA
SDATESDATEDATS8
*
Start Date
SEQNRAUFSEQNRNUMC4
*
Sequence number
USER0AUFUSER0CHAR20 Applicant
USER1AUFUSER1CHAR20 Applicant's telephone number
USER2AUFUSER2CHAR20 Person responsible
USER3AUFUSER3CHAR20 Telephone number of person in charge
USER4AUFUSER4CURR11(2) Estimated total costs of order
USER5AUFUSER5DATS8 Application Date
USER6AUFUSER6CHAR15 Department
USER7AUFUSER7DATS8 Work Start
USER8AUFUSER8DATS8 End of Work
USER9AUFUSER9CHAR1 Identifier for work permit issued
OBJNRJ_OBJNRCHAR22 ONR00Object number
PRCTRPRCTRCHAR10 CEPCProfit CenterALPHA
PSPELPS_PSP_ELENUMC8 PRPSWork breakdown structure element (WBS element)ABPSP
AWSLSAWSLSCHAR6 TKV01Variance Key
ABGSLABGR_SCHLCHAR6 TKKAAResults Analysis Key
TXJCDTXJCDCHAR15 TTXJTax Jurisdiction
FUNC_AREAFKBERCHAR16 TFKBFunctional Area
SCOPESCOPE_CVCHAR2 Object ClassSCOPE
PLINTPLINTCHAR1 Indicator for Integrated Planning
KDAUFKDAUFCHAR10 VBUKSales Order NumberALPHA
KDPOSKDPOSNUMC6 Item Number in Sales Order
AUFEXAUFEXCHAR20 External order numberALPHA
IVPROIM_PROFILCHAR6 TAPRFInvestment measure profile
LOGSYSTEMLOGSYSTEMCHAR10 TBDLSLogical SystemALPHA
FLG_MLTPSCO_MLTPSCHAR1 Order with multiple items
ABUKRIM_ABUKRSCHAR4 T001Requesting company code
AKSTLPS_AKSTLCHAR10 CSKSRequesting cost centerALPHA
SIZECLIM_SIZECLCHAR2 TAIF5Scale of investment objectsALPHA


IZWEKIZWEKCHAR2 T087IReason for investment
UMWKZAM_UMWKZCHAR5 T087KReason for environmental investment
KSTEMPFCO_KSTEMPFCHAR1 Indicator: Direct cost collector
ZSCHMPS_ZSCHMCHAR7 TPI01Interest Profile for Project/Order Interest Calculation
PKOSAPKOSA_DCHAR12
*
Cost collector for production process PROCNRALPHA
ANFAUFNRAUFANFNRCHAR12 AUFKRequesting orderALPHA
PROCNRCKML_F_PROCNRNUMC12
*
Production Process
PROTYCKML_PROZESS_TYPCHAR4
*
Process Category (Procurement/Consumption)
RSORDRSORDCHAR1 Refurbishment order indicator (PM)
BEMOTBEMOTCHAR2 TBMOTAccounting Indicator
ADRNRAAD_ADDRNUMCHAR10
*
Address numberALPHA
ERFZEITCO_INS_TIMETIMS6 Time created
AEZEITCO_CHG_TIMETIMS6 Changed at
CSTG_VRNTCK_KLVARCHAR4
*
Costing Variant
COSTESTNRCK_KALNRNUMC12
*
Cost Estimate Number for Cost Est. w/o Qty Structure
VERAA_USERVERAA_USERCHAR12 USR02Person Responsible for CO Internal Order
DUMMY_CI_AUFKCHAR1CHAR1 Single-Character Indicator
ZFIELD97 TEXT40CHAR40 Text, 40 Characters Long
.INCLUDEGJV_DATA_4 JV data: (gjv_data_1),jv_oco
.INCLUDEGJV_DATA_1 JV data: (vname,recid,etype),otype,jv_jibcl,jv_jibsa
.INCLUDEGJV_DATA_0 General assignments of application objects
VNAMEJV_NAMECHAR6 T8JVJoint VentureALPHA
RECIDJV_RECINDCHAR2 T8JJRecovery IndicatorALPHA
ETYPEJV_ETYPECHAR3 T8JGEquity typeALPHA
OTYPEJV_OTYPECHAR4 Joint Venture Object TypeALPHA
JV_JIBCLJV_JIBCLCHAR3 T8J6AJIB/JIBE Class
JV_JIBSAJV_JIBSACHAR5 T8J6CJIB/JIBE Subclass A
JV_OCOJV_OR_COCHAR1 JV original cost object
.APPEND/CPD/PFP_AUFK_TIMESTMP Time stamp for created on and changed on time
CPD_UPDAT/CPD/PFP_TSTMPDEC15 Time StampTSTLC
.APPEND/CUM/APP_AUFK CU specific APPEND for order master data
/CUM/INDCU/CUM/INDCUCHAR1 CU: Order is Used for Compatible Units
/CUM/CMNUM/CUM/CMNUMCHAR12 CU: Construction Measure NumberALPHA
/CUM/AUEST/CUM/AUESTCHAR1 CU: Automatic Copy of Estimated Costs
/CUM/DESNUM/CUM/DESNUMCHAR12
*
CU: Design NumberALPHA
.APPEND/MRSS/T_APPEND_AUFK TICM CHANGES
.INCLUDE/MRSS/T_INCLUDE_AUFK TICM CHANGES
/MRSS/PL_STRU_ID/MRSS/T_PLAN_STRUCT_IDNUMC8
*
Resource planning nodes
/MRSS/PL_MAN_TYP/MRSS/T_MANAGER_TYPECHAR1 Assignment to resource planner or contact person

/MRSS/ORDER_PROB/MRSS/T_ORDER_PROBCHAR3 Order probability in percentOPROB
/MRSS/ACT_TYPE/MRSS/T_ACTIVITY_TYPECHAR1 Process variant
/MRSS/INIT_DONE/MRSS/T_INIT_DONECHAR1 Internal initialization carried out once
/MRSS/DATACHANGE/MRSS/T_USCREENCTL_DATACHANGEDCHAR1 Data was changed in the controls on the user screen
/MRSS/SALES_ORGVKORGCHAR4
*
Sales Organization
/MRSS/NW_BOOKED/MRSS/T_NW_BOOKEDCHAR1 Network Set to "Booked"
.APPENDAD01AUFK Struttura Append per AUFK
AD01PROFNRAD01PROFNRCHAR8 AD01C_PROFDynamic Item Processor Profile
.APPENDAD02AUFK Work Center
VAPLZGEWRKCHAR8 Main work center for maintenance tasks
WAWRKWERGWCHAR4
*
Plant associated with main work center
.APPENDFERC_AUFK Append structure for Regulatory Reporting
FERC_INDFE_INDCHAR4 FERC_C7Regulatory indicatorALPHA
.APPENDNTW_STATUS Network Leading Status
AUFK_STATUSACTCMB_DELEINT13 ACTCMB_TABStatus Combination
.APPENDWTYSC_HEAD_INDICATOR_AUFK_AS AUFK i├žin ek
.INCLUDEWTYSC_S_CLAIM_CONTR_INDICATOR Structure for claim control indicator
CLAIM_CONTROLWTYSC_CLAIM_CONTROLCHAR1 WTYSCC_CLM_CONTClaim creation control indicator
.INCLUDEWTYSC_S_CLAIM_UPDATE_INDICATOR Structure for claim update
UPDATE_NEEDEDWTYSC_UPDATE_NEEDEDCHAR1 Claim inconsistency with order indicator
.INCLUDEWTYSC_S_CLAIM_UPDATE_CONTROL Structure for claim update control
UPDATE_CONTROLWTYSC_UPDATE_CONTROLCHAR1 WTYSCC_UPDT_CONTClaim update trigger point from service order



Key field
Non-key field

AUFK relationships with other tables


AUFK-Master Data Fields for Selection


AUFK-Order master data
     AFKO-Header Data in PP Orders
          AFPO-Order Item
     CDHDR-Change document header
          CDPOS-Change document items
     THEAD-SAPscript: Text Header
          TLINE-SAPscript: Text Lines
     JSTO-Status object information
          JCDO-Change Documents for Status Object (Table JSTO)
          JEST-Individual Status per Object
               JCDS-Change docs. for system/user status (table JEST)
     COBRA-Settlement Rule for Order Settlement
          COBRB-Distribution rules for sett. rule for order sett.
     BPHI1-Cross-hierarchy data Control
     BPTR1-Object data Control
          BPGE1-Totals record total value Control
               BPVG1-Table generated for view BPVG1
               BKHS1-Header: Unit Costing (Control + Totals)
                    HEAD10-SAPscript: Text Header
                         LINE10-SAPscript: Text Lines
                    BKHT1-Texts for CKHS
                    BKIS1-Individual calculation/verification item gen.
                         BKIT1-Texts for CKIS
                    BKIP1-Periodic Values for Unit Costing Item
          BPJA1-Totals record for total year value Control
               BPVJ1-Table Generated for View BPVJ1
               BKHS2-Header: Unit Costing (Control + Totals)
                    HEAD20-SAPscript: Text Header
                         LINE20-SAPscript: Text Lines
                    BKHT2-Texts for CKHS
                    BKIS2-Individual calculation/verification item gen.
                         BKIT2-Texts for CKIS
                    BKIP2-Periodic Values for Unit Costing Item
          BPIG1-Budget Object Index (Overall Budget)
          BPIJ1-Budget Object Index (Annual Budget)
     COKA1-CO Object: Control Data for Cost Elements
     COKP1-CO Object: Control Data for Primary Planning
          HEAD11-SAPscript: Text Header
               LINE11-SAPscript: Text Lines
          CKHS1-Header: Unit Costing (Control + Totals)
               CKHT1-Texts for CKHS
               HEAD12-SAPscript: Text Header
                    LINE12-SAPscript: Text Lines
               CKIS1-Individual calculation/verification item gen.
                    CKIT1-Texts for CKIS
               CKIP1-Periodic Values for Unit Costing Item
     COSP1-CO Object: Cost Totals for External Postings
          COVP11-CO object: Line items with doc. header (by period)
               COEPD11-CO object: Unvaluated ln. item settlement w/status
                    COEPBR11-CO Object: Valuated Line Item Settlement
               EBII11-CO/SD doc. flow: Billed parts of resource item
          COVJ11-CO object: Line items with doc header (by year)
          COVO1-CO Object: Open Items for Line Items (w/o doc.Hdr)
     COSPD1-CO object: External cost totals - calculated
     COKS1-CO Object: Control Data for Secondary Planning
          HEAD13-SAPscript: Text Header
               LINE13-SAPscript: Text Lines
     COSS1-CO Object: Cost Totals for Internal Postings
          COVP12-CO object: Line items with doc. header (by period)
               COEPD12-CO object: Unvaluated ln. item settlement w/status
                    COEPBR12-CO Object: Valuated Line Item Settlement
               EBII12-CO/SD doc. flow: Billed parts of resource item
          COVJ12-CO object: Line items with doc header (by year)
     COSSD1-CO object: Internal cost totals - calculated
     COKR1-CO Object: Control Data for Statistical Key Figs
          HEAD14-SAPscript: Text Header
               LINE14-SAPscript: Text Lines
     COSR1-CO Object: Statistical Key Figure Totals
          COVPR1-CO object: Stat. key figure line items by period
               EBII1-CO/SD doc. flow: Billed parts of resource item
          COVJR1-CO object: Line items stat. key figures (by year)
     COSL1-CO Object: Activity Type Totals
          COVPL1-CO object: Activity type line items by period
          COVJL1-CO object: Line items for acty types (by year)
     COSB1-CO Object: Total Variances/Results Analyses
          COVPB1-CO object: Variance/accrual line items by period
     COSBD1-CO object: Sums of variance/accrual - calculated
     ANIA1-Depr. simulation for invest. projects
          ANIB1-Invest. projects: Depr. simulation analysis report
     ANLI1-Link table for capital investment measure -> AuC
     FMSU1-FM totals records for financial data
          COVFP1-CO object: Financial data line items with doc. hdr
     RPSCO1-Summarization Table for Project Reporting
     RPSQT-Project info database: quantities
     TPI031-CO Objects: Date of Last Interest Run


ARKOPF-Archiving run header data
     VSKOPF-Version: Header - general data for a
          RSTHIE-BRST structure of the hierarchy table
               PSDYRH-LDB PSJ: Dummy structure under RSTHIE
          PROJ-Project definition
               PSDYPD-LDB PSJ: Dummy structure under PROJ
          VBAK-Sales Document: Header Data
               VBUK-Sales Doc.: Header Status and Administrative Data
               VBKD-Sales Document: Business Data
               VBAP-Sales Document: Item Data
                    VBUP-Sales Document: Item Status
                    VBKDPO-Sales document: Business item data (POSNR > 0)
                         FPLA-Billing plan
                              FPLT-Billing Plan: Dates
                    PSDYVB-LDB PSJ: Dummy structure under VBAP
               PSDYVK-LDB PSJ: Dummy structure under VBAK
          PRPS_R-Project Hierarchy Reporting Structure
               PRTE-Scheduling Data for Project Item
               PSMLST-Milestone I/O Table
               PSTX-PS Texts (Header)
               PLAF-Planned order
               PSMERK (PSMERK_PRPS)-Characteristics for Summarization for WBS Elements
                    KBED04-Capacity Requirement Recs for Planned Orders (LDB)
                    RESB04-Reservation/dependent reqs for plan order (LDB)
               PSDYPR-LDB PSJ: Dummy structure under PRPS_R
          AUFK-Order master data
               AFKO-Order Header Data PP Orders
                    AFPO-Order Item
                    AFFL-Work order sequence
                         ACT01-Activity for LDB 01
                              AFAB01-Network Relationship (for LDB) - 01
                              MLSTD-Milestone I/O Table
                              PSTX1-PS Texts (Header) for Activity (1)
                              AFFH01-Order PRT Data (for LDB) - 01
                              KBED01-Capacity Requirement Records (for LDB) - 01
                                   KBEZ-Additional data for table KBED (for ind.req/split)
                                        KPER-Additional data for KBEZ (person split in days)
                                   AFRU02-Order Confirmations (for LDB) -02
                              RESB01-Reservation/Dependent Requirement for LDB-01
                                   PSDYOK-LDB PSJ: Dummy structure under RESB01
                              AFRU01-Order Confirmations (for LDB) - 01
                              PSMERK (PSMERK_ACT)-Charactersitics for Summarization for Activity
                              PSDYNV-LDB PSJ: Dummy structure under ACT01
               AFIH-Maintenance order header
               PSDYNP-LDB PSJ: Dummy structure under AUFK
          IMTP-Investment programs
               IMPR-Investment Program Positions
                    PSDYIP-LDB PSJ: Dummy structure under IMPR
               PSDYPG-LDB PSJ: Dummy structure under IMTP
          PEGOB-Peg (master data of the CO object)
               PEGQTY-Assigned pegging object quantities
               PSDYPEG-LDB PSJ: Dummy Structure Under PEGOB
          ELM_PS-Additional data for hierarchy nodes (LDB PSJ)
               JSTO-Status object information
                    PSTAT-Condensed status display
                    JCDO-Change Documents for Status Object (Table JSTO)
                    JEST-Individual Status per Object
                         JCDS-Change docs. for system/user status (table JEST)
               ONR00-General Object Number
                    RPSCO1-Summarization Table for Project Reporting
                    RPSQT-Summarization table for project reporting (quants)
                    EVOP (EV_PARAM)-Object parameters for earned value analysis
                    EVPOC_RPSQT (EV_POC)-Earned value analysis: percentage of completion
                    EVVAL_RPSCO (EV_VAL)-Earned value analysis: earned value
                    COBRA-Settlement Rule for Order Settlement
                         COBRB-Distribution rules for sett. rule for order sett.
                    BPHI1-Cross-hierarchy data Control
                    BPTR1-Object Data Control
                         BPGE1-Totals record total value Control
                              BPVG1-Table Generated for View BPVG1
                              BKHS1-Header - Unit Costing (Control + Totals)
                                   HEAD10-SAPscript: Text Header
                                        LINE10-SAPscript: Text Lines
                                   BKHT1-Texts for CKHS
                                   BKIS1-Individual calculation/verification item gen.
                                        BKIT1-Texts for CKIS
                                   BKIP1-Periodic Values for Unit Costing Item
                         BPJA1-Totals record for total year value Control
                              BPVJ1-Table Generated for View BPVJ1
                              BKHS2-Header - Unit Costing (Control + Totals)
                                   HEAD20-SAPscript: Text Header
                                        LINE20-SAPscript: Text Lines
                                   BKHT2-Texts for CKHS
                                   BKIS2-Individual calculation/verification item gen.
                                        BKIT2-Texts for CKIS
                                   BKIP2-Periodic Values for Unit Costing Item
                         BPPE1-Totals Record for Period Values Control
                              BPVP1-Table Generated for View BPVP1
                         BPIG1-Budget Object Index (Overall Budget)
                         BPIJ1-Budget Object Index (Annual Budget)
                    COKA1-CO Object: Cost Element Control Data
                    COKP1-CO Object: Primary Planning Control Data
                         HEAD11-SAPscript: Text Header
                              LINE11-SAPscript: Text Lines
                         CKHS1-Header - Unit Costing (Control + Totals)
                              CKHT1-Texts for CKHS
                              HEAD12-SAPscript: Text Header
                                   LINE12-SAPscript: Text Lines
                              CKIS1-Individual calculation/verification item gen.
                                   CKIT1-Texts for CKIS
                              CKIP1-Periodic Values for Unit Costing Item
                    COSP1-CO Object: Cost Totals for External Postings
                         COVP11-CO object: Line items with doc. header (by period)
                              COEPD11-CO object: Unvaluated ln. item settlement w/status
                                   COEPBR11-CO Object: Valuated Line Item Settlement
                         COVJ11-CO object: Line items with doc header (by year)
                         COVO1-CO Object: Open Items for Line Items (w/o doc.Hdr)
                    COSPD1-CO object: External cost totals - calculated
                    COSPP-Transfer of Order in the COSP Table to the Project
                    COKS1-CO Object: Control Data for Secondary Planning
                         HEAD13-SAPscript: Text Header
                              LINE13-SAPscript: Text Lines
                    COSS1-CO Object: Cost Totals for Internal Postings
                         COVP12-CO object: Line items with doc. header (by period)
                              COEPD12-CO object: Unvaluated ln. item settlement w/status
                                   COEPBR12-CO Object: Valuated Line Item Settlement
                         COVJ12-CO object: Line items with doc header (by year)
                         COVO12-CO object: Fxd price agreement commitment ln items
                    COSSD1-CO object: Internal cost totals - calculated
                    COSSP-Transfer of the Order COSS Table to the Project
                    COKR1-CO Object: Control Data for Statistical Key Figs
                         HEAD14-SAPscript: Text Header
                              LINE14-SAPscript: Text Lines
                    COSR1-CO Object: Statistical Key Figure Totals
                         COVPR1-CO object: Stat. key figure line items by period
                         COVJR1-CO object: Line items stat. key figures (by year)
                    COSL1-CO Object: Activity Type Totals
                         COVPL1-CO object: Activity type line items by period
                         COVJL1-CO object: Line items for acty types (by year)
                    COSLD-CO object: Activity type sums - calculated
                    COSB1-CO Object: Total Variances/Results Analyses
                         COVPB1-CO object: Variance/accrual line items by period
                    COSBD1-CO object: Sums of variance/accrual - calculated
                    ANIA1-Depr. simulation for invest. projects
                         ANIB1-Invest. projects: Depr. simulation analysis report
                    ANLI1-Link table for capital investment measure -> AuC
                    FMSU1-FM totals records for financial data
                         COVFP1-CO object: Financial data line items with doc. hdr
                    TPI031-CO Objects: Date of Last Interest Run
               EKKO-Purchasing Document Header
                    EKPO-Purchasing Document Item
                         EKET-Scheduling Agreement Schedule Lines
                         EKKN-Account Assignment in Purchasing Document
                         EKBE-Purchasing Document History
               EBAN-Purchase requisition
                    EBKN-Purchase Requisition Account Assignment
               FPLA (FPLAPS)-Billing plan for PSP network plan
                    FPLT (FPLTPS)-Billing plan for PSP/network (dates)
               LIKP-SD Document: Delivery Header Data
                    LIPS-SD document: Delivery: Item data
               PSMERK-Characteristics for summarization wo.classificatn
               DRAD-Document-object link