	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	BSEG	345	Accounting Document Segment
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

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

177 COLUMNS | 1 INDEXES | ERP 6.0 | FTUSE TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Sales and Distribution :: Foreign Trade :: Basic Functions
1	ERP EHP7	6.0	FTUSE	177	1	Foreign Trade: Control Table: User-dependent Settings	Basic Functions

SQL: selectupdate insert create

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

SELECT MANDT, UNAME, FT_HTML, FT_BUTT, FT_STDT, FTPRO_FTNOE, FTPRO_DEACT, FTPRO_W3OBJID, FTPRO_TDOBNAME, FTPRO_TDSPRAS, FTCON_FTNOE, FTCON_DEACT, FTCON_W3OBJID, FTCON_TDOBNAME, FTCON_TDSPRAS, FTSLS_FTNOE, FTSLS_DEACT, FTSLS_W3OBJID, FTSLS_TDOBNAME, FTSLS_TDSPRAS, FTLOC_FTNOE, FTLOC_DEACT, FTLOC_W3OBJID, FTLOC_TDOBNAME, FTLOC_TDSPRAS, FTCOM_FTNOE, FTCOM_DEACT, FTCOM_W3OBJID, FTCOM_TDOBNAME, FTCOM_TDSPRAS, FTPRE_FTNOE, FTPRE_DEACT, FTPRE_W3OBJID, FTPRE_TDOBNAME, FTPRE_TDSPRAS, FTMOW_FTNOE, FTMOW_DEACT, FTMOW_W3OBJID, FTMOW_TDOBNAME, FTMOW_TDSPRAS, FTSRV_FTNOE, FTSRV_DEACT, FTSRV_W3OBJID, FTSRV_TDOBNAME, FTSRV_TDSPRAS, FTGOV_FTNOE, FTGOV_DEACT, FTGOV_W3OBJID, FTGOV_TDOBNAME, FTGOV_TDSPRAS, FTGOV_EU_INT_AT, FTGOV_EU_INT_ATP, FTGOV_EU_INT_ATD, FTGOV_EU_INT_ATE, FTGOV_EU_INT_ATW, FTGOV_EU_INT_BE, FTGOV_EU_INT_BEP, FTGOV_EU_INT_BED, FTGOV_EU_INT_BEE, FTGOV_EU_INT_BEW, FTGOV_EU_INT_DE, FTGOV_EU_INT_DEP, FTGOV_EU_INT_DED, FTGOV_EU_INT_DEE, FTGOV_EU_INT_DEW, FTGOV_EU_INT_DK, FTGOV_EU_INT_DKP, FTGOV_EU_INT_DKD, FTGOV_EU_INT_DKE, FTGOV_EU_INT_DKW, FTGOV_EU_INT_ES, FTGOV_EU_INT_ESP, FTGOV_EU_INT_ESD, FTGOV_EU_INT_ESE, FTGOV_EU_INT_ESW, FTGOV_EU_INT_FI, FTGOV_EU_INT_FIP, FTGOV_EU_INT_FID, FTGOV_EU_INT_FIE, FTGOV_EU_INT_FIW, FTGOV_EU_INT_FR, FTGOV_EU_INT_FRP, FTGOV_EU_INT_FRD, FTGOV_EU_INT_FRE, FTGOV_EU_INT_FRW, FTGOV_EU_INT_GB, FTGOV_EU_INT_GBP, FTGOV_EU_INT_GBD, FTGOV_EU_INT_GBE, FTGOV_EU_INT_GBW, FTGOV_EU_INT_GR, FTGOV_EU_INT_GRP, FTGOV_EU_INT_GRD, FTGOV_EU_INT_GRE, FTGOV_EU_INT_GRW, FTGOV_EU_INT_IE, FTGOV_EU_INT_IEP, FTGOV_EU_INT_IED, FTGOV_EU_INT_IEE, FTGOV_EU_INT_IEW, FTGOV_EU_INT_IT, FTGOV_EU_INT_ITP, FTGOV_EU_INT_ITD, FTGOV_EU_INT_ITE, FTGOV_EU_INT_ITW, FTGOV_EU_INT_LU, FTGOV_EU_INT_LUP, FTGOV_EU_INT_LUD, FTGOV_EU_INT_LUE, FTGOV_EU_INT_LUW, FTGOV_EU_INT_NL, FTGOV_EU_INT_NLP, FTGOV_EU_INT_NLD, FTGOV_EU_INT_NLE, FTGOV_EU_INT_NLW, FTGOV_EU_INT_PT, FTGOV_EU_INT_PTP, FTGOV_EU_INT_PTD, FTGOV_EU_INT_PTE, FTGOV_EU_INT_PTW, FTGOV_EU_INT_SE, FTGOV_EU_INT_SEP, FTGOV_EU_INT_SED, FTGOV_EU_INT_SEE, FTGOV_EU_INT_SEW, FTGOV_EU_EXT_DE, FTGOV_EU_EXT_DED, FTGOV_EU_EXT_DEE, FTGOV_EU_EXT_DEW, FTGOV_EU_EXT_NL, FTGOV_EU_EXT_NLD, FTGOV_EU_EXT_NLE, FTGOV_EU_EXT_NLW, FTGOV_EU_KOB_DE, FTGOV_EU_KOB_DED, FTGOV_EU_KOB_DEE, FTGOV_EFTA_CH, FTGOV_EFTA_CHP, FTGOV_EFTA_CHD, FTGOV_EFTA_CHE, FTGOV_ASEAN_JP, FTGOV_NAFTA_USA, FTGOV_NAFTA_USAP, FTGOV_NAFTA_USAD, FTZLD_FTNOE, FTZLD_DEACT, FTZLD_W3OBJID, FTZLD_TDOBNAME, FTZLD_TDSPRAS, FTGOV_EU_EXT_FR, FTGOV_EU_EXT_FRD, FTGOV_EU_EXT_FRE, FTGOV_EU_EXT_FRW, FTGOV_EU_EXT_BE, FTGOV_EU_EXT_BED, FTGOV_EU_EXT_BEE, FTGOV_EU_EXT_BEW, FTGOV_EU_INT_PL, FTGOV_EU_INT_PLP, FTGOV_EU_INT_PLD, FTGOV_EU_INT_PLE, FTGOV_EU_INT_PLW, FTGOV_EU_INT_CZ, FTGOV_EU_INT_CZP, FTGOV_EU_INT_CZD, FTGOV_EU_INT_CZE, FTGOV_EU_INT_CZW, FTGOV_EU_INT_SK, FTGOV_EU_INT_SKP, FTGOV_EU_INT_SKD, FTGOV_EU_INT_SKE, FTGOV_EU_INT_SKW, FTGOV_EU_INT_HU, FTGOV_EU_INT_HUP, FTGOV_EU_INT_HUD, FTGOV_EU_INT_HUE, FTGOV_EU_INT_HUW FROM FTUSE

