SAP ABAP Table AUFKR (Order Master Data Structure for Project Reporting)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-IS (Application Component) Information System
     ⤷ CNIS (Package) Application development R/3 PS information system

Basic Data

Table Category	INTTAB	Structure
Structure	AUFKR	Table Relationship Diagram
Short Description	Order Master Data Structure for Project Reporting

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ARNUMMER	☐	ADMI_RUN_D	ADMI_RUN	CHAR	6	0	Archiving Session Number
2	VSGRUPPE	☐	VSGRUPPE	TEXT20	CHAR	20	0	Group for a project version
3	VSNUMMER	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
4	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
5	PRNAM	☐	IM_PRNAM	IM_PRNAM	CHAR	8	0	Investment program name	IMTP
6	PRPOS	☐	IM_POSID	IM_POSID	CHAR	24	0	Identification for an investment program position
7	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
8	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
9	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
10	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
11	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
12	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
13	AUARTTXT	☐	AUART_BEZ	TEXT20	CHAR	20	0	Description of sales order type
14	AUTYPTXT	☐	AUTYPTEXT	TEXT40	CHAR	40	0	Display field for order category description
15	REFNR	☐	AUFREFNR	AUFNR	CHAR	12	0	Reference order number	AUFK
16	KTEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
17	TXTKZ	☐	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
18	LTEXT	☐	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
19	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
20	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
21	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
22	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
23	KOSTV	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	CSKS
24	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
25	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
26	ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
27	USER0	☐	AUFUSER0	AUFUSER0	CHAR	20	0	Applicant
28	USER1	☐	AUFUSER1	AUFUSER1	CHAR	20	0	Applicant's telephone number
29	USER2	☐	AUFUSER2	AUFUSER2	CHAR	20	0	Person Responsible
30	USER3	☐	AUFUSER3	AUFUSER3	CHAR	20	0	Telephone number of person in charge
31	USER4	☐	AUFUSER4	AUFUSER4	CURR	11	2	Estimated total costs of order
32	USER5	☐	AUFUSER5	AUFUSER5	DATS	8	0	Application date
33	USER6	☐	AUFUSER6	AUFUSER6	CHAR	15	0	Department
34	USER7	☐	AUFUSER7	AUFUSER7	DATS	8	0	Work Start
35	USER8	☐	AUFUSER8	AUFUSER8	DATS	8	0	End of Work
36	USER9	☐	AUFUSER9	AUFUSER9	CHAR	1	0	Identifier for work permit issued
37	AWSLS	☐	AWSLS	AWSLS	CHAR	6	0	Variance Key	TKV01
38	ABGSL	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
39	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
40	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
41	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
42	AUFEX	☐	AUFEX	AUFEX	CHAR	20	0	External order number
43	FLG_MLTPS	☐	CO_MLTPS	KREUZ	CHAR	1	0	Order with multiple items
44	AKSTL	☐	PS_AKSTL	KOSTL	CHAR	10	0	Requesting cost center	CSKS
45	GLTRP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
46	GSTRP	☐	CO_GSTRP	DATUM	DATS	8	0	Basic start date
47	FTRMS	☐	CO_FTRMS	DATUM	DATS	8	0	Scheduled release date
48	GLTRS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
49	GSTRS	☐	CO_GSTRS	DATUM	DATS	8	0	Scheduled start
50	GSTRI	☐	CO_GSTRI	DATUM	DATS	8	0	Actual start date
51	GETRI	☐	CO_GETRI	DATUM	DATS	8	0	Confirmed Order Finish Date
52	GLTRI	☐	CO_GLTRI	DATUM	DATS	8	0	Actual finish date
53	FTRMI	☐	CO_FTRMI	DATUM	DATS	8	0	Actual release date
54	FTRMP	☐	CO_FTRMP	DATUM	DATS	8	0	Planned release date
55	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	RESB
56	GASMG	☐	GASMG	MENG13	QUAN	13	3	Total scrap quantity in the order
57	GAMNG	☐	GAMNG	MENG13	QUAN	13	3	Total order quantity
58	GMEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
59	PLNBEZ	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
60	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
61	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
62	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
63	PLSVB	☐	LOSGRBIS	MENG13	QUAN	13	3	To lot size
64	PLNME	☐	PLNME	MEINS	UNIT	3	0	Task list unit of measure	T006
65	PLSVN	☐	LOSGRVON	MENG13	QUAN	13	3	From Lot Size
66	PDATV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
67	PAENR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
68	PLGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	T024A
69	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
70	STLBEZ	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
71	STLST	☐	STLST	STLST	NUMC	2	0	BOM Statuses	T415S
72	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
73	SDATV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
74	SBMNG	☐	BASMN	MENG13	QUAN	13	3	Base quantity
75	SBMEH	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
76	SAENR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
77	STLAL	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
78	STLAN	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	T416
79	SLSVN	☐	LOSVN	MENG13	QUAN	13	3	From Lot Size
80	SLSBS	☐	LOSBS	MENG13	QUAN	13	3	To Lot Size
81	AUFLD	☐	CO_AUFLD	DATUM	DATS	8	0	Date of BOM Explosion/Routing Transfer
82	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	T024D
83	DSNAM	☐	DSNAM	TEXT18	CHAR	18	0	Name of MRP controller
84	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	T024F
85	FHORI	☐	FHORI	FHORI	CHAR	3	0	Scheduling Margin Key for Floats	T436A
86	TERKZ	☐	TERMKZ	TERART	CHAR	1	0	Scheduling type	T482
87	REDKZ	☐	REDKZ	REDKZ	CHAR	1	0	Reduction indicator for scheduling
88	APRIO	☐	CO_APRIO	CHAR1	CHAR	1	0	Order priority
89	VORGZ	☐	VORGZ	NUM3	NUMC	3	0	Float before production (in days)
90	SICHZ	☐	SICHZ	NUM3	NUMC	3	0	Float after production (in days)
91	FREIZ	☐	FREIZ	NUM3	NUMC	3	0	Release period (in days)
92	KLVARP	☐	KALKVARPLN	KLVAR	CHAR	4	0	Costing variant for planned costs	TCK03
93	KLVARI	☐	KALKVARIST	KLVAR	CHAR	4	0	Costing variant for actual costs	TCK03
94	GLTPP	☐	CO_GLTPP	DATUM	DATS	8	0	Finish date (forecast)
95	GSTPP	☐	CO_GSTPP	DATUM	DATS	8	0	Forecast start date
96	GLTPS	☐	CO_GLTPS	DATUM	DATS	8	0	Scheduled forecast finish
97	GSTPS	☐	CO_GSTPS	DATUM	DATS	8	0	Scheduled forecast start
98	FTRPS	☐	CO_FTRPS	DATUM	DATS	8	0	Scheduled release date (forecast)
99	RDKZP	☐	REDKZP	REDKZ	CHAR	1	0	Reduction indicator for scheduling (forecast)
100	TRKZP	☐	TERMKZP	TERART	CHAR	1	0	Scheduling type (forecast)	T482
101	GLUZS	☐	CO_GLUZS	UHRZT	TIMS	6	0	Scheduled finish time
102	GSUZS	☐	CO_GSUZS	ATIME	TIMS	6	0	Scheduled Start (Time)
103	AUTERM	☐	CO_AUTERM	KREUZ	CHAR	1	0	Indicator: Schedule automatically
104	AUCOST	☐	CO_AUCOST	KREUZ	CHAR	1	0	Indicator: Cost automatically
105	AUDISP	☐	AUDISP	XFELD	CHAR	1	0	Ind: Reservation applicable to MRP;Purc. req. is created
106	STUFE	☐	HISTU	DEC2	DEC	2	0	Level (in Multi-Level BOM Explosions)
107	WEGXX	☐	WEGXX	DEC4	DEC	4	0	Path (for Multi-Level BOM Explosions)
108	VWEGX	☐	WEGXX	DEC4	DEC	4	0	Path (for Multi-Level BOM Explosions)
109	MAUFNR	☐	MAUFNR	AUFNR	CHAR	12	0	Number of superior order	AUFK
110	PRODNET	☐	CO_PRODNET	KREUZ	CHAR	1	0	Indicator: Order is part of collective order
111	IASMG	☐	CO_IASMG	MENG13	QUAN	13	3	Scrap confirmed for order
112	ABARB	☐	CO_ABARB	CO_ABARB	NUMC	3	0	Confirmation: Degree of processing
113	AUFNT	☐	CO_TEILNET	AUFNR	CHAR	12	0	Number of superior network	AUFK
114	VORNT	☐	CN_VORNRT	VORNR	CHAR	4	0	Activity number replaced by sub-network
115	BREAKS	☐	BREAKS	XFELD	CHAR	1	0	Indicator: Scheduling allowing for breaks
116	VORGZ_TRM	☐	VORGZ_TRM	PUFFER_TRM	DEC	6	3	Scheduled float before production in days
117	SICHZ_TRM	☐	SICHZ_TRM	PUFFER_TRM	DEC	6	3	Scheduled float after production in days
118	TRMDT	☐	TRMDT	DATUM	DATS	8	0	Date of the last scheduling
119	GLUZP	☐	CO_GLUZP	UHRZT	TIMS	6	0	Basic finish (time)
120	GSUZP	☐	CO_GSUZP	UHRZT	TIMS	6	0	Basic start time
121	GSUZI	☐	CO_GSUZI	UHRZT	TIMS	6	0	Actual start time
122	GEUZI	☐	CO_GEUZI	UHRZT	TIMS	6	0	Confirmed order finish (time)
123	GLUPP	☐	CO_GLUPP	UHRZT	TIMS	6	0	Forecast finish (time)
124	GSUPP	☐	CO_GSUPP	UHRZT	TIMS	6	0	Forecast start (time)
125	GLUPS	☐	CO_GLUPS	UHRZT	TIMS	6	0	Scheduled forecast finish time
126	GSUPS	☐	CO_GSUPS	UHRZT	TIMS	6	0	Scheduled start time (Forecast)
127	CHSCH	☐	KALSMA_CH	KALSM	CHAR	6	0	Search procedure for batch determination	T683
128	KAPT_VORGZ	☐	KAPT_VORGZ	NUM3	NUMC	3	0	Float (bef. production) remaining after finite scheduling
129	KAPT_SICHZ	☐	KAPT_SICHZ	NUM3	NUMC	3	0	Remaining float after finite scheduling
130	LEAD_AUFNR	☐	CO_LAUFNR	AUFNR	CHAR	12	0	Leading order in current processing	AUFK
131	PNETSTARTD	☐	CO_PSTARTD	DATUM	DATS	8	0	Outline start of collective network (date)
132	PNETSTARTT	☐	CO_PSTARTT	ATIME	TIMS	6	0	Start time of a collective order
133	PNETENDD	☐	CO_PENDD	DATUM	DATS	8	0	Outline finish of collective order (date)
134	PNETENDT	☐	CO_PENDT	ATIME	TIMS	6	0	Outline finish time
135	AUKBED	☐	AUKBED	XFELD	CHAR	1	0	Indicator: Calculate capacity requirements
136	STRMP	☐	CO_STRMP	DATUM	DATS	8	0	Start date of the planned order
137	ETRMP	☐	CO_ETRMP	DATUM	DATS	8	0	Opening date of the planned order
138	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
139	WEMNG	☐	CO_WEMNG	MENG13	QUAN	13	3	Quantity of goods received for the order item
140	IAMNG	☐	CO_IAMNG	MENG13V	QUAN	13	3	Expected surplus/deficit for goods receipt
141	AMEIN	☐	CO_AUFME	MEINS	UNIT	3	0	Unit of measure for in-house production	T006
142	MEINS	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
143	MATNR	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
144	MTEXT	☐	PS_MATTEXT	TEXT40	CHAR	40	0	Material description
145	PAMNG	☐	AVMNG	MENG13	QUAN	13	3	Fixed quantity of scrap from production
146	PGMNG	☐	GSMNG	MENG13	QUAN	13	3	Total planned order quantity
147	LTRMI	☐	CO_LTRMI	DATUM	DATS	8	0	Actual delivery/finish date
148	LTRMP	☐	CO_LTRMP	DATUM	DATS	8	0	Delivery date from planned order
149	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	CKHS
150	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
151	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
152	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
153	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
154	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
155	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
156	PWERK	☐	CO_PWERK	WERKS	CHAR	4	0	Planning plant for the order	T001W
157	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
158	VERTO	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key	T437V
159	WEBAZ	☐	PLWEZ	DEC3	DEC	3	0	Goods receipt processing time in days
160	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
161	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
162	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
163	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
164	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
165	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
166	STATXT	☐	STATUSTEXT_2	CHAR80	CHAR	80	0	Edited status text
167	FRUEHER	☐	FRUEHER_2	DAUER_9_1	QUAN	10	1	Actual start is before earliest scheduled start
168	SPAETER	☐	SPAETER_2	DAUER_9_1	QUAN	10	1	Actual Finish/Planned Finish After Latest Scheduled Finish
169	VERZUG	☐	VERZUG_2	DAUER_9_1	QUAN	10	1	Duration After Latest Scheduled Finish
170	VORBEI	☐	VORBEI_2	DAUER_9_1	QUAN	10	1	Duration After Earliest Scheduled Start
171	VEINH	☐	VERZ_EINHT	MEINS	UNIT	3	0	Unit for Duration of the Delay	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AUFKR	ABGSL	TKKAA	ABGSL	REF	C	CN
2	AUFKR	AENNR	AENR	AENNR
3	AUFKR	AKSTL	CSKS	KOSTL	REF	C	CN
4	AUFKR	AMEIN	T006	MSEHI	REF	C	CN
5	AUFKR	AUART	T003O	AUART	REF	1	CN
6	AUFKR	AUFNT	AUFK	AUFNR	REF	C	CN
7	AUFKR	AWSLS	TKV01	AWSLS	REF	C	CN
8	AUFKR	BUKRS	T001	BUKRS	REF	1	CN
9	AUFKR	BWTAR	T149D	BWTAR	REF	C	CN
10	AUFKR	CHARG	MCHA	CHARG	REF	C	CN
11	AUFKR	CHSCH	T683	KALSM	REF	C	CN
12	AUFKR	DISPO	T024D	DISPO	REF	C	CN
13	AUFKR	FEVOR	T024F	FEVOR	REF	C	CN
14	AUFKR	FHORI	T436A	FHORI	REF	C	CN
15	AUFKR	GMEIN	T006	MSEHI	REF	C	CN
16	AUFKR	GSBER	TGSB	GSBER	REF	C	CN
17	AUFKR	KALNR	CKHS	KALNR	REF	C	CN
18	AUFKR	KALSM	T683	KALSM	REF	1	CN
19	AUFKR	KDAUF	VBUK	VBELN
20	AUFKR	KDPOS	VBUP	POSNR	REF	C	CN
21	AUFKR	KLVARI	TCK03	KLVAR	REF	C	CN
22	AUFKR	KLVARP	TCK03	KLVAR	REF	C	CN
23	AUFKR	KOKRS	TKA01	KOKRS	REF	C	CN
24	AUFKR	KOSTV	CSKS	KOSTL	REF	C	CN
25	AUFKR	LEAD_AUFNR	AUFK	AUFNR	REF	C	CN
26	AUFKR	LGORT	T001L	LGORT	REF	C	CN
27	AUFKR	MATNR	MARA	MATNR	REF	C	CN
28	AUFKR	MAUFNR	AUFK	AUFNR	REF	C	CN
29	AUFKR	MEINS	T006	MSEHI	REF	C	CN
30	AUFKR	PAENR	AENR	AENNR	REF	C	CN
31	AUFKR	PLGRP	T024A	FEVOR	REF	C	CN
32	AUFKR	PLNBEZ	MARA	MATNR	REF	C	CN
33	AUFKR	PLNME	T006	MSEHI	REF	C	CN
34	AUFKR	PLNTY	TCA01	PLNTY	REF	1	CN
35	AUFKR	PRCTR	CEPC	PRCTR	REF	C	CN
36	AUFKR	PRNAM	IMTP	PRNAM			CN
37	AUFKR	PWERK	T001W	WERKS	REF	C	CN
38	AUFKR	REFNR	AUFK	AUFNR	REF	C	CN
39	AUFKR	RSNUM	RESB	RSNUM	REF	C	CN
40	AUFKR	SAENR	AENR	AENNR	REF	C	CN
41	AUFKR	SBMEH	T006	MSEHI	REF	C	CN
42	AUFKR	SERNR	SNUM	SERNR	REF	C	CN
43	AUFKR	STLAN	T416	STLAN	REF	C	CN
44	AUFKR	STLBEZ	MARA	MATNR	REF	C	CN
45	AUFKR	STLST	T415S	STLST	REF	C	CN
46	AUFKR	TERKZ	T482	TERMKZ	REF	C	CN
47	AUFKR	TRKZP	T482	TERMKZ	REF	C	CN
48	AUFKR	TXJCD	TTXJ	TXJCD	REF	C	CN
49	AUFKR	VEINH	T006	MSEHI	REF	C	CN
50	AUFKR	VERTO	T437V	VERTL	REF	C	CN
51	AUFKR	WAERS	TCURC	WAERS	REF	1	CN
52	AUFKR	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in