SAP table AUFK_UPDATE_RELEVANT (Fields that are relevant for update from AUFK (sim. vers.))

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
AUART Order Type CHAR 4 0 T003O AUFART
AUTYP Order category NUMC 2 0 AUFTYP
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
99 Master Planned order
KTEXT Description CHAR 40 0 AUFTEXT
LTEXT Long Text Exists CHAR 1 0 AUFLTEXT
BUKRS Company Code CHAR 4 0 T001 BUKRS
WERKS Plant CHAR 4 0 T001W WERKS_D
GSBER Business Area CHAR 4 0 TGSB GSBER
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
CCKEY Cost Collector Key CHAR 23 0 CCKEY
KOSTV Responsible cost center CHAR 10 0 CSKS AUFKOSTV
STORT Location CHAR 10 0 T499S AUFSTORT
SOWRK Location Plant CHAR 4 0 T001W AUFSOWRK
ASTKZ Identifier for Statistical Order CHAR 1 0 AUFSTKZ
WAERS Order Currency CUKY 5 0 TCURC AUFWAERS
ASTNR Order Status NUMC 2 0 TKO03 AUFASTNR
STDAT Date of Last Status Change DATS 8 0 AUFSTDAT
ESTNR Status Reached so Far NUMC 2 0 TKO03 AUFESTNR
PHAS0 Phase "Order Created" CHAR 1 0 AUFPHAS0
PHAS1 Phase "Order Released" CHAR 1 0 AUFPHAS1
PHAS2 Phase "Order Completed" CHAR 1 0 AUFPHAS2
PHAS3 Phase "Order Closed" CHAR 1 0 AUFPHAS3
PDAT1 Planned release date DATS 8 0 AUFPDAT1
PDAT2 Planned completion date DATS 8 0 AUFPDAT2
PDAT3 Planned closing date DATS 8 0 AUFPDAT3
IDAT1 Release Date DATS 8 0 AUFIDAT1
IDAT2 Technical Completion Date DATS 8 0 AUFIDAT2
IDAT3 Close Date DATS 8 0 AUFIDAT3
OBJID Object ID CHAR 1 0 CCOBJID
VOGRP Group of Disallowed Transactions CHAR 4 0 TKAVG AUFSPSET
LOEKZ Deletion Flag CHAR 1 0 AUFLOEKZ
PLGKZ Identifier for Planning with Line Items CHAR 1 0 PLGKZ
KVEWE Usage of the condition table CHAR 1 0 T681V KVEWE
KAPPL Application CHAR 2 0 T681A KAPPL
KALSM Costing Sheet CHAR 6 0 T683 AUFKALSM
ZSCHL Overhead key CHAR 6 0 AUFZSCHL
ABKRS Processing group NUMC 2 0 TKO08 AUFABKRS
KSTAR Settlement Cost Element CHAR 10 0 CSKB AUFKSTAR
KOSTL Cost Center for Basic Settlement CHAR 10 0 CSKS AUFKOSTL
SAKNR G/L Account for Basic Settlement CHAR 10 0 SKB1 AUFSAKNR
SETNM Allocation Set CHAR 12 0 AUFSETNM
CYCLE Cost center to which costs are actually posted CHAR 10 0 ST_KOSTL
SDATE Start Date DATS 8 0 SDATE
SEQNR Sequence Number NUMC 4 0 AUFSEQNR
USER0 Applicant CHAR 20 0 AUFUSER0
USER1 Applicant's telephone number CHAR 20 0 AUFUSER1
USER2 Person Responsible CHAR 20 0 AUFUSER2
USER3 Telephone number of person in charge CHAR 20 0 AUFUSER3
USER4 Estimated total costs of order CURR 11 2 AUFUSER4
USER5 Application date DATS 8 0 AUFUSER5
USER6 Department CHAR 15 0 AUFUSER6
USER7 Work Start DATS 8 0 AUFUSER7
USER8 End of Work DATS 8 0 AUFUSER8
USER9 Identifier for work permit issued CHAR 1 0 AUFUSER9
X Work permit issued
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
AWSLS Variance Key CHAR 6 0 TKV01 AWSLS
ABGSL Results Analysis Key CHAR 6 0 TKKAA ABGR_SCHL
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
SCOPE Object Class CHAR 2 0 SCOPE_CV
IV Investment
OC Overhead costs
PA Profit analysis
PR Production
PLINT Indicator for Integrated Planning CHAR 1 0 PLINT
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
AUFEX External order number CHAR 20 0 AUFEX
IVPRO Investment Measure Profile CHAR 6 0 TAPRF IM_PROFIL
LOGSYSTEM Logical System CHAR 10 0 TBDLS LOGSYSTEM
FLG_MLTPS Order Has Multiple Items CHAR 1 0 CO_MLTPS
ABUKR Requesting company code CHAR 4 0 T001 IM_ABUKRS
AKSTL Requesting cost center CHAR 10 0 CSKS PS_AKSTL
SIZECL Scale of investment objects CHAR 2 0 TAIF5 IM_SIZECL
IZWEK Reason for Investment CHAR 2 0 T087I IZWEK
UMWKZ Reason for Environmental Investment CHAR 5 0 T087K AM_UMWKZ
KSTEMPF Indicator: Direct cost collector CHAR 1 0 CO_KSTEMPF
E Sales order
K Cost center
P Project
ZSCHM Interest Profile for Project/Order Interest Calculation CHAR 7 0 TPI01 PS_ZSCHM
PKOSA Cost Collector for Production Process CHAR 12 0 PKOSA_D
RSORD Refurbishment order indicator (PM) CHAR 1 0 RSORD
BEMOT Accounting Indicator CHAR 2 0 TBMOT BEMOT
ADRNRA Address Number CHAR 10 0 AD_ADDRNUM
VNAME Joint venture CHAR 6 0 T8JV JV_NAME
RECID Recovery Indicator CHAR 2 0 T8JJ JV_RECIND
ETYPE Equity type CHAR 3 0 T8JG JV_ETYPE
OTYPE Joint Venture Object Type CHAR 4 0 JV_OTYPE
JV_JIBCL JIB/JIBE Class CHAR 3 0 T8J6A JV_JIBCL
JV_JIBSA JIB/JIBE Subclass A CHAR 5 0 T8J6C JV_JIBSA
JV_OCO JV original cost object CHAR 1 0 JV_OR_CO
CLAIM_CONTROL Claim creation control indicator CHAR 1 0 WTYSCC_CLM_CONT WTYSC_CLAIM_CONTROL
UPDATE_NEEDED Claim inconsistency with order indicator CHAR 1 0 WTYSC_UPDATE_NEEDED
X Update needed
UPDATE_CONTROL Claim update trigger point from service order CHAR 1 0 WTYSCC_UPDT_CONT WTYSC_UPDATE_CONTROL

