SAP FTUSE Foreign Trade: Control Table: User-dependent Settings Table data and field list

FTUSE is a standard SAP Table which is used to store Foreign Trade: Control Table: User-dependent Settings data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FTUSE table consists of various fields, each holding specific information or linking keys about Foreign Trade: Control Table: User-dependent Settings data available in SAP. These include UNAME (User Name in User Master Record), FT_HTML (Control indicator for the initial screen in Foreign Trade), FT_BUTT (Control indicator for the initial screen in Foreign Trade), FT_STDT (Control indicator for the initial screen in Foreign Trade)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

FTUSE table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FTUSE table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FTUSE table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
UNAMEUser Name in User Master Record XUBNAMECHAR12USR02XUBNAMEXUS
FT_HTMLControl indicator for the initial screen in Foreign Trade FTHBSCHAR1XFELD
FT_BUTTControl indicator for the initial screen in Foreign Trade FTHBSCHAR1XFELD
FT_STDTControl indicator for the initial screen in Foreign Trade FTHBSCHAR1XFELD
FTPRO_FTNOEMax. Number of Entries for Tree Display in Foreign Trade FTNOEDEC4DEC4
FTPRO_DEACTIndicator for the deactivation of individual FT areas FTDEACHAR1XFELD
FTPRO_W3OBJIDObject name for SapWWWGateway for Foreign Trade areas FTPICCHAR40WWWDATASYCHAR40
FTPRO_TDOBNAMEText name for Foreign Trade areas FTTDNCHAR70TDOBNAME
FTPRO_TDSPRASLanguage key TDSPRASLANG1Assigned to domainISOLASPRAS
FTCON_FTNOEMax. Number of Entries for Tree Display in Foreign Trade FTNOEDEC4DEC4
FTCON_DEACTIndicator for the deactivation of individual FT areas FTDEACHAR1XFELD
FTCON_W3OBJIDObject name for SapWWWGateway for Foreign Trade areas FTPICCHAR40WWWDATASYCHAR40
FTCON_TDOBNAMEText name for Foreign Trade areas FTTDNCHAR70TDOBNAME
FTCON_TDSPRASLanguage key TDSPRASLANG1T002ISOLASPRAS
FTSLS_FTNOEMax. Number of Entries for Tree Display in Foreign Trade FTNOEDEC4DEC4
FTSLS_DEACTIndicator for the deactivation of individual FT areas FTDEACHAR1XFELD
FTSLS_W3OBJIDObject name for SapWWWGateway for Foreign Trade areas FTPICCHAR40WWWDATASYCHAR40
FTSLS_TDOBNAMEText name for Foreign Trade areas FTTDNCHAR70TDOBNAME
FTSLS_TDSPRASLanguage key TDSPRASLANG1T002ISOLASPRAS
FTLOC_FTNOEMax. Number of Entries for Tree Display in Foreign Trade FTNOEDEC4DEC4
FTLOC_DEACTIndicator for the deactivation of individual FT areas FTDEACHAR1XFELD
FTLOC_W3OBJIDObject name for SapWWWGateway for Foreign Trade areas FTPICCHAR40WWWDATASYCHAR40
FTLOC_TDOBNAMEText name for Foreign Trade areas FTTDNCHAR70TDOBNAME
FTLOC_TDSPRASLanguage key TDSPRASLANG1T002ISOLASPRAS
FTCOM_FTNOEMax. Number of Entries for Tree Display in Foreign Trade FTNOEDEC4DEC4
FTCOM_DEACTIndicator for the deactivation of individual FT areas FTDEACHAR1XFELD
FTCOM_W3OBJIDObject name for SapWWWGateway for Foreign Trade areas FTPICCHAR40WWWDATASYCHAR40
FTCOM_TDOBNAMEText name for Foreign Trade areas FTTDNCHAR70TDOBNAME
FTCOM_TDSPRASLanguage key TDSPRASLANG1T002ISOLASPRAS
FTPRE_FTNOEMax. Number of Entries for Tree Display in Foreign Trade FTNOEDEC4DEC4
FTPRE_DEACTIndicator for the deactivation of individual FT areas FTDEACHAR1XFELD
FTPRE_W3OBJIDObject name for SapWWWGateway for Foreign Trade areas FTPICCHAR40WWWDATASYCHAR40
FTPRE_TDOBNAMEText name for Foreign Trade areas FTTDNCHAR70TDOBNAME
FTPRE_TDSPRASLanguage key TDSPRASLANG1T002ISOLASPRAS
FTMOW_FTNOEMax. Number of Entries for Tree Display in Foreign Trade FTNOEDEC4DEC4
FTMOW_DEACTIndicator for the deactivation of individual FT areas FTDEACHAR1XFELD
FTMOW_W3OBJIDObject name for SapWWWGateway for Foreign Trade areas FTPICCHAR40WWWDATASYCHAR40
FTMOW_TDOBNAMEText name for Foreign Trade areas FTTDNCHAR70TDOBNAME
FTMOW_TDSPRASLanguage key TDSPRASLANG1T002ISOLASPRAS
FTSRV_FTNOEMax. Number of Entries for Tree Display in Foreign Trade FTNOEDEC4DEC4
FTSRV_DEACTIndicator for the deactivation of individual FT areas FTDEACHAR1XFELD
FTSRV_W3OBJIDObject name for SapWWWGateway for Foreign Trade areas FTPICCHAR40WWWDATASYCHAR40
FTSRV_TDOBNAMEText name for Foreign Trade areas FTTDNCHAR70TDOBNAME
FTSRV_TDSPRASLanguage key TDSPRASLANG1T002ISOLASPRAS
FTGOV_FTNOEMax. Number of Entries for Tree Display in Foreign Trade FTNOEDEC4DEC4
FTGOV_DEACTIndicator for the deactivation of individual FT areas FTDEACHAR1XFELD
FTGOV_W3OBJIDObject name for SapWWWGateway for Foreign Trade areas FTPICCHAR40WWWDATASYCHAR40
FTGOV_TDOBNAMEText name for Foreign Trade areas FTTDNCHAR70TDOBNAME
FTGOV_TDSPRASLanguage key TDSPRASLANG1T002ISOLASPRAS
FTGOV_EU_INT_ATIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_ATPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_ATDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_ATEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_ATWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_BEIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_BEPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_BEDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_BEEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_BEWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_DEIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_DEPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_DEDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_DEEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_DEWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_DKIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_DKPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_DKDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_DKEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_DKWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_ESIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_ESPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_ESDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_ESEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_ESWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_FIIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_FIPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_FIDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_FIEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_FIWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_FRIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_FRPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_FRDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_FREIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_FRWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_GBIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_GBPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_GBDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_GBEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_GBWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_GRIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_GRPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_GRDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_GREIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_GRWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_IEIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_IEPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_IEDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_IEEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_IEWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_ITIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_ITPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_ITDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_ITEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_ITWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_LUIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_LUPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_LUDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_LUEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_LUWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_NLIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_NLPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_NLDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_NLEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_NLWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_PTIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_PTPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_PTDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_PTEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_PTWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_SEIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_SEPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_SEDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_SEEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_SEWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_EXT_DEIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_EXT_DEDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_EXT_DEEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_EXT_DEWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_EXT_NLIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_EXT_NLDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_EXT_NLEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_EXT_NLWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_KOB_DEIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_KOB_DEDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_KOB_DEEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EFTA_CHIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EFTA_CHPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EFTA_CHDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EFTA_CHEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_ASEAN_JPIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_NAFTA_USAIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_NAFTA_USAPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_NAFTA_USADIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTZLD_FTNOEMax. Number of Entries for Tree Display in Foreign Trade FTNOEDEC4DEC4
FTZLD_DEACTIndicator for the deactivation of individual FT areas FTDEACHAR1XFELD
FTZLD_W3OBJIDObject name for SapWWWGateway for Foreign Trade areas FTPICCHAR40WWWDATASYCHAR40
FTZLD_TDOBNAMEText name for Foreign Trade areas FTTDNCHAR70TDOBNAME
FTZLD_TDSPRASLanguage key TDSPRASLANG1T002ISOLASPRAS
FTGOV_EU_EXT_FRIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_EXT_FRDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_EXT_FREIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_EXT_FRWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_EXT_BEIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_EXT_BEDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_EXT_BEEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_EXT_BEWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_PLIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_PLPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_PLDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_PLEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_PLWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_CZIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_CZPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_CZDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_CZEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_CZWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_SKIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_SKPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_SKDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_SKEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_SKWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI
FTGOV_EU_INT_HUIndicator for deactivating individual declaration types FTDPACHAR1XFELD
FTGOV_EU_INT_HUPIndicator for deactivating the declaration medium 'document' FTPAPCHAR1XFELD
FTGOV_EU_INT_HUDIndicator for deactivating the declaration medium 'diskette' FTPADCHAR1XFELD
FTGOV_EU_INT_HUEIndicator for deactivating the declaration medium 'CUSDEC' FTPAECHAR1XFELD
FTGOV_EU_INT_HUWIndicator for deactivating a goods movem. for periodic decl. FTPAWNUMC1VEREI

Key field Non-key field



How do I retrieve data from SAP table FTUSE using ABAP code

The following ABAP code Example will allow you to do a basic selection on FTUSE to SELECT all data from the table
DATA: WA_FTUSE TYPE FTUSE.

SELECT SINGLE *
FROM FTUSE
INTO CORRESPONDING FIELDS OF WA_FTUSE
WHERE...

How to access SAP table FTUSE

Within an ECC or HANA version of SAP you can also view further information about FTUSE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).