TOP ERP 6.0 | FTUSE 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	UNAME	User Name in User Master Record	nvarchar	12	CHAR	(N' ')	No	USR02	XUBNAME	Allow NULL?
3	FT_HTML	Control indicator for the initial screen in Foreign Trade	char	1	CHAR	(N' ')	Yes		FTHBS	Allow NULL?
4	FT_BUTT	Control indicator for the initial screen in Foreign Trade	char	1	CHAR	(N' ')	Yes		FTHBS	Allow NULL?
5	FT_STDT	Control indicator for the initial screen in Foreign Trade	char	1	CHAR	(N' ')	Yes		FTHBS	Allow NULL?
6	FTPRO_FTNOE	Max. Number of Entries for Tree Display in Foreign Trade	decimal	4	DEC	((0))	Yes		FTNOE
7	FTPRO_DEACT	Indicator for the deactivation of individual FT areas	char	1	CHAR	(N' ')	Yes		FTDEA	Allow NULL?
8	FTPRO_W3OBJID	Object name for SapWWWGateway for Foreign Trade areas	nvarchar	40	CHAR	(N' ')	Yes	WWWDATA	FTPIC	Allow NULL?
9	FTPRO_TDOBNAME	Text name for Foreign Trade areas	nvarchar	70	CHAR	(N' ')	Yes		FTTDN	Allow NULL?
10	FTPRO_TDSPRAS	Language key	char	1	LANG	(N' ')	Yes	*	TDSPRAS	Allow NULL?
11	FTCON_FTNOE	Max. Number of Entries for Tree Display in Foreign Trade	decimal	4	DEC	((0))	Yes		FTNOE
12	FTCON_DEACT	Indicator for the deactivation of individual FT areas	char	1	CHAR	(N' ')	Yes		FTDEA	Allow NULL?
13	FTCON_W3OBJID	Object name for SapWWWGateway for Foreign Trade areas	nvarchar	40	CHAR	(N' ')	Yes	WWWDATA	FTPIC	Allow NULL?
14	FTCON_TDOBNAME	Text name for Foreign Trade areas	nvarchar	70	CHAR	(N' ')	Yes		FTTDN	Allow NULL?
15	FTCON_TDSPRAS	Language key	char	1	LANG	(N' ')	Yes	T002	TDSPRAS	Allow NULL?
16	FTSLS_FTNOE	Max. Number of Entries for Tree Display in Foreign Trade	decimal	4	DEC	((0))	Yes		FTNOE
17	FTSLS_DEACT	Indicator for the deactivation of individual FT areas	char	1	CHAR	(N' ')	Yes		FTDEA	Allow NULL?
18	FTSLS_W3OBJID	Object name for SapWWWGateway for Foreign Trade areas	nvarchar	40	CHAR	(N' ')	Yes	WWWDATA	FTPIC	Allow NULL?
19	FTSLS_TDOBNAME	Text name for Foreign Trade areas	nvarchar	70	CHAR	(N' ')	Yes		FTTDN	Allow NULL?
20	FTSLS_TDSPRAS	Language key	char	1	LANG	(N' ')	Yes	T002	TDSPRAS	Allow NULL?
21	FTLOC_FTNOE	Max. Number of Entries for Tree Display in Foreign Trade	decimal	4	DEC	((0))	Yes		FTNOE
22	FTLOC_DEACT	Indicator for the deactivation of individual FT areas	char	1	CHAR	(N' ')	Yes		FTDEA	Allow NULL?
23	FTLOC_W3OBJID	Object name for SapWWWGateway for Foreign Trade areas	nvarchar	40	CHAR	(N' ')	Yes	WWWDATA	FTPIC	Allow NULL?
24	FTLOC_TDOBNAME	Text name for Foreign Trade areas	nvarchar	70	CHAR	(N' ')	Yes		FTTDN	Allow NULL?
25	FTLOC_TDSPRAS	Language key	char	1	LANG	(N' ')	Yes	T002	TDSPRAS	Allow NULL?
26	FTCOM_FTNOE	Max. Number of Entries for Tree Display in Foreign Trade	decimal	4	DEC	((0))	Yes		FTNOE
27	FTCOM_DEACT	Indicator for the deactivation of individual FT areas	char	1	CHAR	(N' ')	Yes		FTDEA	Allow NULL?
28	FTCOM_W3OBJID	Object name for SapWWWGateway for Foreign Trade areas	nvarchar	40	CHAR	(N' ')	Yes	WWWDATA	FTPIC	Allow NULL?
29	FTCOM_TDOBNAME	Text name for Foreign Trade areas	nvarchar	70	CHAR	(N' ')	Yes		FTTDN	Allow NULL?
30	FTCOM_TDSPRAS	Language key	char	1	LANG	(N' ')	Yes	T002	TDSPRAS	Allow NULL?
31	FTPRE_FTNOE	Max. Number of Entries for Tree Display in Foreign Trade	decimal	4	DEC	((0))	Yes		FTNOE
32	FTPRE_DEACT	Indicator for the deactivation of individual FT areas	char	1	CHAR	(N' ')	Yes		FTDEA	Allow NULL?
33	FTPRE_W3OBJID	Object name for SapWWWGateway for Foreign Trade areas	nvarchar	40	CHAR	(N' ')	Yes	WWWDATA	FTPIC	Allow NULL?
34	FTPRE_TDOBNAME	Text name for Foreign Trade areas	nvarchar	70	CHAR	(N' ')	Yes		FTTDN	Allow NULL?
35	FTPRE_TDSPRAS	Language key	char	1	LANG	(N' ')	Yes	T002	TDSPRAS	Allow NULL?
36	FTMOW_FTNOE	Max. Number of Entries for Tree Display in Foreign Trade	decimal	4	DEC	((0))	Yes		FTNOE
37	FTMOW_DEACT	Indicator for the deactivation of individual FT areas	char	1	CHAR	(N' ')	Yes		FTDEA	Allow NULL?
38	FTMOW_W3OBJID	Object name for SapWWWGateway for Foreign Trade areas	nvarchar	40	CHAR	(N' ')	Yes	WWWDATA	FTPIC	Allow NULL?
39	FTMOW_TDOBNAME	Text name for Foreign Trade areas	nvarchar	70	CHAR	(N' ')	Yes		FTTDN	Allow NULL?
40	FTMOW_TDSPRAS	Language key	char	1	LANG	(N' ')	Yes	T002	TDSPRAS	Allow NULL?
41	FTSRV_FTNOE	Max. Number of Entries for Tree Display in Foreign Trade	decimal	4	DEC	((0))	Yes		FTNOE
42	FTSRV_DEACT	Indicator for the deactivation of individual FT areas	char	1	CHAR	(N' ')	Yes		FTDEA	Allow NULL?
43	FTSRV_W3OBJID	Object name for SapWWWGateway for Foreign Trade areas	nvarchar	40	CHAR	(N' ')	Yes	WWWDATA	FTPIC	Allow NULL?
44	FTSRV_TDOBNAME	Text name for Foreign Trade areas	nvarchar	70	CHAR	(N' ')	Yes		FTTDN	Allow NULL?
45	FTSRV_TDSPRAS	Language key	char	1	LANG	(N' ')	Yes	T002	TDSPRAS	Allow NULL?
46	FTGOV_FTNOE	Max. Number of Entries for Tree Display in Foreign Trade	decimal	4	DEC	((0))	Yes		FTNOE
47	FTGOV_DEACT	Indicator for the deactivation of individual FT areas	char	1	CHAR	(N' ')	Yes		FTDEA	Allow NULL?
48	FTGOV_W3OBJID	Object name for SapWWWGateway for Foreign Trade areas	nvarchar	40	CHAR	(N' ')	Yes	WWWDATA	FTPIC	Allow NULL?
49	FTGOV_TDOBNAME	Text name for Foreign Trade areas	nvarchar	70	CHAR	(N' ')	Yes		FTTDN	Allow NULL?
50	FTGOV_TDSPRAS	Language key	char	1	LANG	(N' ')	Yes	T002	TDSPRAS	Allow NULL?
51	FTGOV_EU_INT_AT	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
52	FTGOV_EU_INT_ATP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
53	FTGOV_EU_INT_ATD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
54	FTGOV_EU_INT_ATE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
55	FTGOV_EU_INT_ATW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
56	FTGOV_EU_INT_BE	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
57	FTGOV_EU_INT_BEP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
58	FTGOV_EU_INT_BED	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
59	FTGOV_EU_INT_BEE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
60	FTGOV_EU_INT_BEW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
61	FTGOV_EU_INT_DE	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
62	FTGOV_EU_INT_DEP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
63	FTGOV_EU_INT_DED	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
64	FTGOV_EU_INT_DEE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
65	FTGOV_EU_INT_DEW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
66	FTGOV_EU_INT_DK	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
67	FTGOV_EU_INT_DKP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
68	FTGOV_EU_INT_DKD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
69	FTGOV_EU_INT_DKE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
70	FTGOV_EU_INT_DKW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
71	FTGOV_EU_INT_ES	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
72	FTGOV_EU_INT_ESP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
73	FTGOV_EU_INT_ESD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
74	FTGOV_EU_INT_ESE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
75	FTGOV_EU_INT_ESW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
76	FTGOV_EU_INT_FI	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
77	FTGOV_EU_INT_FIP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
78	FTGOV_EU_INT_FID	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
79	FTGOV_EU_INT_FIE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
80	FTGOV_EU_INT_FIW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
81	FTGOV_EU_INT_FR	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
82	FTGOV_EU_INT_FRP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
83	FTGOV_EU_INT_FRD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
84	FTGOV_EU_INT_FRE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
85	FTGOV_EU_INT_FRW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
86	FTGOV_EU_INT_GB	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
87	FTGOV_EU_INT_GBP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
88	FTGOV_EU_INT_GBD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
89	FTGOV_EU_INT_GBE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
90	FTGOV_EU_INT_GBW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
91	FTGOV_EU_INT_GR	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
92	FTGOV_EU_INT_GRP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
93	FTGOV_EU_INT_GRD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
94	FTGOV_EU_INT_GRE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
95	FTGOV_EU_INT_GRW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
96	FTGOV_EU_INT_IE	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
97	FTGOV_EU_INT_IEP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
98	FTGOV_EU_INT_IED	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
99	FTGOV_EU_INT_IEE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
100	FTGOV_EU_INT_IEW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
101	FTGOV_EU_INT_IT	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
102	FTGOV_EU_INT_ITP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
103	FTGOV_EU_INT_ITD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
104	FTGOV_EU_INT_ITE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
105	FTGOV_EU_INT_ITW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
106	FTGOV_EU_INT_LU	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
107	FTGOV_EU_INT_LUP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
108	FTGOV_EU_INT_LUD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
109	FTGOV_EU_INT_LUE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
110	FTGOV_EU_INT_LUW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
111	FTGOV_EU_INT_NL	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
112	FTGOV_EU_INT_NLP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
113	FTGOV_EU_INT_NLD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
114	FTGOV_EU_INT_NLE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
115	FTGOV_EU_INT_NLW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
116	FTGOV_EU_INT_PT	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
117	FTGOV_EU_INT_PTP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
118	FTGOV_EU_INT_PTD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
119	FTGOV_EU_INT_PTE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
120	FTGOV_EU_INT_PTW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
121	FTGOV_EU_INT_SE	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
122	FTGOV_EU_INT_SEP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
123	FTGOV_EU_INT_SED	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
124	FTGOV_EU_INT_SEE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
125	FTGOV_EU_INT_SEW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
126	FTGOV_EU_EXT_DE	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
127	FTGOV_EU_EXT_DED	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
128	FTGOV_EU_EXT_DEE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
129	FTGOV_EU_EXT_DEW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
130	FTGOV_EU_EXT_NL	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
131	FTGOV_EU_EXT_NLD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
132	FTGOV_EU_EXT_NLE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
133	FTGOV_EU_EXT_NLW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
134	FTGOV_EU_KOB_DE	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
135	FTGOV_EU_KOB_DED	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
136	FTGOV_EU_KOB_DEE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
137	FTGOV_EFTA_CH	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
138	FTGOV_EFTA_CHP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
139	FTGOV_EFTA_CHD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
140	FTGOV_EFTA_CHE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
141	FTGOV_ASEAN_JP	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
142	FTGOV_NAFTA_USA	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
143	FTGOV_NAFTA_USAP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
144	FTGOV_NAFTA_USAD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
145	FTZLD_FTNOE	Max. Number of Entries for Tree Display in Foreign Trade	decimal	4	DEC	((0))	Yes		FTNOE
146	FTZLD_DEACT	Indicator for the deactivation of individual FT areas	char	1	CHAR	(N' ')	Yes		FTDEA	Allow NULL?
147	FTZLD_W3OBJID	Object name for SapWWWGateway for Foreign Trade areas	nvarchar	40	CHAR	(N' ')	Yes	WWWDATA	FTPIC	Allow NULL?
148	FTZLD_TDOBNAME	Text name for Foreign Trade areas	nvarchar	70	CHAR	(N' ')	Yes		FTTDN	Allow NULL?
149	FTZLD_TDSPRAS	Language key	char	1	LANG	(N' ')	Yes	T002	TDSPRAS	Allow NULL?
150	FTGOV_EU_EXT_FR	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
151	FTGOV_EU_EXT_FRD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
152	FTGOV_EU_EXT_FRE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
153	FTGOV_EU_EXT_FRW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
154	FTGOV_EU_EXT_BE	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
155	FTGOV_EU_EXT_BED	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
156	FTGOV_EU_EXT_BEE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
157	FTGOV_EU_EXT_BEW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
158	FTGOV_EU_INT_PL	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
159	FTGOV_EU_INT_PLP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
160	FTGOV_EU_INT_PLD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
161	FTGOV_EU_INT_PLE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
162	FTGOV_EU_INT_PLW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
163	FTGOV_EU_INT_CZ	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
164	FTGOV_EU_INT_CZP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
165	FTGOV_EU_INT_CZD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
166	FTGOV_EU_INT_CZE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
167	FTGOV_EU_INT_CZW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
168	FTGOV_EU_INT_SK	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
169	FTGOV_EU_INT_SKP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
170	FTGOV_EU_INT_SKD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
171	FTGOV_EU_INT_SKE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
172	FTGOV_EU_INT_SKW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?
173	FTGOV_EU_INT_HU	Indicator for deactivating individual declaration types	char	1	CHAR	(N' ')	Yes		FTDPA	Allow NULL?
174	FTGOV_EU_INT_HUP	Indicator for deactivating the declaration medium "document"	char	1	CHAR	(N' ')	Yes		FTPAP	Allow NULL?
175	FTGOV_EU_INT_HUD	Indicator for deactivating the declaration medium "diskette"	char	1	CHAR	(N' ')	Yes		FTPAD	Allow NULL?
176	FTGOV_EU_INT_HUE	Indicator for deactivating the declaration medium "CUSDEC"	char	1	CHAR	(N' ')	Yes		FTPAE	Allow NULL?
177	FTGOV_EU_INT_HUW	Indicator for deactivating a goods movem. for periodic decl.	char	1	NUMC	(N'0')	Yes		FTPAW	Allow NULL?

TOP ERP 6.0 | FTUSE INDEXES

Name	Primary	Unique	Type	Columns
FTUSE~0	Yes	Yes	CLUSTERED	UNAME, 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

177 COLUMNS | 1 INDEXES | ERP 6.0 | FTUSE TABLE

TOP ERP 6.0 | FTUSE COLUMNS

TOP ERP 6.0 | FTUSE 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

177 COLUMNS | 1 INDEXES | ERP 6.0 | FTUSE TABLE

TOPERP 6.0 | FTUSE COLUMNS

TOPERP 6.0 | FTUSE INDEXES

TOP ERP 6.0 | FTUSE COLUMNS

TOP ERP 6.0 | FTUSE INDEXES