SAP ABAP Table FCOMS_ORDER (Order (AUFK + Texts))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CO (Application Component) Controlling
     ⤷ FCOM_MASTERDATA_CORE (Package) Master data

Basic Data

Table Category	INTTAB	Structure
Structure	FCOMS_ORDER	Table Relationship Diagram
Short Description	Order (AUFK + Texts)

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	.INCLUDE	☐				0	0	Order master data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
4	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
5	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
6	REFNR	☐	AUFREFNR	AUFNR	CHAR	12	0	Reference order number	AUFK
7	ERNAM	☐	AUFERFNAM	USNAM	CHAR	12	0	Entered by
8	ERDAT	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
9	AENAM	☐	AUFAENAM	USNAM	CHAR	12	0	Last changed by
10	AEDAT	☐	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
11	KTEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
12	LTEXT	☐	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
13	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
14	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
15	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
16	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
17	CCKEY	☐	CCKEY	CCKEY	CHAR	23	0	Cost collector key
18	KOSTV	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	CSKS
19	STORT	☐	AUFSTORT	AP_STAND	CHAR	10	0	Location	T499S
20	SOWRK	☐	AUFSOWRK	WERKS	CHAR	4	0	Location plant	T001W
21	ASTKZ	☐	AUFSTKZ	XFELD	CHAR	1	0	Identifier for statistical order
22	WAERS	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	TCURC
23	ASTNR	☐	AUFASTNR	AUFSTNR	NUMC	2	0	Order status	*
24	STDAT	☐	AUFSTDAT	DATUM	DATS	8	0	Date of last status change
25	ESTNR	☐	AUFESTNR	AUFSTNR	NUMC	2	0	Status reached so far	TKO03
26	PHAS0	☐	AUFPHAS0	XFELD	CHAR	1	0	Phase "Order created"
27	PHAS1	☐	AUFPHAS1	XFELD	CHAR	1	0	Phase "Order released"
28	PHAS2	☐	AUFPHAS2	XFELD	CHAR	1	0	Phase "order completed"
29	PHAS3	☐	AUFPHAS3	XFELD	CHAR	1	0	Phase "order closed"
30	PDAT1	☐	AUFPDAT1	DATUM	DATS	8	0	Planned release date
31	PDAT2	☐	AUFPDAT2	DATUM	DATS	8	0	Planned completion date
32	PDAT3	☐	AUFPDAT3	DATUM	DATS	8	0	Planned closing date
33	IDAT1	☐	AUFIDAT1	DATUM	DATS	8	0	Release date
34	IDAT2	☐	AUFIDAT2	DATUM	DATS	8	0	Technical completion date
35	IDAT3	☐	AUFIDAT3	DATUM	DATS	8	0	Close date
36	OBJID	☐	CCOBJID	CHAR1	CHAR	1	0	Object ID
37	VOGRP	☐	AUFSPSET	VOGRP	CHAR	4	0	Group of disallowed transactions	TKAVG
38	LOEKZ	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
39	PLGKZ	☐	PLGKZ	XFELD	CHAR	1	0	Identifier for planning with line items
40	KVEWE	☐	KVEWE	KVEWE	CHAR	1	0	Usage of the Condition Table	T681V
41	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
42	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
43	ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
44	ABKRS	☐	AUFABKRS	AKREIS	NUMC	2	0	Processing group	TKO08
45	KSTAR	☐	AUFKSTAR	KSTAR	CHAR	10	0	Settlement cost element	CSKB
46	KOSTL	☐	AUFKOSTL	KOSTL	CHAR	10	0	Cost center for basic settlement	CSKS
47	SAKNR	☐	AUFSAKNR	SAKNR	CHAR	10	0	G/L account for basic settlement	SKB1
48	SETNM	☐	AUFSETNM	SETNR	CHAR	12	0	Allocation set
49	CYCLE	☐	ST_KOSTL	KOSTL	CHAR	10	0	Cost center to which costs are actually posted	CSKS
50	SDATE	☐	SDATE	SDATE	DATS	8	0	Start Date	*
51	SEQNR	☐	AUFSEQNR	SQNR	NUMC	4	0	Sequence number	*
52	USER0	☐	AUFUSER0	AUFUSER0	CHAR	20	0	Applicant
53	USER1	☐	AUFUSER1	AUFUSER1	CHAR	20	0	Applicant's telephone number
54	USER2	☐	AUFUSER2	AUFUSER2	CHAR	20	0	Person Responsible
55	USER3	☐	AUFUSER3	AUFUSER3	CHAR	20	0	Telephone number of person in charge
56	USER4	☐	AUFUSER4	AUFUSER4	CURR	11	2	Estimated total costs of order
57	USER5	☐	AUFUSER5	AUFUSER5	DATS	8	0	Application date
58	USER6	☐	AUFUSER6	AUFUSER6	CHAR	15	0	Department
59	USER7	☐	AUFUSER7	AUFUSER7	DATS	8	0	Work Start
60	USER8	☐	AUFUSER8	AUFUSER8	DATS	8	0	End of Work
61	USER9	☐	AUFUSER9	AUFUSER9	CHAR	1	0	Identifier for work permit issued
62	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
63	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
64	PSPEL	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
65	AWSLS	☐	AWSLS	AWSLS	CHAR	6	0	Variance Key	TKV01
66	ABGSL	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
67	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
68	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
69	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
70	PLINT	☐	PLINT	XFELD	CHAR	1	0	Indicator for Integrated Planning
71	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
72	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
73	AUFEX	☐	AUFEX	AUFEX	CHAR	20	0	External order number
74	IVPRO	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	TAPRF
75	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	TBDLS
76	FLG_MLTPS	☐	CO_MLTPS	KREUZ	CHAR	1	0	Order with multiple items
77	ABUKR	☐	IM_ABUKRS	BUKRS	CHAR	4	0	Requesting company code	T001
78	AKSTL	☐	PS_AKSTL	KOSTL	CHAR	10	0	Requesting cost center	CSKS
79	SIZECL	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
80	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
81	UMWKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
82	KSTEMPF	☐	CO_KSTEMPF	CO_KSTEMPF	CHAR	1	0	Indicator: Direct cost collector
83	ZSCHM	☐	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	TPI01
84	PKOSA	☐	PKOSA_D	AUFNR	CHAR	12	0	Cost collector for production process PROCNR	*
85	ANFAUFNR	☐	AUFANFNR	AUFNR	CHAR	12	0	Requesting order	AUFK
86	PROCNR	☐	CKML_F_PROCNR	CK_KALNR	NUMC	12	0	Production Process	*
87	PROTY	☐	CKML_PROZESS_TYP	CKML_PROZESS_TYP	CHAR	4	0	Process Category (Procurement/Consumption)	*
88	RSORD	☐	RSORD	XFELD	CHAR	1	0	Refurbishment order indicator (PM)
89	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
90	ADRNRA	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
91	ERFZEIT	☐	CO_INS_TIME	UZEIT	TIMS	6	0	Time created
92	AEZEIT	☐	CO_CHG_TIME	UZEIT	TIMS	6	0	Changed at
93	CSTG_VRNT	☐	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant	*
94	COSTESTNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
95	VERAA_USER	☐	VERAA_USER	XUBNAME	CHAR	12	0	Person Responsible for CO Internal Order	USR02
96	.INCLUDE	☐				0	0
97	.INCLUDE	☐				0	0	JV data: (gjv_data_1),jv_oco
98	.INCLUDE	☐				0	0	JV data: (vname,recid,etype),otype,jv_jibcl,jv_jibsa
99	.INCLUDE	☐				0	0	General assignments of application objects
100	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
101	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
102	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JG
103	OTYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
104	JV_JIBCL	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
105	JV_JIBSA	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
106	JV_OCO	☐	JV_OR_CO	JV_OR_COB	CHAR	1	0	JV original cost object
107	.INCLU--AP	☐				0	0	CU specific APPEND for order master data
108	/CUM/INDCU	☐	/CUM/INDCU	FLAG	CHAR	1	0	CU: Order is Used for Compatible Units
109	/CUM/CMNUM	☐	/CUM/CMNUM	/CUM/CMNUM	CHAR	12	0	CU: Construction Measure Number
110	/CUM/AUEST	☐	/CUM/AUEST	FLAG	CHAR	1	0	CU: Automatic Copy of Estimated Costs
111	/CUM/DESNUM	☐	/CUM/DESNUM	/CUM/DESNUM	CHAR	12	0	CU: Design Number	*
112	.INCLU--AP	☐				0	0	Work Center
113	VAPLZ	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
114	WAWRK	☐	WERGW	WERKS	CHAR	4	0	Plant associated with main work center	*
115	.INCLU--AP	☐				0	0	Append structure for Regulatory Reporting
116	FERC_IND	☐	FE_IND	FE_IND	CHAR	4	0	Regulatory indicator	FERC_C7
117	REFNR_TXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
118	AUART_TXT	☐	AUARTTEXT	TEXT40	CHAR	40	0	Short Text
119	BUKRS_TXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
120	GSBER_TXT	☐	GTEXT	TEXT30	CHAR	30	0	Business area description
121	WERKS_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
122	FUNC_AREA_TXT	☐	FKBTX	TEXT25	CHAR	25	0	Name of the functional area
123	PRCTR_TXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
124	KOSTV_TXT	☐	KLTXT	TEXT40	CHAR	40	0	Description
125	ORDER_GUID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
126	SCOPE_TXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
127	AKSTL_TXT	☐	KLTXT	TEXT40	CHAR	40	0	Description
128	VERAA_USER_TXT	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
129	ABUKR_TXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
130	PSPEL_TXT	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
131	ANFAUFNR_TXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
132	STORT_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
133	SOWRK_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
134	KDAUF_POS_TXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
135	TXJCD_TXT	☐	TEXT1_TXJT	TEXT50	CHAR	50	0	Description
136	WAERS_TXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
137	AUTYP_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
138	LOGSYSTEM_TXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
139	ABGSL_TXT	☐	KKATEXT	KKATEXT	CHAR	40	0	Character Field for Text Table
140	AWSLS_TXT	☐	AWTXT	TEXT40	CHAR	40	0	Name
141	ZSCHL_TXT	☐	BEZEI30	TEXT30	CHAR	30	0	Description
142	ZSCHM_TXT	☐	PS_ZSCHT	TXT50	CHAR	50	0	Name of Interest Calc.Profile
143	KALSM_TXT	☐	VTXTM	TEXT30	CHAR	30	0	Description
144	KSTAR_TXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
145	KOSTL_TXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
146	SAKNR_TXT	☐	TXT20_SKAT	TEXT20	CHAR	20	0	G/L account short text
147	ABKRS_TXT	☐	TEXT40T	TEXT40	CHAR	40	0	Text of length 40 with descriptive text
148	IVPRO_TXT	☐	IM_INVTXT	TEXT50	CHAR	50	0	Name of capital investment profile
149	SIZECL_TXT	☐	IMA_SZTXT	TEXT50	CHAR	50	0	Description of scale
150	IZWEK_TXT	☐	TXT50	TEXT50	CHAR	50	0	Text
151	UMWKZ_TXT	☐	TXT50	TEXT50	CHAR	50	0	Text
152	CYCLE_TXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
153	KOKRS_TXT	☐	BEZEI	TEXT25	CHAR	25	0	Name of the controlling area
154	VNAME_TXT	☐	LTEXT_8JV	TEXT35	CHAR	35	0	Joint Venture Description
155	RECID_TXT	☐	LTEXT_8JJ	TEXT35	CHAR	35	0	Recovery Indicator Description
156	ETYPE_TXT	☐	LTEXT_8JE	TEXT35	CHAR	35	0	Investment Type Description
157	JV_JIBCL_TXT	☐	LTEXT_8J6A	TEXT35	CHAR	35	0	JIB/JIBE Text
158	JV_JIBSA_TXT	☐	LTEXT_8J6C	TEXT35	CHAR	35	0	Text
159	FLG_ERLOE	☐	ERLOESE	ERLOESE	CHAR	1	0	Identifier "Revenue posting allowed"
160	FLG_OBLIGOX	☐	CO_OBLIGOX	XFELD	CHAR	1	0	Commitments Management Active
161	IM_PRNAM	☐	IM_PRNAM	IM_PRNAM	CHAR	8	0	Investment program name	*
162	IM_POSID	☐	IM_POSID	IM_POSID	CHAR	24	0	Identification for an investment program position
163	IM_POST1	☐	IM_POST1	TEXT40	CHAR	40	0	Short description
164	IM_POST2	☐	IM_POST1	TEXT40	CHAR	40	0	Short description
165	IM_GJAHR	☐	IM_GNJHR	GJAHR	NUMC	4	0	Approval year of the investment program
166	IMA_POSNR	☐	IMA_POSNR	IMA_POSNR	CHAR	12	0	Internal number for appropriation request	*
167	IMA_TXT50	☐	IMA_TXT50	TEXT50	CHAR	50	0	Description of appropriation request
168	AM_ANLKL	☐	ANLKL	ANLKL	CHAR	8	0	Asset Class	*
169	AM_AKTIV	☐	AM_AKTIVP	DATUM	DATS	8	0	Planned capitalization date
170	AM_TXK20	☐	TXT20_ANKT	TEXT20	CHAR	20	0	Short Text for Asset Class Name
171	STA_CHG_X	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
172	ERNAM_TXT	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FCOMS_ORDER	ABGSL	TKKAA	ABGSL	REF	C	CN
2	FCOMS_ORDER	ABKRS	TKO08	ABKRS	REF	1	CN
3	FCOMS_ORDER	ABUKR	T001	BUKRS		1	CN
4	FCOMS_ORDER	AKSTL	CSKS	KOSTL		1	CN
5	FCOMS_ORDER	ANFAUFNR	AUFK	AUFNR	REF	1	CN
6	FCOMS_ORDER	AUART	T003O	AUART	REF	1	CN
7	FCOMS_ORDER	AWSLS	TKV01	AWSLS	REF	C	CN
8	FCOMS_ORDER	BEMOT	TBMOT	BEMOT
9	FCOMS_ORDER	BUKRS	T001	BUKRS	REF	1	CN
10	FCOMS_ORDER	CYCLE	CSKS	KOSTL		1	CN
11	FCOMS_ORDER	ESTNR	TKO03	ASTNR	REF	1	CN
12	FCOMS_ORDER	ETYPE	T8JG	ETYPE	REF	C	CN
13	FCOMS_ORDER	FERC_IND	FERC_C7	IND	REF
14	FCOMS_ORDER	FUNC_AREA	TFKB	FKBER
15	FCOMS_ORDER	GSBER	TGSB	GSBER	REF	1	CN
16	FCOMS_ORDER	IVPRO	TAPRF	IVPRO	REF	C	CN
17	FCOMS_ORDER	IZWEK	T087I	IZWEK		1	CN
18	FCOMS_ORDER	JV_JIBCL	T8J6A	CLASS	REF	C	CN
19	FCOMS_ORDER	JV_JIBSA	T8J6C	SUBCLASS	REF	C	CN
20	FCOMS_ORDER	KALSM	T683	KALSM	REF	1	CN
21	FCOMS_ORDER	KAPPL	T681A	KAPPL	REF	1	CN
22	FCOMS_ORDER	KDAUF	VBUK	VBELN		1	CN
23	FCOMS_ORDER	KOKRS	TKA01	KOKRS	REF	1	CN
24	FCOMS_ORDER	KOSTL	CSKS	KOSTL		1	CN
25	FCOMS_ORDER	KOSTV	CSKS	KOSTL		1	CN
26	FCOMS_ORDER	KSTAR	CSKB	KSTAR		1	CN
27	FCOMS_ORDER	KVEWE	T681V	KVEWE	REF	1	CN
28	FCOMS_ORDER	LOGSYSTEM	TBDLS	LOGSYS	REF	1	CN
29	FCOMS_ORDER	MANDT	T000	MANDT	KEY	1	CN
30	FCOMS_ORDER	OBJNR	ONR00	OBJNR	REF	1	1
31	FCOMS_ORDER	PRCTR	CEPC	PRCTR		1	CN
32	FCOMS_ORDER	PSPEL	PRPS	PSPNR	REF	C	CN
33	FCOMS_ORDER	RECID	T8JJ	RECID	REF	C	CN
34	FCOMS_ORDER	REFNR	AUFK	AUFNR	REF	1	CN
35	FCOMS_ORDER	SAKNR	SKB1	SAKNR		1	CN
36	FCOMS_ORDER	SIZECL	TAIF5	SIZECL		1	CN
37	FCOMS_ORDER	SOWRK	T001W	WERKS	REF	1	CN
38	FCOMS_ORDER	STORT	T499S	STAND	REF	1	CN
39	FCOMS_ORDER	TXJCD	TTXJ	TXJCD
40	FCOMS_ORDER	UMWKZ	T087K	UMWKZ		1	CN
41	FCOMS_ORDER	VERAA_USER	USR02	BNAME
42	FCOMS_ORDER	VNAME	T8JV	VNAME	REF	C	CN
43	FCOMS_ORDER	VOGRP	TKAVG	GRUPPE		1	CN
44	FCOMS_ORDER	WAERS	TCURC	WAERS	REF	1	CN
45	FCOMS_ORDER	WERKS	T001W	WERKS	REF	1	CN
46	FCOMS_ORDER	ZSCHM	TPI01	ZSCHM	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	606