AUFK_UPDATE_RELEVANT foreign key relationships

Table Field Check Table Check Field
0 AUFK_UPDATE_RELEVANT ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
0 AUFK_UPDATE_RELEVANT ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
1 AUFK_UPDATE_RELEVANT ABKRS TKO08 Processing groups for orders CLIENT
1 AUFK_UPDATE_RELEVANT ABKRS TKO08 Processing groups for orders KOKRS
1 AUFK_UPDATE_RELEVANT ABKRS TKO08 Processing groups for orders ABKRS
0 AUFK_UPDATE_RELEVANT ABUKR T001 Company Codes BUKRS
1 AUFK_UPDATE_RELEVANT AKSTL CSKS Cost Center Master Record MANDT
1 AUFK_UPDATE_RELEVANT AKSTL CSKS Cost Center Master Record KOKRS
1 AUFK_UPDATE_RELEVANT AKSTL CSKS Cost Center Master Record DATBI
0 AUFK_UPDATE_RELEVANT ASTNR TKO03 Order status CLIENT
0 AUFK_UPDATE_RELEVANT ASTNR TKO03 Order status ART
1 AUFK_UPDATE_RELEVANT AUART T003O Order Types AUART
0 AUFK_UPDATE_RELEVANT AWSLS TKV01 Variance Keys: Cost Centers/Costing MANDT
0 AUFK_UPDATE_RELEVANT AWSLS TKV01 Variance Keys: Cost Centers/Costing AWOBA
0 AUFK_UPDATE_RELEVANT AWSLS TKV01 Variance Keys: Cost Centers/Costing AWSLS
1 AUFK_UPDATE_RELEVANT BEMOT TBMOT Accounting indicators MANDT
1 AUFK_UPDATE_RELEVANT BEMOT TBMOT Accounting indicators BEMOT
0 AUFK_UPDATE_RELEVANT BUKRS T001 Company Codes BUKRS
1 AUFK_UPDATE_RELEVANT CLAIM_CONTROL WTYSCC_CLM_CONT Instance when the Claim can be created from the Order MANDT
1 AUFK_UPDATE_RELEVANT CLAIM_CONTROL WTYSCC_CLM_CONT Instance when the Claim can be created from the Order CLAIM_CONTROL
0 AUFK_UPDATE_RELEVANT ESTNR TKO03 Order status CLIENT
0 AUFK_UPDATE_RELEVANT ESTNR TKO03 Order status ART
1 AUFK_UPDATE_RELEVANT ETYPE T8JG Valid Investment Group MANDT
1 AUFK_UPDATE_RELEVANT ETYPE T8JG Valid Investment Group BUKRS
1 AUFK_UPDATE_RELEVANT ETYPE T8JG Valid Investment Group VNAME
1 AUFK_UPDATE_RELEVANT ETYPE T8JG Valid Investment Group FDATE
0 AUFK_UPDATE_RELEVANT GSBER TGSB Business Areas MANDT
0 AUFK_UPDATE_RELEVANT GSBER TGSB Business Areas GSBER
1 AUFK_UPDATE_RELEVANT IVPRO TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
1 AUFK_UPDATE_RELEVANT IVPRO TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
0 AUFK_UPDATE_RELEVANT IZWEK T087I Reason for investment MANDT
0 AUFK_UPDATE_RELEVANT IZWEK T087I Reason for investment IZWEK
1 AUFK_UPDATE_RELEVANT JV_JIBCL T8J6A JIB/JIBE Class MANDT
1 AUFK_UPDATE_RELEVANT JV_JIBCL T8J6A JIB/JIBE Class BUKRS
1 AUFK_UPDATE_RELEVANT JV_JIBCL T8J6A JIB/JIBE Class CLASS
0 AUFK_UPDATE_RELEVANT JV_JIBSA T8J6C JIB/JIBE Subclass MANDT
0 AUFK_UPDATE_RELEVANT JV_JIBSA T8J6C JIB/JIBE Subclass BUKRS
1 AUFK_UPDATE_RELEVANT KALSM T683 Pricing procedures KAPPL
1 AUFK_UPDATE_RELEVANT KALSM T683 Pricing procedures KALSM
0 AUFK_UPDATE_RELEVANT KAPPL T681A Conditions: Applications KAPPL
1 AUFK_UPDATE_RELEVANT KOKRS TKA01 Controlling Areas MANDT
0 AUFK_UPDATE_RELEVANT KOSTL CSKS Cost Center Master Record MANDT
0 AUFK_UPDATE_RELEVANT KOSTL CSKS Cost Center Master Record KOKRS
0 AUFK_UPDATE_RELEVANT KOSTL CSKS Cost Center Master Record KOSTL
0 AUFK_UPDATE_RELEVANT KOSTL CSKS Cost Center Master Record DATBI
1 AUFK_UPDATE_RELEVANT KOSTV CSKS Cost Center Master Record MANDT
1 AUFK_UPDATE_RELEVANT KOSTV CSKS Cost Center Master Record KOKRS
1 AUFK_UPDATE_RELEVANT KOSTV CSKS Cost Center Master Record DATBI
0 AUFK_UPDATE_RELEVANT KSTAR CSKB Cost Elements (Data Dependent on Controlling Area) MANDT
0 AUFK_UPDATE_RELEVANT KSTAR CSKB Cost Elements (Data Dependent on Controlling Area) KOKRS
0 AUFK_UPDATE_RELEVANT KSTAR CSKB Cost Elements (Data Dependent on Controlling Area) KSTAR
0 AUFK_UPDATE_RELEVANT KSTAR CSKB Cost Elements (Data Dependent on Controlling Area) DATBI
1 AUFK_UPDATE_RELEVANT KVEWE T681V Conditions: Usages KVEWE
0 AUFK_UPDATE_RELEVANT LOGSYSTEM TBDLS Logical system LOGSYS
1 AUFK_UPDATE_RELEVANT MANDT T000 Clients MANDT
0 AUFK_UPDATE_RELEVANT PRCTR CEPC Profit Center Master Data Table PRCTR
0 AUFK_UPDATE_RELEVANT PRCTR CEPC Profit Center Master Data Table DATBI
0 AUFK_UPDATE_RELEVANT PRCTR CEPC Profit Center Master Data Table KOKRS
1 AUFK_UPDATE_RELEVANT RECID T8JJ Recovery Indicator MANDT
1 AUFK_UPDATE_RELEVANT RECID T8JJ Recovery Indicator BUKRS
0 AUFK_UPDATE_RELEVANT SAKNR SKB1 G/L account master (company code) MANDT
0 AUFK_UPDATE_RELEVANT SAKNR SKB1 G/L account master (company code) BUKRS
1 AUFK_UPDATE_RELEVANT SIZECL TAIF5 Scale of investment objects MANDT
1 AUFK_UPDATE_RELEVANT SIZECL TAIF5 Scale of investment objects SIZECL
0 AUFK_UPDATE_RELEVANT SOWRK T001W Plants/Branches MANDT
0 AUFK_UPDATE_RELEVANT SOWRK T001W Plants/Branches WERKS
1 AUFK_UPDATE_RELEVANT STORT T499S Location MANDT
1 AUFK_UPDATE_RELEVANT STORT T499S Location WERKS
0 AUFK_UPDATE_RELEVANT TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 AUFK_UPDATE_RELEVANT TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
1 AUFK_UPDATE_RELEVANT UMWKZ T087K Reason for investment protecting the environment MANDT
0 AUFK_UPDATE_RELEVANT UPDATE_CONTROL WTYSCC_UPDT_CONT Update control points for claim update from service order MANDT
0 AUFK_UPDATE_RELEVANT UPDATE_CONTROL WTYSCC_UPDT_CONT Update control points for claim update from service order UPDATE_CONTROL
1 AUFK_UPDATE_RELEVANT VNAME T8JV Joint Venture MANDT
1 AUFK_UPDATE_RELEVANT VNAME T8JV Joint Venture BUKRS
1 AUFK_UPDATE_RELEVANT VNAME T8JV Joint Venture VNAME
0 AUFK_UPDATE_RELEVANT VOGRP TKAVG Transaction groups OBJID
0 AUFK_UPDATE_RELEVANT VOGRP TKAVG Transaction groups GRUPPE
0 AUFK_UPDATE_RELEVANT VOGRP TKAVG Transaction groups ACTIVITY
1 AUFK_UPDATE_RELEVANT WAERS TCURC Currency Codes MANDT
1 AUFK_UPDATE_RELEVANT WAERS TCURC Currency Codes WAERS
0 AUFK_UPDATE_RELEVANT WERKS T001W Plants/Branches MANDT
0 AUFK_UPDATE_RELEVANT WERKS T001W Plants/Branches WERKS
1 AUFK_UPDATE_RELEVANT ZSCHM TPI01 Interest Profile MANDT