SAP AUFK Order master data Table

Overview

AUFK is a standard SAP S/4HANA table that stores Order master data data. There are total 132 fields in the AUFK table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table AUFK belongs to Overhead Cost Orders (CO-OM-OPA) module and is located in the package Cost Accounting, Orders (KAUF).

In addition, following links provide an overview of foreign key relationships, if any, that link AUFK to other SAP tables and standard CDS views available based on AUFK table in S/4HANA 2020.

Foreign Key Relations
AUFK CDS Views

Techincal Settings of AUFK

Below are technical details of the table AUFK

Buffering not allowed
No buffering
Storage type is Column Store

List of AUFK Fields

The following table gives you an overview of the fields available in AUFK

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

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AUFK

Table Name	Field	Cardinality	Check Table
AUFK	ABGSL	C: CN	TKKAA
AUFK	ABKRS	1: CN	TKO08
AUFK	ABUKR	1: CN	T001
AUFK	AD01PROFNR	1: CN	AD01C_PROF
AUFK	AKSTL	1: CN	CSKS
AUFK	ANFAUFNR	1: CN	AUFK
AUFK	AUART	1: CN	T003O
AUFK	AUFK_STATUS	:	ACTCMB_TAB
AUFK	AWSLS	C: CN	TKV01
AUFK	BEMOT	:	TBMOT
AUFK	BUKRS	1: CN	T001
AUFK	CLAIM_CONTROL	:	WTYSCC_CLM_CONT
AUFK	CYCLE	1: CN	CSKS
AUFK	ESTNR	1: CN	TKO03
AUFK	ETYPE	C: CN	T8JG
AUFK	FERC_IND	:	FERC_C7
AUFK	FUNC_AREA	:	TFKB
AUFK	GSBER	1: CN	TGSB
AUFK	IVPRO	C: CN	TAPRF
AUFK	IZWEK	1: CN	T087I
AUFK	JV_JIBCL	C: CN	T8J6A
AUFK	JV_JIBSA	C: CN	T8J6C
AUFK	KALSM	1: CN	T683
AUFK	KAPPL	1: CN	T681A
AUFK	KOKRS	1: CN	TKA01
AUFK	KOSTL	1: CN	CSKS
AUFK	KOSTV	1: CN	CSKS
AUFK	KSTAR	1: CN	CSKB
AUFK	KVEWE	1: CN	T681V
AUFK	LOGSYSTEM	1: CN	TBDLS
AUFK	MANDT	1: CN	T000
AUFK	OBJNR	1: 1	ONR00
AUFK	PRCTR	1: CN	CEPC
AUFK	PSPEL	C: CN	PRPS
AUFK	RECID	C: CN	T8JJ
AUFK	REFNR	1: CN	AUFK
AUFK	SAKNR	1: CN	SKB1
AUFK	SIZECL	1: CN	TAIF5
AUFK	SOWRK	1: CN	T001W
AUFK	STORT	1: CN	T499S
AUFK	TXJCD	:	TTXJ
AUFK	UMWKZ	1: CN	T087K
AUFK	UPDATE_CONTROL	:	WTYSCC_UPDT_CONT
AUFK	VERAA_USER	:	USR02
AUFK	VNAME	C: CN	T8JV
AUFK	VOGRP	1: CN	TKAVG
AUFK	WAERS	1: CN	TCURC
AUFK	WERKS	1: CN	T001W
AUFK	ZSCHM	C: CN	TPI01

SAP AUFK Order master data Table

Overview

Techincal Settings of AUFK

List of AUFK Fields

Foreign Key Relationships

Other References