	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

193 COLUMNS | 1 INDEXES | ERP 6.0 | TCOA TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Production Planning and Control :: Production Orders
1	ERP EHP7	6.0	TCOA	193	1	Overall profile for order information system	Production Orders

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PROFID, AENAM, PROTECT, VARIANTE, FLG_LOEKZ, FLG_MSTUF, PROFID_AA, HEADER_SEL, HEADER_ANZ, HEADER_AFL, PROFID_BA, ITEM_SEL, ITEM_ANZ, ITEM_AFL, PROFID_BB, SEQUEN_SEL, SEQUEN_ANZ, SEQUEN_AFL, PROFID_BC, CONF_SEL, CONF_ANZ, CONF_AFL, PROFID_BE, DOCL_SEL, DOCL_ANZ, DOCL_AFL, PROFID_CA, OPER_SEL, OPER_ANZ, OPER_AFL, PROFID_CB, GMER_SEL, GMER_ANZ, GMER_AFL, PROFID_CC, GOMO_SEL, GOMO_ANZ, GOMO_AFL, PROFID_DA, OPCAP_SEL, OPCAP_ANZ, OPCAP_AFL, PROFID_DB, SOPER_SEL, SOPER_ANZ, SOPER_AFL, PROFID_DC, OPMST_SEL, OPMST_ANZ, OPMST_AFL, PROFID_DE, OPCOMP_SEL, OPCOMP_ANZ, OPCOMP_AFL, PROFID_DF, OPPRT_SEL, OPPRT_ANZ, OPPRT_AFL, PROFID_DG, OPCONF_SEL, OPCONF_ANZ, OPCONF_AFL, PROFID_EA, OPSCAP_SEL, OPSCAP_ANZ, OPSCAP_AFL, PROFID_EB, SOCAP_SEL, SOCAP_ANZ, SOCAP_AFL, PROFID_EC, SOCONF_SEL, SOCONF_ANZ, SOCONF_AFL, PROFID_ED, OPGMER_SEL, OPGMER_ANZ, OPGMER_AFL, PROFID_EE, OPGOMO_SEL, OPGOMO_ANZ, OPGOMO_AFL, PROFID_FA, SOSCAP_SEL, SOSCAP_ANZ, SOSCAP_AFL, PROFID_FB, SOGMER_SEL, SOGMER_ANZ, SOGMER_AFL, PROFID_FC, OPSCCF_SEL, OPSCCF_ANZ, OPSCCF_AFL, PROFID_FD, SOGOMO_SEL, SOGOMO_ANZ, SOGOMO_AFL, PROFID_GA, SOSCCF_SEL, SOSCCF_ANZ, SOSCCF_AFL, PROFID_BD, MAMO_SEL, MAMO_ANZ, MAMO_AFL, PROFID_DH, OPPREQ_SEL, OPPREQ_ANZ, OPPREQ_AFL, PROFID_DI, OPPORD_SEL, OPPORD_ANZ, OPPORD_AFL, PROFID_EF, SOPREQ_SEL, SOPREQ_ANZ, SOPREQ_AFL, PROFID_EG, SOPORD_SEL, SOPORD_ANZ, SOPORD_AFL, PROFID_DJ, OPDOCL_SEL, OPDOCL_ANZ, OPDOCL_AFL, AEDAT, FLG_ALVTR, LAYOUTID_AA, LAYOUTID_BA, LAYOUTID_BB, LAYOUTID_BC, LAYOUTID_BD, LAYOUTID_BE, LAYOUTID_CA, LAYOUTID_CB, LAYOUTID_CC, LAYOUTID_DA, LAYOUTID_DB, LAYOUTID_DC, LAYOUTID_DE, LAYOUTID_DF, LAYOUTID_DG, LAYOUTID_DH, LAYOUTID_DI, LAYOUTID_DJ, LAYOUTID_EA, LAYOUTID_EB, LAYOUTID_EC, LAYOUTID_ED, LAYOUTID_EE, LAYOUTID_EF, LAYOUTID_EG, LAYOUTID_FA, LAYOUTID_FB, LAYOUTID_FC, LAYOUTID_FD, LAYOUTID_GA, HEADER_POS, ITEM_POS, SEQUEN_POS, MAMO_POS, DOCL_POS, CONF_POS, OPER_POS, GMER_POS, GOMO_POS, OPCAP_POS, OPCOMP_POS, OPCONF_POS, OPMST_POS, OPPRT_POS, OPPREQ_POS, OPPORD_POS, OPDOCL_POS, SOPER_POS, OPSCAP_POS, OPGMER_POS, OPGOMO_POS, SOCAP_POS, SOCONF_POS, SOSCAP_POS, SOPREQ_POS, SOPORD_POS, SOGMER_POS, SOGOMO_POS, OPSCCF_POS, SOSCCF_POS, PRODLIST_SEL, MATVER_SEL, PRODLIST_LAY, MATVER_LAY FROM TCOA

