SAP FTSEL Selection Indicator Work Area for Reporting in FT Table data and field list

FTSEL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Selection Indicator Work Area for Reporting in FT" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FTSEL TYPE FTSEL.

The FTSEL table consists of various fields, each holding specific information or linking keys about Selection Indicator Work Area for Reporting in FT data available in SAP. These include KWLDI (SLS: Create key words: List output?), DEL_DATA (Foreign trade: Legal control - SLS - Delete old data), CHECK_CORE (Check for different control reasons), SLDKZ (Deletion indicator for entry in sanctioned party list)... 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. .

FTSEL structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FTSEL structure 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 FTSEL 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
KWLDISLS: Create key words: List output? KWLDICHAR1XFELD
DEL_DATAForeign trade: Legal control - SLS - Delete old data DEL_DATACHAR1XFELD
CHECK_CORECheck for different control reasons CHECK_CORECHAR1XFELD
SLDKZDeletion indicator for entry in sanctioned party list SLDKZCHAR1XFELD
SHOW_TEXTIndicator: Determines whether texts for data will be read SHOW_TEXTCHAR1XFELD
P_PRZABOpen value in percent for license for legal control P_PRZABDEC5(2) PRZ32
P_ANZTGNumber of days until validity end of export license P_ANZTGNUMC3NUM03
CHECK_ANZForeign Trade: Legal Control: SLS: Number of Checks CHECK_ANZNUMC12CHECK_ANZ
CHECK_PERForeign Trade: Legal Control: SLS: Checking Time CHECK_PERNUMC12CHECK_PER
P_AUFTRDocument type 'sales doc' for Reporting in Foreign Trade P_AUFTRCHAR1XFELD
P_LIEFRDocument type 'delivery doc.' for Reporting in Foreign Trade P_LIEFRCHAR1XFELD
GKEYWForeign Trade: Legal Control: SLS: Determine key words GKEYWCHAR1XFELD
P_KUMLeg. Contrl: Bureau of Exp. Administr. diskette: Aggr. data P_KUMCHAR1XFELD
P_FILELeg. Contrl: Bureau of Exp. Administr. diskette: Create file P_FILECHAR1XFELD
LIFTYPBAFA (German Federal Export Office) diskette: Document type LIFTYPCHAR1CHAR1
DISP_ALLFT: Legal Control: Display Variant (Detail in dialog box) DISP_ALLCHAR1XFELD
SHOW_MSGIndicator if system shall display processing step SHOW_MSGCHAR1XFELD
VAR_CONForeign Trade: Legal Control: Tree variant VAR_CONCHAR14Assigned to domainVARIANTVCN
P_GEGRULegal Regulation for Legal Control P_GEGRUCHAR1CHAR1
P_GEARTLicense type P_GEARTCHAR1CHAR1
P_ALANDDeparture country (country from which the goods are sent) P_ALANDCHAR1CHAR1
P_EXLNDDestination Country of Export Transaction for Legal Control P_EXLNDCHAR1CHAR1
P_PRKLASLegal Control: Product Classification Check P_PRKLASCHAR1CHAR1
P_LAKLASLegal Control: Country Classification P_LAKLASCHAR1CHAR1
P_FORMRName of FORM routine for user-defined function P_FORMRCHAR1CHAR1
P_LGRUPCountry Grouping for Export Control P_LGRUPCHAR1CHAR1
P_ALNUMExport Control Class according the Legal Reg. for Legal Ctrl P_ALNUMCHAR1CHAR1
P_EMBGRGrouping for Legal Control P_EMBGRCHAR1CHAR1
P_LANDEXLegal Control: Existence Check for Countries P_LANDEXCHAR1CHAR1
P_WRKLNDCountries of All Plants P_WRKLNDCHAR1CHAR1
P_LICENSLicense for Product Classification P_LICENSCHAR1CHAR1
P_BEZEIDescriptions in Language of Declaration P_BEZEICHAR1CHAR1
P_BELTYPDocument types P_BELTYPCHAR1CHAR1
P_POSTYPItem categories P_POSTYPCHAR1CHAR1
P_ALNEMBCombination: Export Control Class / Grouping P_ALNEMBCHAR1CHAR1
P_DISCForeign Trade: Create Diskette DISCCHAR1XFELD
CHECK_KOLICheckbox: Check only ... CHECK_KOLICHAR1XFELD
CHECK_KOMACheckbox: Check only ... CHECK_KOMACHAR1XFELD
CHECK_VEMACheckbox: Check only ... CHECK_VEMACHAR1XFELD
CHECK_KOKUCheckbox: Check foreign trade data only CHECK_KOKUCHAR1XFELD
PRINT_REDIndicates whether the log displays errors only PRINT_REDCHAR1XFELD
CHECK_AGRECheck for payment guarantee procedure only CHECK_AGRECHAR1XFELD
CHECK_LECOCheck for legal control only CHECK_LECOCHAR1XFELD
CHECK_VERWCivilian or military use CHECK_VERWCHAR1XFELD
CHECK_LCOMForeign Trade: Consistency Reports:Add.Check-Exempt.Certif. CHECK_LCOMCHAR1XFELD
SALES_VIEWSales view SALES_VIEWCHAR1XFELD
PURCH_VIEWPurchasing view for incompletion reporting in foreign trade PURCH_VIEWCHAR1XFELD
MTEXTForeign trade: Display material description MAT_TXTCHAR1XFELD
KOLKZForeign trade: Import/Export - Consistency reports KOLKZCHAR1XFELD
FIGELForeign trade: Ind. f. displaying invoices transferred to FI FIGELCHAR1XFELD
LAND_STAWNForeign Trade: MMM: Country of Commodity Code/Import Code No LAND_STAWNCHAR3T005LAND1LND
WERKS_STAWNPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
ALL_WERKSForeign Trade: MMM: Indicator, change material in all plants ALL_WERKSCHAR1XFELD
DISPLAY_LISTForeign Trade: MMM: Indicator, if list display DISPLAY_LISTCHAR1XFELD
CHECK_REORGCheckbox: Reorganization Incompleteness CHECK_REORGCHAR1XFELD
P_QUARTALForeign trade: Decl. to auth. - Decl.period for BAFA disk. P_QUARTALCHAR3CHAR3
HLANDCountry of destination of material BESTILANDCHAR3Assigned to domainLAND1LND
P_GESAMT_VIEWFT: Declara. to auth.: Goods catalog: Overall view P_GESAMT_VIEWCHAR1CHAR1
P_VERKAUF_VIEWFT: Declara. to Auth.: Goods Catalog: Sales View P_VERKAUF_VIEWCHAR1CHAR1
P_EINKAUF_VIEWForeign Trade: Declarations: Goods catalog: Purchasing view P_EINKAUF_VIEWCHAR1CHAR1
P_SORT_STAWNFT: Declara. to Auth.: Goods Catalog: STAWN Sorting P_SORT_STAWNCHAR1CHAR1
P_SORT_MATNRFT: Declara. to Auth.: Goods catalog: MATNO sorting P_SORT_MATNRCHAR1CHAR1
P_SORT_MATXTFT: Declara. to Auth.: Goods Catalogue: MATXT sorting P_SORT_MATXTCHAR1CHAR1
P_COMPNRCompany Number for Mineral Oil Products Declaration COMPNRCHAR4CHAR4
P_ANZTENumber of days until presentation date of financial document P_ANZTENUMC3NUM03
P_ANZTFNumber of days until validity end of financial document P_ANZTFNUMC3NUM03
P_ANZTSNumber of days until latest shipping date from financ.doc. P_ANZTSNUMC3NUM03
VARIANT_LOCForeign Trade: Documentary Payments: Tree variant VAR_LOCCHAR14Assigned to domainVARIANTVCN
UV_STATSYSIndicator: Select docs w/ incompletion status set by system UV_STATSYSCHAR1XFELD
UV_STATMANIndicator: Select docs with manually set incompletion status UV_STATMANCHAR1XFELD
UV_CHECKIncompletion: Indicator for check UV_CHECKCHAR1XFELD
P_SIMULIndicator simulated run P_SIMULCHAR1XFELD
PRENE_TForeign Trade: PRE: Vendor Declaration: ALV PRENE_KTXTCHAR60DDTEXT
GZOLX_TForeign Trade: PRE: Vendor Declaration: ALV GZOLX_KTXTCHAR30TEXT30
P_BETOLTolerance days purchase order P_BETOL_DAYSDEC3MHNTGBTO
P_EULIFIndicator 'Only dun EU vendors' P_EUCHAR1XFELD
P_ANSCHPrint letter P_ANSCHCHAR1XFELD
P_MAHNEPrint dunning letter indicator P_MAHNECHAR1XFELD
P_MAXMAMaximum dunning level P_MAXMANUMC1NUMC1
P_ANTXTRequest text P_MTXT1CHAR70TDOBNAME
P_MATXTText container for dunning text P_MATXTCHAR70TDOBNAME
P_SPRASLanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
P_SHOWLIndicator list display P_SHOWLCHAR1XFELD
P_PREISBottom price for materials P_PREISCURR11(2) WERT11V
P_WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
P_BETPRPO tolerance check active P_BETOL_CHECKCHAR1XFELD
P_DRUCKCheckbox XFELDCHAR1XFELD
P_DOCSPOutput language for vendor declaration P_DOCSPCHAR1XFELD
P_NEWPGIndicator separate long-term vendor declara. for each mat. P_NEWPGCHAR1XFELD
P_EKVERAggregate indicator P_EKVERCHAR1XFELD
P_DPATHDirectory for form letter data P_PATHCHAR128LOCALFILE
P_POPUPIndicator selection window for print preview P_POPUPCHAR1XFELD
P_NOPREIndicator: Do not print preference zones on list P_NOPRECHAR1XFELD
P_OUTPTForeign Trade: PRE: Output types P_OUTPTCHAR1XFELD
P_LIEFForeign Trade: Preference: Request vendor declaration? P_LIEFCHAR1XFELD
P_CHKFKMaterials from billing documents P_CHKFKCHAR1XFELD
P_MATNR_PREForeign Trade: Preference Handling: Alternative: Mat. no. MATNR_PRECHAR18Assigned to domainMATN1MATNRMAPMAT1
P_ESOKZIndicator: Select Types of Purchasing Info Records P_ESOKZCHAR1XFELD
P_EKNORForeign Trade: Purchasing info record type P_EKTYPCHAR1XFELDEKN
P_EKKONForeign Trade: Purchasing info record type: Consignment P_EKKONCHAR1XFELDEKK
P_EKLOBForeign Trade: Purchase info record type: Subcontracting P_EKLOBCHAR1XFELDEKL
P_EKPIPForeign Trade: Purchasing info record type: Pipeline P_EKPIPCHAR1XFELDEKI
P_USEPRInd.: Auto. Determ. of Long-Term Vendor Decl. Validity Date P_USEPRCHAR1XFELD
P_ZONESIndicator: Print Preference Zone Comments P_ZONESCHAR1XFELD
EXMENGEExported qty, for which the restitution will be applied for EXMENGEQUAN15(3) MENG15
EXGEWEIWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
P_ALTER_STAWNForeign Trade: Service: Alternative Commodity Code P_ALTER_STAWNCHAR1CHAR1
P_ALTER_TXTForeign Trade: Service: Additional Description P_ALTER_TXTCHAR1CHAR1
P_LAENGELength of commodity code / code number for foreign trade LASTWNUMC2LASTW
C_CASEForeign Trade: Service: Upper/Lower Case C_CASECHAR1CHAR1
C_ZOLLTXTForeign Trade: Service: Additinal Customs Description C_ZOLLTXTCHAR1CHAR1
C_BMEONForeign Trade: Service: Special Unit of Measure only C_BMEONCHAR1CHAR1
DDTEXTDescription with lenght of 80 BEZEI80CHAR80BEZEI80
TEXT_40Description BEZEI40CHAR40TEXT40
VAR_LIGHTSVariant for selection with traffic lights VAR_LIGHTSCHAR14RALDB_VARI
VAR_REPORTVariant for starting a report VAR_REPORTCHAR14RALDB_VARI
S_HEFEL_KOPFHeader fields HEFEL_KOPFCHAR30Assigned to domainFDNAME
S_HEFEL_POSItem fields HEFEL_POSCHAR30Assigned to domainFDNAME
PB_PRERFirst Processing for Printout PB_PRERCHAR1XFELD
PB_PRFEError Processing for Printing PB_PRFECHAR1XFELD
PB_PRWERepeat Processing for Printing PB_PRWECHAR1XFELD
PB_PRSOSpecial Case Processing for Printing PB_PRSOCHAR1XFELD
PB_COERCommunication First Processing PB_COERCHAR1XFELD
PB_COFECommunication Error Processing PB_COFECHAR1XFELD
PB_COWECommunication Repeat Processing PB_COWECHAR1XFELD
DR_VAR_NACHVariant for starting a report DR_VAR_NACHCHAR14RALDB_VARI
DR_VAR_AUDIVariant for starting a report DR_VAR_AUDICHAR14RALDB_VARI
CHAR_YEARCount parameters NUMC4NUMC4NUMC4
CHAR_MONTHTwo digit number NUMC2NUMC2NUMC2
CHAR_DAYTwo digit number NUMC2NUMC2NUMC2

Key field Non-key field



How do I retrieve data from SAP structure FTSEL using ABAP code?

As FTSEL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FTSEL as there is no data to select.

How to access SAP table FTSEL

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

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