AUFK - Order master data

Order master data information is stored in SAP table AUFK.
It is part of development package KAUF in software component CO-OM-OPA. This development package consists of objects that can be grouped under "Cost Accounting, Orders".

Fields for table AUFK

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
AUFNR	Order Number	X	AUFNR	CHAR	24
AUART	Order Type		AUFART	CHAR	8	T003O
AUTYP	Order category		AUFTYP	NUMC	4
REFNR	Reference Order Number		AUFREFNR	CHAR	24	AUFK
ERNAM	Entered By		AUFERFNAM	CHAR	24
ERDAT	Created On		AUFERFDAT	DATS	16
AENAM	Last Changed By		AUFAENAM	CHAR	24
AEDAT	Change Date for Order Master		AUFAEDAT	DATS	16
KTEXT	Description		AUFTEXT	CHAR	80
LTEXT	Long Text Exists		AUFLTEXT	CHAR	2
BUKRS	Company Code		BUKRS	CHAR	8	T001
WERKS	Plant		WERKS_D	CHAR	8	T001W
GSBER	Business Area		GSBER	CHAR	8	TGSB
KOKRS	Controlling Area		KOKRS	CHAR	8	TKA01
CCKEY	Cost Collector Key		CCKEY	CHAR	46
KOSTV	Responsible cost center		AUFKOSTV	CHAR	20	CSKS
STORT	Location		AUFSTORT	CHAR	20	T499S
SOWRK	Location Plant		AUFSOWRK	CHAR	8	T001W
ASTKZ	Identifier for Statistical Order		AUFSTKZ	CHAR	2
WAERS	Order Currency		AUFWAERS	CUKY	10	TCURC
ASTNR	Order Status		AUFASTNR	NUMC	4
STDAT	Date of Last Status Change		AUFSTDAT	DATS	16
ESTNR	Status Reached so Far		AUFESTNR	NUMC	4	TKO03
PHAS0	Phase "Order Created"		AUFPHAS0	CHAR	2
PHAS1	Phase "Order Released"		AUFPHAS1	CHAR	2
PHAS2	Phase "Order Completed"		AUFPHAS2	CHAR	2
PHAS3	Phase "Order Closed"		AUFPHAS3	CHAR	2
PDAT1	Planned release date		AUFPDAT1	DATS	16
PDAT2	Planned completion date		AUFPDAT2	DATS	16
PDAT3	Planned closing date		AUFPDAT3	DATS	16
IDAT1	Release Date		AUFIDAT1	DATS	16
IDAT2	Technical Completion Date		AUFIDAT2	DATS	16
IDAT3	Close Date		AUFIDAT3	DATS	16
OBJID	Object ID		CCOBJID	CHAR	2
VOGRP	Group of Disallowed Transactions		AUFSPSET	CHAR	8	TKAVG
LOEKZ	Deletion Flag		AUFLOEKZ	CHAR	2
PLGKZ	Identifier for Planning with Line Items		PLGKZ	CHAR	2
KVEWE	Usage of the condition table		KVEWE	CHAR	2	T681V
KAPPL	Application		KAPPL	CHAR	4	T681A
KALSM	Costing Sheet		AUFKALSM	CHAR	12	T683
ABKRS	Processing group		AUFABKRS	NUMC	4	TKO08
KSTAR	Settlement Cost Element		AUFKSTAR	CHAR	20	CSKB
KOSTL	Cost Center for Basic Settlement		AUFKOSTL	CHAR	20	CSKS
SAKNR	G/L Account for Basic Settlement		AUFSAKNR	CHAR	20	SKB1
SETNM	Allocation Set		AUFSETNM	CHAR	24
CYCLE	Cost center to which costs are actually posted		ST_KOSTL	CHAR	20	CSKS
SDATE	Start Date		SDATE	DATS	16
SEQNR	Sequence Number		AUFSEQNR	NUMC	8
USER0	Applicant		AUFUSER0	CHAR	40
USER1	Applicant's telephone number		AUFUSER1	CHAR	40
USER2	Person Responsible		AUFUSER2	CHAR	40
USER3	Telephone number of person in charge		AUFUSER3	CHAR	40
USER4	Estimated total costs of order		AUFUSER4	CURR	6
USER5	Application date		AUFUSER5	DATS	16
USER6	Department		AUFUSER6	CHAR	30
USER7	Work Start		AUFUSER7	DATS	16
USER8	End of Work		AUFUSER8	DATS	16
USER9	Identifier for work permit issued		AUFUSER9	CHAR	2
OBJNR	Object number		J_OBJNR	CHAR	44	ONR00
PRCTR	Profit Center		PRCTR	CHAR	20	CEPC
PSPEL	Work breakdown structure element (WBS element)		PS_PSP_ELE	NUMC	16	PRPS
AWSLS	Variance Key		AWSLS	CHAR	12	TKV01
ABGSL	Results Analysis Key		ABGR_SCHL	CHAR	12	TKKAA
EB_POST	Event-Based Posting		FCO_EB_POST	CHAR	2
TXJCD	Tax Jurisdiction		TXJCD	CHAR	30	TTXJ
FUNC_AREA	Functional Area		FKBER	CHAR	32	TFKB
SCOPE	Object Class		SCOPE_CV	CHAR	4
PLINT	Indicator for Integrated Planning		PLINT	CHAR	2
KDAUF	Sales Order Number		KDAUF	CHAR	20
KDPOS	Item number in Sales Order		KDPOS	NUMC	12
AUFEX	External order number		AUFEX	CHAR	40
IVPRO	Investment Measure Profile		IM_PROFIL	CHAR	12	TAPRF
LOGSYSTEM	Logical System		LOGSYSTEM	CHAR	20	TBDLS
FLG_MLTPS	Order Has Multiple Items		CO_MLTPS	CHAR	2
ABUKR	Requesting company code		IM_ABUKRS	CHAR	8	T001
AKSTL	Requesting cost center		PS_AKSTL	CHAR	20	CSKS
SIZECL	Scale of investment objects		IM_SIZECL	CHAR	4	TAIF5
IZWEK	Reason for Investment		IZWEK	CHAR	4	T087I
UMWKZ	Reason for Environmental Investment		AM_UMWKZ	CHAR	10	T087K
KSTEMPF	Indicator: Direct cost collector		CO_KSTEMPF	CHAR	2
PKOSA	Cost Collector for Production Process		PKOSA_D	CHAR	24
ANFAUFNR	Requesting order		AUFANFNR	CHAR	24	AUFK
PROCNR	Production Process		CKML_F_PROCNR	NUMC	24
PROTY	Process Category (Procurement/Consumption)		CKML_PROZESS_TYP	CHAR	8
RSORD	Refurbishment order indicator (PM)		RSORD	CHAR	2
BEMOT	Accounting Indicator		BEMOT	CHAR	4	TBMOT
ADRNRA	Address Number		AD_ADDRNUM	CHAR	20
ERFZEIT	Time created		CO_INS_TIME	TIMS	12
AEZEIT	Changed At		CO_CHG_TIME	TIMS	12
CSTG_VRNT	Costing Variant		CK_KLVAR	CHAR	8
COSTESTNR	Cost Estimate Number for Cost Est. w/o Qty Structure		CK_KALNR	NUMC	24
VERAA_USER	Person Responsible for CO Internal Order		VERAA_USER	CHAR	24	USR02
.INCLUDE	INCL_EEW_AUFK_PS			INCL_EEW_AUFK_PS	0
.INCLUDE				CI_AUFK	0
.INCLU--AP				/PPA/S_CI_AUFK_APPEND	0
/PPA/PERNR	Personnel number project manager		/PPA/T_PERPL	NUMC	16	*
/PPA/PERSV	Personnel number deputy		/PPA/T_PERSV	NUMC	16	*
/PPA/BEIBL	Performance record		/PPA/S_BEIBL	CHAR	2
.INCLUDE				/PPA/CPFSG_MERK_KOPF	0
/PPA/PORTFOLIO	Portfolio 1		/PPA/CPFSG_PORTF	CHAR	32
/PPA/PORTFOLIO2	Portfolio 2		/PPA/CPFSG_PORTF2	CHAR	32
/PPA/KLASSE	Risk class		/PPA/CPFSG_KLASSE	CHAR	2
/PPA/PRIORI	Priority		/PPA/CPFSG_PRIORI	CHAR	2
/PPA/PRODKZ	Productivity indicator		/PPA/CPFSG_PRODKZ	CHAR	2
.INCLUDE				/PPA/CPFSG_MERK_POS_AUFK	0
/PPA/ABEGD	Start for ProServ Orders		/PPA/S_STTER	DATS	16
/PPA/AENDD	End date for ProServ Orders		/PPA/S_EDTER	DATS	16
/PPA/PROGENDE	ProServ: forecast date of completion		/PPA/CPFSG_PRENDTER	DATS	16
/PPA/FSGREL	ProServ Project DOC modus		/PPA/CPFSG_REL	CHAR	2
EEW_AUFK_PS_DUMMY	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				GJV_DATA_4	0
.INCLUDE				GJV_DATA_1	0
.INCLUDE				GJV_DATA_0	0
VNAME	Joint venture		JV_NAME	CHAR	12	T8JV
RECID	Recovery Indicator		JV_RECIND	CHAR	4	T8JJ
ETYPE	Equity type		JV_ETYPE	CHAR	6	T8JG
OTYPE	Joint Venture Object Type		JV_OTYPE	CHAR	8
JV_JIBCL	JIB/JIBE Class		JV_JIBCL	CHAR	6	T8J6A
JV_JIBSA	JIB/JIBE Subclass A		JV_JIBSA	CHAR	10	T8J6C
JV_OCO	JV original cost object		JV_OR_CO	CHAR	2
.INCLU--AP				/CPD/PFP_AUFK_TIMESTMP	0
CPD_UPDAT	Time Stamp		/CPD/PFP_SC_TSTMP	DEC	8
.INCLU--AP				/CUM/APP_AUFK	0
/CUM/INDCU	CU: Order is Used for Compatible Units		/CUM/INDCU	CHAR	2
/CUM/CMNUM	CU: Construction Measure Number		/CUM/CMNUM	CHAR	24
/CUM/AUEST	CU: Automatic Copy of Estimated Costs		/CUM/AUEST	CHAR	2
/CUM/DESNUM	CU: Design Number		/CUM/DESNUM	CHAR	24	*
.INCLU--AP				AD01AUFK	0
AD01PROFNR	Dynamic Item Processor Profile		AD01PROFNR	CHAR	16	AD01C_PROF
.INCLU--AP				AD02AUFK	0
VAPLZ	Main work center for maintenance tasks		GEWRK	CHAR	16
WAWRK	Plant associated with main work center		WERGW	CHAR	8	*
.INCLU--AP				FERC_AUFK	0
FERC_IND	Regulatory indicator		FE_IND	CHAR	8	FERC_C7
.INCLU--AP				NTW_STATUS	0
AUFK_STATUS	Status Combination		ACTCMB_DELE	INT1	1	ACTCMB_TAB
.INCLU--AP				WTYSC_HEAD_INDICATOR_AUFK_AS	0
.INCLUDE				WTYSC_S_CLAIM_CONTR_INDICATOR	0
CLAIM_CONTROL	Claim creation control indicator		WTYSC_CLAIM_CONTROL	CHAR	2	WTYSCC_CLM_CONT
.INCLUDE				WTYSC_S_CLAIM_UPDATE_INDICATOR	0
UPDATE_NEEDED	Claim inconsistency with order indicator		WTYSC_UPDATE_NEEDED	CHAR	2
.INCLUDE				WTYSC_S_CLAIM_UPDATE_CONTROL	0
UPDATE_CONTROL	Claim update trigger point from service order		WTYSC_UPDATE_CONTROL	CHAR	2	WTYSCC_UPDT_CONT