TOP ERP 6.0 | TCOA COLUMNS

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	PROFID	Order information sytem: overall profile	nvarchar	12	CHAR	(N' ')	No		CO_PROF_ST	Allow NULL?
3	AENAM	Last changed by	nvarchar	12	CHAR	(N' ')	No		PS_AENAM	Allow NULL?
4	PROTECT	Indicator: Protected entry	char	1	CHAR	(N' ')	No		MP_PROTECT	Allow NULL?
5	VARIANTE	Variant for order information system	nvarchar	14	CHAR	(N' ')	No	VARID	CO_SEL_VAR	Allow NULL?
6	FLG_LOEKZ	Display deleted orders	char	1	CHAR	(N' ')	No		FLG_LOEKZ	Allow NULL?
7	FLG_MSTUF	Production/Process/Planned Order	char	1	CHAR	(N' ')	No		SEL_TYP	Allow NULL?
8	PROFID_AA	Profile for order headers order information system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_AA	Allow NULL?
9	HEADER_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
10	HEADER_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
11	HEADER_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
12	PROFID_BA	Profile for items in order information system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_BA	Allow NULL?
13	ITEM_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
14	ITEM_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
15	ITEM_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
16	PROFID_BB	Profile for sequences in order information system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_BB	Allow NULL?
17	SEQUEN_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
18	SEQUEN_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
19	SEQUEN_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
20	PROFID_BC	Profile for confirmations header order information system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_BC	Allow NULL?
21	CONF_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
22	CONF_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
23	CONF_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
24	PROFID_BE	Profile document link order info system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_BE	Allow NULL?
25	DOCL_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
26	DOCL_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
27	DOCL_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
28	PROFID_CA	Profile for operations order information system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_CA	Allow NULL?
29	OPER_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
30	OPER_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
31	OPER_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
32	PROFID_CB	Profile for goods movements with errors (header)	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_CB	Allow NULL?
33	GMER_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
34	GMER_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
35	GMER_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
36	PROFID_CC	Profile for goods movements header order information system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_CC	Allow NULL?
37	GOMO_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
38	GOMO_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
39	GOMO_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
40	PROFID_DA	Profile for capacity rqmts. operation order info.system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_DA	Allow NULL?
41	OPCAP_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
42	OPCAP_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
43	OPCAP_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
44	PROFID_DB	Profile for sub-operations order info. system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_DB	Allow NULL?
45	SOPER_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
46	SOPER_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
47	SOPER_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
48	PROFID_DC	Profile for trigger points order information system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_DC	Allow NULL?
49	OPMST_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
50	OPMST_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
51	OPMST_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
52	PROFID_DE	Profile for components order information system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_DE	Allow NULL?
53	OPCOMP_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
54	OPCOMP_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
55	OPCOMP_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
56	PROFID_DF	Profile for PRTs in order information system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_DF	Allow NULL?
57	OPPRT_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
58	OPPRT_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
59	OPPRT_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
60	PROFID_DG	Profile for operation confirmations in order info. system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_DG	Allow NULL?
61	OPCONF_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
62	OPCONF_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
63	OPCONF_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
64	PROFID_EA	Profile for indiv.cap. rqmts. operation order info.system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_EA	Allow NULL?
65	OPSCAP_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
66	OPSCAP_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
67	OPSCAP_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
68	PROFID_EB	Profile for capacity rqmts.(sub-operation) order info system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_EB	Allow NULL?
69	SOCAP_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
70	SOCAP_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
71	SOCAP_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
72	PROFID_EC	Profile for confirmations (sub-operation) order info.system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_EC	Allow NULL?
73	SOCONF_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
74	SOCONF_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
75	SOCONF_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
76	PROFID_ED	Profile for goods movements with errors (operation)	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_ED	Allow NULL?
77	OPGMER_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
78	OPGMER_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
79	OPGMER_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
80	PROFID_EE	Profile for goods movements (operation) in order info.system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_EE	Allow NULL?
81	OPGOMO_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
82	OPGOMO_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
83	OPGOMO_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
84	PROFID_FA	Profile for indiv.cap.rqmts.(sub-operation) order info.sys.	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_FA	Allow NULL?
85	SOSCAP_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
86	SOSCAP_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
87	SOSCAP_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
88	PROFID_FB	Profile for goods movements with errors (sub-operation)	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_FB	Allow NULL?
89	SOGMER_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
90	SOGMER_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
91	SOGMER_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
92	PROFID_FC	Profile for confirmation of individual capacity reqs. (op.)	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_FC	Allow NULL?
93	OPSCCF_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
94	OPSCCF_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
95	OPSCCF_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
96	PROFID_FD	Profile for goods movements - sub-op. order info system	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_FD	Allow NULL?
97	SOGOMO_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
98	SOGOMO_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
99	SOGOMO_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
100	PROFID_GA	Profile for confirmation of individual cap. reqs. (sub-op.)	nvarchar	6	CHAR	(N' ')	No	TCOAD	CO_PROF_GA	Allow NULL?
101	SOSCCF_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	No		KZ_OB_READ	Allow NULL?
102	SOSCCF_ANZ	Display object in order info system	char	1	CHAR	(N' ')	No		KZ_OB_SHOW	Allow NULL?
103	SOSCCF_AFL	Last object to be expanded	char	1	CHAR	(N' ')	No		KZ_OB_EXP	Allow NULL?
104	PROFID_BD	Profile documentation goods movements for order (AUFM)	nvarchar	6	CHAR	(N' ')	Yes	TCOAD	CO_PROF_MM	Allow NULL?
105	MAMO_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	Yes		KZ_OB_READ	Allow NULL?
106	MAMO_ANZ	Display object in order info system	char	1	CHAR	(N' ')	Yes		KZ_OB_SHOW	Allow NULL?
107	MAMO_AFL	Last object to be expanded	char	1	CHAR	(N' ')	Yes		KZ_OB_EXP	Allow NULL?
108	PROFID_DH	Profile purchase requisition operation order info system	nvarchar	6	CHAR	(N' ')	Yes	TCOAD	CO_PROF_DH	Allow NULL?
109	OPPREQ_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	Yes		KZ_OB_READ	Allow NULL?
110	OPPREQ_ANZ	Display object in order info system	char	1	CHAR	(N' ')	Yes		KZ_OB_SHOW	Allow NULL?
111	OPPREQ_AFL	Last object to be expanded	char	1	CHAR	(N' ')	Yes		KZ_OB_EXP	Allow NULL?
112	PROFID_DI	Profile purchase order operation order info system	nvarchar	6	CHAR	(N' ')	Yes	TCOAD	CO_PROF_DI	Allow NULL?
113	OPPORD_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	Yes		KZ_OB_READ	Allow NULL?
114	OPPORD_ANZ	Display object in order info system	char	1	CHAR	(N' ')	Yes		KZ_OB_SHOW	Allow NULL?
115	OPPORD_AFL	Last object to be expanded	char	1	CHAR	(N' ')	Yes		KZ_OB_EXP	Allow NULL?
116	PROFID_EF	Profile purchase requisition sub-operation order info system	nvarchar	6	CHAR	(N' ')	Yes	TCOAD	CO_PROF_EF	Allow NULL?
117	SOPREQ_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	Yes		KZ_OB_READ	Allow NULL?
118	SOPREQ_ANZ	Display object in order info system	char	1	CHAR	(N' ')	Yes		KZ_OB_SHOW	Allow NULL?
119	SOPREQ_AFL	Last object to be expanded	char	1	CHAR	(N' ')	Yes		KZ_OB_EXP	Allow NULL?
120	PROFID_EG	Profile purchase requisition sub-operation order info system	nvarchar	6	CHAR	(N' ')	Yes	TCOAD	CO_PROF_EG	Allow NULL?
121	SOPORD_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	Yes		KZ_OB_READ	Allow NULL?
122	SOPORD_ANZ	Display object in order info system	char	1	CHAR	(N' ')	Yes		KZ_OB_SHOW	Allow NULL?
123	SOPORD_AFL	Last object to be expanded	char	1	CHAR	(N' ')	Yes		KZ_OB_EXP	Allow NULL?
124	PROFID_DJ	Profile document link order info system	nvarchar	6	CHAR	(N' ')	Yes	TCOAD	CO_PROF_DJ	Allow NULL?
125	OPDOCL_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	Yes		KZ_OB_READ	Allow NULL?
126	OPDOCL_ANZ	Display object in order info system	char	1	CHAR	(N' ')	Yes		KZ_OB_SHOW	Allow NULL?
127	OPDOCL_AFL	Last object to be expanded	char	1	CHAR	(N' ')	Yes		KZ_OB_EXP	Allow NULL?
128	AEDAT	Changed On	nvarchar	8	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
129	FLG_ALVTR	Layout-Based Output of the Object Overview in Info System	char	1	CHAR	(N' ')	Yes		COIS_ALVTR	Allow NULL?
130	LAYOUTID_AA	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
131	LAYOUTID_BA	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
132	LAYOUTID_BB	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
133	LAYOUTID_BC	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
134	LAYOUTID_BD	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
135	LAYOUTID_BE	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
136	LAYOUTID_CA	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
137	LAYOUTID_CB	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
138	LAYOUTID_CC	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
139	LAYOUTID_DA	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
140	LAYOUTID_DB	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
141	LAYOUTID_DC	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
142	LAYOUTID_DE	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
143	LAYOUTID_DF	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
144	LAYOUTID_DG	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
145	LAYOUTID_DH	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
146	LAYOUTID_DI	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
147	LAYOUTID_DJ	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
148	LAYOUTID_EA	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
149	LAYOUTID_EB	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
150	LAYOUTID_EC	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
151	LAYOUTID_ED	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
152	LAYOUTID_EE	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
153	LAYOUTID_EF	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
154	LAYOUTID_EG	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
155	LAYOUTID_FA	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
156	LAYOUTID_FB	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
157	LAYOUTID_FC	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
158	LAYOUTID_FD	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
159	LAYOUTID_GA	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
160	HEADER_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
161	ITEM_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
162	SEQUEN_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
163	MAMO_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
164	DOCL_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
165	CONF_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
166	OPER_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
167	GMER_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
168	GOMO_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
169	OPCAP_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
170	OPCOMP_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
171	OPCONF_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
172	OPMST_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
173	OPPRT_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
174	OPPREQ_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
175	OPPORD_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
176	OPDOCL_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
177	SOPER_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
178	OPSCAP_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
179	OPGMER_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
180	OPGOMO_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
181	SOCAP_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
182	SOCONF_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
183	SOSCAP_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
184	SOPREQ_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
185	SOPORD_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
186	SOGMER_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
187	SOGOMO_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
188	OPSCCF_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
189	SOSCCF_POS	Item from Individual List in Object Overview	nvarchar	2	NUMC	(N'00')	Yes		COIS_POS	Allow NULL?
190	PRODLIST_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	Yes		KZ_OB_READ	Allow NULL?
191	MATVER_SEL	Read object in order info system from DB	char	1	CHAR	(N' ')	Yes		KZ_OB_READ	Allow NULL?
192	PRODLIST_LAY	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?
193	MATVER_LAY	Layout for Objects in the Order Information System	nvarchar	12	CHAR	(N' ')	Yes		COIS_LAYOUT	Allow NULL?

TOP ERP 6.0 | TCOA INDEXES

Name	Primary	Unique	Type	Columns
TCOA~0	Yes	Yes	CLUSTERED	PROFID, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

193 COLUMNS | 1 INDEXES | ERP 6.0 | TCOA TABLE

TOP ERP 6.0 | TCOA COLUMNS

TOP ERP 6.0 | TCOA INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

193 COLUMNS | 1 INDEXES | ERP 6.0 | TCOA TABLE

TOPERP 6.0 | TCOA COLUMNS

TOPERP 6.0 | TCOA INDEXES

TOP ERP 6.0 | TCOA COLUMNS

TOP ERP 6.0 | TCOA INDEXES